PREVIEW / futures_1hour / 2010-10-26
file: by_date/futures_1hour/2010/2010-10-26.parquet size: 48 KB rows: 1,458
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-26 00:00:00 | ES | Futures | 1166.58 | 1167.32 | 1166.09 | 1166.83 | 2545.0 |
| 2010-10-26 01:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.09 | 1166.83 | 3586.0 |
| 2010-10-26 02:00:00 | ES | Futures | 1166.83 | 1167.32 | 1165.11 | 1165.35 | 11026.0 |
| 2010-10-26 03:00:00 | ES | Futures | 1165.35 | 1167.57 | 1163.13 | 1163.63 | 36491.0 |
| 2010-10-26 04:00:00 | ES | Futures | 1163.87 | 1165.6 | 1163.13 | 1164.61 | 27356.0 |
| 2010-10-26 05:00:00 | ES | Futures | 1164.37 | 1164.61 | 1162.39 | 1164.37 | 23702.0 |
| 2010-10-26 06:00:00 | ES | Futures | 1164.12 | 1166.58 | 1164.12 | 1165.85 | 15292.0 |
| 2010-10-26 07:00:00 | ES | Futures | 1165.85 | 1166.34 | 1161.9 | 1163.38 | 29813.0 |
| 2010-10-26 08:00:00 | ES | Futures | 1163.38 | 1163.38 | 1160.67 | 1161.41 | 64014.0 |
| 2010-10-26 09:00:00 | ES | Futures | 1161.16 | 1161.9 | 1157.46 | 1160.67 | 248904.0 |
| 2010-10-26 10:00:00 | ES | Futures | 1160.67 | 1166.09 | 1160.18 | 1164.86 | 340899.0 |
| 2010-10-26 11:00:00 | ES | Futures | 1164.86 | 1166.34 | 1161.65 | 1165.35 | 205355.0 |
| 2010-10-26 12:00:00 | ES | Futures | 1165.6 | 1166.58 | 1164.12 | 1165.11 | 93580.0 |
| 2010-10-26 13:00:00 | ES | Futures | 1164.86 | 1166.58 | 1162.39 | 1162.89 | 120003.0 |
| 2010-10-26 14:00:00 | ES | Futures | 1162.89 | 1165.11 | 1161.16 | 1164.12 | 179933.0 |
| 2010-10-26 15:00:00 | ES | Futures | 1164.12 | 1167.08 | 1163.87 | 1165.6 | 232468.0 |
| 2010-10-26 16:00:00 | ES | Futures | 1165.85 | 1167.57 | 1165.35 | 1166.58 | 84349.0 |
| 2010-10-26 17:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.34 | 1166.83 | 1262.0 |
| 2010-10-26 18:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.34 | 1166.83 | 1644.0 |
| 2010-10-26 19:00:00 | ES | Futures | 1166.58 | 1167.57 | 1166.34 | 1167.32 | 1994.0 |
| 2010-10-26 20:00:00 | ES | Futures | 1167.32 | 1169.54 | 1166.58 | 1167.82 | 11347.0 |
| 2010-10-26 21:00:00 | ES | Futures | 1168.06 | 1168.31 | 1165.85 | 1166.83 | 6768.0 |
| 2010-10-26 22:00:00 | ES | Futures | 1166.83 | 1167.32 | 1164.86 | 1165.11 | 6979.0 |
| 2010-10-26 23:00:00 | ES | Futures | 1165.11 | 1165.35 | 1161.16 | 1161.65 | 14339.0 |
| 2010-10-26 00:00:00 | NQ | Futures | 2421.17 | 2422.03 | 2419.16 | 2419.74 | 414.0 |
| 2010-10-26 01:00:00 | NQ | Futures | 2419.74 | 2421.17 | 2419.74 | 2420.31 | 324.0 |
| 2010-10-26 02:00:00 | NQ | Futures | 2420.02 | 2421.17 | 2417.44 | 2417.73 | 365.0 |
| 2010-10-26 03:00:00 | NQ | Futures | 2417.73 | 2422.6 | 2414.86 | 2415.15 | 1862.0 |
| 2010-10-26 04:00:00 | NQ | Futures | 2415.43 | 2418.88 | 2414.28 | 2416.87 | 1235.0 |
| 2010-10-26 05:00:00 | NQ | Futures | 2416.58 | 2417.15 | 2413.42 | 2416.87 | 977.0 |
| 2010-10-26 06:00:00 | NQ | Futures | 2417.15 | 2421.74 | 2416.87 | 2420.6 | 1042.0 |
| 2010-10-26 07:00:00 | NQ | Futures | 2420.31 | 2421.46 | 2413.42 | 2415.43 | 1997.0 |
| 2010-10-26 08:00:00 | NQ | Futures | 2415.15 | 2416.01 | 2410.84 | 2411.42 | 4957.0 |
| 2010-10-26 09:00:00 | NQ | Futures | 2411.7 | 2412.28 | 2401.37 | 2406.54 | 42529.0 |
| 2010-10-26 10:00:00 | NQ | Futures | 2407.11 | 2426.05 | 2407.11 | 2424.61 | 49755.0 |
| 2010-10-26 11:00:00 | NQ | Futures | 2424.61 | 2430.35 | 2420.31 | 2429.2 | 34994.0 |
| 2010-10-26 12:00:00 | NQ | Futures | 2429.2 | 2433.51 | 2427.2 | 2430.06 | 22623.0 |
| 2010-10-26 13:00:00 | NQ | Futures | 2430.06 | 2435.23 | 2425.76 | 2426.33 | 19734.0 |
| 2010-10-26 14:00:00 | NQ | Futures | 2426.33 | 2431.5 | 2423.18 | 2428.92 | 24728.0 |
| 2010-10-26 15:00:00 | NQ | Futures | 2429.2 | 2434.08 | 2426.91 | 2429.49 | 36853.0 |
| 2010-10-26 16:00:00 | NQ | Futures | 2429.49 | 2432.36 | 2427.2 | 2430.35 | 8946.0 |
| 2010-10-26 17:00:00 | NQ | Futures | 2430.92 | 2431.5 | 2430.06 | 2430.06 | 125.0 |
| 2010-10-26 18:00:00 | NQ | Futures | 2430.06 | 2432.07 | 2430.06 | 2431.5 | 292.0 |
| 2010-10-26 19:00:00 | NQ | Futures | 2431.5 | 2433.51 | 2431.5 | 2433.51 | 231.0 |
| 2010-10-26 20:00:00 | NQ | Futures | 2433.51 | 2438.38 | 2433.51 | 2436.09 | 1026.0 |
| 2010-10-26 21:00:00 | NQ | Futures | 2436.38 | 2436.38 | 2432.36 | 2433.22 | 554.0 |
| 2010-10-26 22:00:00 | NQ | Futures | 2433.79 | 2434.37 | 2429.49 | 2429.78 | 407.0 |
| 2010-10-26 23:00:00 | NQ | Futures | 2429.78 | 2430.06 | 2422.6 | 2423.47 | 995.0 |
| 2010-10-26 00:00:00 | YM | Futures | 10595.4 | 10600.1 | 10589.7 | 10591.6 | 127.0 |
| 2010-10-26 01:00:00 | YM | Futures | 10592.5 | 10598.2 | 10588.7 | 10592.5 | 155.0 |
> showing 50 of 1,458 rows — these rows as CSV