PREVIEW / futures_1hour / 2010-03-30
file: by_date/futures_1hour/2010/2010-03-30.parquet size: 44 KB rows: 1,362
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-30 00:00:00 | ES | Futures | 1141.96 | 1143.18 | 1141.96 | 1143.18 | 2667.0 |
| 2010-03-30 01:00:00 | ES | Futures | 1142.94 | 1143.67 | 1142.94 | 1143.67 | 3205.0 |
| 2010-03-30 02:00:00 | ES | Futures | 1143.43 | 1145.63 | 1143.43 | 1145.14 | 12015.0 |
| 2010-03-30 03:00:00 | ES | Futures | 1145.14 | 1146.36 | 1143.91 | 1144.16 | 18797.0 |
| 2010-03-30 04:00:00 | ES | Futures | 1144.16 | 1145.14 | 1142.94 | 1143.91 | 16400.0 |
| 2010-03-30 05:00:00 | ES | Futures | 1143.91 | 1144.4 | 1142.94 | 1143.67 | 9301.0 |
| 2010-03-30 06:00:00 | ES | Futures | 1143.67 | 1145.14 | 1142.69 | 1144.89 | 10581.0 |
| 2010-03-30 07:00:00 | ES | Futures | 1144.65 | 1145.63 | 1144.16 | 1144.89 | 17976.0 |
| 2010-03-30 08:00:00 | ES | Futures | 1144.89 | 1145.38 | 1142.94 | 1143.43 | 29465.0 |
| 2010-03-30 09:00:00 | ES | Futures | 1143.43 | 1147.34 | 1142.94 | 1146.85 | 223978.0 |
| 2010-03-30 10:00:00 | ES | Futures | 1146.85 | 1147.58 | 1143.18 | 1143.91 | 312289.0 |
| 2010-03-30 11:00:00 | ES | Futures | 1144.16 | 1144.16 | 1138.29 | 1141.72 | 357467.0 |
| 2010-03-30 12:00:00 | ES | Futures | 1141.47 | 1143.43 | 1140.74 | 1142.69 | 143486.0 |
| 2010-03-30 13:00:00 | ES | Futures | 1142.94 | 1142.94 | 1140.0 | 1141.47 | 123063.0 |
| 2010-03-30 14:00:00 | ES | Futures | 1141.72 | 1144.89 | 1141.23 | 1143.91 | 94166.0 |
| 2010-03-30 15:00:00 | ES | Futures | 1143.67 | 1144.89 | 1142.45 | 1143.18 | 160402.0 |
| 2010-03-30 16:00:00 | ES | Futures | 1142.94 | 1143.67 | 1142.2 | 1142.45 | 87979.0 |
| 2010-03-30 17:00:00 | ES | Futures | 1142.45 | 1143.43 | 1142.45 | 1142.45 | 3166.0 |
| 2010-03-30 18:00:00 | ES | Futures | 1142.69 | 1142.69 | 1142.2 | 1142.69 | 1975.0 |
| 2010-03-30 19:00:00 | ES | Futures | 1142.69 | 1143.67 | 1142.69 | 1143.43 | 3498.0 |
| 2010-03-30 20:00:00 | ES | Futures | 1143.43 | 1143.43 | 1142.2 | 1142.94 | 5899.0 |
| 2010-03-30 21:00:00 | ES | Futures | 1142.94 | 1142.94 | 1142.2 | 1142.45 | 1270.0 |
| 2010-03-30 22:00:00 | ES | Futures | 1142.45 | 1142.69 | 1141.47 | 1141.72 | 2820.0 |
| 2010-03-30 23:00:00 | ES | Futures | 1141.96 | 1142.94 | 1141.47 | 1142.45 | 2675.0 |
| 2010-03-30 00:00:00 | NQ | Futures | 2246.59 | 2248.31 | 2246.59 | 2248.31 | 86.0 |
| 2010-03-30 01:00:00 | NQ | Futures | 2248.31 | 2249.17 | 2247.74 | 2248.88 | 241.0 |
| 2010-03-30 02:00:00 | NQ | Futures | 2249.17 | 2252.03 | 2248.6 | 2251.75 | 657.0 |
| 2010-03-30 03:00:00 | NQ | Futures | 2251.46 | 2253.47 | 2250.03 | 2250.6 | 1357.0 |
| 2010-03-30 04:00:00 | NQ | Futures | 2250.6 | 2251.46 | 2248.31 | 2249.74 | 1007.0 |
| 2010-03-30 05:00:00 | NQ | Futures | 2249.74 | 2250.03 | 2248.6 | 2250.03 | 797.0 |
| 2010-03-30 06:00:00 | NQ | Futures | 2249.74 | 2251.46 | 2248.88 | 2250.32 | 982.0 |
| 2010-03-30 07:00:00 | NQ | Futures | 2250.6 | 2252.89 | 2250.32 | 2251.75 | 1196.0 |
| 2010-03-30 08:00:00 | NQ | Futures | 2251.46 | 2253.18 | 2247.74 | 2248.02 | 4648.0 |
| 2010-03-30 09:00:00 | NQ | Futures | 2248.31 | 2258.05 | 2248.02 | 2257.19 | 38839.0 |
| 2010-03-30 10:00:00 | NQ | Futures | 2256.9 | 2258.91 | 2245.45 | 2248.6 | 49736.0 |
| 2010-03-30 11:00:00 | NQ | Futures | 2248.31 | 2248.88 | 2236.28 | 2244.87 | 42363.0 |
| 2010-03-30 12:00:00 | NQ | Futures | 2244.87 | 2249.17 | 2244.3 | 2248.02 | 20962.0 |
| 2010-03-30 13:00:00 | NQ | Futures | 2247.74 | 2248.6 | 2242.87 | 2246.31 | 14673.0 |
| 2010-03-30 14:00:00 | NQ | Futures | 2246.59 | 2252.03 | 2245.16 | 2251.17 | 14651.0 |
| 2010-03-30 15:00:00 | NQ | Futures | 2251.17 | 2254.33 | 2249.46 | 2251.17 | 27821.0 |
| 2010-03-30 16:00:00 | NQ | Futures | 2251.17 | 2251.46 | 2248.31 | 2248.31 | 7584.0 |
| 2010-03-30 17:00:00 | NQ | Futures | 2248.6 | 2249.74 | 2248.6 | 2248.6 | 168.0 |
| 2010-03-30 18:00:00 | NQ | Futures | 2248.6 | 2248.88 | 2248.02 | 2248.88 | 88.0 |
| 2010-03-30 19:00:00 | NQ | Futures | 2248.6 | 2249.74 | 2248.6 | 2249.46 | 219.0 |
| 2010-03-30 20:00:00 | NQ | Futures | 2249.46 | 2249.46 | 2247.45 | 2248.88 | 398.0 |
| 2010-03-30 21:00:00 | NQ | Futures | 2248.88 | 2248.88 | 2248.02 | 2248.88 | 145.0 |
| 2010-03-30 22:00:00 | NQ | Futures | 2248.88 | 2249.17 | 2247.17 | 2247.45 | 192.0 |
| 2010-03-30 23:00:00 | NQ | Futures | 2247.45 | 2249.46 | 2247.17 | 2248.88 | 142.0 |
| 2010-03-30 00:00:00 | YM | Futures | 10188.0 | 10193.6 | 10188.0 | 10192.7 | 77.0 |
| 2010-03-30 01:00:00 | YM | Futures | 10192.7 | 10198.3 | 10192.7 | 10198.3 | 172.0 |
> showing 50 of 1,362 rows — these rows as CSV