PREVIEW / futures_30min / 2010-06-11
file: by_date/futures_30min/2010/2010-06-11.parquet size: 59 KB rows: 1,994
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-11 00:00:00 | ES | Futures | 1058.12 | 1059.59 | 1058.12 | 1059.34 | 614.0 |
| 2010-06-11 00:30:00 | ES | Futures | 1059.34 | 1060.57 | 1058.12 | 1058.12 | 1360.0 |
| 2010-06-11 01:00:00 | ES | Futures | 1058.12 | 1060.08 | 1057.39 | 1058.61 | 918.0 |
| 2010-06-11 01:30:00 | ES | Futures | 1058.37 | 1059.59 | 1057.63 | 1059.59 | 1249.0 |
| 2010-06-11 02:00:00 | ES | Futures | 1059.59 | 1061.79 | 1059.59 | 1061.79 | 5093.0 |
| 2010-06-11 02:30:00 | ES | Futures | 1061.54 | 1061.79 | 1059.59 | 1059.83 | 3574.0 |
| 2010-06-11 03:00:00 | ES | Futures | 1059.83 | 1060.57 | 1057.88 | 1058.37 | 8696.0 |
| 2010-06-11 03:30:00 | ES | Futures | 1058.61 | 1059.83 | 1057.63 | 1057.63 | 8063.0 |
| 2010-06-11 04:00:00 | ES | Futures | 1057.63 | 1060.08 | 1057.63 | 1059.1 | 8272.0 |
| 2010-06-11 04:30:00 | ES | Futures | 1058.85 | 1061.54 | 1057.63 | 1060.08 | 6389.0 |
| 2010-06-11 05:00:00 | ES | Futures | 1059.83 | 1063.01 | 1059.83 | 1062.28 | 6312.0 |
| 2010-06-11 05:30:00 | ES | Futures | 1062.28 | 1063.25 | 1061.05 | 1062.28 | 6034.0 |
| 2010-06-11 06:00:00 | ES | Futures | 1062.28 | 1062.77 | 1061.3 | 1061.3 | 5594.0 |
| 2010-06-11 06:30:00 | ES | Futures | 1061.54 | 1063.01 | 1059.83 | 1060.08 | 6682.0 |
| 2010-06-11 07:00:00 | ES | Futures | 1060.08 | 1061.54 | 1059.34 | 1059.83 | 5540.0 |
| 2010-06-11 07:30:00 | ES | Futures | 1059.59 | 1060.32 | 1058.85 | 1060.08 | 6235.0 |
| 2010-06-11 08:00:00 | ES | Futures | 1060.08 | 1061.3 | 1059.83 | 1059.83 | 7823.0 |
| 2010-06-11 08:30:00 | ES | Futures | 1059.83 | 1059.83 | 1050.79 | 1051.28 | 66898.0 |
| 2010-06-11 09:00:00 | ES | Futures | 1051.28 | 1052.99 | 1050.54 | 1052.74 | 24464.0 |
| 2010-06-11 09:30:00 | ES | Futures | 1052.5 | 1060.08 | 1052.01 | 1059.59 | 87182.0 |
| 2010-06-11 10:00:00 | ES | Futures | 1059.59 | 1064.48 | 1057.63 | 1062.77 | 86860.0 |
| 2010-06-11 10:30:00 | ES | Futures | 1062.77 | 1064.23 | 1058.37 | 1058.85 | 46435.0 |
| 2010-06-11 11:00:00 | ES | Futures | 1058.85 | 1059.1 | 1054.94 | 1057.63 | 50435.0 |
| 2010-06-11 11:30:00 | ES | Futures | 1057.63 | 1060.57 | 1056.41 | 1060.32 | 35509.0 |
| 2010-06-11 12:00:00 | ES | Futures | 1060.32 | 1060.81 | 1057.39 | 1058.37 | 20261.0 |
| 2010-06-11 12:30:00 | ES | Futures | 1058.37 | 1060.57 | 1056.65 | 1059.34 | 17337.0 |
| 2010-06-11 13:00:00 | ES | Futures | 1059.34 | 1062.52 | 1059.1 | 1060.81 | 18070.0 |
| 2010-06-11 13:30:00 | ES | Futures | 1061.05 | 1061.54 | 1057.63 | 1058.37 | 17474.0 |
| 2010-06-11 14:00:00 | ES | Futures | 1058.61 | 1060.32 | 1055.68 | 1056.9 | 18069.0 |
| 2010-06-11 14:30:00 | ES | Futures | 1056.9 | 1060.57 | 1056.65 | 1059.1 | 11787.0 |
| 2010-06-11 15:00:00 | ES | Futures | 1059.1 | 1061.79 | 1057.88 | 1060.57 | 20642.0 |
| 2010-06-11 15:30:00 | ES | Futures | 1060.57 | 1067.9 | 1060.08 | 1067.17 | 67342.0 |
| 2010-06-11 16:00:00 | ES | Futures | 1067.17 | 1067.17 | 1064.72 | 1065.21 | 29087.0 |
| 2010-06-11 00:00:00 | NQ | Futures | 2084.51 | 2085.37 | 2084.51 | 2085.37 | 24.0 |
| 2010-06-11 00:30:00 | NQ | Futures | 2087.08 | 2087.94 | 2084.22 | 2084.22 | 18.0 |
| 2010-06-11 01:00:00 | NQ | Futures | 2087.08 | 2087.08 | 2083.36 | 2084.51 | 47.0 |
| 2010-06-11 01:30:00 | NQ | Futures | 2084.22 | 2086.51 | 2082.79 | 2086.51 | 59.0 |
| 2010-06-11 02:00:00 | NQ | Futures | 2088.23 | 2091.67 | 2088.23 | 2091.09 | 307.0 |
| 2010-06-11 02:30:00 | NQ | Futures | 2091.38 | 2091.38 | 2088.8 | 2089.37 | 502.0 |
| 2010-06-11 03:00:00 | NQ | Futures | 2089.66 | 2091.09 | 2084.51 | 2085.08 | 808.0 |
| 2010-06-11 03:30:00 | NQ | Futures | 2086.22 | 2088.8 | 2083.65 | 2085.94 | 534.0 |
| 2010-06-11 04:00:00 | NQ | Futures | 2086.22 | 2089.37 | 2084.79 | 2087.37 | 576.0 |
| 2010-06-11 04:30:00 | NQ | Futures | 2085.37 | 2091.67 | 2085.37 | 2088.8 | 503.0 |
| 2010-06-11 05:00:00 | NQ | Futures | 2089.66 | 2093.67 | 2088.8 | 2092.24 | 350.0 |
| 2010-06-11 05:30:00 | NQ | Futures | 2091.95 | 2093.67 | 2090.23 | 2092.52 | 357.0 |
| 2010-06-11 06:00:00 | NQ | Futures | 2092.52 | 2093.38 | 2089.95 | 2091.09 | 379.0 |
| 2010-06-11 06:30:00 | NQ | Futures | 2091.09 | 2094.53 | 2088.52 | 2088.8 | 394.0 |
| 2010-06-11 07:00:00 | NQ | Futures | 2089.09 | 2091.95 | 2087.66 | 2088.23 | 407.0 |
| 2010-06-11 07:30:00 | NQ | Futures | 2087.94 | 2089.95 | 2086.8 | 2089.66 | 688.0 |
| 2010-06-11 08:00:00 | NQ | Futures | 2089.37 | 2092.24 | 2088.52 | 2090.52 | 685.0 |
> showing 50 of 1,994 rows — these rows as CSV