PREVIEW / futures_30min / 2018-09-04
file: by_date/futures_30min/2018/2018-09-04.parquet size: 88 KB rows: 3,174
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-04 00:00:00 | ES | Futures | 3166.6 | 3167.15 | 3165.51 | 3166.6 | 1523.0 |
| 2018-09-04 00:30:00 | ES | Futures | 3166.6 | 3168.24 | 3166.6 | 3167.97 | 1717.0 |
| 2018-09-04 01:00:00 | ES | Futures | 3167.69 | 3169.87 | 3167.15 | 3169.33 | 3227.0 |
| 2018-09-04 01:30:00 | ES | Futures | 3169.33 | 3170.69 | 3169.33 | 3169.33 | 4547.0 |
| 2018-09-04 02:00:00 | ES | Futures | 3169.33 | 3172.05 | 3169.33 | 3171.78 | 3261.0 |
| 2018-09-04 02:30:00 | ES | Futures | 3171.51 | 3172.33 | 3170.69 | 3171.78 | 3992.0 |
| 2018-09-04 03:00:00 | ES | Futures | 3171.78 | 3173.69 | 3171.24 | 3172.6 | 9777.0 |
| 2018-09-04 03:30:00 | ES | Futures | 3172.6 | 3172.6 | 3169.6 | 3170.69 | 5734.0 |
| 2018-09-04 04:00:00 | ES | Futures | 3170.69 | 3171.51 | 3167.69 | 3169.06 | 5888.0 |
| 2018-09-04 04:30:00 | ES | Futures | 3169.06 | 3169.06 | 3166.88 | 3167.97 | 6089.0 |
| 2018-09-04 05:00:00 | ES | Futures | 3168.24 | 3168.24 | 3164.97 | 3165.79 | 8683.0 |
| 2018-09-04 05:30:00 | ES | Futures | 3165.79 | 3165.79 | 3162.79 | 3163.33 | 9610.0 |
| 2018-09-04 06:00:00 | ES | Futures | 3163.33 | 3166.06 | 3162.79 | 3163.61 | 7312.0 |
| 2018-09-04 06:30:00 | ES | Futures | 3163.61 | 3164.7 | 3161.15 | 3162.79 | 9454.0 |
| 2018-09-04 07:00:00 | ES | Futures | 3162.52 | 3163.33 | 3156.25 | 3157.07 | 28753.0 |
| 2018-09-04 07:30:00 | ES | Futures | 3156.79 | 3157.07 | 3151.62 | 3156.52 | 30217.0 |
| 2018-09-04 08:00:00 | ES | Futures | 3156.52 | 3158.97 | 3155.43 | 3157.61 | 20269.0 |
| 2018-09-04 08:30:00 | ES | Futures | 3157.61 | 3158.7 | 3156.25 | 3157.88 | 12811.0 |
| 2018-09-04 09:00:00 | ES | Futures | 3157.88 | 3158.97 | 3155.98 | 3157.88 | 16016.0 |
| 2018-09-04 09:30:00 | ES | Futures | 3157.88 | 3158.7 | 3145.62 | 3150.26 | 241968.0 |
| 2018-09-04 10:00:00 | ES | Futures | 3150.26 | 3160.61 | 3149.98 | 3155.98 | 145443.0 |
| 2018-09-04 10:30:00 | ES | Futures | 3155.7 | 3161.7 | 3153.8 | 3159.79 | 124294.0 |
| 2018-09-04 11:00:00 | ES | Futures | 3159.79 | 3160.34 | 3154.89 | 3155.43 | 81635.0 |
| 2018-09-04 11:30:00 | ES | Futures | 3155.16 | 3157.88 | 3149.71 | 3150.26 | 77941.0 |
| 2018-09-04 12:00:00 | ES | Futures | 3150.53 | 3151.35 | 3144.81 | 3147.8 | 102795.0 |
| 2018-09-04 12:30:00 | ES | Futures | 3148.08 | 3152.16 | 3146.71 | 3151.35 | 56559.0 |
| 2018-09-04 13:00:00 | ES | Futures | 3151.07 | 3154.07 | 3150.8 | 3152.98 | 43513.0 |
| 2018-09-04 13:30:00 | ES | Futures | 3152.98 | 3155.98 | 3150.53 | 3154.89 | 50614.0 |
| 2018-09-04 14:00:00 | ES | Futures | 3154.89 | 3157.61 | 3153.8 | 3156.79 | 41677.0 |
| 2018-09-04 14:30:00 | ES | Futures | 3156.79 | 3159.52 | 3155.43 | 3158.43 | 45379.0 |
| 2018-09-04 15:00:00 | ES | Futures | 3158.43 | 3159.25 | 3155.43 | 3156.25 | 34267.0 |
| 2018-09-04 15:30:00 | ES | Futures | 3156.25 | 3158.7 | 3152.44 | 3157.61 | 126094.0 |
| 2018-09-04 16:00:00 | ES | Futures | 3157.61 | 3159.52 | 3157.34 | 3158.97 | 45871.0 |
| 2018-09-04 16:30:00 | ES | Futures | 3158.97 | 3160.34 | 3158.7 | 3159.25 | 6959.0 |
| 2018-09-04 18:00:00 | ES | Futures | 3159.25 | 3159.79 | 3158.16 | 3158.97 | 2270.0 |
| 2018-09-04 18:30:00 | ES | Futures | 3159.25 | 3159.25 | 3157.88 | 3158.16 | 809.0 |
| 2018-09-04 19:00:00 | ES | Futures | 3158.16 | 3158.16 | 3157.34 | 3157.88 | 1005.0 |
| 2018-09-04 19:30:00 | ES | Futures | 3157.88 | 3158.16 | 3156.79 | 3157.88 | 1062.0 |
| 2018-09-04 20:00:00 | ES | Futures | 3157.88 | 3158.16 | 3155.98 | 3156.52 | 2934.0 |
| 2018-09-04 20:30:00 | ES | Futures | 3156.52 | 3158.16 | 3155.7 | 3158.16 | 3445.0 |
| 2018-09-04 21:00:00 | ES | Futures | 3158.16 | 3160.06 | 3156.79 | 3159.25 | 5339.0 |
| 2018-09-04 21:30:00 | ES | Futures | 3159.52 | 3161.15 | 3157.07 | 3157.88 | 5993.0 |
| 2018-09-04 22:00:00 | ES | Futures | 3157.88 | 3159.52 | 3156.79 | 3159.25 | 2526.0 |
| 2018-09-04 22:30:00 | ES | Futures | 3158.97 | 3159.79 | 3157.07 | 3157.88 | 2497.0 |
| 2018-09-04 23:00:00 | ES | Futures | 3157.88 | 3157.88 | 3156.25 | 3156.25 | 2726.0 |
| 2018-09-04 23:30:00 | ES | Futures | 3156.52 | 3158.43 | 3156.25 | 3158.16 | 1783.0 |
| 2018-09-04 00:00:00 | NQ | Futures | 9035.1 | 9036.28 | 9031.57 | 9034.52 | 405.0 |
| 2018-09-04 00:30:00 | NQ | Futures | 9034.22 | 9040.7 | 9034.22 | 9038.93 | 643.0 |
| 2018-09-04 01:00:00 | NQ | Futures | 9038.64 | 9044.23 | 9036.58 | 9043.64 | 1347.0 |
| 2018-09-04 01:30:00 | NQ | Futures | 9043.35 | 9048.06 | 9041.88 | 9042.46 | 1642.0 |
> showing 50 of 3,174 rows — these rows as CSV