PREVIEW / futures_1hour / 2010-11-22
file: by_date/futures_1hour/2010/2010-11-22.parquet size: 47 KB rows: 1,385
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-11-22 00:00:00 | ES | Futures | 1187.54 | 1187.54 | 1186.3 | 1186.55 | 3455.0 |
| 2010-11-22 01:00:00 | ES | Futures | 1186.3 | 1188.27 | 1186.3 | 1187.54 | 4334.0 |
| 2010-11-22 02:00:00 | ES | Futures | 1187.54 | 1188.52 | 1186.55 | 1187.54 | 20201.0 |
| 2010-11-22 03:00:00 | ES | Futures | 1187.78 | 1188.77 | 1186.3 | 1186.8 | 28378.0 |
| 2010-11-22 04:00:00 | ES | Futures | 1186.8 | 1187.29 | 1185.07 | 1185.32 | 16048.0 |
| 2010-11-22 05:00:00 | ES | Futures | 1185.07 | 1186.55 | 1184.58 | 1185.07 | 15077.0 |
| 2010-11-22 06:00:00 | ES | Futures | 1185.32 | 1185.56 | 1181.37 | 1182.11 | 32459.0 |
| 2010-11-22 07:00:00 | ES | Futures | 1182.11 | 1182.11 | 1178.91 | 1180.39 | 52984.0 |
| 2010-11-22 08:00:00 | ES | Futures | 1180.63 | 1180.63 | 1175.7 | 1177.18 | 87521.0 |
| 2010-11-22 09:00:00 | ES | Futures | 1177.43 | 1180.63 | 1173.73 | 1179.89 | 229445.0 |
| 2010-11-22 10:00:00 | ES | Futures | 1179.89 | 1180.39 | 1172.5 | 1173.49 | 360718.0 |
| 2010-11-22 11:00:00 | ES | Futures | 1173.24 | 1175.21 | 1171.51 | 1174.23 | 197592.0 |
| 2010-11-22 12:00:00 | ES | Futures | 1174.23 | 1174.47 | 1165.85 | 1168.56 | 340400.0 |
| 2010-11-22 13:00:00 | ES | Futures | 1168.8 | 1172.5 | 1167.57 | 1172.01 | 178839.0 |
| 2010-11-22 14:00:00 | ES | Futures | 1172.01 | 1177.43 | 1171.51 | 1176.94 | 221020.0 |
| 2010-11-22 15:00:00 | ES | Futures | 1177.18 | 1180.39 | 1174.72 | 1179.65 | 269882.0 |
| 2010-11-22 16:00:00 | ES | Futures | 1179.65 | 1181.62 | 1178.66 | 1179.89 | 83622.0 |
| 2010-11-22 17:00:00 | ES | Futures | 1179.89 | 1180.39 | 1179.15 | 1180.39 | 2522.0 |
| 2010-11-22 18:00:00 | ES | Futures | 1180.14 | 1180.88 | 1178.42 | 1178.66 | 6993.0 |
| 2010-11-22 19:00:00 | ES | Futures | 1178.42 | 1179.15 | 1177.92 | 1178.17 | 6008.0 |
| 2010-11-22 20:00:00 | ES | Futures | 1178.17 | 1178.66 | 1177.18 | 1177.68 | 7089.0 |
| 2010-11-22 21:00:00 | ES | Futures | 1177.68 | 1178.42 | 1176.44 | 1176.69 | 5202.0 |
| 2010-11-22 22:00:00 | ES | Futures | 1176.69 | 1176.94 | 1175.7 | 1176.2 | 6831.0 |
| 2010-11-22 23:00:00 | ES | Futures | 1176.2 | 1176.69 | 1175.7 | 1176.44 | 4454.0 |
| 2010-11-22 00:00:00 | NQ | Futures | 2461.34 | 2463.06 | 2461.05 | 2461.62 | 169.0 |
| 2010-11-22 01:00:00 | NQ | Futures | 2461.62 | 2463.92 | 2461.62 | 2463.34 | 343.0 |
| 2010-11-22 02:00:00 | NQ | Futures | 2463.63 | 2465.35 | 2461.91 | 2464.49 | 1190.0 |
| 2010-11-22 03:00:00 | NQ | Futures | 2464.49 | 2466.21 | 2461.05 | 2464.49 | 2233.0 |
| 2010-11-22 04:00:00 | NQ | Futures | 2464.49 | 2465.07 | 2459.9 | 2460.48 | 1327.0 |
| 2010-11-22 05:00:00 | NQ | Futures | 2460.48 | 2463.06 | 2459.33 | 2460.19 | 793.0 |
| 2010-11-22 06:00:00 | NQ | Futures | 2460.19 | 2460.48 | 2453.02 | 2454.16 | 2210.0 |
| 2010-11-22 07:00:00 | NQ | Futures | 2454.45 | 2454.45 | 2448.43 | 2451.3 | 3242.0 |
| 2010-11-22 08:00:00 | NQ | Futures | 2451.3 | 2451.3 | 2439.53 | 2442.11 | 8145.0 |
| 2010-11-22 09:00:00 | NQ | Futures | 2442.4 | 2465.93 | 2436.09 | 2464.49 | 46375.0 |
| 2010-11-22 10:00:00 | NQ | Futures | 2464.78 | 2467.36 | 2445.27 | 2449.0 | 49701.0 |
| 2010-11-22 11:00:00 | NQ | Futures | 2449.29 | 2455.31 | 2443.84 | 2454.45 | 23888.0 |
| 2010-11-22 12:00:00 | NQ | Futures | 2454.45 | 2454.74 | 2433.79 | 2438.38 | 40297.0 |
| 2010-11-22 13:00:00 | NQ | Futures | 2438.1 | 2448.43 | 2435.52 | 2447.57 | 24172.0 |
| 2010-11-22 14:00:00 | NQ | Futures | 2447.57 | 2460.19 | 2445.84 | 2459.62 | 29445.0 |
| 2010-11-22 15:00:00 | NQ | Futures | 2459.62 | 2468.8 | 2456.17 | 2468.51 | 37112.0 |
| 2010-11-22 16:00:00 | NQ | Futures | 2468.51 | 2473.67 | 2467.36 | 2470.52 | 12126.0 |
| 2010-11-22 17:00:00 | NQ | Futures | 2470.8 | 2471.67 | 2469.94 | 2471.67 | 236.0 |
| 2010-11-22 18:00:00 | NQ | Futures | 2470.8 | 2472.24 | 2467.36 | 2467.65 | 309.0 |
| 2010-11-22 19:00:00 | NQ | Futures | 2467.65 | 2468.8 | 2466.79 | 2467.36 | 383.0 |
| 2010-11-22 20:00:00 | NQ | Futures | 2467.65 | 2468.8 | 2465.93 | 2466.5 | 436.0 |
| 2010-11-22 21:00:00 | NQ | Futures | 2466.5 | 2467.36 | 2464.49 | 2464.78 | 323.0 |
| 2010-11-22 22:00:00 | NQ | Futures | 2464.78 | 2465.35 | 2464.49 | 2464.78 | 1010.0 |
| 2010-11-22 23:00:00 | NQ | Futures | 2465.07 | 2465.64 | 2463.34 | 2465.07 | 2002.0 |
| 2010-11-22 00:00:00 | YM | Futures | 10693.5 | 10695.4 | 10687.8 | 10689.7 | 238.0 |
| 2010-11-22 01:00:00 | YM | Futures | 10687.8 | 10700.2 | 10687.8 | 10696.3 | 259.0 |
> showing 50 of 1,385 rows — these rows as CSV