PREVIEW / futures_30min / 2018-08-30
file: by_date/futures_30min/2018/2018-08-30.parquet size: 84 KB rows: 3,150
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-30 00:00:00 | ES | Futures | 3174.23 | 3174.5 | 3173.69 | 3174.23 | 998.0 |
| 2018-08-30 00:30:00 | ES | Futures | 3174.23 | 3174.78 | 3174.23 | 3174.23 | 634.0 |
| 2018-08-30 01:00:00 | ES | Futures | 3174.5 | 3174.5 | 3172.05 | 3172.6 | 3383.0 |
| 2018-08-30 01:30:00 | ES | Futures | 3172.6 | 3173.14 | 3172.33 | 3172.6 | 2289.0 |
| 2018-08-30 02:00:00 | ES | Futures | 3172.6 | 3173.41 | 3172.05 | 3172.87 | 2541.0 |
| 2018-08-30 02:30:00 | ES | Futures | 3172.87 | 3174.23 | 3172.33 | 3173.96 | 3296.0 |
| 2018-08-30 03:00:00 | ES | Futures | 3174.23 | 3174.23 | 3170.96 | 3171.51 | 9160.0 |
| 2018-08-30 03:30:00 | ES | Futures | 3171.78 | 3173.14 | 3170.96 | 3172.05 | 6218.0 |
| 2018-08-30 04:00:00 | ES | Futures | 3172.05 | 3172.87 | 3169.6 | 3170.15 | 8798.0 |
| 2018-08-30 04:30:00 | ES | Futures | 3170.15 | 3170.96 | 3168.24 | 3170.15 | 15578.0 |
| 2018-08-30 05:00:00 | ES | Futures | 3170.15 | 3170.69 | 3169.33 | 3169.6 | 5191.0 |
| 2018-08-30 05:30:00 | ES | Futures | 3169.6 | 3171.24 | 3169.33 | 3170.42 | 6473.0 |
| 2018-08-30 06:00:00 | ES | Futures | 3170.42 | 3170.96 | 3168.51 | 3169.33 | 6962.0 |
| 2018-08-30 06:30:00 | ES | Futures | 3169.6 | 3172.87 | 3169.33 | 3171.51 | 10105.0 |
| 2018-08-30 07:00:00 | ES | Futures | 3171.51 | 3172.6 | 3170.42 | 3172.33 | 5496.0 |
| 2018-08-30 07:30:00 | ES | Futures | 3172.33 | 3173.14 | 3170.42 | 3171.24 | 7745.0 |
| 2018-08-30 08:00:00 | ES | Futures | 3170.96 | 3173.41 | 3170.15 | 3172.33 | 9049.0 |
| 2018-08-30 08:30:00 | ES | Futures | 3172.33 | 3173.96 | 3170.96 | 3170.96 | 13402.0 |
| 2018-08-30 09:00:00 | ES | Futures | 3170.96 | 3172.33 | 3169.06 | 3170.15 | 25642.0 |
| 2018-08-30 09:30:00 | ES | Futures | 3170.42 | 3172.87 | 3168.51 | 3169.33 | 141518.0 |
| 2018-08-30 10:00:00 | ES | Futures | 3169.33 | 3173.41 | 3169.33 | 3171.24 | 63106.0 |
| 2018-08-30 10:30:00 | ES | Futures | 3171.24 | 3174.78 | 3169.6 | 3172.05 | 63074.0 |
| 2018-08-30 11:00:00 | ES | Futures | 3172.05 | 3174.5 | 3164.97 | 3166.6 | 100945.0 |
| 2018-08-30 11:30:00 | ES | Futures | 3166.6 | 3168.24 | 3165.24 | 3166.88 | 46363.0 |
| 2018-08-30 12:00:00 | ES | Futures | 3167.15 | 3169.87 | 3166.06 | 3169.33 | 44433.0 |
| 2018-08-30 12:30:00 | ES | Futures | 3169.33 | 3172.87 | 3169.06 | 3172.05 | 38422.0 |
| 2018-08-30 13:00:00 | ES | Futures | 3172.05 | 3174.23 | 3171.78 | 3173.69 | 44444.0 |
| 2018-08-30 13:30:00 | ES | Futures | 3173.69 | 3174.5 | 3172.6 | 3173.14 | 32509.0 |
| 2018-08-30 14:00:00 | ES | Futures | 3173.14 | 3174.5 | 3158.43 | 3161.97 | 160004.0 |
| 2018-08-30 14:30:00 | ES | Futures | 3161.7 | 3166.88 | 3160.61 | 3160.88 | 87461.0 |
| 2018-08-30 15:00:00 | ES | Futures | 3160.61 | 3161.43 | 3155.7 | 3160.88 | 104695.0 |
| 2018-08-30 15:30:00 | ES | Futures | 3160.88 | 3163.88 | 3158.97 | 3162.24 | 144546.0 |
| 2018-08-30 16:00:00 | ES | Futures | 3162.24 | 3164.42 | 3162.24 | 3162.79 | 41175.0 |
| 2018-08-30 16:30:00 | ES | Futures | 3162.52 | 3162.79 | 3159.25 | 3159.52 | 6194.0 |
| 2018-08-30 18:00:00 | ES | Futures | 3158.43 | 3159.79 | 3156.25 | 3156.79 | 4414.0 |
| 2018-08-30 18:30:00 | ES | Futures | 3157.07 | 3158.16 | 3157.07 | 3158.16 | 1439.0 |
| 2018-08-30 19:00:00 | ES | Futures | 3158.16 | 3160.06 | 3157.88 | 3159.52 | 1234.0 |
| 2018-08-30 19:30:00 | ES | Futures | 3159.25 | 3159.79 | 3157.88 | 3157.88 | 1077.0 |
| 2018-08-30 20:00:00 | ES | Futures | 3158.16 | 3160.61 | 3156.79 | 3159.52 | 4217.0 |
| 2018-08-30 20:30:00 | ES | Futures | 3159.79 | 3160.34 | 3158.16 | 3159.25 | 2328.0 |
| 2018-08-30 21:00:00 | ES | Futures | 3159.52 | 3162.24 | 3159.25 | 3159.52 | 4825.0 |
| 2018-08-30 21:30:00 | ES | Futures | 3159.52 | 3162.79 | 3159.25 | 3161.7 | 4990.0 |
| 2018-08-30 22:00:00 | ES | Futures | 3161.7 | 3161.97 | 3160.61 | 3160.88 | 1982.0 |
| 2018-08-30 22:30:00 | ES | Futures | 3160.88 | 3161.43 | 3159.25 | 3159.79 | 2816.0 |
| 2018-08-30 23:00:00 | ES | Futures | 3159.79 | 3161.7 | 3159.52 | 3161.43 | 2202.0 |
| 2018-08-30 23:30:00 | ES | Futures | 3161.43 | 3163.06 | 3160.88 | 3162.24 | 1897.0 |
| 2018-08-30 00:00:00 | NQ | Futures | 9021.56 | 9022.74 | 9020.97 | 9022.15 | 347.0 |
| 2018-08-30 00:30:00 | NQ | Futures | 9022.15 | 9023.33 | 9020.68 | 9022.15 | 451.0 |
| 2018-08-30 01:00:00 | NQ | Futures | 9021.86 | 9021.86 | 9016.26 | 9016.85 | 1191.0 |
| 2018-08-30 01:30:00 | NQ | Futures | 9016.85 | 9018.32 | 9015.38 | 9017.44 | 1237.0 |
> showing 50 of 3,150 rows — these rows as CSV