PREVIEW / futures_30min / 2019-07-30
file: by_date/futures_30min/2019/2019-07-30.parquet size: 90 KB rows: 3,488
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-30 00:00:00 | ES | Futures | 3275.53 | 3276.34 | 3275.53 | 3275.53 | 1191.0 |
| 2019-07-30 00:30:00 | ES | Futures | 3275.53 | 3276.61 | 3275.53 | 3276.34 | 1766.0 |
| 2019-07-30 01:00:00 | ES | Futures | 3276.34 | 3276.88 | 3276.07 | 3276.61 | 1261.0 |
| 2019-07-30 01:30:00 | ES | Futures | 3276.61 | 3276.61 | 3275.26 | 3275.53 | 1947.0 |
| 2019-07-30 02:00:00 | ES | Futures | 3275.53 | 3275.8 | 3274.18 | 3274.45 | 3916.0 |
| 2019-07-30 02:30:00 | ES | Futures | 3274.18 | 3274.99 | 3273.64 | 3273.91 | 3227.0 |
| 2019-07-30 03:00:00 | ES | Futures | 3273.91 | 3274.45 | 3270.12 | 3270.39 | 10953.0 |
| 2019-07-30 03:30:00 | ES | Futures | 3270.66 | 3271.2 | 3268.76 | 3270.12 | 10152.0 |
| 2019-07-30 04:00:00 | ES | Futures | 3269.85 | 3270.66 | 3267.68 | 3268.49 | 7866.0 |
| 2019-07-30 04:30:00 | ES | Futures | 3268.49 | 3268.49 | 3263.89 | 3264.16 | 13031.0 |
| 2019-07-30 05:00:00 | ES | Futures | 3264.43 | 3265.24 | 3262.0 | 3262.54 | 11513.0 |
| 2019-07-30 05:30:00 | ES | Futures | 3262.54 | 3266.06 | 3262.0 | 3264.97 | 10812.0 |
| 2019-07-30 06:00:00 | ES | Futures | 3264.97 | 3265.52 | 3260.91 | 3264.43 | 9656.0 |
| 2019-07-30 06:30:00 | ES | Futures | 3264.43 | 3265.24 | 3262.54 | 3264.97 | 10122.0 |
| 2019-07-30 07:00:00 | ES | Futures | 3264.97 | 3264.97 | 3260.37 | 3260.37 | 23141.0 |
| 2019-07-30 07:30:00 | ES | Futures | 3260.64 | 3260.64 | 3256.04 | 3257.12 | 29934.0 |
| 2019-07-30 08:00:00 | ES | Futures | 3257.12 | 3260.37 | 3256.04 | 3257.66 | 18435.0 |
| 2019-07-30 08:30:00 | ES | Futures | 3257.39 | 3259.56 | 3252.79 | 3254.69 | 30792.0 |
| 2019-07-30 09:00:00 | ES | Futures | 3254.69 | 3257.12 | 3253.33 | 3254.42 | 26456.0 |
| 2019-07-30 09:30:00 | ES | Futures | 3254.69 | 3261.18 | 3250.09 | 3259.83 | 184175.0 |
| 2019-07-30 10:00:00 | ES | Futures | 3259.83 | 3263.35 | 3256.85 | 3259.83 | 97549.0 |
| 2019-07-30 10:30:00 | ES | Futures | 3259.83 | 3263.08 | 3258.48 | 3261.45 | 65639.0 |
| 2019-07-30 11:00:00 | ES | Futures | 3261.73 | 3264.43 | 3261.18 | 3262.81 | 54925.0 |
| 2019-07-30 11:30:00 | ES | Futures | 3262.81 | 3265.24 | 3258.75 | 3259.56 | 60737.0 |
| 2019-07-30 12:00:00 | ES | Futures | 3259.29 | 3263.35 | 3258.75 | 3262.54 | 45642.0 |
| 2019-07-30 12:30:00 | ES | Futures | 3262.54 | 3263.89 | 3258.48 | 3259.56 | 37971.0 |
| 2019-07-30 13:00:00 | ES | Futures | 3259.56 | 3261.18 | 3259.02 | 3259.83 | 29374.0 |
| 2019-07-30 13:30:00 | ES | Futures | 3260.1 | 3263.62 | 3259.56 | 3262.54 | 29461.0 |
| 2019-07-30 14:00:00 | ES | Futures | 3262.54 | 3268.22 | 3262.54 | 3266.87 | 49366.0 |
| 2019-07-30 14:30:00 | ES | Futures | 3266.87 | 3266.87 | 3263.89 | 3264.16 | 24975.0 |
| 2019-07-30 15:00:00 | ES | Futures | 3264.43 | 3265.79 | 3260.64 | 3260.91 | 45579.0 |
| 2019-07-30 15:30:00 | ES | Futures | 3260.91 | 3264.7 | 3259.83 | 3264.43 | 113122.0 |
| 2019-07-30 16:00:00 | ES | Futures | 3264.43 | 3264.7 | 3261.45 | 3261.45 | 46412.0 |
| 2019-07-30 16:30:00 | ES | Futures | 3260.91 | 3265.52 | 3260.37 | 3264.97 | 12829.0 |
| 2019-07-30 18:00:00 | ES | Futures | 3266.06 | 3266.87 | 3264.43 | 3266.06 | 3400.0 |
| 2019-07-30 18:30:00 | ES | Futures | 3266.06 | 3266.06 | 3264.7 | 3265.79 | 1014.0 |
| 2019-07-30 19:00:00 | ES | Futures | 3265.52 | 3266.06 | 3264.7 | 3264.97 | 676.0 |
| 2019-07-30 19:30:00 | ES | Futures | 3264.97 | 3265.79 | 3263.35 | 3265.79 | 2598.0 |
| 2019-07-30 20:00:00 | ES | Futures | 3265.79 | 3268.22 | 3264.7 | 3266.6 | 6957.0 |
| 2019-07-30 20:30:00 | ES | Futures | 3266.33 | 3267.95 | 3265.79 | 3266.6 | 3375.0 |
| 2019-07-30 21:00:00 | ES | Futures | 3266.6 | 3267.95 | 3264.97 | 3265.52 | 5042.0 |
| 2019-07-30 21:30:00 | ES | Futures | 3265.52 | 3267.41 | 3263.62 | 3263.89 | 5812.0 |
| 2019-07-30 22:00:00 | ES | Futures | 3263.89 | 3265.52 | 3263.62 | 3265.24 | 4046.0 |
| 2019-07-30 22:30:00 | ES | Futures | 3265.24 | 3267.68 | 3264.97 | 3267.41 | 3436.0 |
| 2019-07-30 23:00:00 | ES | Futures | 3267.41 | 3269.58 | 3266.06 | 3269.03 | 5765.0 |
| 2019-07-30 23:30:00 | ES | Futures | 3269.03 | 3269.58 | 3268.22 | 3268.76 | 3091.0 |
| 2019-07-30 00:00:00 | NQ | Futures | 9298.48 | 9300.52 | 9297.03 | 9297.32 | 598.0 |
| 2019-07-30 00:30:00 | NQ | Futures | 9297.32 | 9301.97 | 9297.32 | 9300.23 | 692.0 |
| 2019-07-30 01:00:00 | NQ | Futures | 9300.23 | 9303.71 | 9299.94 | 9301.97 | 698.0 |
| 2019-07-30 01:30:00 | NQ | Futures | 9301.97 | 9301.97 | 9295.0 | 9297.03 | 1062.0 |
> showing 50 of 3,488 rows — these rows as CSV