PREVIEW / futures_30min / 2019-04-16
file: by_date/futures_30min/2019/2019-04-16.parquet size: 82 KB rows: 3,242
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-04-16 00:00:00 | ES | Futures | 3158.88 | 3159.15 | 3158.34 | 3158.61 | 1257.0 |
| 2019-04-16 00:30:00 | ES | Futures | 3158.88 | 3159.43 | 3158.61 | 3159.43 | 1215.0 |
| 2019-04-16 01:00:00 | ES | Futures | 3159.15 | 3162.68 | 3158.61 | 3162.41 | 5755.0 |
| 2019-04-16 01:30:00 | ES | Futures | 3162.14 | 3162.41 | 3160.78 | 3161.32 | 3412.0 |
| 2019-04-16 02:00:00 | ES | Futures | 3161.05 | 3162.14 | 3159.97 | 3161.05 | 8393.0 |
| 2019-04-16 02:30:00 | ES | Futures | 3160.78 | 3161.59 | 3159.15 | 3159.7 | 5187.0 |
| 2019-04-16 03:00:00 | ES | Futures | 3159.97 | 3162.68 | 3158.61 | 3161.32 | 15099.0 |
| 2019-04-16 03:30:00 | ES | Futures | 3161.32 | 3166.75 | 3161.32 | 3165.66 | 15763.0 |
| 2019-04-16 04:00:00 | ES | Futures | 3165.39 | 3166.75 | 3164.85 | 3164.85 | 9220.0 |
| 2019-04-16 04:30:00 | ES | Futures | 3164.85 | 3167.83 | 3164.58 | 3167.29 | 8394.0 |
| 2019-04-16 05:00:00 | ES | Futures | 3167.29 | 3167.56 | 3163.76 | 3165.12 | 9868.0 |
| 2019-04-16 05:30:00 | ES | Futures | 3165.12 | 3165.93 | 3163.49 | 3164.85 | 9191.0 |
| 2019-04-16 06:00:00 | ES | Futures | 3164.85 | 3166.47 | 3164.03 | 3164.85 | 6329.0 |
| 2019-04-16 06:30:00 | ES | Futures | 3164.58 | 3165.66 | 3164.03 | 3165.12 | 3015.0 |
| 2019-04-16 07:00:00 | ES | Futures | 3164.85 | 3166.47 | 3164.85 | 3165.66 | 5022.0 |
| 2019-04-16 07:30:00 | ES | Futures | 3165.66 | 3166.47 | 3165.39 | 3165.66 | 4657.0 |
| 2019-04-16 08:00:00 | ES | Futures | 3165.93 | 3167.56 | 3165.93 | 3166.75 | 10212.0 |
| 2019-04-16 08:30:00 | ES | Futures | 3166.75 | 3166.75 | 3164.85 | 3165.39 | 10705.0 |
| 2019-04-16 09:00:00 | ES | Futures | 3165.39 | 3166.75 | 3165.12 | 3165.93 | 14490.0 |
| 2019-04-16 09:30:00 | ES | Futures | 3165.66 | 3166.47 | 3161.05 | 3162.41 | 149435.0 |
| 2019-04-16 10:00:00 | ES | Futures | 3162.41 | 3164.31 | 3159.7 | 3161.32 | 99893.0 |
| 2019-04-16 10:30:00 | ES | Futures | 3161.32 | 3161.59 | 3157.26 | 3158.61 | 92706.0 |
| 2019-04-16 11:00:00 | ES | Futures | 3158.61 | 3161.32 | 3156.99 | 3159.7 | 49930.0 |
| 2019-04-16 11:30:00 | ES | Futures | 3159.97 | 3159.97 | 3156.99 | 3158.61 | 51435.0 |
| 2019-04-16 12:00:00 | ES | Futures | 3158.34 | 3160.78 | 3158.07 | 3158.88 | 34971.0 |
| 2019-04-16 12:30:00 | ES | Futures | 3158.88 | 3160.78 | 3157.8 | 3160.51 | 30913.0 |
| 2019-04-16 13:00:00 | ES | Futures | 3160.51 | 3160.51 | 3158.61 | 3158.61 | 25696.0 |
| 2019-04-16 13:30:00 | ES | Futures | 3158.61 | 3159.43 | 3156.44 | 3157.8 | 36306.0 |
| 2019-04-16 14:00:00 | ES | Futures | 3157.8 | 3158.61 | 3155.36 | 3158.61 | 43694.0 |
| 2019-04-16 14:30:00 | ES | Futures | 3158.61 | 3159.43 | 3157.53 | 3159.15 | 38178.0 |
| 2019-04-16 15:00:00 | ES | Futures | 3159.15 | 3160.51 | 3157.8 | 3158.34 | 44361.0 |
| 2019-04-16 15:30:00 | ES | Futures | 3158.34 | 3158.34 | 3149.67 | 3157.53 | 135232.0 |
| 2019-04-16 16:00:00 | ES | Futures | 3157.26 | 3158.61 | 3154.0 | 3157.26 | 68409.0 |
| 2019-04-16 16:30:00 | ES | Futures | 3157.8 | 3158.61 | 3156.17 | 3156.71 | 6235.0 |
| 2019-04-16 18:00:00 | ES | Futures | 3155.9 | 3156.71 | 3154.55 | 3155.09 | 2325.0 |
| 2019-04-16 18:30:00 | ES | Futures | 3155.09 | 3156.17 | 3154.27 | 3154.55 | 1370.0 |
| 2019-04-16 19:00:00 | ES | Futures | 3154.82 | 3156.44 | 3154.55 | 3156.17 | 1309.0 |
| 2019-04-16 19:30:00 | ES | Futures | 3156.17 | 3156.71 | 3155.09 | 3155.9 | 2130.0 |
| 2019-04-16 20:00:00 | ES | Futures | 3155.9 | 3158.07 | 3154.55 | 3157.53 | 6220.0 |
| 2019-04-16 20:30:00 | ES | Futures | 3157.26 | 3159.15 | 3157.26 | 3158.34 | 5460.0 |
| 2019-04-16 21:00:00 | ES | Futures | 3158.34 | 3159.15 | 3155.09 | 3155.63 | 4623.0 |
| 2019-04-16 21:30:00 | ES | Futures | 3155.36 | 3164.31 | 3154.55 | 3162.41 | 11578.0 |
| 2019-04-16 22:00:00 | ES | Futures | 3162.68 | 3164.31 | 3160.24 | 3161.59 | 18416.0 |
| 2019-04-16 22:30:00 | ES | Futures | 3161.59 | 3162.14 | 3159.7 | 3160.78 | 7022.0 |
| 2019-04-16 23:00:00 | ES | Futures | 3160.51 | 3160.78 | 3158.34 | 3159.43 | 6770.0 |
| 2019-04-16 23:30:00 | ES | Futures | 3159.43 | 3159.97 | 3158.34 | 3159.7 | 5031.0 |
| 2019-04-16 00:00:00 | NQ | Futures | 8922.77 | 8925.39 | 8922.19 | 8923.93 | 886.0 |
| 2019-04-16 00:30:00 | NQ | Futures | 8923.93 | 8925.39 | 8922.77 | 8924.81 | 706.0 |
| 2019-04-16 01:00:00 | NQ | Futures | 8924.81 | 8936.45 | 8922.48 | 8935.29 | 2690.0 |
| 2019-04-16 01:30:00 | NQ | Futures | 8935.58 | 8936.45 | 8929.17 | 8930.63 | 1990.0 |
> showing 50 of 3,242 rows — these rows as CSV