forked from TalaikisInc/Quantrade
-
Notifications
You must be signed in to change notification settings - Fork 0
/
dev-dump.sql
108 lines (97 loc) · 40.4 KB
/
dev-dump.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
-- MySQL dump 10.13 Distrib 5.7.17, for Linux (x86_64)
--
-- Host: localhost Database: admin_quantrade
-- ------------------------------------------------------
-- Server version 5.7.17
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `collector_signals`
--
DROP TABLE IF EXISTS `collector_signals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `collector_signals` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`email` varchar(100) NOT NULL,
`_key` varchar(100) NOT NULL,
`broker` varchar(40) NOT NULL,
`symbol` varchar(20) NOT NULL,
`period` int(11) NOT NULL,
`system` varchar(20) NOT NULL,
`date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`_signal` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `symbol` (`symbol`,`broker`,`date_time`,`period`,`system`),
UNIQUE KEY `symbol_2` (`symbol`,`broker`,`date_time`,`period`,`system`),
UNIQUE KEY `symbol_3` (`symbol`,`broker`,`date_time`,`period`,`system`),
UNIQUE KEY `symbol_4` (`symbol`,`broker`,`date_time`,`period`,`system`),
UNIQUE KEY `symbol_5` (`symbol`,`broker`,`date_time`,`period`,`system`),
UNIQUE KEY `symbol_6` (`symbol`,`broker`,`date_time`,`period`,`system`),
UNIQUE KEY `symbol_7` (`symbol`,`broker`,`date_time`,`period`,`system`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `collector_signals`
--
LOCK TABLES `collector_signals` WRITE;
/*!40000 ALTER TABLE `collector_signals` DISABLE KEYS */;
/*!40000 ALTER TABLE `collector_signals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `collector_symbols`
--
DROP TABLE IF EXISTS `collector_symbols`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `collector_symbols` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`symbol` varchar(20) NOT NULL,
`description` varchar(120) DEFAULT NULL,
`spread` decimal(10,5) DEFAULT NULL,
`tick_value` decimal(10,5) DEFAULT NULL,
`tick_size` decimal(8,5) DEFAULT NULL,
`margin_initial` decimal(10,2) DEFAULT NULL,
`digits` decimal(8,5) DEFAULT NULL,
`profit_calc` int(2) DEFAULT NULL,
`profit_currency` varchar(10) DEFAULT NULL,
`price_at_calc_time` decimal(20,5) DEFAULT NULL,
`commission` decimal(15,5) DEFAULT NULL,
`broker` varchar(40) NOT NULL,
`points` decimal(8,5) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `symbol` (`symbol`),
UNIQUE KEY `symbol_2` (`symbol`,`broker`),
UNIQUE KEY `symbol_3` (`symbol`,`broker`),
UNIQUE KEY `symbol_4` (`symbol`,`broker`),
UNIQUE KEY `symbol_5` (`symbol`,`broker`),
UNIQUE KEY `symbol_6` (`symbol`,`broker`),
UNIQUE KEY `symbol_7` (`symbol`,`broker`),
UNIQUE KEY `symbol_8` (`symbol`,`broker`)
) ENGINE=InnoDB AUTO_INCREMENT=622432 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `collector_symbols`
--
LOCK TABLES `collector_symbols` WRITE;
/*!40000 ALTER TABLE `collector_symbols` DISABLE KEYS */;
INSERT INTO `collector_symbols` VALUES (1,'GASES','1 Lot= 10,000 Shares ',30.00000,10.00000,0.00100,20455.00,3.00000,1,'EUR',20.56000,NULL,'Ava Trade EU Ltd.',0.00000),(2,'ATT','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,3325.57,2.00000,1,'USD',37.62000,NULL,'Ava Trade EU Ltd.',0.01000),(3,'EURCHF','Euro vs Swiss Franc',10.00000,0.91420,0.00001,250.00,5.00000,0,'CHF',1.09462,NULL,'Pepperstone Group Limited',0.00000),(4,'5YTNOTES','1 Lot= 1,000 Contracts',4.00000,10.00000,0.01000,1035.73,2.00000,1,'USD',117.77000,NULL,'Ava Trade EU Ltd.',0.01000),(5,'PFIZER','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,2960.75,2.00000,1,'USD',33.59000,NULL,'Ava Trade EU Ltd.',0.01000),(6,'USDPLN','US Dollar vs Polish Zloty',84.00000,0.23596,0.00001,219.78,5.00000,0,'PLN',3.70335,NULL,'Pepperstone Group Limited',0.00000),(7,'GBPILS','1 Lot= 100,000 GBP',80.00000,2.51800,0.00010,1138.97,4.00000,0,'ILS',4.53030,NULL,'Ava Trade EU Ltd.',0.00000),(8,'USDZAR','1 Lot= 100,000 USD',120.00000,0.66720,0.00010,219.77,4.00000,0,'ZAR',13.05440,NULL,'Ava Trade EU Ltd.',0.00000),(9,'EWA','1 Lot= 1,000 Shares (MSCI AUS FUND)',5.00000,10.00000,0.01000,955.12,2.00000,1,'USD',21.80000,NULL,'Ava Trade EU Ltd.',0.01000),(10,'EURUSD','1 Lot= 100,000 EUR',30.00000,0.87920,0.00001,250.00,5.00000,0,'USD',1.14218,NULL,'Ava Trade EU Ltd.',0.00000),(11,'EUROBUND','1 Lot= 1,000 Contracts',4.00000,10.00000,0.01000,1622.20,2.00000,1,'EUR',161.74000,NULL,'Ava Trade EU Ltd.',0.01000),(12,'USDRUB','US Dollar vs Russian Ruble',2740.00000,0.01485,0.00001,219.78,5.00000,0,'RUB',58.92850,NULL,'Pepperstone Group Limited',0.00000),(13,'CHFJPY','Swiss Frank vs Japanese Yen',17.00000,0.77775,0.00100,228.54,3.00000,0,'JPY',117.24700,NULL,'Pepperstone Group Limited',0.00000),(14,'USDTRY','1 Lot= 100,000 USD',20.00000,2.48084,0.00010,219.77,4.00000,0,'TRY',3.51840,NULL,'Ava Trade EU Ltd.',0.00000),(15,'COTTON2','1 Lot= 1,000 Pounds (lbs)',9.00000,10.00000,0.01000,1800.71,2.00000,1,'USD',68.62000,NULL,'Ava Trade EU Ltd.',0.01000),(17,'ALIBABA','1 Lot= 100 Shares ',9.00000,1.00000,0.01000,619.80,2.00000,1,'USD',140.77000,NULL,'Ava Trade EU Ltd.',0.01000),(19,'AUDNZD','1 Lot= 100,000 AUD',80.00000,0.64114,0.00001,168.20,5.00000,0,'NZD',1.04780,NULL,'Ava Trade EU Ltd.',0.00000),(20,'COCOA','1 Lot= 100 Metric Ton',10.00000,100.00000,1.00000,3456.55,0.00000,1,'USD',1927.00000,NULL,'Ava Trade EU Ltd.',1.00000),(21,'GBPAUD','Great Britain Pound vs Australian Dollar',21.00000,0.67276,0.00001,284.79,5.00000,0,'AUD',1.69469,NULL,'Pepperstone Group Limited',0.00000),(22,'FRA40','CAC40 Index',10.00000,0.10000,0.10000,51.73,1.00000,1,'EUR',5148.10000,NULL,'Pepperstone Group Limited',0.10000),(23,'EURCAD','Euro vs Canadian Dollar',15.00000,0.67702,0.00001,250.00,5.00000,0,'CAD',1.48039,NULL,'Pepperstone Group Limited',0.00000),(24,'JPMORGAN','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,8053.27,2.00000,1,'USD',91.15000,NULL,'Ava Trade EU Ltd.',0.01000),(26,'JPN225','Nikkei 225',80.00000,0.07778,0.10000,78.31,1.00000,1,'JPY',20080.50000,NULL,'Pepperstone Group Limited',0.10000),(28,'EPI','1 Lot= 1,000 Shares (IND EARN FUND)',5.00000,10.00000,0.01000,1078.63,2.00000,1,'USD',24.30000,NULL,'Ava Trade EU Ltd.',0.01000),(29,'EWC','1 Lot= 1,000 Shares (MSCI CAN FUND)',5.00000,10.00000,0.01000,1178.85,2.00000,1,'USD',26.77000,NULL,'Ava Trade EU Ltd.',0.01000),(30,'NZDCHF','New Zealand Dollar vs Swiss Franc',23.00000,0.91420,0.00001,160.25,5.00000,0,'CHF',0.70249,NULL,'Pepperstone Group Limited',0.00000),(31,'MCDONALDS','1 Lot= 1,000 Shares',8.00000,10.00000,0.01000,13483.36,2.00000,1,'USD',153.12000,NULL,'Ava Trade EU Ltd.',0.01000),(32,'CHINAA50','1 Lot= 100 Indexes',150.00000,500.00000,5.00000,39681.77,1.00000,1,'USD',11345.00000,NULL,'Ava Trade EU Ltd.',0.10000),(33,'OMX30','1 Lot= 1,000 Indexes',75.00000,250.00000,0.25000,3351.27,2.00000,1,'SEK',1603.75000,NULL,'Ava Trade EU Ltd.',0.01000),(34,'UNICREDITO','1 Lot= 1,000 Shares ',140.00000,0.10000,0.00010,1682.20,4.00000,1,'EUR',16.34800,NULL,'Ava Trade EU Ltd.',0.00000),(35,'EURILS','1 Lot= 100,000 EUR',50.00000,2.51800,0.00010,1000.00,4.00000,0,'ILS',3.98200,NULL,'Ava Trade EU Ltd.',0.00000),(36,'GOOGLE','1 Lot= 100 Shares',33.00000,1.00000,0.01000,4090.28,2.00000,1,'USD',937.96000,NULL,'Ava Trade EU Ltd.',0.01000),(37,'NZDJPY','1 Lot= 100,000 NZD',70.00000,0.77803,0.00100,160.25,3.00000,0,'JPY',82.28000,NULL,'Ava Trade EU Ltd.',0.00000),(38,'CORN','1 Lot= 100 Units',50.00000,25.00000,0.25000,1021.27,2.00000,1,'USD',378.75000,NULL,'Ava Trade EU Ltd.',0.01000),(40,'PLATINUM','1 Lot= 100 Troy Oz',7.00000,10.00000,0.10000,1615.75,1.00000,1,'USD',929.20000,NULL,'Ava Trade EU Ltd.',0.10000),(41,'USDSGD','1 Lot= 100,000 USD',60.00000,0.63639,0.00001,219.77,5.00000,0,'SGD',1.37618,NULL,'Ava Trade EU Ltd.',0.00000),(42,'AUDUSD','Australian Dollar vs US Dollar',3.00000,0.87912,0.00001,168.18,5.00000,0,'USD',0.76859,NULL,'Pepperstone Group Limited',0.00000),(43,'BKIAES','1 Lot= 10,000 Shares (BANKIA)',22.00000,10.00000,0.00100,4374.00,3.00000,1,'EUR',4.23000,NULL,'Ava Trade EU Ltd.',0.00000),(44,'MICROSOFT','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,6070.06,2.00000,1,'USD',68.51000,NULL,'Ava Trade EU Ltd.',0.01000),(46,'CrudeOIL','1 Lot= 1,000 Barrels',3.00000,10.00000,0.01000,405.70,2.00000,1,'USD',46.26000,NULL,'Ava Trade EU Ltd.',0.01000),(47,'UBIIT','1 Lot= 10,000 Shares ',140.00000,1.00000,0.00010,7087.00,4.00000,1,'EUR',6.87800,NULL,'Ava Trade EU Ltd.',0.00000),(48,'EWG','1 Lot= 1,000 Shares (MSCI DEU FUND)',5.00000,10.00000,0.01000,1332.25,2.00000,1,'USD',30.34000,NULL,'Ava Trade EU Ltd.',0.01000),(49,'BP','1 Lot= 10,000 Shares ',50.00000,1.13944,0.01000,5096.62,2.00000,1,'PNC',443.25000,NULL,'Ava Trade EU Ltd.',0.01000),(50,'EURJPY','1 Lot= 100,000 EUR',40.00000,0.77804,0.00100,250.00,3.00000,0,'JPY',128.20200,NULL,'Ava Trade EU Ltd.',0.00000),(51,'10YTNOTES','1 Lot= 1,000 Contracts',4.00000,10.00000,0.01000,1102.81,2.00000,1,'USD',125.41000,NULL,'Ava Trade EU Ltd.',0.01000),(52,'GROUPON','1 Lot= 1,000 Shares',3.00000,10.00000,0.01000,340.20,2.00000,1,'USD',3.60000,NULL,'Ava Trade EU Ltd.',0.01000),(55,'BARCLAYS','1 Lot= 10,000 Shares ',65.00000,1.13944,0.01000,2344.09,2.00000,1,'PNC',202.20000,NULL,'Ava Trade EU Ltd.',0.01000),(56,'SPI200','1 Lot= 100 Indexes',3.00000,100.00000,1.00000,7601.22,0.00000,1,'AUD',5666.00000,NULL,'Ava Trade EU Ltd.',1.00000),(57,'CAFR','1 Lot= 1,000 Shares (CARREFOUR)',25.00000,1.00000,0.00100,2227.50,3.00000,1,'EUR',22.14500,NULL,'Ava Trade EU Ltd.',0.00000),(59,'XAUAUD','Gold vs Australian Dollar',85.00000,0.67276,0.01000,271.13,2.00000,0,'AUD',1613.82000,NULL,'Pepperstone Group Limited',0.01000),(60,'DOLLARINDX','1 Lot= 1,000 Indexes',60.00000,5.00000,0.00500,1684.85,3.00000,1,'USD',95.36000,NULL,'Ava Trade EU Ltd.',0.00000),(61,'USDCHF','1 Lot= 100,000 USD',40.00000,0.91429,0.00001,219.77,5.00000,0,'CHF',0.95865,NULL,'Ava Trade EU Ltd.',0.00000),(62,'ORANGEFR','1 Lot= 10,000 Shares',25.00000,10.00000,0.00100,14050.00,3.00000,1,'EUR',13.86500,NULL,'Ava Trade EU Ltd.',0.00000),(63,'BANCOST','1 Lot= 10,000 Shares (B. SANT)',21.00000,10.00000,0.00100,5909.00,3.00000,1,'EUR',5.78700,NULL,'Ava Trade EU Ltd.',0.00000),(64,'Sugar','Sugar Futures',60.00000,0.08791,0.00100,23.65,3.00000,1,'USD',13.78000,NULL,'Pepperstone Group Limited',0.00000),(65,'DTEDE','1 Lot= 10,000 Shares (DE TELEKM)',15.00000,10.00000,0.00100,15765.00,3.00000,1,'EUR',15.72000,NULL,'Ava Trade EU Ltd.',0.00000),(66,'GOLD','1 Lot= 100 Troy Oz',60.00000,1.00000,0.01000,542.49,2.00000,1,'USD',1241.33000,NULL,'Ava Trade EU Ltd.',0.01000),(67,'GBPJPY','Great Britain Pound vs Japanese Yen',15.00000,0.77775,0.00100,284.79,3.00000,0,'JPY',146.43600,NULL,'Pepperstone Group Limited',0.00000),(68,'NIFTY50','1 Lot= 100 Indexes',35.00000,50.00000,0.50000,16924.09,1.00000,1,'USD',9525.50000,NULL,'Ava Trade EU Ltd.',0.10000),(69,'IYR','1 Lot= 1,000 Shares (US REAL EST.)',5.00000,10.00000,0.01000,3508.42,2.00000,1,'USD',79.76000,NULL,'Ava Trade EU Ltd.',0.01000),(70,'GS','1 Lot= 1,000 Shares (GLD. SACHS)',7.00000,10.00000,0.01000,19534.97,2.00000,1,'USD',224.63000,NULL,'Ava Trade EU Ltd.',0.01000),(72,'GBPSGD','Great Britain Pound vs Singapore Dollar',35.00000,0.63620,0.00001,284.79,5.00000,0,'SGD',1.79293,NULL,'Pepperstone Group Limited',0.00000),(73,'CADJPY','Canadian Dollar vs Japanese Yen',11.00000,0.77776,0.00100,169.25,3.00000,0,'JPY',86.69200,NULL,'Pepperstone Group Limited',0.00000),(74,'VODAFONE','1 Lot= 100,000 Shares ',25.00000,11.39491,0.01000,24752.18,2.00000,1,'PNC',217.25000,NULL,'Ava Trade EU Ltd.',0.01000),(76,'PERRIGO','1 Lot= 1,000 Shares',8.00000,8.79198,0.01000,6652.02,2.00000,1,'USD',75.87000,NULL,'Ava Trade EU Ltd.',0.01000),(77,'LOCKHEED','1 Lot= 100 Shares',8.00000,1.00000,0.01000,2444.55,2.00000,1,'USD',276.79000,NULL,'Ava Trade EU Ltd.',0.01000),(78,'CHEVRON','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,9183.77,2.00000,1,'USD',104.10000,NULL,'Ava Trade EU Ltd.',0.01000),(79,'BTCWeekly','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Ava Trade EU Ltd.',0.00000),(81,'AUDJPY','1 Lot= 100,000 AUD',50.00000,0.77803,0.00100,168.20,3.00000,0,'JPY',86.25500,NULL,'Ava Trade EU Ltd.',0.00000),(82,'PALLADIUM','1 Lot= 100 Troy Oz',70.00000,0.87920,0.01000,1477.56,2.00000,1,'USD',842.40000,NULL,'Ava Trade EU Ltd.',0.01000),(83,'VERIZON','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,3929.50,2.00000,1,'USD',44.39000,NULL,'Ava Trade EU Ltd.',0.01000),(84,'BERKSHIRE','1 Lot= 1,000 Shares',10.00000,10.00000,0.01000,14931.21,2.00000,1,'USD',169.24000,NULL,'Ava Trade EU Ltd.',0.01000),(85,'ENELIT','1 Lot= 10,000 Shares ',100.00000,1.00000,0.00010,4730.00,4.00000,1,'EUR',4.71400,NULL,'Ava Trade EU Ltd.',0.00000),(86,'RWEDE','1 Lot= 1,000 Shares ',40.00000,1.00000,0.00100,1758.50,3.00000,1,'EUR',17.48000,NULL,'Ava Trade EU Ltd.',0.00000),(87,'SABES','1 Lot= 10,000 Shares (B. SABADL)',21.00000,10.00000,0.00100,1827.00,3.00000,1,'EUR',1.76900,NULL,'Ava Trade EU Ltd.',0.00000),(88,'USDSEK','1 Lot= 100,000 USD',50.00000,1.03733,0.00010,219.77,4.00000,0,'SEK',8.42190,NULL,'Ava Trade EU Ltd.',0.00000),(89,'ENI','1 Lot= 10,000 Shares ',500.00000,1.00000,0.00010,13400.00,4.00000,1,'EUR',13.10000,NULL,'Ava Trade EU Ltd.',0.00000),(91,'GBPCHF','1 Lot= 100,000 GBP',70.00000,0.91429,0.00001,284.74,5.00000,0,'CHF',1.24766,NULL,'Ava Trade EU Ltd.',0.00000),(92,'GBPUSD','Great Britain Pound vs US Dollar',6.00000,0.87911,0.00001,284.79,5.00000,0,'USD',1.30271,NULL,'Pepperstone Group Limited',0.00000),(93,'GBPNZD','Great Britain Pound vs New Zealand Dollar',44.00000,0.64104,0.00001,284.79,5.00000,0,'NZD',1.77639,NULL,'Pepperstone Group Limited',0.00000),(94,'USDCZK','US Dollar vs Czech Republic Koruna',1450.00000,0.03829,0.00001,219.78,5.00000,0,'CZK',22.84815,NULL,'Pepperstone Group Limited',0.00000),(95,'AMAZON','1 Lot= 100 Shares',17.00000,1.00000,0.01000,4258.05,2.00000,1,'USD',975.83000,NULL,'Ava Trade EU Ltd.',0.01000),(96,'UNITEDTECH','1 Lot= 100 Shares',7.00000,1.00000,0.01000,1075.82,2.00000,1,'USD',121.63000,NULL,'Ava Trade EU Ltd.',0.01000),(98,'SAPDE','1 Lot= 1,000 Shares ',50.00000,1.00000,0.00100,9148.00,3.00000,1,'EUR',91.48000,NULL,'Ava Trade EU Ltd.',0.00000),(99,'AMDOCS','1 Lot= 1,000 Shares',7.00000,8.79198,0.01000,5673.60,2.00000,1,'USD',63.95000,NULL,'Ava Trade EU Ltd.',0.01000),(101,'NZDCAD','New Zealand Dollar vs Canadian Dollar',20.00000,0.67702,0.00001,160.25,5.00000,0,'CAD',0.95019,NULL,'Pepperstone Group Limited',0.00000),(102,'EURGBP','Euro vs Great Britain Pound ',5.00000,1.13917,0.00001,250.00,5.00000,0,'GBP',0.87651,NULL,'Pepperstone Group Limited',0.00000),(103,'USDTHB','US Dollar vs Thai Baht',640.00000,0.02587,0.00001,219.78,5.00000,0,'THB',33.89480,NULL,'Pepperstone Group Limited',0.00000),(104,'AUDSGD','Australian Dollar vs Singapore Dollar',33.00000,0.63620,0.00001,168.18,5.00000,0,'SGD',1.05805,NULL,'Pepperstone Group Limited',0.00000),(105,'IT40','Italy 40',100.00000,0.10000,0.10000,209.12,1.00000,1,'EUR',20577.00000,NULL,'Pepperstone Group Limited',0.10000),(106,'GBPSEK','Great Britain Pound vs Swedish Krona',235.00000,0.10374,0.00001,284.79,5.00000,0,'SEK',10.97443,NULL,'Pepperstone Group Limited',0.00000),(107,'EURTRY','Euro vs Turkish Lira',78.00000,0.24803,0.00001,250.00,5.00000,0,'TRY',4.02140,NULL,'Pepperstone Group Limited',0.00000),(108,'RUSSELL2000','1 Lot= 100 Indexes',4.00000,10.00000,0.10000,2491.14,1.00000,1,'USD',1412.90000,NULL,'Ava Trade EU Ltd.',0.10000),(110,'EWW','1 Lot= 1,000 Shares (MSCI MEX FUND)',5.00000,10.00000,0.01000,2371.76,2.00000,1,'USD',53.57000,NULL,'Ava Trade EU Ltd.',0.01000),(115,'TEVA','1 Lot= 1,000 Shares',7.00000,8.79198,0.01000,2928.22,2.00000,1,'USD',32.80000,NULL,'Ava Trade EU Ltd.',0.01000),(116,'USDMXN','US Dollar vs Mexican Peso',32.00000,0.48314,0.00010,219.78,4.00000,0,'MXN',18.11970,NULL,'Pepperstone Group Limited',0.00000),(117,'XPDUSD','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Pepperstone Group Limited',0.00000),(118,'USDNOK','1 Lot= 100,000 USD',50.00000,1.05157,0.00010,219.77,4.00000,0,'NOK',8.33890,NULL,'Ava Trade EU Ltd.',0.00000),(119,'VXX','1 Lot= 1,000 Shares (S&P500 VIX ST)',5.00000,10.00000,0.01000,559.98,2.00000,1,'USD',12.90000,NULL,'Ava Trade EU Ltd.',0.01000),(121,'ALLIANZ','1 Lot= 1,000 Shares ',150.00000,1.00000,0.00100,17435.00,3.00000,1,'EUR',172.60000,NULL,'Ava Trade EU Ltd.',0.00000),(122,'POPES','1 Lot= 10,000 Shares (B. POPULR)',29.00000,10.00000,0.00100,330.00,3.00000,1,'EUR',0.30500,NULL,'Ava Trade EU Ltd.',0.00000),(123,'GBPCAD','1 Lot= 100,000 GBP',70.00000,0.67713,0.00001,284.74,5.00000,0,'CAD',1.68856,NULL,'Ava Trade EU Ltd.',0.00000),(124,'FACEBOOK','1 Lot= 1,000 Shares',11.00000,10.00000,0.01000,6642.35,2.00000,1,'USD',151.05000,NULL,'Ava Trade EU Ltd.',0.01000),(125,'SHELL','1 Lot= 10,000 Shares ',250.00000,1.13946,0.01000,18787.23,2.00000,1,'PNC',1636.50000,NULL,'Ava Trade EU Ltd.',0.01000),(126,'REPSOLYPF','1 Lot= 10,000 Shares ',30.00000,10.00000,0.00100,13680.00,3.00000,1,'EUR',13.41000,NULL,'Ava Trade EU Ltd.',0.00000),(127,'ALUFR','1 Lot= 10,000 Shares (ALCATEL-L)',20.00000,10.00000,0.00100,3515.00,3.00000,1,'EUR',3.49500,NULL,'Ava Trade EU Ltd.',0.00000),(128,'EWT','1 Lot= 1,000 Shares (MSCI TWN FUND)',5.00000,10.00000,0.01000,1573.12,2.00000,1,'USD',35.58000,NULL,'Ava Trade EU Ltd.',0.01000),(130,'EURHUF','1 Lot= 100,000 EUR',75.00000,3.23918,0.01000,250.00,2.00000,0,'HUF',308.38000,NULL,'Ava Trade EU Ltd.',0.01000),(132,'XNGUSD','Natural Gas vs US Dollar',40.00000,0.87911,0.00010,65.41,4.00000,0,'USD',3.02900,NULL,'Pepperstone Group Limited',0.00000),(133,'CAC40','1 Lot= 100 Indexes',15.00000,50.00000,0.50000,10336.00,1.00000,1,'EUR',5145.50000,NULL,'Ava Trade EU Ltd.',0.10000),(134,'US500','US SPX 500',6.00000,0.08791,0.10000,10.69,1.00000,1,'USD',2424.00000,NULL,'Pepperstone Group Limited',0.10000),(135,'XAUEUR','Gold vs Euro',24.00000,1.00000,0.01000,271.16,2.00000,0,'EUR',1086.49000,NULL,'Pepperstone Group Limited',0.01000),(137,'EON','1 Lot= 1,000 Shares ',22.00000,1.00000,0.00100,832.90,3.00000,1,'EUR',8.25800,NULL,'Ava Trade EU Ltd.',0.00000),(141,'NAS100','US Tech 100',10.00000,0.08791,0.10000,24.90,1.00000,1,'USD',5654.90000,NULL,'Pepperstone Group Limited',0.10000),(142,'SUGAR11','1 Lot= 10,000 Units',4.00000,100.00000,0.01000,3541.82,2.00000,1,'USD',13.79000,NULL,'Ava Trade EU Ltd.',0.01000),(144,'COFFEEC','1 Lot= 1,000 Units',15.00000,8.79198,0.01000,3374.36,2.00000,1,'USD',125.90000,NULL,'Ava Trade EU Ltd.',0.01000),(147,'LTCWeekly','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Ava Trade EU Ltd.',0.00000),(151,'XPTUSD','Platinum vs US Dollar',160.00000,0.87911,0.01000,201.46,2.00000,0,'USD',924.48000,NULL,'Pepperstone Group Limited',0.01000),(153,'EURNZD','Euro vs New Zealand Dollar',23.00000,0.64104,0.00001,250.00,5.00000,0,'NZD',1.55745,NULL,'Pepperstone Group Limited',0.00000),(156,'TENIT','1 Lot= 1,000 Shares (TENARIS)',300.00000,0.10000,0.00010,1387.00,4.00000,1,'EUR',13.61000,NULL,'Ava Trade EU Ltd.',0.00000),(157,'HSBC','1 Lot= 10,000 Shares ',80.00000,1.13946,0.01000,8238.36,2.00000,1,'PNC',711.10000,NULL,'Ava Trade EU Ltd.',0.01000),(158,'EURPLN','1 Lot= 100,000 EUR',50.00000,2.36083,0.00010,250.00,4.00000,0,'PLN',4.22780,NULL,'Ava Trade EU Ltd.',0.00000),(159,'BNPFR','1 Lot= 1,000 Shares ',50.00000,1.00000,0.00100,6388.00,3.00000,1,'EUR',63.06000,NULL,'Ava Trade EU Ltd.',0.00000),(160,'EURDKK','1 Lot= 100,000 EUR',30.00000,1.34499,0.00010,250.00,4.00000,0,'DKK',7.43470,NULL,'Ava Trade EU Ltd.',0.00000),(162,'NASDAQ100','1 Lot= 100 Indexes',150.00000,25.00000,0.25000,2490.33,2.00000,1,'USD',5663.75000,NULL,'Ava Trade EU Ltd.',0.01000),(163,'GBPTRY','Great Britain Pound vs Turkish Lira',150.00000,0.24802,0.00001,284.79,5.00000,0,'TRY',4.58680,NULL,'Pepperstone Group Limited',0.00000),(166,'ELEES','1 Lot= 1,000 Shares (ENDESA)',25.00000,1.00000,0.00100,2028.00,3.00000,1,'EUR',20.23500,NULL,'Ava Trade EU Ltd.',0.00000),(167,'CN50','China A50 Index',170.00000,0.08791,0.10000,99.92,1.00000,1,'USD',11431.00000,NULL,'Pepperstone Group Limited',0.10000),(168,'XAUUSD','Gold vs US Dollar',17.00000,0.87911,0.01000,271.13,2.00000,0,'USD',1241.49000,NULL,'Pepperstone Group Limited',0.01000),(169,'AUDCAD','1 Lot= 100,000 AUD',60.00000,0.67713,0.00001,168.20,5.00000,0,'CAD',0.99714,NULL,'Ava Trade EU Ltd.',0.00000),(172,'EURSEK','1 Lot= 100,000 EUR',50.00000,1.03733,0.00010,250.00,4.00000,0,'SEK',9.62100,NULL,'Ava Trade EU Ltd.',0.00000),(175,'NZDUSD','1 Lot= 100,000 NZD',50.00000,0.87920,0.00001,160.25,5.00000,0,'USD',0.73310,NULL,'Ava Trade EU Ltd.',0.00000),(177,'PNCUSD','PNC ',0.00000,0.87920,0.00001,219.77,5.00000,0,'USD',0.01302,NULL,'Ava Trade EU Ltd.',0.00000),(178,'DJEUR50','1 Lot= 100 Indexes',2.00000,100.00000,1.00000,6930.00,0.00000,1,'EUR',3449.00000,NULL,'Ava Trade EU Ltd.',1.00000),(181,'BBVA','1 Lot= 10,000 Shares (BANC BILBAO)',22.00000,10.00000,0.00100,7429.00,3.00000,1,'EUR',7.27100,NULL,'Ava Trade EU Ltd.',0.00000),(182,'DJ30',' 1 Lot= 100 Indexes',4.00000,100.00000,1.00000,9397.39,0.00000,1,'USD',21332.00000,NULL,'Ava Trade EU Ltd.',1.00000),(183,'USDHUF','US Dollar vs Hungarian Forint',110.00000,0.32353,0.00100,219.78,3.00000,0,'HUF',270.33000,NULL,'Pepperstone Group Limited',0.00000),(185,'ITB','1 Lot= 1,000 Shares (US HOME CONST)',5.00000,10.00000,0.01000,1493.56,2.00000,1,'USD',33.45000,NULL,'Ava Trade EU Ltd.',0.01000),(189,'EURNOK','1 Lot= 100,000 EUR',40.00000,1.05157,0.00010,250.00,4.00000,0,'NOK',9.52660,NULL,'Ava Trade EU Ltd.',0.00000),(191,'POTASH','1 Lot= 1,000 Shares',11.00000,8.79198,0.01000,1438.18,2.00000,1,'USD',16.19000,NULL,'Ava Trade EU Ltd.',0.01000),(193,'HEATINGOIL','1 Lot= 100,000 Gallons',23.00000,10.00000,0.00010,2613.69,4.00000,1,'USD',1.48590,NULL,'Ava Trade EU Ltd.',0.00000),(194,'Cotton','Cotton Futures',350.00000,0.08791,0.00100,120.26,3.00000,1,'USD',68.41000,NULL,'Pepperstone Group Limited',0.00000),(200,'EWM','1 Lot= 1,000 Shares (MSCI MYS FUND)',5.00000,10.00000,0.01000,1395.54,2.00000,1,'USD',31.53000,NULL,'Ava Trade EU Ltd.',0.01000),(201,'CAT','1 Lot= 1,000 Shares',8.00000,10.00000,0.01000,9466.84,2.00000,1,'USD',105.65000,NULL,'Ava Trade EU Ltd.',0.01000),(202,'DISNEY','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,9356.07,2.00000,1,'USD',105.62000,NULL,'Ava Trade EU Ltd.',0.01000),(203,'AMERICANE','1 Lot= 1,000 Shares (EXP)',7.00000,10.00000,0.01000,7419.45,2.00000,1,'USD',83.66000,NULL,'Ava Trade EU Ltd.',0.01000),(205,'EURAUD','Euro vs Australian Dollar',11.00000,0.67276,0.00001,250.00,5.00000,0,'AUD',1.48552,NULL,'Pepperstone Group Limited',0.00000),(206,'INTESASAN','1 Lot= 10,000 Shares ',140.00000,1.00000,0.00010,2843.00,4.00000,1,'EUR',2.76300,NULL,'Ava Trade EU Ltd.',0.00000),(207,'TELECOMIT','1 Lot= 100,000 Shares ',45.00000,10.00000,0.00010,8085.00,4.00000,1,'EUR',0.80400,NULL,'Ava Trade EU Ltd.',0.00000),(208,'CADCHF','1 Lot= 100,000 CAD',50.00000,0.91429,0.00001,169.25,5.00000,0,'CHF',0.73869,NULL,'Ava Trade EU Ltd.',0.00000),(209,'GBPNOK','Great Britain Pound vs Norwegian Krone',397.00000,0.10514,0.00001,284.79,5.00000,0,'NOK',10.86550,NULL,'Pepperstone Group Limited',0.00000),(212,'FTSE100','1 Lot= 100 Indexes',15.00000,50.00000,0.50000,16568.53,1.00000,1,'GBP',7263.50000,NULL,'Ava Trade EU Ltd.',0.10000),(217,'EURCZK','Euro vs Czech Republic Koruna',730.00000,0.03829,0.00001,250.00,5.00000,0,'CZK',26.10305,NULL,'Pepperstone Group Limited',0.00000),(219,'BOEING','1 Lot= 1,000 Shares',8.00000,10.00000,0.01000,17424.29,2.00000,1,'USD',197.51000,NULL,'Ava Trade EU Ltd.',0.01000),(220,'EWZ','1 Lot= 1,000 Shares (MSCI BRA FUND)',5.00000,10.00000,0.01000,1501.03,2.00000,1,'USD',33.83000,NULL,'Ava Trade EU Ltd.',0.01000),(222,'USDJPY','1 Lot= 100,000 USD',30.00000,0.77803,0.00100,219.77,3.00000,0,'JPY',112.23000,NULL,'Ava Trade EU Ltd.',0.00000),(224,'NOKJPY','Norwegian Krone vs Japanese Yen',10.00000,0.77777,0.00100,262.83,3.00000,0,'JPY',13.46400,NULL,'Pepperstone Group Limited',0.00000),(225,'DEUTSCHEB','1 Lot= 1,000 Shares ',65.00000,1.00000,0.00100,1593.50,3.00000,1,'EUR',15.55500,NULL,'Ava Trade EU Ltd.',0.00000),(227,'USDCNH','US Dollar vs Chinese Yuan',92.00000,0.12939,0.00001,219.78,5.00000,0,'CNH',6.77783,NULL,'Pepperstone Group Limited',0.00000),(228,'UGFR','1 Lot= 1,000 Shares (PEUGEOT)',30.00000,1.00000,0.00100,1772.50,3.00000,1,'EUR',17.45500,NULL,'Ava Trade EU Ltd.',0.00000),(229,'EURZAR','Euro vs South African Rand',650.00000,0.06667,0.00001,250.00,5.00000,0,'ZAR',14.92290,NULL,'Pepperstone Group Limited',0.00000),(230,'SILVER','1 Lot= 10,000 Troy Oz',50.00000,10.00000,0.00100,2901.50,3.00000,1,'USD',16.58100,NULL,'Ava Trade EU Ltd.',0.00000),(232,'UK100','FTSE 100',10.00000,0.11392,0.10000,41.80,1.00000,1,'GBP',7326.80000,NULL,'Pepperstone Group Limited',0.10000),(233,'US30','US Wall Street 30',30.00000,0.08791,0.10000,94.28,1.00000,1,'USD',21392.00000,NULL,'Pepperstone Group Limited',0.10000),(239,'CHFHUF','1 Lot= 100,000 CHF',40.00000,3.23918,0.01000,228.53,2.00000,0,'HUF',281.49000,NULL,'Ava Trade EU Ltd.',0.01000),(241,'BASDE','1 Lot= 1,000 Shares (BASF)',70.00000,1.00000,0.00100,8213.50,3.00000,1,'EUR',81.49500,NULL,'Ava Trade EU Ltd.',0.00000),(244,'HK50','Hang Seng 50',80.00000,0.01126,0.10000,29.00,1.00000,1,'HKD',25767.00000,NULL,'Pepperstone Group Limited',0.10000),(245,'APPLE','1 Lot= 100 Shares',13.00000,1.00000,0.01000,634.43,2.00000,1,'USD',143.64000,NULL,'Ava Trade EU Ltd.',0.01000),(249,'RIOUK','1 Lot= 1,000 Shares (RIO TINTO)',450.00000,0.11395,0.01000,3765.99,2.00000,1,'PNC',3236.00000,NULL,'Ava Trade EU Ltd.',0.01000),(257,'GSKUK','1 Lot= 10,000 Shares ',240.00000,1.13946,0.01000,18544.56,2.00000,1,'PNC',1632.80000,NULL,'Ava Trade EU Ltd.',0.01000),(261,'AUS200','S&P/ASX200 Index',19.00000,0.06728,0.10000,19.17,1.00000,1,'AUD',5717.10000,NULL,'Pepperstone Group Limited',0.10000),(267,'EWH','1 Lot= 1,000 Shares (MSCI HK FUND)',5.00000,10.00000,0.01000,1032.04,2.00000,1,'USD',23.45000,NULL,'Ava Trade EU Ltd.',0.01000),(268,'BTCMini','1 Lot= 10 BTC',2267.00000,0.08792,0.01000,1085.13,2.00000,1,'USD',2411.66000,NULL,'Ava Trade EU Ltd.',0.01000),(270,'SEKJPY','Swedish Krona vs Japanese Yen',50.00000,0.77777,0.00100,259.32,3.00000,0,'JPY',13.31100,NULL,'Pepperstone Group Limited',0.00000),(271,'IBEX35','1 Lot= 100 Indexes',5.00000,100.00000,1.00000,21022.00,0.00000,1,'EUR',10451.00000,NULL,'Ava Trade EU Ltd.',1.00000),(272,'GE','1 Lot= 1,000 Shares (GEN. ELEC)',7.00000,10.00000,0.01000,2382.31,2.00000,1,'USD',26.98000,NULL,'Ava Trade EU Ltd.',0.01000),(274,'Copper','Copper (Futures)',51.00000,0.00010,0.00010,93.43,4.00000,1,'USD',2.58670,NULL,'Pepperstone Group Limited',0.00000),(283,'YAHOO','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Ava Trade EU Ltd.',0.00000),(284,'IBERDROLA','1 Lot= 10,000 Shares ',62.00000,10.00000,0.00100,6950.00,3.00000,1,'EUR',6.91600,NULL,'Ava Trade EU Ltd.',0.00000),(285,'FCAIT','1 Lot= 10,000 Shares (FIAT)',180.00000,1.00000,0.00010,9584.00,4.00000,1,'EUR',9.27100,NULL,'Ava Trade EU Ltd.',0.00000),(286,'XLB','1 Lot= 1,000 Shares (MATERIAL SPDR)',5.00000,10.00000,0.01000,2369.13,2.00000,1,'USD',53.53000,NULL,'Ava Trade EU Ltd.',0.01000),(576,'HSI','1 Lot= 100 Indexes',11.00000,100.00000,1.00000,5783.24,0.00000,1,'HKD',25630.00000,NULL,'Ava Trade EU Ltd.',1.00000),(582,'CHFSGD','Swiss Frank vs Singapore Dollar',70.00000,0.63620,0.00001,228.54,5.00000,0,'SGD',1.43562,NULL,'Pepperstone Group Limited',0.00000),(587,'GBPHUF','1 Lot= 100,000 GBP',60.00000,3.23918,0.01000,284.74,2.00000,0,'HUF',351.32000,NULL,'Ava Trade EU Ltd.',0.01000),(591,'DAX30','1 Lot= 10 Indexes',20.00000,5.00000,0.50000,2479.60,1.00000,1,'EUR',12368.00000,NULL,'Ava Trade EU Ltd.',0.10000),(592,'COCACOLA','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,3579.62,2.00000,1,'USD',40.53000,NULL,'Ava Trade EU Ltd.',0.01000),(597,'GASOLINE','1 Lot= 100,000 Gallons',16.00000,10.00000,0.00010,2652.54,4.00000,1,'USD',1.51000,NULL,'Ava Trade EU Ltd.',0.00000),(598,'MANU','1 Lot= 1,000 Shares',20.00000,10.00000,0.01000,1559.49,2.00000,1,'USD',17.27000,NULL,'Ava Trade EU Ltd.',0.01000),(599,'SIEMENS','1 Lot= 1,000 Shares ',180.00000,1.00000,0.00100,12184.00,3.00000,1,'EUR',120.51000,NULL,'Ava Trade EU Ltd.',0.00000),(601,'SPA35','Spain 35',80.00000,0.10000,0.10000,105.42,1.00000,1,'EUR',10483.00000,NULL,'Pepperstone Group Limited',0.10000),(604,'AUDCHF','1 Lot= 100,000 AUD',80.00000,0.91429,0.00001,168.20,5.00000,0,'CHF',0.73665,NULL,'Ava Trade EU Ltd.',0.00000),(605,'USDCAD','US Dollar vs Canadian Dollar',5.00000,0.67702,0.00001,219.78,5.00000,0,'CAD',1.29638,NULL,'Pepperstone Group Limited',0.00000),(611,'FXI','1 Lot= 1,000 Shares (MSCI CHN FUND)',5.00000,10.00000,0.01000,1745.86,2.00000,1,'USD',39.58000,NULL,'Ava Trade EU Ltd.',0.01000),(612,'AALUK','1 Lot= 1,000 Shares (ANGLO AMER)',250.00000,0.11394,0.01000,1193.98,2.00000,1,'PNC',1024.00000,NULL,'Ava Trade EU Ltd.',0.01000),(614,'XBRUSD','US Dollar vs Brent Oil',7.00000,0.87911,0.01000,53.35,2.00000,0,'USD',48.95000,NULL,'Pepperstone Group Limited',0.01000),(615,'ANAES','1 Lot= 1,000 Shares (ACCIONA)',190.00000,1.00000,0.00100,7618.00,3.00000,1,'EUR',77.09000,NULL,'Ava Trade EU Ltd.',0.00000),(616,'GENERALI','1 Lot= 10,000 Shares ',500.00000,1.00000,0.00010,14550.00,4.00000,1,'EUR',14.39000,NULL,'Ava Trade EU Ltd.',0.00000),(618,'BNFR','1 Lot= 1,000 Shares (DANONE)',80.00000,1.00000,0.00100,6645.00,3.00000,1,'EUR',65.99000,NULL,'Ava Trade EU Ltd.',0.00000),(619,'EXXONMOBIL','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,7106.50,2.00000,1,'USD',80.55000,NULL,'Ava Trade EU Ltd.',0.01000),(622,'XTIUSD','US Dollar vs Crude Oil',5.00000,0.87911,0.01000,50.55,2.00000,0,'USD',46.40000,NULL,'Pepperstone Group Limited',0.01000),(623,'NATURALGAS','1 Lot= 10,000 mmBtu',5.00000,10.00000,0.00100,523.76,3.00000,1,'USD',2.95200,NULL,'Ava Trade EU Ltd.',0.00000),(626,'XAGEUR','Silver vs Euro',28.00000,5.00000,0.00100,181.30,3.00000,0,'EUR',14.52000,NULL,'Pepperstone Group Limited',0.00000),(627,'TELEFONICA','1 Lot= 10,000 Shares ',22.00000,10.00000,0.00100,9206.00,3.00000,1,'EUR',9.02200,NULL,'Ava Trade EU Ltd.',0.00000),(636,'JNJ','1 Lot= 1,000 Shares (JONS&JONS)',8.00000,10.00000,0.01000,11655.75,2.00000,1,'USD',132.66000,NULL,'Ava Trade EU Ltd.',0.01000),(640,'EWY','1 Lot= 1,000 Shares (MSCI ROK FUND)',5.00000,10.00000,0.01000,2980.97,2.00000,1,'USD',67.28000,NULL,'Ava Trade EU Ltd.',0.01000),(641,'FTSEMIB40','1 Lot= 10 Indexes',15.00000,50.00000,5.00000,4170.00,0.00000,1,'EUR',20505.00000,NULL,'Ava Trade EU Ltd.',1.00000),(643,'ACFR','1 Lot= 1,000 Shares (ACCOR)',30.00000,1.00000,0.00100,4101.00,3.00000,1,'EUR',41.04500,NULL,'Ava Trade EU Ltd.',0.00000),(647,'EURSGD','Euro vs Singapore Dollar',29.00000,0.63620,0.00001,250.00,5.00000,0,'SGD',1.57223,NULL,'Pepperstone Group Limited',0.00000),(648,'30YTBOND','1 Lot= 1,000 Contracts',6.00000,10.00000,0.01000,1348.69,2.00000,1,'USD',153.42000,NULL,'Ava Trade EU Ltd.',0.01000),(651,'XAGUSD','Silver vs US Dollar',17.00000,4.39557,0.00100,181.13,3.00000,0,'USD',16.60900,NULL,'Pepperstone Group Limited',0.00000),(653,'MORGANSTA','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,3927.74,2.00000,1,'USD',44.73000,NULL,'Ava Trade EU Ltd.',0.01000),(660,'INTEL','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,2972.18,2.00000,1,'USD',33.53000,NULL,'Ava Trade EU Ltd.',0.01000),(664,'TWITTER','1 Lot= 100 Shares ',7.00000,1.00000,0.01000,157.44,2.00000,1,'USD',17.62000,NULL,'Ava Trade EU Ltd.',0.01000),(667,'OrangeJuice','Orange Juice Futures',100.00000,0.17582,0.01000,46.82,2.00000,1,'USD',133.75000,NULL,'Pepperstone Group Limited',0.01000),(673,'EWS','1 Lot= 1,000 Shares (MSCI SGP FUND)',5.00000,10.00000,0.01000,1040.83,2.00000,1,'USD',23.74000,NULL,'Ava Trade EU Ltd.',0.01000),(679,'USDX','US Dollar Futures',90.00000,0.01000,0.01000,84.25,3.00000,1,'USD',95.35000,NULL,'Pepperstone Group Limited',0.00000),(680,'SOYBEAN','1 Lot= 100 Units',150.00000,25.00000,0.25000,2554.17,2.00000,1,'USD',946.75000,NULL,'Ava Trade EU Ltd.',0.01000),(684,'PMIIT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ava Trade EU Ltd.',NULL),(688,'USDILS','1 Lot= 100,000 USD',35.00000,2.51800,0.00010,879.08,4.00000,0,'ILS',3.49240,NULL,'Ava Trade EU Ltd.',0.00000),(689,'ITXES','1 Lot= 1,000 Shares (INDITEX)',65.00000,1.00000,0.00100,3380.50,3.00000,1,'EUR',33.67000,NULL,'Ava Trade EU Ltd.',0.00000),(692,'GLEFR','1 Lot= 1,000 Shares (SOC GEN)',45.00000,1.00000,0.00100,4781.50,3.00000,1,'EUR',47.18000,NULL,'Ava Trade EU Ltd.',0.00000),(694,'USDHKD','1 Lot= 100,000 USD',8.00000,1.12601,0.00010,219.77,4.00000,0,'HKD',7.80610,NULL,'Ava Trade EU Ltd.',0.00000),(705,'Coffee','Coffee Futures',90.00000,0.08791,0.01000,22.56,2.00000,1,'USD',125.58000,NULL,'Pepperstone Group Limited',0.01000),(709,'XLF','1 Lot= 1,000 Shares (FINANCE SPDR)',5.00000,10.00000,0.01000,1086.99,2.00000,1,'USD',24.66000,NULL,'Ava Trade EU Ltd.',0.01000),(710,'BAYER','1 Lot= 1,000 Shares ',110.00000,1.00000,0.00100,11153.00,3.00000,1,'EUR',113.17000,NULL,'Ava Trade EU Ltd.',0.00000),(714,'CITIGROUP','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,5894.25,2.00000,1,'USD',67.01000,NULL,'Ava Trade EU Ltd.',0.01000),(719,'TESLA','1 Lot= 100 Shares ',12.00000,10.00000,0.01000,1592.06,2.00000,1,'USD',360.97000,NULL,'Ava Trade EU Ltd.',0.01000),(720,'MASTERCARD','1 Lot= 100 Shares',8.00000,1.00000,0.01000,1068.17,2.00000,1,'USD',121.55000,NULL,'Ava Trade EU Ltd.',0.01000),(722,'SP500','1 Lot= 100 Indexes',50.00000,25.00000,0.25000,1067.54,2.00000,1,'USD',2424.25000,NULL,'Ava Trade EU Ltd.',0.01000),(726,'BLTUK','1 Lot= 1,000 Shares (BHP)',300.00000,0.11394,0.01000,1362.02,2.00000,1,'PNC',1174.00000,NULL,'Ava Trade EU Ltd.',0.01000),(728,'TESCOUK','1 Lot= 100,000 Shares',30.00000,11.39461,0.01000,19140.42,2.00000,1,'PNC',168.50000,NULL,'Ava Trade EU Ltd.',0.01000),(733,'EEM','1 Lot= 1,000 Shares (MSCI EM FUND)',5.00000,10.00000,0.01000,1820.14,2.00000,1,'USD',41.17000,NULL,'Ava Trade EU Ltd.',0.01000),(740,'WHEAT','1 Lot= 100 Units',50.00000,25.00000,0.25000,1418.18,2.00000,1,'USD',525.50000,NULL,'Ava Trade EU Ltd.',0.01000),(745,'WALMART','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,6659.05,2.00000,1,'USD',75.80000,NULL,'Ava Trade EU Ltd.',0.01000),(752,'GDX','1 Lot= 1,000 Shares (GOLD MINERS)',5.00000,10.00000,0.01000,970.07,2.00000,1,'USD',21.94000,NULL,'Ava Trade EU Ltd.',0.01000),(753,'BOA','1 Lot= 1,000 Shares (B. OF AMERICA)',7.00000,10.00000,0.01000,2142.32,2.00000,1,'USD',24.28000,NULL,'Ava Trade EU Ltd.',0.01000),(754,'PG','1 Lot= 1,000 Shares (PROC & GAMB)',7.00000,10.00000,0.01000,7676.15,2.00000,1,'USD',86.99000,NULL,'Ava Trade EU Ltd.',0.01000),(759,'SMI','1 Lot= 100 Indexes',3.00000,100.00000,1.00000,16370.18,0.00000,1,'CHF',8924.00000,NULL,'Ava Trade EU Ltd.',1.00000),(764,'US2000','Russell 2000 Index',3.00000,0.08791,0.10000,12.45,1.00000,1,'USD',1412.00000,NULL,'Pepperstone Group Limited',0.10000),(778,'VISA','1 Lot= 100 Shares',7.00000,1.00000,0.01000,825.72,2.00000,1,'USD',94.40000,NULL,'Ava Trade EU Ltd.',0.01000),(780,'DAIDE','1 Lot= 1,000 Shares (DAIMLER)',40.00000,1.00000,0.00100,6391.50,3.00000,1,'EUR',63.27500,NULL,'Ava Trade EU Ltd.',0.00000),(782,'MSCITAIWAN','1 Lot= 1,000 Indexes',2.00000,100.00000,0.10000,6807.61,1.00000,1,'USD',385.30000,NULL,'Ava Trade EU Ltd.',0.10000),(783,'GM','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,3079.43,2.00000,1,'USD',34.85000,NULL,'Ava Trade EU Ltd.',0.01000),(784,'NOKSEK','Norwegian Krone vs Swedish Krona',50.00000,0.10374,0.00001,262.83,5.00000,0,'SEK',1.00865,NULL,'Pepperstone Group Limited',0.00000),(787,'USDDKK','1 Lot= 100,000 USD',20.00000,1.34499,0.00010,219.77,4.00000,0,'DKK',6.50870,NULL,'Ava Trade EU Ltd.',0.00000),(790,'EURRUB','1 Lot= 100,000 EUR',900.00000,0.14850,0.00010,5000.00,4.00000,0,'RUB',67.45780,NULL,'Ava Trade EU Ltd.',0.00000),(797,'EFA','1 Lot= 1,000 Shares (MSCI EAFE)',5.00000,10.00000,0.01000,2867.57,2.00000,1,'USD',65.12000,NULL,'Ava Trade EU Ltd.',0.01000),(800,'BATSUK','1 Lot= 1,000 Shares ',400.00000,0.11394,0.01000,5945.39,2.00000,1,'PNC',5238.50000,NULL,'Ava Trade EU Ltd.',0.01000),(801,'LTCMini','1 Lot= 100 LTC',53.00000,0.01000,0.01000,791.17,2.00000,1,'USD',39.64000,NULL,'Ava Trade EU Ltd.',0.01000),(808,'CHECKPOINT','1 Lot= 1,000 Shares',8.00000,8.79198,0.01000,9598.70,2.00000,1,'USD',109.63000,NULL,'Ava Trade EU Ltd.',0.01000),(813,'SPMIT','1 Lot= 1,000 Shares (SAIPEM)',100.00000,0.10000,0.00010,330.70,4.00000,1,'EUR',3.21300,NULL,'Ava Trade EU Ltd.',0.00000),(817,'BRENTOIL','1 Lot= 1,000 Barrels',4.00000,10.00000,0.01000,429.17,2.00000,1,'USD',48.97000,NULL,'Ava Trade EU Ltd.',0.01000),(830,'EUSTX50','EU Stock 50',20.00000,0.10000,0.10000,34.74,1.00000,1,'EUR',3455.30000,NULL,'Pepperstone Group Limited',0.10000),(835,'ACAFR','1 Lot= 1,000 Shares (CREDT AGRI)',20.00000,1.00000,0.00100,1441.00,3.00000,1,'EUR',14.12000,NULL,'Ava Trade EU Ltd.',0.00000),(836,'ZARJPY','South African Rand vs Japanese Yen',10.00000,0.77777,0.00100,166.65,3.00000,0,'JPY',8.56800,NULL,'Pepperstone Group Limited',0.00000),(840,'TOTAL','1 Lot= 1,000 Shares ',45.00000,1.00000,0.00100,4407.00,3.00000,1,'EUR',43.27000,NULL,'Ava Trade EU Ltd.',0.00000),(863,'USDCNY','1 Lot= 100,000 USD',50.00000,1.29440,0.00010,1758.16,4.00000,0,'CNY',6.77460,NULL,'Ava Trade EU Ltd.',0.00000),(872,'CISCO','1 Lot= 1,000 Shares',7.00000,10.00000,0.01000,2758.56,2.00000,1,'USD',31.40000,NULL,'Ava Trade EU Ltd.',0.01000),(892,'SGDJPY','Singapore Dollar vs Japanese Yen',10.00000,0.77777,0.00100,159.04,3.00000,0,'JPY',81.61800,NULL,'Pepperstone Group Limited',0.00000),(903,'VKFR','1 Lot= 1,000 Shares (VALLOUREC)',46.00000,1.00000,0.00100,548.80,3.00000,1,'EUR',5.30000,NULL,'Ava Trade EU Ltd.',0.00000),(921,'GER30','Germany 30',10.00000,0.10000,0.10000,62.03,1.00000,1,'EUR',12373.90000,NULL,'Pepperstone Group Limited',0.10000),(931,'XLE','1 Lot= 1,000 Shares (ENERGY SPDR)',5.00000,10.00000,0.01000,2854.82,2.00000,1,'USD',64.58000,NULL,'Ava Trade EU Ltd.',0.01000),(968,'BMWDE','1 Lot= 1,000 Shares ',70.00000,1.00000,0.00100,8236.00,3.00000,1,'EUR',81.27000,NULL,'Ava Trade EU Ltd.',0.00000),(1043,'JAPANBOND','1 Lot= 100,000 Contracts',9.00000,1000.00000,0.01000,1168.49,2.00000,1,'JPY',150.11000,NULL,'Ava Trade EU Ltd.',0.01000),(1044,'SANOFI','1 Lot= 1,000 Shares ',80.00000,1.00000,0.00100,8406.00,3.00000,1,'EUR',84.07000,NULL,'Ava Trade EU Ltd.',0.00000),(1069,'NIKKEI225','1 Lot= 10,000 Indexes',20.00000,50000.00000,5.00000,31334.11,0.00000,1,'JPY',20025.00000,NULL,'Ava Trade EU Ltd.',1.00000),(1077,'ENGIEFR','1 Lot= 1,000 Shares',25.00000,1.00000,0.00100,1337.50,3.00000,1,'EUR',13.21000,NULL,'Ava Trade EU Ltd.',0.00000),(1102,'AEX','1 Lot= 100 Indexes',15.00000,5.00000,0.05000,510.15,2.00000,1,'EUR',509.20000,NULL,'Ava Trade EU Ltd.',0.01000),(165132,'USDCLP','1 Lot = 100,000 USD ',100.00000,1.32599,0.01000,219.77,2.00000,0,'CLP',662.96000,NULL,'Ava Trade EU Ltd.',0.01000),(165201,'SNAPCHAT','1 Lot= 1,000 Shares ',7.00000,10.00000,0.01000,784.14,2.00000,1,'USD',17.86000,NULL,'Ava Trade EU Ltd.',0.01000),(210932,'M1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ava Trade EU Ltd.',NULL),(220473,'AI50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ava Trade EU Ltd.',NULL),(381152,'Bitcoin','Bitcoin vs US Dollar',100.00000,0.08791,0.10000,109.65,1.00000,1,'USD',2510.30000,NULL,'Pepperstone Group Limited',0.10000),(384090,'DASHWeekly','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Ava Trade EU Ltd.',0.00000),(384091,'XRP','1 Lot= 100,000 RIPPLE',30.00000,8.79198,0.00010,4314.54,4.00000,1,'USD',0.24470,NULL,'Ava Trade EU Ltd.',0.00000),(384146,'ETHWeekly','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Ava Trade EU Ltd.',0.00000),(384276,'XRPWeekly','',0.00000,0.00000,0.00000,0.00,0.00000,0,'',0.00000,NULL,'Ava Trade EU Ltd.',0.00000),(384384,'ETH','1 Lot= 100 ETH',387.00000,0.87920,0.01000,2403.94,2.00000,1,'USD',275.98000,NULL,'Ava Trade EU Ltd.',0.01000),(384560,'DASH','1 Lot= 100 DSH',250.00000,0.87920,0.01000,3034.42,2.00000,1,'USD',167.65000,NULL,'Ava Trade EU Ltd.',0.01000),(489395,'ETCUSD','1 Lot= 100 ETH',40.00000,0.87920,0.01000,295.55,2.00000,1,'USD',16.85000,NULL,'Ava Trade EU Ltd.',0.01000),(489739,'BTCEUR','1 Lot= 10 BTC',3113.00000,0.10000,0.01000,1101.33,2.00000,1,'EUR',2162.75000,NULL,'Ava Trade EU Ltd.',0.01000);
/*!40000 ALTER TABLE `collector_symbols` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-07-03 13:46:13