PREVIEW / futures_daily / 2015-11-24
file: by_date/futures_daily/2015/2015-11-24.parquet size: 9 KB rows: 108
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-11-24 | ES | Futures | 2215.79 | 2224.84 | 2197.18 | 2217.66 | 1517871.0 |
| 2015-11-24 | NQ | Futures | 5464.59 | 5477.16 | 5401.74 | 5455.53 | 230131.0 |
| 2015-11-24 | YM | Futures | 18319.2 | 18396.6 | 18183.0 | 18329.5 | 132919.0 |
| 2015-11-24 | CL | Futures | 64.93 | 67.12 | 64.65 | 66.21 | 430304.0 |
| 2015-11-24 | GC | Futures | 1379.3 | 1395.1 | 1378.8 | 1386.2 | 158532.0 |
| 2015-11-24 | ZN | Futures | 121.521251 | 121.835569 | 121.431446 | 121.566153 | 2364395.0 |
| 2015-11-24 | A6 | Futures | 0.71883 | 0.72513 | 0.71793 | 0.72403 | 79845.0 |
| 2015-11-24 | AD | Futures | 0.76625 | 0.77097 | 0.76564 | 0.77056 | 57486.0 |
| 2015-11-24 | ALI | Futures | 2080.97 | 2080.97 | 2080.97 | 2080.97 | 0.0 |
| 2015-11-24 | B | Futures | 39.79 | 41.02 | 39.62 | 40.68 | 271930.0 |
| 2015-11-24 | B6 | Futures | 1.5924 | 1.5958 | 1.5852 | 1.589 | 72326.0 |
| 2015-11-24 | BFX | Futures | 4453.1 | 4455.6 | 4419.7 | 4453.7 | 55.0 |
| 2015-11-24 | BR | Futures | 0.16491 | 0.16491 | 0.16491 | 0.16491 | 163.0 |
| 2015-11-24 | BZ | Futures | 39.58 | 40.76 | 39.39 | 40.42 | 32819.0 |
| 2015-11-24 | C | Futures | 2415.0 | 2437.0 | 2413.0 | 2435.0 | 13773.0 |
| 2015-11-24 | CB | Futures | 242.444 | 242.753 | 241.207 | 241.207 | 15.0 |
| 2015-11-24 | CC | Futures | 2453.0 | 2469.0 | 2442.0 | 2461.0 | 12653.0 |
| 2015-11-24 | CNH | Futures | 7.1532 | 7.1559 | 7.1473 | 7.1478 | 143.0 |
| 2015-11-24 | CSC | Futures | 4.081 | 4.081 | 4.04 | 4.047 | 123.0 |
| 2015-11-24 | CT | Futures | 72.17 | 72.96 | 72.17 | 72.55 | 10970.0 |
| 2015-11-24 | DC | Futures | 32.59 | 32.59 | 32.18 | 32.29 | 95.0 |
| 2015-11-24 | DX | Futures | 93.325 | 93.381 | 93.072 | 93.143 | 23234.0 |
| 2015-11-24 | E1 | Futures | 1.24599 | 1.25106 | 1.2451 | 1.25055 | 21290.0 |
| 2015-11-24 | E6 | Futures | 1.24594 | 1.25074 | 1.2443 | 1.24863 | 192624.0 |
| 2015-11-24 | E7 | Futures | 1.2393 | 1.2438 | 1.2374 | 1.2417 | 3589.0 |
| 2015-11-24 | EBM | Futures | 258.69 | 259.05 | 257.22 | 257.22 | 18720.0 |
| 2015-11-24 | ED | Futures | 95.6631 | 95.6655 | 95.6511 | 95.6583 | 284761.0 |
| 2015-11-24 | ER | Futures | 98.264 | 98.269 | 98.249 | 98.254 | 70650.0 |
| 2015-11-24 | EW | Futures | 1529.3 | 1541.3 | 1516.1 | 1537.2 | 23175.0 |
| 2015-11-24 | FBON | Futures | 116.16 | 116.32 | 116.06 | 116.17 | 1075.0 |
| 2015-11-24 | FBTP | Futures | 105.31 | 105.52 | 105.17 | 105.4 | 78289.0 |
| 2015-11-24 | FBTS | Futures | 100.722 | 100.758 | 100.704 | 100.749 | 17199.0 |
| 2015-11-24 | FCE | Futures | 4075.3 | 4078.2 | 3986.7 | 4026.4 | 128548.0 |
| 2015-11-24 | FDAX | Futures | 12193.2 | 12206.5 | 11968.6 | 12025.8 | 116852.0 |
| 2015-11-24 | FDXM | Futures | 11389.0 | 11402.3 | 11184.2 | 11235.6 | 17828.0 |
| 2015-11-24 | FESX | Futures | 2573.7 | 2577.4 | 2527.9 | 2552.7 | 1484628.0 |
| 2015-11-24 | FGBL | Futures | 140.26 | 140.6 | 140.09 | 140.41 | 700489.0 |
| 2015-11-24 | FGBM | Futures | 126.08 | 126.18 | 125.95 | 126.05 | 502116.0 |
| 2015-11-24 | FGBS | Futures | 111.573 | 111.598 | 111.523 | 111.548 | 356251.0 |
| 2015-11-24 | FGBX | Futures | 159.63 | 160.55 | 158.83 | 159.34 | 34675.0 |
| 2015-11-24 | FMWO | Futures | 5670.6 | 5670.6 | 5631.1 | 5655.8 | 468.0 |
| 2015-11-24 | FOAT | Futures | 128.74 | 129.08 | 128.63 | 128.92 | 79369.0 |
| 2015-11-24 | FTDX | Futures | 1731.1 | 1732.0 | 1695.1 | 1700.7 | 353.0 |
| 2015-11-24 | FTI | Futures | 403.55 | 403.98 | 395.47 | 400.86 | 51163.0 |
| 2015-11-24 | FTUK | Futures | 5059.4 | 5075.5 | 5000.7 | 5046.5 | 103457.0 |
| 2015-11-24 | FVSA | Futures | 2082.28 | 2191.13 | 2082.28 | 2139.07 | 10839.0 |
| 2015-11-24 | FXXP | Futures | 295.2 | 295.2 | 290.3 | 292.4 | 26569.0 |
| 2015-11-24 | G | Futures | 104.41 | 104.73 | 104.37 | 104.5 | 322790.0 |
| 2015-11-24 | GF | Futures | 317.916 | 323.031 | 314.924 | 317.868 | 3867.0 |
| 2015-11-24 | GSCI | Futures | 542.04 | 546.08 | 542.04 | 544.57 | 20.0 |
> showing 50 of 108 rows — these rows as CSV