PREVIEW / futures_30min / 2019-04-17
file: by_date/futures_30min/2019/2019-04-17.parquet size: 81 KB rows: 3,276
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-17 00:00:00 | ES | Futures | 3159.97 | 3161.05 | 3159.43 | 3160.24 | 3370.0 |
| 2019-04-17 00:30:00 | ES | Futures | 3160.51 | 3160.78 | 3159.43 | 3159.7 | 1948.0 |
| 2019-04-17 01:00:00 | ES | Futures | 3159.7 | 3161.59 | 3159.43 | 3161.59 | 2238.0 |
| 2019-04-17 01:30:00 | ES | Futures | 3161.59 | 3162.14 | 3161.05 | 3161.59 | 2120.0 |
| 2019-04-17 02:00:00 | ES | Futures | 3161.59 | 3162.14 | 3160.51 | 3160.78 | 2603.0 |
| 2019-04-17 02:30:00 | ES | Futures | 3160.51 | 3161.59 | 3160.24 | 3160.51 | 2292.0 |
| 2019-04-17 03:00:00 | ES | Futures | 3160.51 | 3161.87 | 3159.97 | 3161.59 | 5578.0 |
| 2019-04-17 03:30:00 | ES | Futures | 3161.59 | 3161.87 | 3160.24 | 3161.32 | 2814.0 |
| 2019-04-17 04:00:00 | ES | Futures | 3161.32 | 3162.68 | 3161.05 | 3162.41 | 3010.0 |
| 2019-04-17 04:30:00 | ES | Futures | 3162.41 | 3162.41 | 3161.59 | 3162.14 | 2855.0 |
| 2019-04-17 05:00:00 | ES | Futures | 3162.41 | 3162.95 | 3161.87 | 3162.41 | 3573.0 |
| 2019-04-17 05:30:00 | ES | Futures | 3162.41 | 3163.76 | 3162.14 | 3163.49 | 4720.0 |
| 2019-04-17 06:00:00 | ES | Futures | 3163.49 | 3163.76 | 3162.68 | 3162.95 | 3270.0 |
| 2019-04-17 06:30:00 | ES | Futures | 3163.22 | 3163.22 | 3162.14 | 3162.14 | 2875.0 |
| 2019-04-17 07:00:00 | ES | Futures | 3162.14 | 3164.31 | 3162.14 | 3163.76 | 4288.0 |
| 2019-04-17 07:30:00 | ES | Futures | 3163.76 | 3164.85 | 3163.76 | 3164.31 | 4929.0 |
| 2019-04-17 08:00:00 | ES | Futures | 3164.58 | 3165.39 | 3164.31 | 3164.85 | 6820.0 |
| 2019-04-17 08:30:00 | ES | Futures | 3164.85 | 3167.02 | 3164.58 | 3165.93 | 13238.0 |
| 2019-04-17 09:00:00 | ES | Futures | 3165.93 | 3170.0 | 3165.93 | 3169.73 | 30018.0 |
| 2019-04-17 09:30:00 | ES | Futures | 3169.73 | 3170.27 | 3155.63 | 3155.9 | 212821.0 |
| 2019-04-17 10:00:00 | ES | Futures | 3155.9 | 3156.71 | 3149.67 | 3156.17 | 171856.0 |
| 2019-04-17 10:30:00 | ES | Futures | 3156.17 | 3157.8 | 3151.84 | 3152.38 | 85193.0 |
| 2019-04-17 11:00:00 | ES | Futures | 3152.38 | 3156.71 | 3150.48 | 3151.02 | 63434.0 |
| 2019-04-17 11:30:00 | ES | Futures | 3150.75 | 3153.73 | 3147.23 | 3149.94 | 86685.0 |
| 2019-04-17 12:00:00 | ES | Futures | 3149.94 | 3150.48 | 3145.6 | 3149.94 | 62644.0 |
| 2019-04-17 12:30:00 | ES | Futures | 3149.94 | 3152.65 | 3149.4 | 3151.56 | 39296.0 |
| 2019-04-17 13:00:00 | ES | Futures | 3151.29 | 3154.0 | 3149.12 | 3149.94 | 68079.0 |
| 2019-04-17 13:30:00 | ES | Futures | 3149.94 | 3152.65 | 3148.85 | 3149.12 | 46951.0 |
| 2019-04-17 14:00:00 | ES | Futures | 3149.12 | 3150.48 | 3143.16 | 3144.24 | 97213.0 |
| 2019-04-17 14:30:00 | ES | Futures | 3144.52 | 3149.4 | 3144.24 | 3148.58 | 41502.0 |
| 2019-04-17 15:00:00 | ES | Futures | 3148.58 | 3151.02 | 3148.58 | 3149.12 | 34923.0 |
| 2019-04-17 15:30:00 | ES | Futures | 3149.12 | 3152.11 | 3148.31 | 3148.58 | 97803.0 |
| 2019-04-17 16:00:00 | ES | Futures | 3148.58 | 3149.12 | 3144.79 | 3145.33 | 47807.0 |
| 2019-04-17 16:30:00 | ES | Futures | 3145.6 | 3146.14 | 3144.79 | 3145.6 | 7384.0 |
| 2019-04-17 18:00:00 | ES | Futures | 3145.87 | 3147.23 | 3145.6 | 3146.68 | 3018.0 |
| 2019-04-17 18:30:00 | ES | Futures | 3146.68 | 3147.77 | 3146.41 | 3147.5 | 1569.0 |
| 2019-04-17 19:00:00 | ES | Futures | 3147.77 | 3148.04 | 3147.23 | 3148.04 | 1258.0 |
| 2019-04-17 19:30:00 | ES | Futures | 3147.77 | 3148.58 | 3146.96 | 3148.58 | 1628.0 |
| 2019-04-17 20:00:00 | ES | Futures | 3148.58 | 3148.58 | 3144.79 | 3145.06 | 4576.0 |
| 2019-04-17 20:30:00 | ES | Futures | 3145.06 | 3146.41 | 3144.79 | 3145.6 | 2246.0 |
| 2019-04-17 21:00:00 | ES | Futures | 3145.6 | 3146.96 | 3139.36 | 3142.35 | 12883.0 |
| 2019-04-17 21:30:00 | ES | Futures | 3142.62 | 3143.97 | 3140.72 | 3140.99 | 7776.0 |
| 2019-04-17 22:00:00 | ES | Futures | 3140.72 | 3142.62 | 3140.18 | 3142.62 | 5284.0 |
| 2019-04-17 22:30:00 | ES | Futures | 3142.35 | 3142.62 | 3141.53 | 3141.8 | 2813.0 |
| 2019-04-17 23:00:00 | ES | Futures | 3141.53 | 3141.8 | 3137.74 | 3138.01 | 5288.0 |
| 2019-04-17 23:30:00 | ES | Futures | 3137.74 | 3138.28 | 3136.11 | 3136.92 | 5592.0 |
| 2019-04-17 00:00:00 | NQ | Futures | 8959.45 | 8962.66 | 8958.0 | 8960.62 | 1292.0 |
| 2019-04-17 00:30:00 | NQ | Futures | 8960.62 | 8960.91 | 8956.54 | 8957.71 | 736.0 |
| 2019-04-17 01:00:00 | NQ | Futures | 8957.71 | 8964.69 | 8957.71 | 8963.82 | 796.0 |
| 2019-04-17 01:30:00 | NQ | Futures | 8964.11 | 8966.44 | 8962.66 | 8964.11 | 917.0 |
> showing 50 of 3,276 rows — these rows as CSV