PREVIEW / futures_30min / 2017-04-02
file: by_date/futures_30min/2017/2017-04-02.parquet size: 20 KB rows: 564
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-04-02 18:00:00 | ES | Futures | 2575.74 | 2579.29 | 2575.19 | 2578.47 | 3809.0 |
| 2017-04-02 18:30:00 | ES | Futures | 2578.47 | 2579.56 | 2578.2 | 2578.74 | 1914.0 |
| 2017-04-02 19:00:00 | ES | Futures | 2579.02 | 2579.29 | 2578.47 | 2578.74 | 817.0 |
| 2017-04-02 19:30:00 | ES | Futures | 2579.02 | 2579.02 | 2577.65 | 2577.65 | 2280.0 |
| 2017-04-02 20:00:00 | ES | Futures | 2577.65 | 2578.2 | 2574.1 | 2575.47 | 7758.0 |
| 2017-04-02 20:30:00 | ES | Futures | 2575.47 | 2579.02 | 2575.19 | 2578.47 | 3942.0 |
| 2017-04-02 21:00:00 | ES | Futures | 2578.2 | 2579.56 | 2577.38 | 2577.65 | 4374.0 |
| 2017-04-02 21:30:00 | ES | Futures | 2577.92 | 2578.47 | 2576.56 | 2578.2 | 3011.0 |
| 2017-04-02 22:00:00 | ES | Futures | 2578.2 | 2579.02 | 2577.38 | 2578.47 | 2890.0 |
| 2017-04-02 22:30:00 | ES | Futures | 2578.47 | 2578.47 | 2577.65 | 2577.92 | 1239.0 |
| 2017-04-02 23:00:00 | ES | Futures | 2577.92 | 2578.47 | 2577.38 | 2578.2 | 1300.0 |
| 2017-04-02 23:30:00 | ES | Futures | 2578.2 | 2578.2 | 2577.1 | 2577.38 | 1563.0 |
| 2017-04-02 18:00:00 | NQ | Futures | 6483.65 | 6492.0 | 6482.16 | 6489.62 | 998.0 |
| 2017-04-02 18:30:00 | NQ | Futures | 6489.62 | 6492.6 | 6488.72 | 6491.11 | 487.0 |
| 2017-04-02 19:00:00 | NQ | Futures | 6490.51 | 6492.3 | 6490.21 | 6491.11 | 216.0 |
| 2017-04-02 19:30:00 | NQ | Futures | 6490.81 | 6490.81 | 6487.23 | 6488.72 | 304.0 |
| 2017-04-02 20:00:00 | NQ | Futures | 6488.72 | 6489.92 | 6478.88 | 6482.46 | 2067.0 |
| 2017-04-02 20:30:00 | NQ | Futures | 6482.16 | 6492.0 | 6481.27 | 6489.32 | 925.0 |
| 2017-04-02 21:00:00 | NQ | Futures | 6489.02 | 6492.0 | 6486.93 | 6489.32 | 1027.0 |
| 2017-04-02 21:30:00 | NQ | Futures | 6489.02 | 6491.11 | 6485.74 | 6490.51 | 806.0 |
| 2017-04-02 22:00:00 | NQ | Futures | 6490.51 | 6492.0 | 6488.43 | 6490.81 | 563.0 |
| 2017-04-02 22:30:00 | NQ | Futures | 6490.51 | 6491.11 | 6488.43 | 6489.62 | 663.0 |
| 2017-04-02 23:00:00 | NQ | Futures | 6489.62 | 6491.11 | 6488.13 | 6489.92 | 292.0 |
| 2017-04-02 23:30:00 | NQ | Futures | 6489.92 | 6489.92 | 6488.43 | 6488.72 | 296.0 |
| 2017-04-02 18:00:00 | YM | Futures | 22386.8 | 22410.7 | 22377.0 | 22403.1 | 667.0 |
| 2017-04-02 18:30:00 | YM | Futures | 22402.0 | 22411.8 | 22402.0 | 22404.2 | 463.0 |
| 2017-04-02 19:00:00 | YM | Futures | 22404.2 | 22407.5 | 22403.1 | 22405.3 | 137.0 |
| 2017-04-02 19:30:00 | YM | Futures | 22404.2 | 22406.4 | 22395.5 | 22398.8 | 293.0 |
| 2017-04-02 20:00:00 | YM | Futures | 22398.8 | 22402.0 | 22371.6 | 22384.6 | 1340.0 |
| 2017-04-02 20:30:00 | YM | Futures | 22385.7 | 22406.4 | 22380.3 | 22402.0 | 765.0 |
| 2017-04-02 21:00:00 | YM | Futures | 22400.9 | 22410.7 | 22395.5 | 22400.9 | 793.0 |
| 2017-04-02 21:30:00 | YM | Futures | 22399.9 | 22405.3 | 22392.2 | 22404.2 | 621.0 |
| 2017-04-02 22:00:00 | YM | Futures | 22404.2 | 22407.5 | 22399.9 | 22403.1 | 459.0 |
| 2017-04-02 22:30:00 | YM | Futures | 22404.2 | 22404.2 | 22398.8 | 22403.1 | 206.0 |
| 2017-04-02 23:00:00 | YM | Futures | 22403.1 | 22406.4 | 22397.7 | 22402.0 | 316.0 |
| 2017-04-02 23:30:00 | YM | Futures | 22400.9 | 22400.9 | 22394.4 | 22396.6 | 239.0 |
| 2017-04-02 18:00:00 | CL | Futures | 47.08 | 47.14 | 47.01 | 47.04 | 2248.0 |
| 2017-04-02 18:30:00 | CL | Futures | 47.05 | 47.06 | 46.97 | 47.02 | 1113.0 |
| 2017-04-02 19:00:00 | CL | Futures | 47.01 | 47.04 | 47.0 | 47.0 | 647.0 |
| 2017-04-02 19:30:00 | CL | Futures | 47.0 | 47.04 | 46.98 | 47.0 | 841.0 |
| 2017-04-02 20:00:00 | CL | Futures | 47.0 | 47.02 | 46.95 | 47.02 | 1160.0 |
| 2017-04-02 20:30:00 | CL | Futures | 47.02 | 47.02 | 46.98 | 46.99 | 608.0 |
| 2017-04-02 21:00:00 | CL | Futures | 47.0 | 47.06 | 46.99 | 47.02 | 909.0 |
| 2017-04-02 21:30:00 | CL | Futures | 47.02 | 47.03 | 46.97 | 46.98 | 741.0 |
| 2017-04-02 22:00:00 | CL | Futures | 46.98 | 47.0 | 46.95 | 46.97 | 939.0 |
| 2017-04-02 22:30:00 | CL | Futures | 46.98 | 46.98 | 46.95 | 46.97 | 367.0 |
| 2017-04-02 23:00:00 | CL | Futures | 46.96 | 46.99 | 46.93 | 46.94 | 1111.0 |
| 2017-04-02 23:30:00 | CL | Futures | 46.94 | 46.94 | 46.91 | 46.92 | 792.0 |
| 2017-04-02 18:00:00 | GC | Futures | 1680.7 | 1681.7 | 1677.7 | 1680.0 | 1291.0 |
| 2017-04-02 18:30:00 | GC | Futures | 1680.0 | 1680.5 | 1679.1 | 1680.1 | 613.0 |
> showing 50 of 564 rows — these rows as CSV