PREVIEW / futures_30min / 2018-09-17
file: by_date/futures_30min/2018/2018-09-17.parquet size: 81 KB rows: 3,067
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-17 00:00:00 | ES | Futures | 3162.8 | 3163.07 | 3162.25 | 3162.52 | 721.0 |
| 2018-09-17 00:30:00 | ES | Futures | 3162.52 | 3162.8 | 3162.25 | 3162.25 | 593.0 |
| 2018-09-17 01:00:00 | ES | Futures | 3162.25 | 3162.52 | 3161.16 | 3161.44 | 913.0 |
| 2018-09-17 01:30:00 | ES | Futures | 3161.44 | 3162.52 | 3161.16 | 3162.25 | 1335.0 |
| 2018-09-17 02:00:00 | ES | Futures | 3162.25 | 3163.61 | 3160.62 | 3162.25 | 2457.0 |
| 2018-09-17 02:30:00 | ES | Futures | 3162.25 | 3162.25 | 3160.89 | 3161.44 | 1790.0 |
| 2018-09-17 03:00:00 | ES | Futures | 3161.44 | 3162.52 | 3160.08 | 3161.44 | 6950.0 |
| 2018-09-17 03:30:00 | ES | Futures | 3161.44 | 3163.07 | 3161.16 | 3162.25 | 3144.0 |
| 2018-09-17 04:00:00 | ES | Futures | 3162.25 | 3165.79 | 3161.44 | 3165.24 | 9749.0 |
| 2018-09-17 04:30:00 | ES | Futures | 3165.24 | 3167.42 | 3164.97 | 3166.88 | 5824.0 |
| 2018-09-17 05:00:00 | ES | Futures | 3166.88 | 3167.15 | 3162.25 | 3162.52 | 5196.0 |
| 2018-09-17 05:30:00 | ES | Futures | 3162.52 | 3163.61 | 3161.98 | 3162.52 | 2825.0 |
| 2018-09-17 06:00:00 | ES | Futures | 3162.52 | 3163.34 | 3161.44 | 3162.25 | 4284.0 |
| 2018-09-17 06:30:00 | ES | Futures | 3162.25 | 3163.61 | 3161.98 | 3162.8 | 3907.0 |
| 2018-09-17 07:00:00 | ES | Futures | 3163.07 | 3164.97 | 3163.07 | 3164.97 | 4762.0 |
| 2018-09-17 07:30:00 | ES | Futures | 3164.97 | 3165.24 | 3163.34 | 3164.7 | 5350.0 |
| 2018-09-17 08:00:00 | ES | Futures | 3164.7 | 3165.24 | 3163.07 | 3163.34 | 6571.0 |
| 2018-09-17 08:30:00 | ES | Futures | 3163.34 | 3164.7 | 3162.8 | 3164.43 | 9487.0 |
| 2018-09-17 09:00:00 | ES | Futures | 3164.43 | 3165.79 | 3163.34 | 3165.79 | 7894.0 |
| 2018-09-17 09:30:00 | ES | Futures | 3165.52 | 3166.33 | 3160.08 | 3161.98 | 99800.0 |
| 2018-09-17 10:00:00 | ES | Futures | 3161.98 | 3162.52 | 3158.99 | 3160.89 | 69730.0 |
| 2018-09-17 10:30:00 | ES | Futures | 3160.62 | 3161.44 | 3154.36 | 3155.18 | 90654.0 |
| 2018-09-17 11:00:00 | ES | Futures | 3155.18 | 3160.08 | 3154.91 | 3158.17 | 59556.0 |
| 2018-09-17 11:30:00 | ES | Futures | 3158.17 | 3160.08 | 3157.36 | 3158.72 | 33998.0 |
| 2018-09-17 12:00:00 | ES | Futures | 3158.99 | 3161.16 | 3157.9 | 3159.8 | 33139.0 |
| 2018-09-17 12:30:00 | ES | Futures | 3159.8 | 3160.62 | 3156.0 | 3158.72 | 38211.0 |
| 2018-09-17 13:00:00 | ES | Futures | 3158.72 | 3159.8 | 3155.18 | 3155.45 | 33208.0 |
| 2018-09-17 13:30:00 | ES | Futures | 3155.18 | 3158.44 | 3152.73 | 3156.54 | 61980.0 |
| 2018-09-17 14:00:00 | ES | Futures | 3156.54 | 3158.44 | 3155.45 | 3157.08 | 34588.0 |
| 2018-09-17 14:30:00 | ES | Futures | 3157.08 | 3157.63 | 3152.19 | 3153.82 | 36434.0 |
| 2018-09-17 15:00:00 | ES | Futures | 3153.82 | 3154.91 | 3148.38 | 3150.01 | 93335.0 |
| 2018-09-17 15:30:00 | ES | Futures | 3150.01 | 3151.37 | 3146.75 | 3149.74 | 147577.0 |
| 2018-09-17 16:00:00 | ES | Futures | 3149.74 | 3153.0 | 3149.74 | 3150.83 | 55576.0 |
| 2018-09-17 16:30:00 | ES | Futures | 3150.83 | 3151.92 | 3149.47 | 3150.83 | 6866.0 |
| 2018-09-17 18:00:00 | ES | Futures | 3150.28 | 3151.1 | 3147.56 | 3148.11 | 4177.0 |
| 2018-09-17 18:30:00 | ES | Futures | 3148.38 | 3148.92 | 3137.23 | 3138.04 | 14858.0 |
| 2018-09-17 19:00:00 | ES | Futures | 3138.04 | 3141.85 | 3138.04 | 3140.76 | 4920.0 |
| 2018-09-17 19:30:00 | ES | Futures | 3140.76 | 3141.04 | 3138.32 | 3138.59 | 2965.0 |
| 2018-09-17 20:00:00 | ES | Futures | 3138.59 | 3142.12 | 3138.04 | 3141.58 | 4927.0 |
| 2018-09-17 20:30:00 | ES | Futures | 3141.31 | 3141.58 | 3140.22 | 3140.76 | 2540.0 |
| 2018-09-17 21:00:00 | ES | Futures | 3140.49 | 3142.67 | 3139.4 | 3141.04 | 3706.0 |
| 2018-09-17 21:30:00 | ES | Futures | 3141.04 | 3144.84 | 3141.04 | 3144.3 | 6843.0 |
| 2018-09-17 22:00:00 | ES | Futures | 3144.3 | 3145.39 | 3143.21 | 3143.21 | 2302.0 |
| 2018-09-17 22:30:00 | ES | Futures | 3143.21 | 3146.48 | 3142.94 | 3146.48 | 3117.0 |
| 2018-09-17 23:00:00 | ES | Futures | 3146.48 | 3147.84 | 3146.2 | 3146.2 | 3625.0 |
| 2018-09-17 23:30:00 | ES | Futures | 3146.48 | 3149.2 | 3146.2 | 3148.65 | 5155.0 |
| 2018-09-17 00:00:00 | NQ | Futures | 8873.05 | 8874.22 | 8868.06 | 8868.06 | 585.0 |
| 2018-09-17 00:30:00 | NQ | Futures | 8867.77 | 8873.34 | 8867.18 | 8868.65 | 423.0 |
| 2018-09-17 01:00:00 | NQ | Futures | 8868.65 | 8870.11 | 8864.54 | 8866.89 | 640.0 |
| 2018-09-17 01:30:00 | NQ | Futures | 8866.59 | 8867.77 | 8862.49 | 8867.47 | 595.0 |
> showing 50 of 3,067 rows — these rows as CSV