PREVIEW / futures_30min / 2020-04-28
file: by_date/futures_30min/2020/2020-04-28.parquet size: 100 KB rows: 3,505
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-04-28 00:00:00 | ES | Futures | 3136.01 | 3136.28 | 3129.42 | 3135.46 | 3155.0 |
| 2020-04-28 00:30:00 | ES | Futures | 3135.18 | 3138.2 | 3133.81 | 3137.38 | 5042.0 |
| 2020-04-28 01:00:00 | ES | Futures | 3137.65 | 3145.06 | 3135.46 | 3143.14 | 4910.0 |
| 2020-04-28 01:30:00 | ES | Futures | 3143.14 | 3149.45 | 3141.22 | 3144.51 | 3526.0 |
| 2020-04-28 02:00:00 | ES | Futures | 3144.51 | 3149.18 | 3140.12 | 3146.16 | 4820.0 |
| 2020-04-28 02:30:00 | ES | Futures | 3146.43 | 3146.98 | 3142.59 | 3143.14 | 2707.0 |
| 2020-04-28 03:00:00 | ES | Futures | 3143.14 | 3154.67 | 3141.77 | 3148.9 | 10936.0 |
| 2020-04-28 03:30:00 | ES | Futures | 3148.9 | 3164.27 | 3147.53 | 3161.8 | 15366.0 |
| 2020-04-28 04:00:00 | ES | Futures | 3161.8 | 3162.62 | 3153.29 | 3157.96 | 13080.0 |
| 2020-04-28 04:30:00 | ES | Futures | 3157.69 | 3162.08 | 3155.49 | 3158.23 | 10114.0 |
| 2020-04-28 05:00:00 | ES | Futures | 3158.23 | 3182.93 | 3157.69 | 3178.82 | 24659.0 |
| 2020-04-28 05:30:00 | ES | Futures | 3178.82 | 3189.52 | 3176.62 | 3188.69 | 25636.0 |
| 2020-04-28 06:00:00 | ES | Futures | 3188.69 | 3191.99 | 3183.21 | 3185.4 | 20326.0 |
| 2020-04-28 06:30:00 | ES | Futures | 3185.13 | 3191.16 | 3183.21 | 3184.03 | 13600.0 |
| 2020-04-28 07:00:00 | ES | Futures | 3184.3 | 3189.52 | 3181.01 | 3189.52 | 17192.0 |
| 2020-04-28 07:30:00 | ES | Futures | 3189.52 | 3190.89 | 3185.4 | 3190.89 | 15120.0 |
| 2020-04-28 08:00:00 | ES | Futures | 3190.89 | 3193.63 | 3186.5 | 3191.71 | 21829.0 |
| 2020-04-28 08:30:00 | ES | Futures | 3191.71 | 3197.48 | 3190.34 | 3196.65 | 25564.0 |
| 2020-04-28 09:00:00 | ES | Futures | 3196.65 | 3198.02 | 3190.34 | 3192.54 | 31994.0 |
| 2020-04-28 09:30:00 | ES | Futures | 3192.54 | 3196.65 | 3174.97 | 3175.25 | 153732.0 |
| 2020-04-28 10:00:00 | ES | Futures | 3174.97 | 3181.01 | 3164.82 | 3168.39 | 127458.0 |
| 2020-04-28 10:30:00 | ES | Futures | 3168.39 | 3169.49 | 3133.26 | 3135.46 | 141717.0 |
| 2020-04-28 11:00:00 | ES | Futures | 3135.73 | 3153.02 | 3132.71 | 3151.1 | 105847.0 |
| 2020-04-28 11:30:00 | ES | Futures | 3151.1 | 3156.59 | 3142.59 | 3145.89 | 76938.0 |
| 2020-04-28 12:00:00 | ES | Futures | 3146.16 | 3153.02 | 3133.54 | 3141.49 | 85070.0 |
| 2020-04-28 12:30:00 | ES | Futures | 3141.77 | 3153.84 | 3139.03 | 3151.37 | 61066.0 |
| 2020-04-28 13:00:00 | ES | Futures | 3151.37 | 3155.22 | 3148.08 | 3152.2 | 48418.0 |
| 2020-04-28 13:30:00 | ES | Futures | 3152.47 | 3158.78 | 3147.53 | 3153.02 | 51887.0 |
| 2020-04-28 14:00:00 | ES | Futures | 3152.75 | 3162.62 | 3152.75 | 3160.16 | 61336.0 |
| 2020-04-28 14:30:00 | ES | Futures | 3160.16 | 3162.62 | 3148.63 | 3151.92 | 72509.0 |
| 2020-04-28 15:00:00 | ES | Futures | 3151.65 | 3160.43 | 3145.89 | 3154.12 | 65996.0 |
| 2020-04-28 15:30:00 | ES | Futures | 3153.84 | 3155.76 | 3130.52 | 3134.91 | 152212.0 |
| 2020-04-28 16:00:00 | ES | Futures | 3134.63 | 3148.08 | 3132.99 | 3146.98 | 51456.0 |
| 2020-04-28 16:30:00 | ES | Futures | 3146.43 | 3147.26 | 3139.3 | 3139.85 | 8797.0 |
| 2020-04-28 18:00:00 | ES | Futures | 3150.83 | 3153.57 | 3142.87 | 3148.9 | 7229.0 |
| 2020-04-28 18:30:00 | ES | Futures | 3148.9 | 3149.45 | 3140.12 | 3143.96 | 3613.0 |
| 2020-04-28 19:00:00 | ES | Futures | 3143.96 | 3151.92 | 3140.4 | 3150.55 | 3813.0 |
| 2020-04-28 19:30:00 | ES | Futures | 3150.55 | 3157.14 | 3150.28 | 3151.92 | 5065.0 |
| 2020-04-28 20:00:00 | ES | Futures | 3152.2 | 3160.16 | 3151.37 | 3159.33 | 6450.0 |
| 2020-04-28 20:30:00 | ES | Futures | 3159.06 | 3160.98 | 3156.59 | 3158.78 | 3894.0 |
| 2020-04-28 21:00:00 | ES | Futures | 3158.78 | 3179.36 | 3158.23 | 3177.99 | 13541.0 |
| 2020-04-28 21:30:00 | ES | Futures | 3177.99 | 3184.85 | 3173.88 | 3174.97 | 10991.0 |
| 2020-04-28 22:00:00 | ES | Futures | 3174.7 | 3181.56 | 3172.78 | 3180.74 | 6339.0 |
| 2020-04-28 22:30:00 | ES | Futures | 3180.74 | 3183.21 | 3176.89 | 3182.38 | 4465.0 |
| 2020-04-28 23:00:00 | ES | Futures | 3182.38 | 3182.66 | 3174.97 | 3179.09 | 3160.0 |
| 2020-04-28 23:30:00 | ES | Futures | 3178.82 | 3182.11 | 3177.99 | 3181.29 | 2238.0 |
| 2020-04-28 00:00:00 | NQ | Futures | 10050.84 | 10050.84 | 10028.56 | 10049.98 | 1075.0 |
| 2020-04-28 00:30:00 | NQ | Futures | 10048.84 | 10057.98 | 10045.12 | 10057.41 | 1036.0 |
| 2020-04-28 01:00:00 | NQ | Futures | 10056.26 | 10085.4 | 10047.7 | 10077.4 | 2628.0 |
| 2020-04-28 01:30:00 | NQ | Futures | 10076.83 | 10100.82 | 10069.69 | 10085.69 | 1880.0 |
> showing 50 of 3,505 rows — these rows as CSV