PREVIEW / futures_30min / 2020-05-25
file: by_date/futures_30min/2020/2020-05-25.parquet size: 65 KB rows: 2,373
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-25 00:00:00 | ES | Futures | 3251.81 | 3255.38 | 3251.54 | 3254.83 | 1488.0 |
| 2020-05-25 00:30:00 | ES | Futures | 3254.83 | 3255.1 | 3252.63 | 3252.91 | 1359.0 |
| 2020-05-25 01:00:00 | ES | Futures | 3253.18 | 3256.75 | 3252.91 | 3256.2 | 2127.0 |
| 2020-05-25 01:30:00 | ES | Futures | 3256.47 | 3257.3 | 3252.63 | 3254.83 | 3143.0 |
| 2020-05-25 02:00:00 | ES | Futures | 3254.83 | 3260.04 | 3254.83 | 3257.85 | 6353.0 |
| 2020-05-25 02:30:00 | ES | Futures | 3257.85 | 3259.77 | 3256.75 | 3256.75 | 2532.0 |
| 2020-05-25 03:00:00 | ES | Futures | 3257.02 | 3257.3 | 3249.61 | 3252.63 | 5649.0 |
| 2020-05-25 03:30:00 | ES | Futures | 3252.36 | 3253.73 | 3248.24 | 3252.36 | 4304.0 |
| 2020-05-25 04:00:00 | ES | Futures | 3252.36 | 3256.2 | 3249.07 | 3255.38 | 5969.0 |
| 2020-05-25 04:30:00 | ES | Futures | 3255.38 | 3275.13 | 3255.38 | 3270.74 | 15489.0 |
| 2020-05-25 05:00:00 | ES | Futures | 3270.74 | 3274.04 | 3269.37 | 3271.57 | 4131.0 |
| 2020-05-25 05:30:00 | ES | Futures | 3271.84 | 3275.13 | 3270.47 | 3273.76 | 7362.0 |
| 2020-05-25 06:00:00 | ES | Futures | 3273.76 | 3274.31 | 3268.0 | 3269.1 | 6337.0 |
| 2020-05-25 06:30:00 | ES | Futures | 3269.1 | 3276.51 | 3267.18 | 3275.41 | 6869.0 |
| 2020-05-25 07:00:00 | ES | Futures | 3275.13 | 3275.41 | 3272.67 | 3273.21 | 3101.0 |
| 2020-05-25 07:30:00 | ES | Futures | 3273.21 | 3273.76 | 3269.92 | 3271.84 | 6112.0 |
| 2020-05-25 08:00:00 | ES | Futures | 3272.39 | 3274.59 | 3270.47 | 3272.67 | 3646.0 |
| 2020-05-25 08:30:00 | ES | Futures | 3272.67 | 3277.33 | 3271.84 | 3275.96 | 4845.0 |
| 2020-05-25 09:00:00 | ES | Futures | 3275.96 | 3277.88 | 3274.31 | 3277.33 | 3911.0 |
| 2020-05-25 09:30:00 | ES | Futures | 3277.33 | 3277.6 | 3274.04 | 3276.51 | 8533.0 |
| 2020-05-25 10:00:00 | ES | Futures | 3276.78 | 3278.98 | 3275.68 | 3278.7 | 4778.0 |
| 2020-05-25 10:30:00 | ES | Futures | 3278.7 | 3280.35 | 3278.7 | 3280.07 | 6405.0 |
| 2020-05-25 11:00:00 | ES | Futures | 3279.8 | 3281.45 | 3278.7 | 3280.07 | 6584.0 |
| 2020-05-25 11:30:00 | ES | Futures | 3280.07 | 3282.0 | 3279.8 | 3280.35 | 6383.0 |
| 2020-05-25 12:00:00 | ES | Futures | 3280.35 | 3280.35 | 3278.7 | 3279.25 | 2918.0 |
| 2020-05-25 12:30:00 | ES | Futures | 3279.25 | 3282.0 | 3279.25 | 3281.45 | 4053.0 |
| 2020-05-25 18:00:00 | ES | Futures | 3281.45 | 3282.0 | 3274.04 | 3275.96 | 5945.0 |
| 2020-05-25 18:30:00 | ES | Futures | 3275.96 | 3277.88 | 3275.13 | 3276.23 | 1800.0 |
| 2020-05-25 19:00:00 | ES | Futures | 3276.51 | 3276.78 | 3272.12 | 3273.49 | 2500.0 |
| 2020-05-25 19:30:00 | ES | Futures | 3273.49 | 3276.78 | 3273.49 | 3273.49 | 2479.0 |
| 2020-05-25 20:00:00 | ES | Futures | 3273.76 | 3276.23 | 3271.84 | 3274.04 | 5290.0 |
| 2020-05-25 20:30:00 | ES | Futures | 3274.04 | 3280.9 | 3273.21 | 3278.43 | 6491.0 |
| 2020-05-25 21:00:00 | ES | Futures | 3278.7 | 3285.29 | 3277.6 | 3283.64 | 10354.0 |
| 2020-05-25 21:30:00 | ES | Futures | 3283.64 | 3286.39 | 3283.37 | 3286.11 | 6276.0 |
| 2020-05-25 22:00:00 | ES | Futures | 3286.39 | 3288.31 | 3284.46 | 3285.84 | 6333.0 |
| 2020-05-25 22:30:00 | ES | Futures | 3286.11 | 3286.11 | 3283.64 | 3285.01 | 3392.0 |
| 2020-05-25 23:00:00 | ES | Futures | 3285.29 | 3287.48 | 3284.46 | 3287.21 | 2616.0 |
| 2020-05-25 23:30:00 | ES | Futures | 3287.21 | 3294.89 | 3287.21 | 3293.25 | 8329.0 |
| 2020-05-25 00:00:00 | NQ | Futures | 10790.65 | 10804.07 | 10789.5 | 10802.93 | 889.0 |
| 2020-05-25 00:30:00 | NQ | Futures | 10802.36 | 10804.36 | 10794.07 | 10796.36 | 723.0 |
| 2020-05-25 01:00:00 | NQ | Futures | 10796.07 | 10810.36 | 10795.5 | 10807.21 | 1203.0 |
| 2020-05-25 01:30:00 | NQ | Futures | 10807.78 | 10812.64 | 10794.07 | 10805.5 | 1621.0 |
| 2020-05-25 02:00:00 | NQ | Futures | 10804.36 | 10824.64 | 10804.36 | 10817.78 | 2405.0 |
| 2020-05-25 02:30:00 | NQ | Futures | 10817.5 | 10824.07 | 10815.21 | 10817.78 | 1054.0 |
| 2020-05-25 03:00:00 | NQ | Futures | 10818.35 | 10818.64 | 10796.64 | 10801.79 | 3217.0 |
| 2020-05-25 03:30:00 | NQ | Futures | 10801.5 | 10808.64 | 10790.36 | 10804.36 | 1947.0 |
| 2020-05-25 04:00:00 | NQ | Futures | 10804.36 | 10811.5 | 10792.07 | 10809.5 | 2229.0 |
| 2020-05-25 04:30:00 | NQ | Futures | 10809.5 | 10861.77 | 10809.5 | 10850.63 | 4995.0 |
| 2020-05-25 05:00:00 | NQ | Futures | 10850.35 | 10858.34 | 10845.2 | 10850.63 | 1875.0 |
| 2020-05-25 05:30:00 | NQ | Futures | 10850.35 | 10860.34 | 10841.78 | 10857.49 | 2376.0 |
> showing 50 of 2,373 rows — these rows as CSV