PREVIEW / futures_1hour / 2010-10-25
file: by_date/futures_1hour/2010/2010-10-25.parquet size: 46 KB rows: 1,404
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-10-25 00:00:00 | ES | Futures | 1172.5 | 1176.2 | 1172.25 | 1174.23 | 19766.0 |
| 2010-10-25 01:00:00 | ES | Futures | 1173.98 | 1174.47 | 1172.25 | 1172.99 | 5311.0 |
| 2010-10-25 02:00:00 | ES | Futures | 1172.99 | 1173.24 | 1171.51 | 1172.25 | 13685.0 |
| 2010-10-25 03:00:00 | ES | Futures | 1172.25 | 1172.25 | 1169.79 | 1170.04 | 27433.0 |
| 2010-10-25 04:00:00 | ES | Futures | 1170.28 | 1172.5 | 1170.04 | 1171.76 | 18139.0 |
| 2010-10-25 05:00:00 | ES | Futures | 1172.01 | 1172.25 | 1170.53 | 1171.51 | 10094.0 |
| 2010-10-25 06:00:00 | ES | Futures | 1171.27 | 1172.99 | 1171.27 | 1172.25 | 14708.0 |
| 2010-10-25 07:00:00 | ES | Futures | 1172.25 | 1172.5 | 1170.53 | 1171.51 | 13438.0 |
| 2010-10-25 08:00:00 | ES | Futures | 1171.27 | 1171.76 | 1169.3 | 1169.79 | 44290.0 |
| 2010-10-25 09:00:00 | ES | Futures | 1170.04 | 1175.21 | 1169.3 | 1174.72 | 218870.0 |
| 2010-10-25 10:00:00 | ES | Futures | 1174.72 | 1176.2 | 1168.31 | 1169.54 | 378034.0 |
| 2010-10-25 11:00:00 | ES | Futures | 1169.54 | 1171.27 | 1167.57 | 1169.3 | 189885.0 |
| 2010-10-25 12:00:00 | ES | Futures | 1169.3 | 1169.54 | 1165.85 | 1166.83 | 126393.0 |
| 2010-10-25 13:00:00 | ES | Futures | 1166.83 | 1170.04 | 1166.34 | 1168.56 | 104582.0 |
| 2010-10-25 14:00:00 | ES | Futures | 1168.56 | 1170.04 | 1166.34 | 1168.06 | 130209.0 |
| 2010-10-25 15:00:00 | ES | Futures | 1168.06 | 1171.51 | 1164.61 | 1165.6 | 311530.0 |
| 2010-10-25 16:00:00 | ES | Futures | 1165.35 | 1166.83 | 1164.86 | 1165.6 | 82335.0 |
| 2010-10-25 17:00:00 | ES | Futures | 1165.85 | 1166.58 | 1165.6 | 1166.34 | 2355.0 |
| 2010-10-25 18:00:00 | ES | Futures | 1165.85 | 1166.09 | 1164.86 | 1165.85 | 2602.0 |
| 2010-10-25 19:00:00 | ES | Futures | 1165.6 | 1165.85 | 1164.61 | 1165.6 | 3588.0 |
| 2010-10-25 20:00:00 | ES | Futures | 1165.85 | 1166.58 | 1165.35 | 1166.09 | 4716.0 |
| 2010-10-25 21:00:00 | ES | Futures | 1166.34 | 1166.83 | 1165.6 | 1166.09 | 1958.0 |
| 2010-10-25 22:00:00 | ES | Futures | 1165.85 | 1165.85 | 1164.37 | 1164.86 | 4006.0 |
| 2010-10-25 23:00:00 | ES | Futures | 1164.86 | 1167.32 | 1164.37 | 1166.58 | 5458.0 |
| 2010-10-25 00:00:00 | NQ | Futures | 2428.34 | 2436.38 | 2428.34 | 2433.22 | 1308.0 |
| 2010-10-25 01:00:00 | NQ | Futures | 2432.93 | 2432.93 | 2429.2 | 2429.78 | 311.0 |
| 2010-10-25 02:00:00 | NQ | Futures | 2429.78 | 2430.64 | 2427.77 | 2429.49 | 783.0 |
| 2010-10-25 03:00:00 | NQ | Futures | 2429.2 | 2429.49 | 2423.18 | 2423.47 | 2296.0 |
| 2010-10-25 04:00:00 | NQ | Futures | 2423.75 | 2428.63 | 2423.47 | 2427.48 | 1504.0 |
| 2010-10-25 05:00:00 | NQ | Futures | 2428.06 | 2428.63 | 2425.19 | 2426.62 | 529.0 |
| 2010-10-25 06:00:00 | NQ | Futures | 2426.62 | 2428.63 | 2426.33 | 2427.2 | 959.0 |
| 2010-10-25 07:00:00 | NQ | Futures | 2427.2 | 2428.06 | 2425.19 | 2426.62 | 1136.0 |
| 2010-10-25 08:00:00 | NQ | Futures | 2426.33 | 2427.77 | 2423.18 | 2424.61 | 4411.0 |
| 2010-10-25 09:00:00 | NQ | Futures | 2424.9 | 2437.52 | 2420.6 | 2435.52 | 33926.0 |
| 2010-10-25 10:00:00 | NQ | Futures | 2435.8 | 2439.25 | 2423.18 | 2426.33 | 47561.0 |
| 2010-10-25 11:00:00 | NQ | Futures | 2426.05 | 2431.21 | 2421.74 | 2428.34 | 28955.0 |
| 2010-10-25 12:00:00 | NQ | Futures | 2428.34 | 2428.92 | 2421.74 | 2423.75 | 22273.0 |
| 2010-10-25 13:00:00 | NQ | Futures | 2424.04 | 2431.5 | 2422.32 | 2429.78 | 22290.0 |
| 2010-10-25 14:00:00 | NQ | Futures | 2429.78 | 2432.65 | 2425.47 | 2428.34 | 19294.0 |
| 2010-10-25 15:00:00 | NQ | Futures | 2428.06 | 2434.08 | 2422.03 | 2422.6 | 39891.0 |
| 2010-10-25 16:00:00 | NQ | Futures | 2422.6 | 2423.47 | 2417.73 | 2420.02 | 11098.0 |
| 2010-10-25 17:00:00 | NQ | Futures | 2420.31 | 2421.74 | 2420.02 | 2421.46 | 172.0 |
| 2010-10-25 18:00:00 | NQ | Futures | 2420.6 | 2421.17 | 2418.59 | 2420.31 | 232.0 |
| 2010-10-25 19:00:00 | NQ | Futures | 2419.74 | 2419.74 | 2417.44 | 2418.88 | 313.0 |
| 2010-10-25 20:00:00 | NQ | Futures | 2419.16 | 2421.17 | 2418.88 | 2420.6 | 380.0 |
| 2010-10-25 21:00:00 | NQ | Futures | 2420.6 | 2421.17 | 2419.16 | 2419.74 | 232.0 |
| 2010-10-25 22:00:00 | NQ | Futures | 2419.74 | 2419.74 | 2416.29 | 2416.87 | 472.0 |
| 2010-10-25 23:00:00 | NQ | Futures | 2417.15 | 2421.74 | 2416.58 | 2420.6 | 509.0 |
| 2010-10-25 00:00:00 | YM | Futures | 10627.8 | 10655.4 | 10627.8 | 10644.9 | 1178.0 |
| 2010-10-25 01:00:00 | YM | Futures | 10644.0 | 10644.9 | 10631.6 | 10634.4 | 304.0 |
> showing 50 of 1,404 rows — these rows as CSV