PREVIEW / futures_30min / 2019-09-02
file: by_date/futures_30min/2019/2019-09-02.parquet size: 68 KB rows: 2,506
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-09-02 00:00:00 | ES | Futures | 3153.44 | 3153.98 | 3151.55 | 3152.63 | 1756.0 |
| 2019-09-02 00:30:00 | ES | Futures | 3152.63 | 3154.53 | 3151.82 | 3151.82 | 1531.0 |
| 2019-09-02 01:00:00 | ES | Futures | 3152.09 | 3155.34 | 3152.09 | 3155.34 | 2895.0 |
| 2019-09-02 01:30:00 | ES | Futures | 3155.34 | 3156.15 | 3153.17 | 3154.26 | 2765.0 |
| 2019-09-02 02:00:00 | ES | Futures | 3154.26 | 3156.42 | 3151.82 | 3152.9 | 4251.0 |
| 2019-09-02 02:30:00 | ES | Futures | 3152.9 | 3153.71 | 3151.01 | 3152.63 | 4916.0 |
| 2019-09-02 03:00:00 | ES | Futures | 3152.36 | 3160.48 | 3152.36 | 3159.67 | 11108.0 |
| 2019-09-02 03:30:00 | ES | Futures | 3159.4 | 3161.56 | 3156.96 | 3158.86 | 11919.0 |
| 2019-09-02 04:00:00 | ES | Futures | 3158.86 | 3161.84 | 3155.88 | 3160.75 | 14114.0 |
| 2019-09-02 04:30:00 | ES | Futures | 3160.75 | 3161.02 | 3158.32 | 3160.21 | 4160.0 |
| 2019-09-02 05:00:00 | ES | Futures | 3159.94 | 3160.75 | 3156.69 | 3158.59 | 6439.0 |
| 2019-09-02 05:30:00 | ES | Futures | 3158.59 | 3160.75 | 3157.23 | 3159.67 | 6035.0 |
| 2019-09-02 06:00:00 | ES | Futures | 3159.67 | 3166.98 | 3159.13 | 3166.98 | 8868.0 |
| 2019-09-02 06:30:00 | ES | Futures | 3166.98 | 3168.87 | 3164.81 | 3166.71 | 10859.0 |
| 2019-09-02 07:00:00 | ES | Futures | 3166.44 | 3166.98 | 3164.27 | 3164.27 | 5424.0 |
| 2019-09-02 07:30:00 | ES | Futures | 3164.27 | 3164.81 | 3161.84 | 3162.11 | 5888.0 |
| 2019-09-02 08:00:00 | ES | Futures | 3162.11 | 3162.92 | 3159.13 | 3159.13 | 4361.0 |
| 2019-09-02 08:30:00 | ES | Futures | 3159.4 | 3160.75 | 3158.59 | 3160.48 | 6680.0 |
| 2019-09-02 09:00:00 | ES | Futures | 3160.48 | 3160.75 | 3156.69 | 3158.86 | 6510.0 |
| 2019-09-02 09:30:00 | ES | Futures | 3159.13 | 3159.4 | 3151.82 | 3152.9 | 12852.0 |
| 2019-09-02 10:00:00 | ES | Futures | 3152.63 | 3159.67 | 3152.63 | 3158.59 | 9650.0 |
| 2019-09-02 10:30:00 | ES | Futures | 3158.32 | 3160.21 | 3158.05 | 3159.13 | 6434.0 |
| 2019-09-02 11:00:00 | ES | Futures | 3158.86 | 3159.94 | 3151.82 | 3155.34 | 11423.0 |
| 2019-09-02 11:30:00 | ES | Futures | 3155.34 | 3156.69 | 3128.27 | 3145.05 | 34542.0 |
| 2019-09-02 12:00:00 | ES | Futures | 3145.32 | 3148.03 | 3139.91 | 3142.07 | 15519.0 |
| 2019-09-02 12:30:00 | ES | Futures | 3141.8 | 3145.59 | 3138.28 | 3138.83 | 8993.0 |
| 2019-09-02 18:00:00 | ES | Futures | 3139.1 | 3148.3 | 3138.55 | 3147.49 | 6637.0 |
| 2019-09-02 18:30:00 | ES | Futures | 3147.49 | 3150.19 | 3146.95 | 3147.76 | 2829.0 |
| 2019-09-02 19:00:00 | ES | Futures | 3147.76 | 3148.57 | 3146.95 | 3148.3 | 888.0 |
| 2019-09-02 19:30:00 | ES | Futures | 3148.3 | 3148.3 | 3142.62 | 3143.43 | 3566.0 |
| 2019-09-02 20:00:00 | ES | Futures | 3143.43 | 3149.65 | 3142.62 | 3148.57 | 9136.0 |
| 2019-09-02 20:30:00 | ES | Futures | 3148.57 | 3148.84 | 3145.59 | 3145.86 | 3416.0 |
| 2019-09-02 21:00:00 | ES | Futures | 3145.86 | 3151.55 | 3143.7 | 3148.84 | 8688.0 |
| 2019-09-02 21:30:00 | ES | Futures | 3148.84 | 3156.96 | 3148.03 | 3154.8 | 12613.0 |
| 2019-09-02 22:00:00 | ES | Futures | 3154.53 | 3156.69 | 3150.47 | 3152.09 | 5884.0 |
| 2019-09-02 22:30:00 | ES | Futures | 3152.09 | 3153.71 | 3150.19 | 3151.28 | 3375.0 |
| 2019-09-02 23:00:00 | ES | Futures | 3151.28 | 3153.44 | 3149.38 | 3149.92 | 3069.0 |
| 2019-09-02 23:30:00 | ES | Futures | 3150.19 | 3151.82 | 3148.3 | 3149.11 | 2304.0 |
| 2019-09-02 00:00:00 | NQ | Futures | 8866.75 | 8869.36 | 8860.95 | 8865.59 | 1164.0 |
| 2019-09-02 00:30:00 | NQ | Futures | 8865.88 | 8868.78 | 8861.82 | 8863.27 | 895.0 |
| 2019-09-02 01:00:00 | NQ | Futures | 8863.56 | 8871.69 | 8862.69 | 8871.4 | 1562.0 |
| 2019-09-02 01:30:00 | NQ | Futures | 8871.69 | 8875.17 | 8866.75 | 8869.65 | 1636.0 |
| 2019-09-02 02:00:00 | NQ | Futures | 8869.94 | 8878.94 | 8862.69 | 8865.59 | 2348.0 |
| 2019-09-02 02:30:00 | NQ | Futures | 8865.59 | 8869.36 | 8858.34 | 8863.27 | 1849.0 |
| 2019-09-02 03:00:00 | NQ | Futures | 8864.14 | 8899.25 | 8862.69 | 8896.06 | 6114.0 |
| 2019-09-02 03:30:00 | NQ | Futures | 8895.77 | 8907.37 | 8892.58 | 8898.09 | 5098.0 |
| 2019-09-02 04:00:00 | NQ | Futures | 8898.67 | 8911.14 | 8888.51 | 8903.31 | 4794.0 |
| 2019-09-02 04:30:00 | NQ | Futures | 8903.02 | 8904.76 | 8893.74 | 8900.12 | 1976.0 |
| 2019-09-02 05:00:00 | NQ | Futures | 8900.12 | 8903.31 | 8888.51 | 8896.64 | 2654.0 |
| 2019-09-02 05:30:00 | NQ | Futures | 8896.93 | 8901.57 | 8891.42 | 8896.93 | 2026.0 |
> showing 50 of 2,506 rows — these rows as CSV