PREVIEW / futures_30min / 2019-10-18
file: by_date/futures_30min/2019/2019-10-18.parquet size: 79 KB rows: 2,857
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-10-18 00:00:00 | ES | Futures | 3252.51 | 3253.6 | 3251.69 | 3251.97 | 1345.0 |
| 2019-10-18 00:30:00 | ES | Futures | 3252.24 | 3253.32 | 3251.97 | 3252.78 | 1340.0 |
| 2019-10-18 01:00:00 | ES | Futures | 3252.78 | 3254.41 | 3250.06 | 3250.61 | 2999.0 |
| 2019-10-18 01:30:00 | ES | Futures | 3250.34 | 3251.42 | 3248.43 | 3249.25 | 5599.0 |
| 2019-10-18 02:00:00 | ES | Futures | 3249.25 | 3252.78 | 3248.98 | 3251.69 | 5841.0 |
| 2019-10-18 02:30:00 | ES | Futures | 3251.69 | 3253.05 | 3250.88 | 3252.24 | 3431.0 |
| 2019-10-18 03:00:00 | ES | Futures | 3252.24 | 3253.6 | 3247.62 | 3253.05 | 16366.0 |
| 2019-10-18 03:30:00 | ES | Futures | 3253.05 | 3255.23 | 3252.78 | 3254.14 | 8812.0 |
| 2019-10-18 04:00:00 | ES | Futures | 3254.14 | 3255.77 | 3253.05 | 3254.14 | 5555.0 |
| 2019-10-18 04:30:00 | ES | Futures | 3254.14 | 3256.58 | 3252.51 | 3255.5 | 6358.0 |
| 2019-10-18 05:00:00 | ES | Futures | 3255.23 | 3257.94 | 3253.6 | 3256.04 | 7000.0 |
| 2019-10-18 05:30:00 | ES | Futures | 3256.04 | 3258.49 | 3255.23 | 3258.21 | 9681.0 |
| 2019-10-18 06:00:00 | ES | Futures | 3258.21 | 3258.49 | 3256.31 | 3256.58 | 8070.0 |
| 2019-10-18 06:30:00 | ES | Futures | 3256.31 | 3258.76 | 3255.77 | 3258.49 | 4165.0 |
| 2019-10-18 07:00:00 | ES | Futures | 3258.49 | 3259.84 | 3257.67 | 3258.49 | 7423.0 |
| 2019-10-18 07:30:00 | ES | Futures | 3258.49 | 3260.93 | 3258.49 | 3259.57 | 8280.0 |
| 2019-10-18 08:00:00 | ES | Futures | 3259.57 | 3260.66 | 3259.03 | 3259.57 | 6854.0 |
| 2019-10-18 08:30:00 | ES | Futures | 3259.3 | 3260.11 | 3256.86 | 3257.13 | 9614.0 |
| 2019-10-18 09:00:00 | ES | Futures | 3257.13 | 3257.67 | 3248.43 | 3250.88 | 46155.0 |
| 2019-10-18 09:30:00 | ES | Futures | 3250.61 | 3258.49 | 3250.61 | 3257.67 | 132170.0 |
| 2019-10-18 10:00:00 | ES | Futures | 3257.4 | 3257.67 | 3249.79 | 3251.97 | 97369.0 |
| 2019-10-18 10:30:00 | ES | Futures | 3251.97 | 3252.51 | 3244.9 | 3250.06 | 88240.0 |
| 2019-10-18 11:00:00 | ES | Futures | 3250.06 | 3253.6 | 3248.43 | 3251.97 | 54367.0 |
| 2019-10-18 11:30:00 | ES | Futures | 3252.24 | 3253.6 | 3243.0 | 3243.55 | 78454.0 |
| 2019-10-18 12:00:00 | ES | Futures | 3243.27 | 3245.72 | 3232.41 | 3236.75 | 111503.0 |
| 2019-10-18 12:30:00 | ES | Futures | 3236.75 | 3242.46 | 3235.12 | 3241.92 | 55868.0 |
| 2019-10-18 13:00:00 | ES | Futures | 3241.64 | 3247.89 | 3241.37 | 3245.99 | 58827.0 |
| 2019-10-18 13:30:00 | ES | Futures | 3246.26 | 3250.61 | 3245.18 | 3249.79 | 39977.0 |
| 2019-10-18 14:00:00 | ES | Futures | 3249.79 | 3251.42 | 3246.81 | 3250.88 | 43605.0 |
| 2019-10-18 14:30:00 | ES | Futures | 3251.15 | 3251.15 | 3247.35 | 3250.06 | 33866.0 |
| 2019-10-18 15:00:00 | ES | Futures | 3250.34 | 3253.6 | 3249.79 | 3249.79 | 53596.0 |
| 2019-10-18 15:30:00 | ES | Futures | 3250.06 | 3252.24 | 3243.27 | 3243.27 | 136130.0 |
| 2019-10-18 16:00:00 | ES | Futures | 3243.55 | 3248.43 | 3243.0 | 3246.81 | 61511.0 |
| 2019-10-18 16:30:00 | ES | Futures | 3246.53 | 3248.43 | 3246.26 | 3247.89 | 7564.0 |
| 2019-10-18 00:00:00 | NQ | Futures | 9221.1 | 9223.42 | 9218.77 | 9220.23 | 527.0 |
| 2019-10-18 00:30:00 | NQ | Futures | 9220.23 | 9225.16 | 9219.64 | 9222.55 | 712.0 |
| 2019-10-18 01:00:00 | NQ | Futures | 9222.55 | 9226.04 | 9212.67 | 9215.29 | 1495.0 |
| 2019-10-18 01:30:00 | NQ | Futures | 9215.0 | 9218.48 | 9208.03 | 9210.64 | 2123.0 |
| 2019-10-18 02:00:00 | NQ | Futures | 9210.64 | 9223.13 | 9208.32 | 9219.35 | 2457.0 |
| 2019-10-18 02:30:00 | NQ | Futures | 9219.64 | 9222.84 | 9212.96 | 9217.9 | 1607.0 |
| 2019-10-18 03:00:00 | NQ | Futures | 9217.9 | 9222.55 | 9199.6 | 9218.77 | 5604.0 |
| 2019-10-18 03:30:00 | NQ | Futures | 9218.77 | 9228.07 | 9216.74 | 9224.0 | 3183.0 |
| 2019-10-18 04:00:00 | NQ | Futures | 9224.29 | 9230.1 | 9221.1 | 9222.84 | 2353.0 |
| 2019-10-18 04:30:00 | NQ | Futures | 9222.84 | 9231.56 | 9219.06 | 9226.62 | 2657.0 |
| 2019-10-18 05:00:00 | NQ | Futures | 9226.62 | 9234.75 | 9221.68 | 9230.1 | 2356.0 |
| 2019-10-18 05:30:00 | NQ | Futures | 9229.81 | 9235.33 | 9226.91 | 9233.88 | 2542.0 |
| 2019-10-18 06:00:00 | NQ | Futures | 9234.17 | 9234.75 | 9228.36 | 9228.94 | 1842.0 |
| 2019-10-18 06:30:00 | NQ | Futures | 9228.65 | 9236.78 | 9227.2 | 9236.2 | 1452.0 |
| 2019-10-18 07:00:00 | NQ | Futures | 9235.33 | 9241.43 | 9233.59 | 9235.62 | 3495.0 |
| 2019-10-18 07:30:00 | NQ | Futures | 9235.62 | 9246.37 | 9235.62 | 9242.3 | 3348.0 |
> showing 50 of 2,857 rows — these rows as CSV