PREVIEW / futures_30min / 2018-08-28
file: by_date/futures_30min/2018/2018-08-28.parquet size: 81 KB rows: 3,105
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-08-28 00:00:00 | ES | Futures | 3161.7 | 3161.97 | 3160.06 | 3160.06 | 1808.0 |
| 2018-08-28 00:30:00 | ES | Futures | 3160.34 | 3160.88 | 3159.79 | 3159.79 | 785.0 |
| 2018-08-28 01:00:00 | ES | Futures | 3160.06 | 3160.06 | 3158.7 | 3159.52 | 2832.0 |
| 2018-08-28 01:30:00 | ES | Futures | 3159.52 | 3160.06 | 3158.97 | 3159.25 | 2547.0 |
| 2018-08-28 02:00:00 | ES | Futures | 3158.97 | 3159.52 | 3157.88 | 3158.7 | 3118.0 |
| 2018-08-28 02:30:00 | ES | Futures | 3158.43 | 3160.61 | 3158.16 | 3160.34 | 3289.0 |
| 2018-08-28 03:00:00 | ES | Futures | 3160.34 | 3160.88 | 3158.97 | 3160.06 | 6046.0 |
| 2018-08-28 03:30:00 | ES | Futures | 3160.06 | 3160.34 | 3159.25 | 3159.52 | 3779.0 |
| 2018-08-28 04:00:00 | ES | Futures | 3159.52 | 3160.06 | 3158.97 | 3159.25 | 4082.0 |
| 2018-08-28 04:30:00 | ES | Futures | 3159.25 | 3160.06 | 3157.88 | 3158.43 | 5486.0 |
| 2018-08-28 05:00:00 | ES | Futures | 3158.43 | 3161.97 | 3158.16 | 3161.97 | 6405.0 |
| 2018-08-28 05:30:00 | ES | Futures | 3161.97 | 3162.79 | 3161.15 | 3162.52 | 5267.0 |
| 2018-08-28 06:00:00 | ES | Futures | 3162.52 | 3162.52 | 3160.88 | 3161.97 | 3562.0 |
| 2018-08-28 06:30:00 | ES | Futures | 3161.97 | 3162.24 | 3161.43 | 3161.97 | 2656.0 |
| 2018-08-28 07:00:00 | ES | Futures | 3161.7 | 3162.79 | 3161.15 | 3162.52 | 6040.0 |
| 2018-08-28 07:30:00 | ES | Futures | 3162.52 | 3163.33 | 3161.97 | 3163.06 | 4570.0 |
| 2018-08-28 08:00:00 | ES | Futures | 3163.06 | 3164.15 | 3162.52 | 3163.61 | 7977.0 |
| 2018-08-28 08:30:00 | ES | Futures | 3163.33 | 3164.15 | 3162.79 | 3163.88 | 6525.0 |
| 2018-08-28 09:00:00 | ES | Futures | 3163.88 | 3167.42 | 3163.61 | 3164.15 | 30889.0 |
| 2018-08-28 09:30:00 | ES | Futures | 3164.15 | 3165.51 | 3161.15 | 3163.06 | 139375.0 |
| 2018-08-28 10:00:00 | ES | Futures | 3163.06 | 3164.15 | 3158.7 | 3160.06 | 61619.0 |
| 2018-08-28 10:30:00 | ES | Futures | 3160.06 | 3161.15 | 3157.07 | 3160.88 | 53605.0 |
| 2018-08-28 11:00:00 | ES | Futures | 3160.61 | 3162.24 | 3158.97 | 3161.43 | 49317.0 |
| 2018-08-28 11:30:00 | ES | Futures | 3161.15 | 3161.43 | 3154.61 | 3154.89 | 66285.0 |
| 2018-08-28 12:00:00 | ES | Futures | 3154.89 | 3158.7 | 3154.34 | 3157.07 | 40984.0 |
| 2018-08-28 12:30:00 | ES | Futures | 3157.07 | 3159.25 | 3157.07 | 3158.97 | 19270.0 |
| 2018-08-28 13:00:00 | ES | Futures | 3158.97 | 3160.61 | 3156.52 | 3157.34 | 37043.0 |
| 2018-08-28 13:30:00 | ES | Futures | 3157.34 | 3161.7 | 3156.25 | 3160.06 | 33081.0 |
| 2018-08-28 14:00:00 | ES | Futures | 3160.06 | 3160.88 | 3159.52 | 3160.34 | 22224.0 |
| 2018-08-28 14:30:00 | ES | Futures | 3160.34 | 3160.88 | 3158.43 | 3160.34 | 30193.0 |
| 2018-08-28 15:00:00 | ES | Futures | 3160.34 | 3161.43 | 3157.61 | 3158.7 | 35100.0 |
| 2018-08-28 15:30:00 | ES | Futures | 3158.7 | 3160.06 | 3155.43 | 3159.79 | 111490.0 |
| 2018-08-28 16:00:00 | ES | Futures | 3159.79 | 3161.15 | 3159.25 | 3160.06 | 40928.0 |
| 2018-08-28 16:30:00 | ES | Futures | 3160.61 | 3161.43 | 3160.06 | 3160.34 | 4064.0 |
| 2018-08-28 18:00:00 | ES | Futures | 3161.15 | 3162.79 | 3160.61 | 3161.97 | 4178.0 |
| 2018-08-28 18:30:00 | ES | Futures | 3161.97 | 3162.52 | 3161.97 | 3162.52 | 550.0 |
| 2018-08-28 19:00:00 | ES | Futures | 3162.52 | 3162.52 | 3161.97 | 3162.24 | 515.0 |
| 2018-08-28 19:30:00 | ES | Futures | 3162.24 | 3162.52 | 3161.7 | 3162.24 | 864.0 |
| 2018-08-28 20:00:00 | ES | Futures | 3162.24 | 3164.42 | 3162.24 | 3163.33 | 4835.0 |
| 2018-08-28 20:30:00 | ES | Futures | 3163.61 | 3163.88 | 3163.06 | 3163.61 | 1735.0 |
| 2018-08-28 21:00:00 | ES | Futures | 3163.61 | 3163.88 | 3162.79 | 3163.06 | 2077.0 |
| 2018-08-28 21:30:00 | ES | Futures | 3162.79 | 3164.15 | 3162.52 | 3163.88 | 1944.0 |
| 2018-08-28 22:00:00 | ES | Futures | 3163.88 | 3166.06 | 3163.88 | 3165.79 | 3391.0 |
| 2018-08-28 22:30:00 | ES | Futures | 3166.06 | 3166.06 | 3164.7 | 3164.97 | 1699.0 |
| 2018-08-28 23:00:00 | ES | Futures | 3165.24 | 3165.79 | 3164.42 | 3165.51 | 1013.0 |
| 2018-08-28 23:30:00 | ES | Futures | 3165.51 | 3165.51 | 3164.97 | 3165.51 | 797.0 |
| 2018-08-28 00:00:00 | NQ | Futures | 8927.64 | 8928.23 | 8921.46 | 8921.75 | 608.0 |
| 2018-08-28 00:30:00 | NQ | Futures | 8921.75 | 8925.29 | 8920.58 | 8920.58 | 413.0 |
| 2018-08-28 01:00:00 | NQ | Futures | 8920.87 | 8920.87 | 8914.98 | 8919.69 | 1557.0 |
| 2018-08-28 01:30:00 | NQ | Futures | 8919.99 | 8922.34 | 8917.63 | 8919.4 | 778.0 |
> showing 50 of 3,105 rows — these rows as CSV