PREVIEW / futures_daily / 2018-10-16
file: by_date/futures_daily/2018/2018-10-16.parquet size: 10 KB rows: 115
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-16 | ES | Futures | 2979.69 | 3057.24 | 2977.53 | 3055.88 | 1780311.0 |
| 2018-10-16 | NQ | Futures | 8209.95 | 8545.93 | 8204.44 | 8541.57 | 614355.0 |
| 2018-10-16 | YM | Futures | 26500.9 | 27173.8 | 26500.9 | 27149.6 | 250411.0 |
| 2018-10-16 | CL | Futures | 74.55 | 75.18 | 73.86 | 74.78 | 249389.0 |
| 2018-10-16 | GC | Futures | 1559.6 | 1566.4 | 1554.2 | 1560.2 | 242416.0 |
| 2018-10-16 | ZN | Futures | 117.752006 | 117.783132 | 117.580809 | 117.752006 | 1463983.0 |
| 2018-10-16 | A6 | Futures | 0.73488 | 0.73632 | 0.7322 | 0.73498 | 75375.0 |
| 2018-10-16 | AD | Futures | 0.77967 | 0.78371 | 0.77876 | 0.78235 | 55388.0 |
| 2018-10-16 | B | Futures | 59.43 | 60.07 | 58.63 | 59.82 | 329327.0 |
| 2018-10-16 | B6 | Futures | 1.3565 | 1.3652 | 1.3553 | 1.3603 | 93580.0 |
| 2018-10-16 | BR | Futures | 0.20548 | 0.20548 | 0.20369 | 0.20369 | 4.0 |
| 2018-10-16 | BTC | Futures | 9220.9 | 9372.5 | 9206.5 | 9264.2 | 1604.0 |
| 2018-10-16 | BZ | Futures | 58.85 | 59.61 | 58.19 | 59.37 | 33816.0 |
| 2018-10-16 | C | Futures | 1453.0 | 1489.0 | 1436.0 | 1472.0 | 6862.0 |
| 2018-10-16 | CB | Futures | 270.966 | 272.769 | 270.966 | 271.868 | 19.0 |
| 2018-10-16 | CC | Futures | 1488.0 | 1552.0 | 1482.0 | 1532.0 | 23931.0 |
| 2018-10-16 | CNH | Futures | 6.9688 | 6.9759 | 6.955 | 6.9606 | 390.0 |
| 2018-10-16 | CSC | Futures | 3.142 | 3.142 | 3.132 | 3.132 | 106.0 |
| 2018-10-16 | CT | Futures | 88.6 | 88.67 | 87.83 | 87.92 | 13539.0 |
| 2018-10-16 | DC | Futures | 26.24 | 26.24 | 26.09 | 26.24 | 332.0 |
| 2018-10-16 | DX | Futures | 90.025 | 90.153 | 89.745 | 90.009 | 15733.0 |
| 2018-10-16 | E1 | Futures | 1.20741 | 1.20872 | 1.20267 | 1.20386 | 24344.0 |
| 2018-10-16 | E6 | Futures | 1.29384 | 1.2984 | 1.29212 | 1.29351 | 189349.0 |
| 2018-10-16 | E7 | Futures | 1.2879 | 1.292 | 1.2857 | 1.2871 | 3181.0 |
| 2018-10-16 | EBM | Futures | 213.13 | 213.65 | 211.05 | 211.31 | 18294.0 |
| 2018-10-16 | ED | Futures | 95.0329 | 95.0525 | 95.028 | 95.0378 | 332656.0 |
| 2018-10-16 | ER | Futures | 98.377 | 98.386 | 98.377 | 98.386 | 69623.0 |
| 2018-10-16 | EW | Futures | 1972.1 | 2020.9 | 1971.3 | 2020.4 | 18412.0 |
| 2018-10-16 | FBON | Futures | 126.17 | 126.47 | 126.12 | 126.42 | 1533.0 |
| 2018-10-16 | FBTP | Futures | 103.54 | 104.43 | 103.29 | 104.17 | 91838.0 |
| 2018-10-16 | FBTS | Futures | 101.15 | 101.563 | 101.066 | 101.478 | 102796.0 |
| 2018-10-16 | FCE | Futures | 4566.2 | 4636.1 | 4547.0 | 4627.6 | 123795.0 |
| 2018-10-16 | FDAX | Futures | 12232.5 | 12415.4 | 12189.4 | 12374.4 | 100395.0 |
| 2018-10-16 | FDXM | Futures | 12021.7 | 12200.4 | 11978.3 | 12160.1 | 43662.0 |
| 2018-10-16 | FESX | Futures | 2691.5 | 2735.2 | 2684.8 | 2727.7 | 1140500.0 |
| 2018-10-16 | FGBL | Futures | 151.68 | 151.98 | 151.53 | 151.9 | 578937.0 |
| 2018-10-16 | FGBM | Futures | 130.49 | 130.6 | 130.39 | 130.56 | 397111.0 |
| 2018-10-16 | FGBS | Futures | 112.593 | 112.603 | 112.557 | 112.593 | 471920.0 |
| 2018-10-16 | FGBX | Futures | 174.3 | 175.11 | 174.02 | 174.81 | 33823.0 |
| 2018-10-16 | FMWO | Futures | 6855.8 | 6982.1 | 6848.9 | 6941.6 | 2653.0 |
| 2018-10-16 | FOAT | Futures | 139.06 | 139.43 | 138.97 | 139.39 | 118179.0 |
| 2018-10-16 | FTDX | Futures | 2538.1 | 2630.4 | 2538.1 | 2628.5 | 602.0 |
| 2018-10-16 | FTI | Futures | 482.96 | 490.84 | 481.23 | 489.12 | 47164.0 |
| 2018-10-16 | FTUK | Futures | 6254.5 | 6307.7 | 6229.1 | 6284.5 | 109771.0 |
| 2018-10-16 | FVSA | Futures | 346.28 | 346.28 | 321.55 | 327.26 | 48468.0 |
| 2018-10-16 | FXXP | Futures | 310.9 | 315.8 | 310.1 | 314.9 | 69710.0 |
| 2018-10-16 | G | Futures | 113.47 | 113.58 | 113.32 | 113.44 | 232769.0 |
| 2018-10-16 | GF | Futures | 322.757 | 323.224 | 320.21 | 320.677 | 4256.0 |
| 2018-10-16 | GSCI | Futures | 551.19 | 553.93 | 549.99 | 553.76 | 118.0 |
| 2018-10-16 | HE | Futures | 76.236 | 78.283 | 76.035 | 76.337 | 26003.0 |
> showing 50 of 115 rows — these rows as CSV