PREVIEW / futures_1hour / 2010-03-05
file: by_date/futures_1hour/2010/2010-03-05.parquet size: 37 KB rows: 1,096
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-03-05 00:00:00 | ES | Futures | 1093.2 | 1094.18 | 1093.2 | 1093.93 | 2614.0 |
| 2010-03-05 01:00:00 | ES | Futures | 1094.18 | 1094.42 | 1093.2 | 1093.2 | 2620.0 |
| 2010-03-05 02:00:00 | ES | Futures | 1093.45 | 1094.42 | 1093.2 | 1094.18 | 7736.0 |
| 2010-03-05 03:00:00 | ES | Futures | 1094.18 | 1095.39 | 1092.96 | 1094.66 | 20900.0 |
| 2010-03-05 04:00:00 | ES | Futures | 1094.42 | 1095.15 | 1093.69 | 1093.69 | 8517.0 |
| 2010-03-05 05:00:00 | ES | Futures | 1093.93 | 1097.34 | 1093.69 | 1096.85 | 20279.0 |
| 2010-03-05 06:00:00 | ES | Futures | 1096.85 | 1097.1 | 1095.64 | 1095.88 | 11264.0 |
| 2010-03-05 07:00:00 | ES | Futures | 1095.88 | 1098.07 | 1095.64 | 1096.37 | 23640.0 |
| 2010-03-05 08:00:00 | ES | Futures | 1096.61 | 1100.99 | 1095.15 | 1098.56 | 146430.0 |
| 2010-03-05 09:00:00 | ES | Futures | 1098.31 | 1100.26 | 1095.64 | 1099.77 | 236866.0 |
| 2010-03-05 10:00:00 | ES | Futures | 1099.77 | 1103.91 | 1098.8 | 1102.94 | 313160.0 |
| 2010-03-05 11:00:00 | ES | Futures | 1102.69 | 1103.91 | 1101.96 | 1102.45 | 148985.0 |
| 2010-03-05 12:00:00 | ES | Futures | 1102.21 | 1103.67 | 1101.96 | 1103.42 | 85584.0 |
| 2010-03-05 13:00:00 | ES | Futures | 1103.18 | 1104.15 | 1102.45 | 1103.42 | 96770.0 |
| 2010-03-05 14:00:00 | ES | Futures | 1103.67 | 1106.34 | 1102.69 | 1105.85 | 206987.0 |
| 2010-03-05 15:00:00 | ES | Futures | 1106.1 | 1108.04 | 1104.88 | 1107.31 | 352135.0 |
| 2010-03-05 16:00:00 | ES | Futures | 1107.31 | 1107.31 | 1105.37 | 1105.61 | 137299.0 |
| 2010-03-05 00:00:00 | NQ | Futures | 2125.94 | 2126.79 | 2125.94 | 2126.79 | 214.0 |
| 2010-03-05 01:00:00 | NQ | Futures | 2127.08 | 2127.94 | 2126.51 | 2126.79 | 265.0 |
| 2010-03-05 02:00:00 | NQ | Futures | 2126.51 | 2129.08 | 2126.22 | 2128.22 | 441.0 |
| 2010-03-05 03:00:00 | NQ | Futures | 2128.22 | 2129.94 | 2126.79 | 2128.22 | 720.0 |
| 2010-03-05 04:00:00 | NQ | Futures | 2128.22 | 2128.51 | 2126.51 | 2126.79 | 639.0 |
| 2010-03-05 05:00:00 | NQ | Futures | 2126.79 | 2131.08 | 2126.79 | 2131.08 | 851.0 |
| 2010-03-05 06:00:00 | NQ | Futures | 2131.08 | 2131.36 | 2128.51 | 2128.79 | 1016.0 |
| 2010-03-05 07:00:00 | NQ | Futures | 2129.08 | 2133.08 | 2129.08 | 2131.65 | 1562.0 |
| 2010-03-05 08:00:00 | NQ | Futures | 2131.65 | 2138.79 | 2129.37 | 2137.08 | 12723.0 |
| 2010-03-05 09:00:00 | NQ | Futures | 2136.79 | 2145.36 | 2134.79 | 2144.22 | 50987.0 |
| 2010-03-05 10:00:00 | NQ | Futures | 2144.22 | 2153.64 | 2142.5 | 2151.64 | 62353.0 |
| 2010-03-05 11:00:00 | NQ | Futures | 2151.64 | 2154.21 | 2150.79 | 2151.36 | 28179.0 |
| 2010-03-05 12:00:00 | NQ | Futures | 2151.07 | 2155.07 | 2150.22 | 2154.79 | 17450.0 |
| 2010-03-05 13:00:00 | NQ | Futures | 2154.5 | 2157.07 | 2153.07 | 2154.5 | 22045.0 |
| 2010-03-05 14:00:00 | NQ | Futures | 2154.5 | 2157.64 | 2152.79 | 2156.5 | 25869.0 |
| 2010-03-05 15:00:00 | NQ | Futures | 2156.5 | 2158.79 | 2153.93 | 2155.93 | 44526.0 |
| 2010-03-05 16:00:00 | NQ | Futures | 2155.93 | 2156.5 | 2152.79 | 2153.36 | 15041.0 |
| 2010-03-05 00:00:00 | YM | Futures | 9769.9 | 9776.4 | 9768.9 | 9776.4 | 158.0 |
| 2010-03-05 01:00:00 | YM | Futures | 9776.4 | 9777.4 | 9768.9 | 9768.9 | 198.0 |
| 2010-03-05 02:00:00 | YM | Futures | 9769.9 | 9778.3 | 9769.9 | 9776.4 | 443.0 |
| 2010-03-05 03:00:00 | YM | Futures | 9775.5 | 9784.8 | 9768.0 | 9778.3 | 1315.0 |
| 2010-03-05 04:00:00 | YM | Futures | 9778.3 | 9782.0 | 9774.6 | 9774.6 | 686.0 |
| 2010-03-05 05:00:00 | YM | Futures | 9775.5 | 9800.8 | 9775.5 | 9797.0 | 865.0 |
| 2010-03-05 06:00:00 | YM | Futures | 9797.0 | 9797.9 | 9783.0 | 9786.7 | 604.0 |
| 2010-03-05 07:00:00 | YM | Futures | 9787.7 | 9800.8 | 9786.7 | 9792.3 | 872.0 |
| 2010-03-05 08:00:00 | YM | Futures | 9792.3 | 9827.0 | 9780.2 | 9805.4 | 8257.0 |
| 2010-03-05 09:00:00 | YM | Futures | 9805.4 | 9834.4 | 9796.1 | 9827.0 | 21554.0 |
| 2010-03-05 10:00:00 | YM | Futures | 9826.0 | 9852.2 | 9817.6 | 9847.5 | 21436.0 |
| 2010-03-05 11:00:00 | YM | Futures | 9847.5 | 9856.0 | 9838.2 | 9841.0 | 12498.0 |
| 2010-03-05 12:00:00 | YM | Futures | 9840.1 | 9845.7 | 9837.3 | 9843.8 | 6647.0 |
| 2010-03-05 13:00:00 | YM | Futures | 9843.8 | 9847.5 | 9837.3 | 9843.8 | 6737.0 |
| 2010-03-05 14:00:00 | YM | Futures | 9843.8 | 9865.3 | 9836.3 | 9863.5 | 11725.0 |
| 2010-03-05 15:00:00 | YM | Futures | 9863.5 | 9883.1 | 9860.6 | 9880.3 | 18890.0 |
> showing 50 of 1,096 rows — these rows as CSV