PREVIEW / futures_30min / 2018-08-29
file: by_date/futures_30min/2018/2018-08-29.parquet size: 82 KB rows: 3,130
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-29 00:00:00 | ES | Futures | 3165.51 | 3165.51 | 3164.97 | 3165.24 | 742.0 |
| 2018-08-29 00:30:00 | ES | Futures | 3165.24 | 3165.51 | 3164.42 | 3165.24 | 772.0 |
| 2018-08-29 01:00:00 | ES | Futures | 3165.24 | 3166.06 | 3163.61 | 3165.79 | 2963.0 |
| 2018-08-29 01:30:00 | ES | Futures | 3165.79 | 3165.79 | 3163.61 | 3163.88 | 3382.0 |
| 2018-08-29 02:00:00 | ES | Futures | 3164.15 | 3164.15 | 3163.33 | 3163.88 | 2730.0 |
| 2018-08-29 02:30:00 | ES | Futures | 3163.88 | 3164.42 | 3163.06 | 3163.88 | 3579.0 |
| 2018-08-29 03:00:00 | ES | Futures | 3164.15 | 3165.24 | 3163.33 | 3163.88 | 6445.0 |
| 2018-08-29 03:30:00 | ES | Futures | 3163.88 | 3164.42 | 3161.7 | 3162.52 | 6234.0 |
| 2018-08-29 04:00:00 | ES | Futures | 3162.24 | 3163.33 | 3161.97 | 3162.52 | 4772.0 |
| 2018-08-29 04:30:00 | ES | Futures | 3162.52 | 3163.61 | 3161.7 | 3161.7 | 4620.0 |
| 2018-08-29 05:00:00 | ES | Futures | 3161.7 | 3163.33 | 3161.43 | 3162.52 | 3335.0 |
| 2018-08-29 05:30:00 | ES | Futures | 3162.52 | 3162.52 | 3159.79 | 3161.15 | 6992.0 |
| 2018-08-29 06:00:00 | ES | Futures | 3161.15 | 3161.15 | 3159.79 | 3160.06 | 6521.0 |
| 2018-08-29 06:30:00 | ES | Futures | 3160.06 | 3160.88 | 3159.25 | 3159.79 | 2724.0 |
| 2018-08-29 07:00:00 | ES | Futures | 3160.06 | 3162.24 | 3159.79 | 3161.7 | 5395.0 |
| 2018-08-29 07:30:00 | ES | Futures | 3161.7 | 3162.52 | 3161.43 | 3161.97 | 2874.0 |
| 2018-08-29 08:00:00 | ES | Futures | 3161.97 | 3162.52 | 3158.43 | 3158.7 | 13261.0 |
| 2018-08-29 08:30:00 | ES | Futures | 3158.97 | 3160.06 | 3157.88 | 3159.25 | 16853.0 |
| 2018-08-29 09:00:00 | ES | Futures | 3159.25 | 3162.79 | 3159.25 | 3162.52 | 24280.0 |
| 2018-08-29 09:30:00 | ES | Futures | 3162.52 | 3163.61 | 3159.25 | 3162.52 | 131216.0 |
| 2018-08-29 10:00:00 | ES | Futures | 3162.79 | 3166.6 | 3160.06 | 3166.6 | 74008.0 |
| 2018-08-29 10:30:00 | ES | Futures | 3166.6 | 3170.96 | 3166.06 | 3170.42 | 105524.0 |
| 2018-08-29 11:00:00 | ES | Futures | 3170.15 | 3176.68 | 3169.06 | 3176.41 | 92308.0 |
| 2018-08-29 11:30:00 | ES | Futures | 3176.14 | 3178.05 | 3173.96 | 3176.68 | 76605.0 |
| 2018-08-29 12:00:00 | ES | Futures | 3176.68 | 3178.32 | 3175.05 | 3176.96 | 47226.0 |
| 2018-08-29 12:30:00 | ES | Futures | 3176.68 | 3178.05 | 3175.87 | 3176.96 | 30987.0 |
| 2018-08-29 13:00:00 | ES | Futures | 3176.96 | 3178.05 | 3174.78 | 3175.32 | 37651.0 |
| 2018-08-29 13:30:00 | ES | Futures | 3175.32 | 3175.59 | 3172.87 | 3173.41 | 39786.0 |
| 2018-08-29 14:00:00 | ES | Futures | 3173.41 | 3175.59 | 3172.87 | 3174.5 | 34846.0 |
| 2018-08-29 14:30:00 | ES | Futures | 3174.5 | 3176.14 | 3173.96 | 3175.32 | 26934.0 |
| 2018-08-29 15:00:00 | ES | Futures | 3175.32 | 3178.86 | 3175.32 | 3178.32 | 42612.0 |
| 2018-08-29 15:30:00 | ES | Futures | 3178.32 | 3179.68 | 3175.32 | 3176.41 | 123634.0 |
| 2018-08-29 16:00:00 | ES | Futures | 3176.41 | 3177.23 | 3175.32 | 3176.68 | 54008.0 |
| 2018-08-29 16:30:00 | ES | Futures | 3176.68 | 3177.5 | 3176.41 | 3177.5 | 5385.0 |
| 2018-08-29 18:00:00 | ES | Futures | 3177.77 | 3178.32 | 3176.68 | 3177.77 | 2809.0 |
| 2018-08-29 18:30:00 | ES | Futures | 3177.77 | 3178.32 | 3176.96 | 3177.77 | 1268.0 |
| 2018-08-29 19:00:00 | ES | Futures | 3177.77 | 3178.05 | 3177.23 | 3177.77 | 435.0 |
| 2018-08-29 19:30:00 | ES | Futures | 3177.77 | 3177.77 | 3176.41 | 3176.41 | 1486.0 |
| 2018-08-29 20:00:00 | ES | Futures | 3176.41 | 3176.68 | 3175.32 | 3175.87 | 3422.0 |
| 2018-08-29 20:30:00 | ES | Futures | 3176.14 | 3176.68 | 3175.59 | 3176.41 | 1540.0 |
| 2018-08-29 21:00:00 | ES | Futures | 3176.68 | 3177.23 | 3174.78 | 3175.32 | 3410.0 |
| 2018-08-29 21:30:00 | ES | Futures | 3175.05 | 3175.32 | 3172.87 | 3173.69 | 5873.0 |
| 2018-08-29 22:00:00 | ES | Futures | 3173.96 | 3174.78 | 3173.69 | 3173.96 | 2427.0 |
| 2018-08-29 22:30:00 | ES | Futures | 3173.69 | 3174.78 | 3173.69 | 3173.69 | 1622.0 |
| 2018-08-29 23:00:00 | ES | Futures | 3173.96 | 3174.5 | 3173.14 | 3173.69 | 2613.0 |
| 2018-08-29 23:30:00 | ES | Futures | 3173.96 | 3174.5 | 3173.69 | 3173.96 | 1859.0 |
| 2018-08-29 00:00:00 | NQ | Futures | 8947.07 | 8949.72 | 8946.48 | 8949.43 | 667.0 |
| 2018-08-29 00:30:00 | NQ | Futures | 8949.43 | 8950.31 | 8946.78 | 8949.43 | 616.0 |
| 2018-08-29 01:00:00 | NQ | Futures | 8949.13 | 8949.72 | 8942.36 | 8949.13 | 1524.0 |
| 2018-08-29 01:30:00 | NQ | Futures | 8949.13 | 8949.72 | 8945.31 | 8946.48 | 1215.0 |
> showing 50 of 3,130 rows — these rows as CSV