PREVIEW / futures_30min / 2019-04-05
file: by_date/futures_30min/2019/2019-04-05.parquet size: 69 KB rows: 2,630
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-04-05 00:00:00 | ES | Futures | 3130.69 | 3131.5 | 3130.15 | 3131.23 | 1625.0 |
| 2019-04-05 00:30:00 | ES | Futures | 3130.96 | 3131.5 | 3130.15 | 3130.15 | 1610.0 |
| 2019-04-05 01:00:00 | ES | Futures | 3130.42 | 3130.96 | 3129.6 | 3130.15 | 3621.0 |
| 2019-04-05 01:30:00 | ES | Futures | 3130.15 | 3130.96 | 3129.88 | 3130.96 | 4213.0 |
| 2019-04-05 02:00:00 | ES | Futures | 3130.96 | 3131.77 | 3130.15 | 3131.23 | 5756.0 |
| 2019-04-05 02:30:00 | ES | Futures | 3131.5 | 3132.32 | 3131.23 | 3132.04 | 3553.0 |
| 2019-04-05 03:00:00 | ES | Futures | 3131.77 | 3133.13 | 3131.5 | 3132.86 | 8066.0 |
| 2019-04-05 03:30:00 | ES | Futures | 3132.59 | 3133.13 | 3130.42 | 3130.69 | 6440.0 |
| 2019-04-05 04:00:00 | ES | Futures | 3130.96 | 3133.13 | 3130.42 | 3130.69 | 5806.0 |
| 2019-04-05 04:30:00 | ES | Futures | 3130.96 | 3131.5 | 3130.42 | 3130.69 | 2666.0 |
| 2019-04-05 05:00:00 | ES | Futures | 3130.96 | 3130.96 | 3129.88 | 3130.42 | 2540.0 |
| 2019-04-05 05:30:00 | ES | Futures | 3130.42 | 3131.5 | 3129.6 | 3130.96 | 4714.0 |
| 2019-04-05 06:00:00 | ES | Futures | 3130.96 | 3131.5 | 3129.33 | 3130.42 | 4736.0 |
| 2019-04-05 06:30:00 | ES | Futures | 3130.69 | 3131.77 | 3130.42 | 3131.23 | 2260.0 |
| 2019-04-05 07:00:00 | ES | Futures | 3131.23 | 3131.5 | 3129.6 | 3130.69 | 3653.0 |
| 2019-04-05 07:30:00 | ES | Futures | 3130.69 | 3130.69 | 3128.25 | 3129.33 | 5515.0 |
| 2019-04-05 08:00:00 | ES | Futures | 3129.33 | 3130.69 | 3128.79 | 3129.33 | 7122.0 |
| 2019-04-05 08:30:00 | ES | Futures | 3129.6 | 3137.74 | 3129.6 | 3134.21 | 49432.0 |
| 2019-04-05 09:00:00 | ES | Futures | 3134.21 | 3135.57 | 3132.04 | 3133.94 | 17602.0 |
| 2019-04-05 09:30:00 | ES | Futures | 3133.94 | 3137.47 | 3130.42 | 3136.92 | 158306.0 |
| 2019-04-05 10:00:00 | ES | Futures | 3136.65 | 3139.91 | 3136.11 | 3137.2 | 93912.0 |
| 2019-04-05 10:30:00 | ES | Futures | 3137.47 | 3140.99 | 3135.57 | 3138.01 | 74885.0 |
| 2019-04-05 11:00:00 | ES | Futures | 3138.01 | 3140.72 | 3136.11 | 3138.28 | 69351.0 |
| 2019-04-05 11:30:00 | ES | Futures | 3138.28 | 3139.36 | 3135.84 | 3136.92 | 62134.0 |
| 2019-04-05 12:00:00 | ES | Futures | 3137.2 | 3139.64 | 3136.92 | 3138.28 | 35778.0 |
| 2019-04-05 12:30:00 | ES | Futures | 3138.28 | 3139.09 | 3134.21 | 3137.47 | 40866.0 |
| 2019-04-05 13:00:00 | ES | Futures | 3137.47 | 3138.82 | 3136.38 | 3137.74 | 22719.0 |
| 2019-04-05 13:30:00 | ES | Futures | 3137.74 | 3139.64 | 3136.92 | 3139.64 | 23968.0 |
| 2019-04-05 14:00:00 | ES | Futures | 3139.36 | 3140.18 | 3135.57 | 3136.38 | 51115.0 |
| 2019-04-05 14:30:00 | ES | Futures | 3136.65 | 3138.55 | 3135.57 | 3137.74 | 41682.0 |
| 2019-04-05 15:00:00 | ES | Futures | 3137.74 | 3140.45 | 3135.84 | 3139.64 | 52028.0 |
| 2019-04-05 15:30:00 | ES | Futures | 3139.64 | 3141.8 | 3137.2 | 3140.72 | 131892.0 |
| 2019-04-05 16:00:00 | ES | Futures | 3140.72 | 3142.35 | 3139.64 | 3140.99 | 53832.0 |
| 2019-04-05 16:30:00 | ES | Futures | 3140.99 | 3142.62 | 3140.99 | 3142.35 | 6542.0 |
| 2019-04-05 00:00:00 | NQ | Futures | 8819.99 | 8821.74 | 8817.66 | 8820.86 | 481.0 |
| 2019-04-05 00:30:00 | NQ | Futures | 8820.57 | 8822.61 | 8819.12 | 8819.12 | 678.0 |
| 2019-04-05 01:00:00 | NQ | Futures | 8819.41 | 8823.19 | 8817.95 | 8821.15 | 968.0 |
| 2019-04-05 01:30:00 | NQ | Futures | 8820.57 | 8823.48 | 8819.99 | 8823.48 | 882.0 |
| 2019-04-05 02:00:00 | NQ | Futures | 8823.19 | 8825.81 | 8820.57 | 8825.52 | 1934.0 |
| 2019-04-05 02:30:00 | NQ | Futures | 8825.81 | 8827.27 | 8824.07 | 8825.81 | 898.0 |
| 2019-04-05 03:00:00 | NQ | Futures | 8825.81 | 8833.67 | 8824.65 | 8832.22 | 3188.0 |
| 2019-04-05 03:30:00 | NQ | Futures | 8832.22 | 8833.09 | 8824.94 | 8825.52 | 2255.0 |
| 2019-04-05 04:00:00 | NQ | Futures | 8825.52 | 8834.55 | 8822.9 | 8824.07 | 3879.0 |
| 2019-04-05 04:30:00 | NQ | Futures | 8824.36 | 8826.1 | 8822.32 | 8824.07 | 1673.0 |
| 2019-04-05 05:00:00 | NQ | Futures | 8824.07 | 8825.52 | 8820.57 | 8823.19 | 1426.0 |
| 2019-04-05 05:30:00 | NQ | Futures | 8823.48 | 8827.56 | 8821.45 | 8824.94 | 1715.0 |
| 2019-04-05 06:00:00 | NQ | Futures | 8824.94 | 8827.27 | 8820.28 | 8823.78 | 1612.0 |
| 2019-04-05 06:30:00 | NQ | Futures | 8824.07 | 8826.98 | 8823.78 | 8825.81 | 804.0 |
| 2019-04-05 07:00:00 | NQ | Futures | 8826.1 | 8826.1 | 8821.15 | 8823.19 | 1539.0 |
| 2019-04-05 07:30:00 | NQ | Futures | 8823.19 | 8823.19 | 8814.17 | 8818.53 | 2611.0 |
> showing 50 of 2,630 rows — these rows as CSV