PREVIEW / futures_30min / 2019-07-16
file: by_date/futures_30min/2019/2019-07-16.parquet size: 92 KB rows: 3,441
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-07-16 00:00:00 | ES | Futures | 3269.85 | 3270.12 | 3269.03 | 3269.31 | 1229.0 |
| 2019-07-16 00:30:00 | ES | Futures | 3269.31 | 3270.12 | 3268.76 | 3269.85 | 1104.0 |
| 2019-07-16 01:00:00 | ES | Futures | 3269.85 | 3270.39 | 3269.03 | 3270.12 | 2220.0 |
| 2019-07-16 01:30:00 | ES | Futures | 3270.12 | 3270.93 | 3269.85 | 3270.12 | 2456.0 |
| 2019-07-16 02:00:00 | ES | Futures | 3270.12 | 3270.12 | 3269.03 | 3269.03 | 2587.0 |
| 2019-07-16 02:30:00 | ES | Futures | 3269.31 | 3269.58 | 3267.68 | 3267.68 | 2876.0 |
| 2019-07-16 03:00:00 | ES | Futures | 3267.95 | 3269.03 | 3266.6 | 3266.87 | 8532.0 |
| 2019-07-16 03:30:00 | ES | Futures | 3266.87 | 3268.22 | 3266.33 | 3267.95 | 6384.0 |
| 2019-07-16 04:00:00 | ES | Futures | 3267.68 | 3269.58 | 3267.41 | 3269.03 | 5624.0 |
| 2019-07-16 04:30:00 | ES | Futures | 3268.76 | 3269.58 | 3268.22 | 3269.31 | 3802.0 |
| 2019-07-16 05:00:00 | ES | Futures | 3269.03 | 3270.12 | 3267.14 | 3267.68 | 5664.0 |
| 2019-07-16 05:30:00 | ES | Futures | 3267.41 | 3268.22 | 3266.06 | 3267.41 | 5558.0 |
| 2019-07-16 06:00:00 | ES | Futures | 3267.41 | 3269.58 | 3267.14 | 3268.76 | 3541.0 |
| 2019-07-16 06:30:00 | ES | Futures | 3269.03 | 3269.03 | 3265.79 | 3266.6 | 7985.0 |
| 2019-07-16 07:00:00 | ES | Futures | 3266.6 | 3269.03 | 3266.33 | 3268.49 | 7094.0 |
| 2019-07-16 07:30:00 | ES | Futures | 3268.49 | 3270.93 | 3268.49 | 3270.12 | 10623.0 |
| 2019-07-16 08:00:00 | ES | Futures | 3270.12 | 3272.01 | 3269.58 | 3269.85 | 8023.0 |
| 2019-07-16 08:30:00 | ES | Futures | 3269.58 | 3270.66 | 3267.41 | 3267.68 | 17728.0 |
| 2019-07-16 09:00:00 | ES | Futures | 3267.68 | 3268.76 | 3266.06 | 3266.6 | 14805.0 |
| 2019-07-16 09:30:00 | ES | Futures | 3266.6 | 3267.95 | 3263.62 | 3266.33 | 85659.0 |
| 2019-07-16 10:00:00 | ES | Futures | 3266.6 | 3267.14 | 3263.89 | 3266.87 | 49945.0 |
| 2019-07-16 10:30:00 | ES | Futures | 3266.87 | 3268.76 | 3264.97 | 3266.87 | 41953.0 |
| 2019-07-16 11:00:00 | ES | Futures | 3267.14 | 3267.68 | 3263.08 | 3263.89 | 39874.0 |
| 2019-07-16 11:30:00 | ES | Futures | 3263.89 | 3265.24 | 3259.83 | 3260.37 | 41730.0 |
| 2019-07-16 12:00:00 | ES | Futures | 3260.37 | 3261.18 | 3253.33 | 3256.04 | 109610.0 |
| 2019-07-16 12:30:00 | ES | Futures | 3256.31 | 3259.83 | 3255.23 | 3258.21 | 48349.0 |
| 2019-07-16 13:00:00 | ES | Futures | 3258.21 | 3263.08 | 3258.21 | 3261.18 | 47668.0 |
| 2019-07-16 13:30:00 | ES | Futures | 3261.18 | 3261.73 | 3254.69 | 3254.96 | 37526.0 |
| 2019-07-16 14:00:00 | ES | Futures | 3254.96 | 3257.66 | 3253.6 | 3255.5 | 34325.0 |
| 2019-07-16 14:30:00 | ES | Futures | 3255.23 | 3259.02 | 3253.33 | 3257.12 | 39590.0 |
| 2019-07-16 15:00:00 | ES | Futures | 3257.12 | 3260.64 | 3256.31 | 3257.94 | 38609.0 |
| 2019-07-16 15:30:00 | ES | Futures | 3257.94 | 3261.18 | 3255.23 | 3256.58 | 105807.0 |
| 2019-07-16 16:00:00 | ES | Futures | 3256.31 | 3258.75 | 3255.5 | 3255.77 | 41101.0 |
| 2019-07-16 16:30:00 | ES | Futures | 3256.04 | 3256.58 | 3253.87 | 3254.69 | 6425.0 |
| 2019-07-16 18:00:00 | ES | Futures | 3254.69 | 3256.04 | 3252.79 | 3254.15 | 3934.0 |
| 2019-07-16 18:30:00 | ES | Futures | 3254.15 | 3256.04 | 3254.15 | 3255.77 | 1083.0 |
| 2019-07-16 19:00:00 | ES | Futures | 3255.77 | 3255.77 | 3254.96 | 3255.23 | 566.0 |
| 2019-07-16 19:30:00 | ES | Futures | 3255.23 | 3256.04 | 3254.69 | 3255.77 | 1560.0 |
| 2019-07-16 20:00:00 | ES | Futures | 3255.5 | 3256.58 | 3254.15 | 3255.5 | 4008.0 |
| 2019-07-16 20:30:00 | ES | Futures | 3255.23 | 3255.5 | 3254.15 | 3254.69 | 1495.0 |
| 2019-07-16 21:00:00 | ES | Futures | 3254.42 | 3255.23 | 3251.98 | 3254.15 | 4982.0 |
| 2019-07-16 21:30:00 | ES | Futures | 3254.15 | 3257.39 | 3253.06 | 3257.39 | 5941.0 |
| 2019-07-16 22:00:00 | ES | Futures | 3257.39 | 3258.48 | 3256.31 | 3257.39 | 3900.0 |
| 2019-07-16 22:30:00 | ES | Futures | 3257.39 | 3257.94 | 3256.04 | 3256.85 | 2610.0 |
| 2019-07-16 23:00:00 | ES | Futures | 3256.58 | 3257.94 | 3256.58 | 3257.94 | 1451.0 |
| 2019-07-16 23:30:00 | ES | Futures | 3258.21 | 3258.48 | 3257.39 | 3257.39 | 1345.0 |
| 2019-07-16 00:00:00 | NQ | Futures | 9281.66 | 9282.82 | 9277.59 | 9278.47 | 615.0 |
| 2019-07-16 00:30:00 | NQ | Futures | 9278.47 | 9280.21 | 9276.14 | 9280.21 | 419.0 |
| 2019-07-16 01:00:00 | NQ | Futures | 9280.21 | 9282.24 | 9276.14 | 9281.66 | 631.0 |
| 2019-07-16 01:30:00 | NQ | Futures | 9282.24 | 9286.3 | 9280.21 | 9281.08 | 1302.0 |
> showing 50 of 3,441 rows — these rows as CSV