PREVIEW / futures_daily / 2015-01-23
file: by_date/futures_daily/2015/2015-01-23.parquet size: 9 KB rows: 107
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2015-01-23 | ES | Futures | 2155.48 | 2161.76 | 2140.54 | 2142.37 | 1353089.0 |
| 2015-01-23 | NQ | Futures | 4949.22 | 4973.3 | 4931.53 | 4950.96 | 227200.0 |
| 2015-01-23 | YM | Futures | 18066.8 | 18123.8 | 17899.7 | 17913.0 | 133884.0 |
| 2015-01-23 | CL | Futures | 89.61 | 91.78 | 86.88 | 87.61 | 374289.0 |
| 2015-01-23 | GC | Futures | 1703.6 | 1705.4 | 1681.0 | 1691.9 | 149213.0 |
| 2015-01-23 | ZN | Futures | 121.836893 | 122.49937 | 121.748562 | 122.175492 | 1179367.0 |
| 2015-01-23 | A6 | Futures | 0.78298 | 0.78631 | 0.76937 | 0.77397 | 124876.0 |
| 2015-01-23 | AD | Futures | 0.82125 | 0.82339 | 0.81687 | 0.81901 | 57843.0 |
| 2015-01-23 | ALI | Futures | 2825.25 | 2825.25 | 2825.25 | 2825.25 | 6.0 |
| 2015-01-23 | B | Futures | 49.55 | 50.44 | 49.2 | 49.44 | 109643.0 |
| 2015-01-23 | B6 | Futures | 1.5774 | 1.5805 | 1.5715 | 1.5784 | 103427.0 |
| 2015-01-23 | BFX | Futures | 4195.3 | 4246.0 | 4195.3 | 4230.3 | 53.0 |
| 2015-01-23 | BR | Futures | 0.21388 | 0.21388 | 0.21057 | 0.21167 | 475.0 |
| 2015-01-23 | BZ | Futures | 49.82 | 50.17 | 49.14 | 49.32 | 21518.0 |
| 2015-01-23 | C | Futures | 2131.0 | 2148.0 | 2113.0 | 2114.0 | 7976.0 |
| 2015-01-23 | CB | Futures | 132.612 | 134.399 | 132.612 | 134.399 | 8.0 |
| 2015-01-23 | CC | Futures | 2055.0 | 2067.0 | 2032.0 | 2033.0 | 22050.0 |
| 2015-01-23 | CNH | Futures | 7.1054 | 7.1436 | 7.1054 | 7.1436 | 23.0 |
| 2015-01-23 | CSC | Futures | 4.29 | 4.319 | 4.262 | 4.29 | 19.0 |
| 2015-01-23 | CT | Futures | 73.78 | 74.93 | 72.86 | 73.18 | 20389.0 |
| 2015-01-23 | DC | Futures | 33.89 | 34.31 | 33.71 | 34.22 | 160.0 |
| 2015-01-23 | DX | Futures | 89.375 | 90.658 | 89.309 | 89.975 | 57849.0 |
| 2015-01-23 | E1 | Futures | 1.47356 | 1.47765 | 1.45441 | 1.46067 | 15623.0 |
| 2015-01-23 | E6 | Futures | 1.33752 | 1.33846 | 1.30788 | 1.3234 | 382010.0 |
| 2015-01-23 | E7 | Futures | 1.3297 | 1.3302 | 1.3001 | 1.3155 | 11687.0 |
| 2015-01-23 | EBM | Futures | 321.57 | 323.6 | 320.76 | 321.98 | 16680.0 |
| 2015-01-23 | ED | Futures | 95.4594 | 95.4641 | 95.4546 | 95.4546 | 97424.0 |
| 2015-01-23 | ER | Futures | 98.053 | 98.058 | 98.043 | 98.053 | 44138.0 |
| 2015-01-23 | EW | Futures | 1527.1 | 1532.4 | 1516.0 | 1517.0 | 16962.0 |
| 2015-01-23 | FBTP | Futures | 101.33 | 102.36 | 101.32 | 101.48 | 151075.0 |
| 2015-01-23 | FBTS | Futures | 99.218 | 99.306 | 99.173 | 99.191 | 25782.0 |
| 2015-01-23 | FCE | Futures | 3749.4 | 3813.8 | 3739.6 | 3785.7 | 168499.0 |
| 2015-01-23 | FDAX | Futures | 11657.0 | 11891.8 | 11642.0 | 11839.1 | 158269.0 |
| 2015-01-23 | FESX | Futures | 2413.0 | 2459.1 | 2410.1 | 2439.0 | 1743885.0 |
| 2015-01-23 | FEU3 | Futures | 98.67 | 98.67 | 98.67 | 98.67 | 29.0 |
| 2015-01-23 | FGBL | Futures | 138.18 | 139.16 | 138.07 | 138.98 | 820234.0 |
| 2015-01-23 | FGBM | Futures | 124.02 | 124.27 | 124.0 | 124.23 | 512435.0 |
| 2015-01-23 | FGBS | Futures | 111.123 | 111.133 | 111.093 | 111.113 | 293916.0 |
| 2015-01-23 | FGBX | Futures | 162.49 | 166.54 | 162.39 | 164.59 | 36488.0 |
| 2015-01-23 | FMWO | Futures | 5634.7 | 5645.9 | 5613.7 | 5633.5 | 891.0 |
| 2015-01-23 | FOAT | Futures | 127.61 | 128.33 | 127.49 | 127.97 | 109627.0 |
| 2015-01-23 | FTDX | Futures | 1388.5 | 1396.5 | 1380.1 | 1389.5 | 311.0 |
| 2015-01-23 | FTI | Futures | 389.12 | 394.58 | 388.0 | 392.11 | 57117.0 |
| 2015-01-23 | FTUK | Futures | 5273.8 | 5292.5 | 5252.0 | 5276.9 | 95957.0 |
| 2015-01-23 | FVSA | Futures | 1941.25 | 2010.12 | 1889.59 | 1979.99 | 11302.0 |
| 2015-01-23 | FXXP | Futures | 276.7 | 280.8 | 276.1 | 279.0 | 14373.0 |
| 2015-01-23 | G | Futures | 105.33 | 105.88 | 105.31 | 105.61 | 200618.0 |
| 2015-01-23 | GF | Futures | 346.799 | 347.052 | 340.472 | 340.472 | 3708.0 |
| 2015-01-23 | GSCI | Futures | 658.91 | 660.72 | 653.57 | 654.6 | 64.0 |
| 2015-01-23 | HE | Futures | 96.123 | 96.492 | 93.909 | 94.781 | 24031.0 |
> showing 50 of 107 rows — these rows as CSV