PREVIEW / futures_30min / 2018-08-03
file: by_date/futures_30min/2018/2018-08-03.parquet size: 74 KB rows: 2,612
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-03 00:00:00 | ES | Futures | 3080.78 | 3082.14 | 3080.78 | 3081.59 | 703.0 |
| 2018-08-03 00:30:00 | ES | Futures | 3081.59 | 3082.14 | 3081.32 | 3082.14 | 1068.0 |
| 2018-08-03 01:00:00 | ES | Futures | 3082.14 | 3082.68 | 3081.32 | 3081.32 | 1661.0 |
| 2018-08-03 01:30:00 | ES | Futures | 3081.32 | 3082.14 | 3081.05 | 3081.59 | 1547.0 |
| 2018-08-03 02:00:00 | ES | Futures | 3081.59 | 3083.23 | 3081.05 | 3082.96 | 3887.0 |
| 2018-08-03 02:30:00 | ES | Futures | 3082.96 | 3082.96 | 3080.78 | 3081.59 | 4795.0 |
| 2018-08-03 03:00:00 | ES | Futures | 3081.59 | 3081.87 | 3078.87 | 3079.96 | 12161.0 |
| 2018-08-03 03:30:00 | ES | Futures | 3079.69 | 3081.59 | 3079.41 | 3080.5 | 5662.0 |
| 2018-08-03 04:00:00 | ES | Futures | 3080.78 | 3081.59 | 3078.6 | 3081.05 | 9254.0 |
| 2018-08-03 04:30:00 | ES | Futures | 3080.78 | 3081.59 | 3079.96 | 3080.78 | 4324.0 |
| 2018-08-03 05:00:00 | ES | Futures | 3080.78 | 3081.05 | 3079.96 | 3081.05 | 3121.0 |
| 2018-08-03 05:30:00 | ES | Futures | 3081.05 | 3082.96 | 3081.05 | 3082.96 | 4565.0 |
| 2018-08-03 06:00:00 | ES | Futures | 3083.23 | 3084.86 | 3082.68 | 3083.5 | 4590.0 |
| 2018-08-03 06:30:00 | ES | Futures | 3083.5 | 3084.32 | 3082.68 | 3084.05 | 3227.0 |
| 2018-08-03 07:00:00 | ES | Futures | 3084.05 | 3089.77 | 3084.05 | 3089.5 | 16073.0 |
| 2018-08-03 07:30:00 | ES | Futures | 3089.22 | 3090.86 | 3087.32 | 3087.32 | 13983.0 |
| 2018-08-03 08:00:00 | ES | Futures | 3087.59 | 3088.68 | 3083.77 | 3085.95 | 26140.0 |
| 2018-08-03 08:30:00 | ES | Futures | 3085.95 | 3087.32 | 3079.96 | 3082.14 | 27615.0 |
| 2018-08-03 09:00:00 | ES | Futures | 3082.41 | 3085.68 | 3081.59 | 3083.23 | 15041.0 |
| 2018-08-03 09:30:00 | ES | Futures | 3083.23 | 3085.68 | 3081.05 | 3083.23 | 109020.0 |
| 2018-08-03 10:00:00 | ES | Futures | 3083.23 | 3090.04 | 3082.14 | 3088.95 | 71897.0 |
| 2018-08-03 10:30:00 | ES | Futures | 3089.22 | 3090.31 | 3084.86 | 3085.68 | 57630.0 |
| 2018-08-03 11:00:00 | ES | Futures | 3085.68 | 3088.41 | 3084.05 | 3086.77 | 41697.0 |
| 2018-08-03 11:30:00 | ES | Futures | 3086.77 | 3087.32 | 3082.96 | 3082.96 | 38466.0 |
| 2018-08-03 12:00:00 | ES | Futures | 3082.96 | 3088.95 | 3082.68 | 3088.68 | 32496.0 |
| 2018-08-03 12:30:00 | ES | Futures | 3088.68 | 3089.22 | 3087.32 | 3088.13 | 19928.0 |
| 2018-08-03 13:00:00 | ES | Futures | 3088.13 | 3090.59 | 3088.13 | 3090.04 | 22912.0 |
| 2018-08-03 13:30:00 | ES | Futures | 3090.04 | 3092.22 | 3088.68 | 3091.68 | 27849.0 |
| 2018-08-03 14:00:00 | ES | Futures | 3091.68 | 3091.95 | 3090.04 | 3091.13 | 23708.0 |
| 2018-08-03 14:30:00 | ES | Futures | 3091.4 | 3092.22 | 3090.31 | 3091.95 | 30998.0 |
| 2018-08-03 15:00:00 | ES | Futures | 3092.22 | 3095.49 | 3091.68 | 3093.31 | 47321.0 |
| 2018-08-03 15:30:00 | ES | Futures | 3093.31 | 3095.76 | 3092.22 | 3095.76 | 101151.0 |
| 2018-08-03 16:00:00 | ES | Futures | 3095.49 | 3095.76 | 3093.85 | 3095.49 | 51602.0 |
| 2018-08-03 16:30:00 | ES | Futures | 3094.94 | 3096.85 | 3094.67 | 3096.58 | 7107.0 |
| 2018-08-03 00:00:00 | NQ | Futures | 8697.41 | 8701.23 | 8697.41 | 8699.17 | 362.0 |
| 2018-08-03 00:30:00 | NQ | Futures | 8698.88 | 8700.65 | 8695.64 | 8698.88 | 483.0 |
| 2018-08-03 01:00:00 | NQ | Futures | 8698.88 | 8699.47 | 8694.46 | 8695.64 | 560.0 |
| 2018-08-03 01:30:00 | NQ | Futures | 8695.05 | 8700.06 | 8695.05 | 8700.06 | 744.0 |
| 2018-08-03 02:00:00 | NQ | Futures | 8700.06 | 8703.29 | 8698.0 | 8702.71 | 1323.0 |
| 2018-08-03 02:30:00 | NQ | Futures | 8702.12 | 8703.88 | 8696.52 | 8697.41 | 1023.0 |
| 2018-08-03 03:00:00 | NQ | Futures | 8698.0 | 8698.88 | 8690.34 | 8694.17 | 2928.0 |
| 2018-08-03 03:30:00 | NQ | Futures | 8693.87 | 8699.76 | 8693.58 | 8696.82 | 1305.0 |
| 2018-08-03 04:00:00 | NQ | Futures | 8697.11 | 8699.76 | 8691.22 | 8698.58 | 1563.0 |
| 2018-08-03 04:30:00 | NQ | Futures | 8698.58 | 8698.88 | 8694.76 | 8697.11 | 1012.0 |
| 2018-08-03 05:00:00 | NQ | Futures | 8697.11 | 8698.88 | 8695.35 | 8698.88 | 835.0 |
| 2018-08-03 05:30:00 | NQ | Futures | 8699.17 | 8706.24 | 8698.58 | 8705.65 | 1656.0 |
| 2018-08-03 06:00:00 | NQ | Futures | 8705.65 | 8713.6 | 8703.59 | 8705.65 | 2192.0 |
| 2018-08-03 06:30:00 | NQ | Futures | 8705.65 | 8708.3 | 8702.41 | 8705.94 | 1284.0 |
| 2018-08-03 07:00:00 | NQ | Futures | 8705.94 | 8724.49 | 8705.06 | 8722.73 | 4195.0 |
| 2018-08-03 07:30:00 | NQ | Futures | 8723.32 | 8732.44 | 8722.43 | 8724.2 | 3813.0 |
> showing 50 of 2,612 rows — these rows as CSV