PREVIEW / futures_30min / 2019-06-16
file: by_date/futures_30min/2019/2019-06-16.parquet size: 23 KB rows: 643
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-16 18:00:00 | ES | Futures | 3134.76 | 3138.28 | 3134.76 | 3137.47 | 3200.0 |
| 2019-06-16 18:30:00 | ES | Futures | 3137.47 | 3139.1 | 3137.47 | 3138.28 | 957.0 |
| 2019-06-16 19:00:00 | ES | Futures | 3138.28 | 3138.28 | 3137.2 | 3137.47 | 488.0 |
| 2019-06-16 19:30:00 | ES | Futures | 3137.2 | 3142.07 | 3136.93 | 3139.64 | 3875.0 |
| 2019-06-16 20:00:00 | ES | Futures | 3139.91 | 3140.18 | 3136.93 | 3137.47 | 5291.0 |
| 2019-06-16 20:30:00 | ES | Futures | 3137.47 | 3139.91 | 3137.47 | 3139.37 | 2870.0 |
| 2019-06-16 21:00:00 | ES | Futures | 3139.37 | 3142.34 | 3138.01 | 3141.26 | 6498.0 |
| 2019-06-16 21:30:00 | ES | Futures | 3141.26 | 3145.32 | 3141.26 | 3144.24 | 8889.0 |
| 2019-06-16 22:00:00 | ES | Futures | 3144.51 | 3144.78 | 3142.62 | 3143.16 | 4154.0 |
| 2019-06-16 22:30:00 | ES | Futures | 3143.16 | 3144.24 | 3142.62 | 3143.97 | 2435.0 |
| 2019-06-16 23:00:00 | ES | Futures | 3143.7 | 3144.24 | 3141.8 | 3142.07 | 2728.0 |
| 2019-06-16 23:30:00 | ES | Futures | 3142.07 | 3143.16 | 3141.8 | 3142.89 | 1581.0 |
| 2019-06-16 18:00:00 | NQ | Futures | 8713.56 | 8726.9 | 8712.4 | 8722.84 | 1230.0 |
| 2019-06-16 18:30:00 | NQ | Futures | 8724.0 | 8730.1 | 8723.42 | 8726.03 | 608.0 |
| 2019-06-16 19:00:00 | NQ | Futures | 8726.03 | 8726.9 | 8721.97 | 8723.71 | 275.0 |
| 2019-06-16 19:30:00 | NQ | Futures | 8724.0 | 8739.38 | 8722.55 | 8733.58 | 851.0 |
| 2019-06-16 20:00:00 | NQ | Futures | 8732.71 | 8733.58 | 8723.42 | 8725.16 | 1222.0 |
| 2019-06-16 20:30:00 | NQ | Futures | 8725.16 | 8733.29 | 8724.87 | 8730.1 | 957.0 |
| 2019-06-16 21:00:00 | NQ | Futures | 8730.39 | 8743.44 | 8724.87 | 8738.51 | 2122.0 |
| 2019-06-16 21:30:00 | NQ | Futures | 8738.8 | 8752.44 | 8737.64 | 8749.54 | 2593.0 |
| 2019-06-16 22:00:00 | NQ | Futures | 8749.83 | 8750.7 | 8744.89 | 8746.63 | 1242.0 |
| 2019-06-16 22:30:00 | NQ | Futures | 8746.34 | 8750.7 | 8745.18 | 8750.41 | 975.0 |
| 2019-06-16 23:00:00 | NQ | Futures | 8750.7 | 8751.86 | 8744.31 | 8745.18 | 1102.0 |
| 2019-06-16 23:30:00 | NQ | Futures | 8745.18 | 8749.54 | 8745.18 | 8747.79 | 490.0 |
| 2019-06-16 18:00:00 | YM | Futures | 28415.3 | 28455.5 | 28402.2 | 28444.7 | 623.0 |
| 2019-06-16 18:30:00 | YM | Futures | 28447.9 | 28457.7 | 28440.3 | 28443.6 | 239.0 |
| 2019-06-16 19:00:00 | YM | Futures | 28444.7 | 28445.7 | 28438.1 | 28440.3 | 105.0 |
| 2019-06-16 19:30:00 | YM | Futures | 28440.3 | 28481.6 | 28438.1 | 28463.1 | 632.0 |
| 2019-06-16 20:00:00 | YM | Futures | 28462.1 | 28465.3 | 28439.2 | 28445.7 | 622.0 |
| 2019-06-16 20:30:00 | YM | Futures | 28444.7 | 28465.3 | 28443.6 | 28457.7 | 499.0 |
| 2019-06-16 21:00:00 | YM | Futures | 28458.8 | 28482.7 | 28444.7 | 28471.8 | 1176.0 |
| 2019-06-16 21:30:00 | YM | Futures | 28472.9 | 28512.1 | 28472.9 | 28503.4 | 1282.0 |
| 2019-06-16 22:00:00 | YM | Futures | 28504.5 | 28504.5 | 28481.6 | 28486.0 | 625.0 |
| 2019-06-16 22:30:00 | YM | Futures | 28484.9 | 28500.1 | 28482.7 | 28499.0 | 525.0 |
| 2019-06-16 23:00:00 | YM | Futures | 28500.1 | 28502.3 | 28475.1 | 28478.4 | 611.0 |
| 2019-06-16 23:30:00 | YM | Futures | 28477.3 | 28490.3 | 28477.3 | 28489.2 | 182.0 |
| 2019-06-16 18:00:00 | CL | Futures | 46.77 | 47.02 | 46.6 | 46.98 | 1525.0 |
| 2019-06-16 18:30:00 | CL | Futures | 46.99 | 47.02 | 46.89 | 46.93 | 589.0 |
| 2019-06-16 19:00:00 | CL | Futures | 46.91 | 46.92 | 46.86 | 46.88 | 461.0 |
| 2019-06-16 19:30:00 | CL | Futures | 46.87 | 46.98 | 46.87 | 46.97 | 378.0 |
| 2019-06-16 20:00:00 | CL | Futures | 46.98 | 47.01 | 46.9 | 46.99 | 506.0 |
| 2019-06-16 20:30:00 | CL | Futures | 46.99 | 47.02 | 46.92 | 46.93 | 616.0 |
| 2019-06-16 21:00:00 | CL | Futures | 46.93 | 46.98 | 46.83 | 46.88 | 1316.0 |
| 2019-06-16 21:30:00 | CL | Futures | 46.89 | 47.0 | 46.89 | 46.98 | 840.0 |
| 2019-06-16 22:00:00 | CL | Futures | 46.98 | 47.03 | 46.93 | 46.96 | 778.0 |
| 2019-06-16 22:30:00 | CL | Futures | 46.96 | 46.98 | 46.9 | 46.92 | 540.0 |
| 2019-06-16 23:00:00 | CL | Futures | 46.92 | 47.0 | 46.9 | 46.92 | 660.0 |
| 2019-06-16 23:30:00 | CL | Futures | 46.92 | 46.96 | 46.91 | 46.92 | 261.0 |
| 2019-06-16 18:00:00 | GC | Futures | 1720.1 | 1721.0 | 1719.6 | 1719.8 | 1374.0 |
| 2019-06-16 18:30:00 | GC | Futures | 1720.0 | 1720.2 | 1719.2 | 1719.2 | 569.0 |
> showing 50 of 643 rows — these rows as CSV