PREVIEW / futures_30min / 2018-07-30
file: by_date/futures_30min/2018/2018-07-30.parquet size: 79 KB rows: 3,085
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-30 00:00:00 | ES | Futures | 3062.25 | 3062.79 | 3061.43 | 3061.98 | 1015.0 |
| 2018-07-30 00:30:00 | ES | Futures | 3061.7 | 3062.52 | 3060.89 | 3062.25 | 1177.0 |
| 2018-07-30 01:00:00 | ES | Futures | 3062.52 | 3062.52 | 3060.07 | 3061.98 | 2874.0 |
| 2018-07-30 01:30:00 | ES | Futures | 3062.25 | 3062.25 | 3060.61 | 3061.43 | 3311.0 |
| 2018-07-30 02:00:00 | ES | Futures | 3061.43 | 3063.34 | 3061.43 | 3062.79 | 2981.0 |
| 2018-07-30 02:30:00 | ES | Futures | 3062.79 | 3064.7 | 3062.25 | 3064.7 | 2430.0 |
| 2018-07-30 03:00:00 | ES | Futures | 3064.7 | 3066.61 | 3063.34 | 3065.25 | 8359.0 |
| 2018-07-30 03:30:00 | ES | Futures | 3065.25 | 3067.43 | 3065.25 | 3066.34 | 6968.0 |
| 2018-07-30 04:00:00 | ES | Futures | 3066.06 | 3067.7 | 3065.25 | 3066.34 | 6871.0 |
| 2018-07-30 04:30:00 | ES | Futures | 3066.61 | 3067.43 | 3065.25 | 3067.15 | 9309.0 |
| 2018-07-30 05:00:00 | ES | Futures | 3067.15 | 3069.33 | 3067.15 | 3067.15 | 6821.0 |
| 2018-07-30 05:30:00 | ES | Futures | 3067.15 | 3068.79 | 3066.88 | 3068.52 | 8316.0 |
| 2018-07-30 06:00:00 | ES | Futures | 3068.79 | 3069.33 | 3067.97 | 3069.06 | 5592.0 |
| 2018-07-30 06:30:00 | ES | Futures | 3069.06 | 3069.33 | 3067.7 | 3069.06 | 2647.0 |
| 2018-07-30 07:00:00 | ES | Futures | 3069.33 | 3070.42 | 3067.97 | 3068.79 | 5263.0 |
| 2018-07-30 07:30:00 | ES | Futures | 3068.79 | 3069.88 | 3067.7 | 3069.06 | 5852.0 |
| 2018-07-30 08:00:00 | ES | Futures | 3069.33 | 3071.79 | 3069.06 | 3070.97 | 8627.0 |
| 2018-07-30 08:30:00 | ES | Futures | 3070.97 | 3072.06 | 3070.42 | 3070.7 | 6818.0 |
| 2018-07-30 09:00:00 | ES | Futures | 3070.97 | 3073.15 | 3070.15 | 3072.87 | 14137.0 |
| 2018-07-30 09:30:00 | ES | Futures | 3073.15 | 3075.33 | 3065.52 | 3067.15 | 145905.0 |
| 2018-07-30 10:00:00 | ES | Futures | 3067.15 | 3069.88 | 3063.07 | 3069.88 | 103600.0 |
| 2018-07-30 10:30:00 | ES | Futures | 3069.88 | 3069.88 | 3062.79 | 3063.34 | 76730.0 |
| 2018-07-30 11:00:00 | ES | Futures | 3063.34 | 3065.52 | 3060.07 | 3061.98 | 61708.0 |
| 2018-07-30 11:30:00 | ES | Futures | 3061.98 | 3064.43 | 3059.52 | 3061.98 | 46773.0 |
| 2018-07-30 12:00:00 | ES | Futures | 3061.7 | 3061.98 | 3054.89 | 3055.98 | 76804.0 |
| 2018-07-30 12:30:00 | ES | Futures | 3055.98 | 3056.8 | 3049.72 | 3054.35 | 68600.0 |
| 2018-07-30 13:00:00 | ES | Futures | 3054.07 | 3058.71 | 3049.99 | 3058.16 | 50886.0 |
| 2018-07-30 13:30:00 | ES | Futures | 3058.16 | 3062.25 | 3057.34 | 3061.98 | 40214.0 |
| 2018-07-30 14:00:00 | ES | Futures | 3062.25 | 3063.88 | 3059.8 | 3060.07 | 35973.0 |
| 2018-07-30 14:30:00 | ES | Futures | 3060.07 | 3063.61 | 3056.53 | 3058.16 | 57106.0 |
| 2018-07-30 15:00:00 | ES | Futures | 3058.43 | 3059.8 | 3053.53 | 3054.07 | 46054.0 |
| 2018-07-30 15:30:00 | ES | Futures | 3054.35 | 3058.16 | 3052.17 | 3055.71 | 135569.0 |
| 2018-07-30 16:00:00 | ES | Futures | 3055.71 | 3056.53 | 3053.8 | 3055.16 | 50979.0 |
| 2018-07-30 16:30:00 | ES | Futures | 3055.71 | 3058.98 | 3055.16 | 3057.34 | 7069.0 |
| 2018-07-30 18:00:00 | ES | Futures | 3057.62 | 3058.71 | 3057.07 | 3057.89 | 1877.0 |
| 2018-07-30 18:30:00 | ES | Futures | 3057.89 | 3059.52 | 3057.62 | 3059.25 | 953.0 |
| 2018-07-30 19:00:00 | ES | Futures | 3059.25 | 3059.25 | 3058.43 | 3058.98 | 692.0 |
| 2018-07-30 19:30:00 | ES | Futures | 3058.98 | 3058.98 | 3057.34 | 3058.16 | 1179.0 |
| 2018-07-30 20:00:00 | ES | Futures | 3058.43 | 3058.71 | 3056.53 | 3056.8 | 3735.0 |
| 2018-07-30 20:30:00 | ES | Futures | 3056.8 | 3058.43 | 3054.62 | 3058.43 | 4420.0 |
| 2018-07-30 21:00:00 | ES | Futures | 3058.43 | 3059.52 | 3056.25 | 3058.98 | 3083.0 |
| 2018-07-30 21:30:00 | ES | Futures | 3058.98 | 3059.25 | 3057.07 | 3057.89 | 3165.0 |
| 2018-07-30 22:00:00 | ES | Futures | 3057.89 | 3058.16 | 3055.71 | 3057.62 | 3217.0 |
| 2018-07-30 22:30:00 | ES | Futures | 3057.62 | 3059.25 | 3057.62 | 3058.16 | 1235.0 |
| 2018-07-30 23:00:00 | ES | Futures | 3057.89 | 3058.71 | 3056.8 | 3057.07 | 1092.0 |
| 2018-07-30 23:30:00 | ES | Futures | 3057.34 | 3058.16 | 3056.53 | 3057.34 | 1161.0 |
| 2018-07-30 00:00:00 | NQ | Futures | 8560.8 | 8562.86 | 8553.73 | 8554.91 | 1032.0 |
| 2018-07-30 00:30:00 | NQ | Futures | 8554.61 | 8556.09 | 8551.08 | 8555.2 | 929.0 |
| 2018-07-30 01:00:00 | NQ | Futures | 8555.5 | 8559.32 | 8539.3 | 8558.44 | 2476.0 |
| 2018-07-30 01:30:00 | NQ | Futures | 8558.44 | 8558.44 | 8549.31 | 8554.61 | 1027.0 |
> showing 50 of 3,085 rows — these rows as CSV