PREVIEW / futures_30min / 2019-07-15
file: by_date/futures_30min/2019/2019-07-15.parquet size: 88 KB rows: 3,394
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-15 00:00:00 | ES | Futures | 3268.22 | 3268.49 | 3267.41 | 3267.41 | 691.0 |
| 2019-07-15 00:30:00 | ES | Futures | 3267.41 | 3268.49 | 3267.41 | 3268.49 | 661.0 |
| 2019-07-15 01:00:00 | ES | Futures | 3268.49 | 3268.49 | 3267.41 | 3267.68 | 1221.0 |
| 2019-07-15 01:30:00 | ES | Futures | 3267.68 | 3268.76 | 3267.14 | 3268.49 | 1292.0 |
| 2019-07-15 02:00:00 | ES | Futures | 3268.49 | 3268.76 | 3266.87 | 3267.14 | 3738.0 |
| 2019-07-15 02:30:00 | ES | Futures | 3267.41 | 3270.12 | 3267.14 | 3269.85 | 4001.0 |
| 2019-07-15 03:00:00 | ES | Futures | 3269.85 | 3273.91 | 3269.31 | 3273.64 | 19753.0 |
| 2019-07-15 03:30:00 | ES | Futures | 3273.37 | 3273.91 | 3272.28 | 3272.55 | 7197.0 |
| 2019-07-15 04:00:00 | ES | Futures | 3272.55 | 3273.37 | 3267.41 | 3267.95 | 13464.0 |
| 2019-07-15 04:30:00 | ES | Futures | 3267.95 | 3271.47 | 3267.41 | 3269.85 | 8432.0 |
| 2019-07-15 05:00:00 | ES | Futures | 3269.85 | 3270.12 | 3267.68 | 3267.95 | 9749.0 |
| 2019-07-15 05:30:00 | ES | Futures | 3267.95 | 3268.76 | 3266.33 | 3268.49 | 7226.0 |
| 2019-07-15 06:00:00 | ES | Futures | 3268.49 | 3271.2 | 3267.95 | 3269.31 | 7263.0 |
| 2019-07-15 06:30:00 | ES | Futures | 3269.58 | 3270.66 | 3268.76 | 3270.12 | 4862.0 |
| 2019-07-15 07:00:00 | ES | Futures | 3270.39 | 3271.2 | 3269.85 | 3270.66 | 5001.0 |
| 2019-07-15 07:30:00 | ES | Futures | 3270.93 | 3272.28 | 3270.12 | 3271.74 | 6874.0 |
| 2019-07-15 08:00:00 | ES | Futures | 3271.74 | 3272.82 | 3271.47 | 3272.01 | 7975.0 |
| 2019-07-15 08:30:00 | ES | Futures | 3272.01 | 3273.09 | 3270.66 | 3272.55 | 12441.0 |
| 2019-07-15 09:00:00 | ES | Futures | 3272.28 | 3272.82 | 3270.93 | 3271.47 | 7755.0 |
| 2019-07-15 09:30:00 | ES | Futures | 3271.74 | 3271.74 | 3264.16 | 3266.06 | 102143.0 |
| 2019-07-15 10:00:00 | ES | Futures | 3265.79 | 3268.22 | 3264.16 | 3267.41 | 67033.0 |
| 2019-07-15 10:30:00 | ES | Futures | 3267.41 | 3268.76 | 3263.62 | 3267.14 | 55487.0 |
| 2019-07-15 11:00:00 | ES | Futures | 3267.14 | 3267.95 | 3265.52 | 3265.79 | 37597.0 |
| 2019-07-15 11:30:00 | ES | Futures | 3265.79 | 3266.06 | 3263.35 | 3263.89 | 38826.0 |
| 2019-07-15 12:00:00 | ES | Futures | 3264.16 | 3264.7 | 3262.81 | 3263.89 | 29195.0 |
| 2019-07-15 12:30:00 | ES | Futures | 3263.89 | 3264.16 | 3262.0 | 3263.08 | 25635.0 |
| 2019-07-15 13:00:00 | ES | Futures | 3263.08 | 3263.89 | 3262.0 | 3263.62 | 20922.0 |
| 2019-07-15 13:30:00 | ES | Futures | 3263.35 | 3265.79 | 3263.08 | 3264.43 | 20881.0 |
| 2019-07-15 14:00:00 | ES | Futures | 3264.43 | 3268.22 | 3264.16 | 3266.6 | 29167.0 |
| 2019-07-15 14:30:00 | ES | Futures | 3266.6 | 3267.14 | 3264.97 | 3266.33 | 24939.0 |
| 2019-07-15 15:00:00 | ES | Futures | 3266.33 | 3267.68 | 3264.16 | 3265.24 | 36238.0 |
| 2019-07-15 15:30:00 | ES | Futures | 3265.24 | 3267.95 | 3264.7 | 3267.95 | 96568.0 |
| 2019-07-15 16:00:00 | ES | Futures | 3267.68 | 3269.03 | 3266.06 | 3267.41 | 38733.0 |
| 2019-07-15 16:30:00 | ES | Futures | 3267.68 | 3268.49 | 3266.87 | 3267.41 | 6329.0 |
| 2019-07-15 18:00:00 | ES | Futures | 3267.14 | 3267.41 | 3265.79 | 3266.6 | 1791.0 |
| 2019-07-15 18:30:00 | ES | Futures | 3266.87 | 3267.68 | 3266.33 | 3266.87 | 1348.0 |
| 2019-07-15 19:00:00 | ES | Futures | 3267.14 | 3267.68 | 3266.6 | 3267.41 | 725.0 |
| 2019-07-15 19:30:00 | ES | Futures | 3267.41 | 3270.39 | 3267.41 | 3269.58 | 3318.0 |
| 2019-07-15 20:00:00 | ES | Futures | 3269.58 | 3270.66 | 3268.49 | 3269.58 | 4483.0 |
| 2019-07-15 20:30:00 | ES | Futures | 3269.58 | 3269.85 | 3268.22 | 3268.49 | 2672.0 |
| 2019-07-15 21:00:00 | ES | Futures | 3268.49 | 3269.58 | 3267.68 | 3268.49 | 3519.0 |
| 2019-07-15 21:30:00 | ES | Futures | 3268.49 | 3269.03 | 3266.87 | 3267.95 | 4251.0 |
| 2019-07-15 22:00:00 | ES | Futures | 3267.68 | 3268.49 | 3266.87 | 3267.41 | 2732.0 |
| 2019-07-15 22:30:00 | ES | Futures | 3267.68 | 3270.39 | 3267.41 | 3270.12 | 2494.0 |
| 2019-07-15 23:00:00 | ES | Futures | 3270.39 | 3270.39 | 3269.58 | 3270.39 | 1996.0 |
| 2019-07-15 23:30:00 | ES | Futures | 3270.12 | 3270.39 | 3269.85 | 3269.85 | 1219.0 |
| 2019-07-15 00:00:00 | NQ | Futures | 9243.07 | 9245.1 | 9241.33 | 9241.62 | 464.0 |
| 2019-07-15 00:30:00 | NQ | Futures | 9241.33 | 9244.23 | 9241.33 | 9243.36 | 415.0 |
| 2019-07-15 01:00:00 | NQ | Futures | 9243.65 | 9244.52 | 9238.72 | 9240.75 | 770.0 |
| 2019-07-15 01:30:00 | NQ | Futures | 9241.04 | 9244.81 | 9238.14 | 9242.49 | 503.0 |
> showing 50 of 3,394 rows — these rows as CSV