PREVIEW / futures_1hour / 2010-11-15
file: by_date/futures_1hour/2010/2010-11-15.parquet size: 48 KB rows: 1,406
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-15 00:00:00 | ES | Futures | 1181.13 | 1181.87 | 1180.39 | 1181.13 | 4098.0 |
| 2010-11-15 01:00:00 | ES | Futures | 1181.13 | 1182.36 | 1180.63 | 1181.37 | 3556.0 |
| 2010-11-15 02:00:00 | ES | Futures | 1181.37 | 1181.62 | 1179.15 | 1179.4 | 10961.0 |
| 2010-11-15 03:00:00 | ES | Futures | 1179.4 | 1179.65 | 1175.7 | 1176.44 | 39646.0 |
| 2010-11-15 04:00:00 | ES | Futures | 1176.44 | 1180.39 | 1176.44 | 1180.14 | 23989.0 |
| 2010-11-15 05:00:00 | ES | Futures | 1180.14 | 1181.62 | 1179.15 | 1179.89 | 18913.0 |
| 2010-11-15 06:00:00 | ES | Futures | 1179.89 | 1182.85 | 1178.91 | 1181.62 | 24534.0 |
| 2010-11-15 07:00:00 | ES | Futures | 1181.62 | 1184.58 | 1181.37 | 1184.08 | 32874.0 |
| 2010-11-15 08:00:00 | ES | Futures | 1184.08 | 1185.81 | 1181.62 | 1183.59 | 106606.0 |
| 2010-11-15 09:00:00 | ES | Futures | 1183.59 | 1186.55 | 1182.61 | 1182.85 | 253829.0 |
| 2010-11-15 10:00:00 | ES | Futures | 1182.61 | 1185.56 | 1180.39 | 1184.08 | 318953.0 |
| 2010-11-15 11:00:00 | ES | Futures | 1184.08 | 1188.77 | 1182.11 | 1187.54 | 281716.0 |
| 2010-11-15 12:00:00 | ES | Futures | 1187.78 | 1188.52 | 1184.82 | 1187.04 | 157309.0 |
| 2010-11-15 13:00:00 | ES | Futures | 1187.29 | 1188.27 | 1185.32 | 1186.55 | 99963.0 |
| 2010-11-15 14:00:00 | ES | Futures | 1186.55 | 1187.54 | 1182.61 | 1184.58 | 189036.0 |
| 2010-11-15 15:00:00 | ES | Futures | 1184.82 | 1185.07 | 1177.92 | 1178.42 | 392626.0 |
| 2010-11-15 16:00:00 | ES | Futures | 1178.42 | 1179.89 | 1176.44 | 1177.68 | 74516.0 |
| 2010-11-15 17:00:00 | ES | Futures | 1177.68 | 1177.92 | 1176.44 | 1176.44 | 2544.0 |
| 2010-11-15 18:00:00 | ES | Futures | 1176.69 | 1177.92 | 1176.69 | 1176.94 | 6040.0 |
| 2010-11-15 19:00:00 | ES | Futures | 1177.18 | 1177.68 | 1173.49 | 1174.47 | 15496.0 |
| 2010-11-15 20:00:00 | ES | Futures | 1174.47 | 1176.44 | 1173.49 | 1173.98 | 9915.0 |
| 2010-11-15 21:00:00 | ES | Futures | 1173.73 | 1174.72 | 1171.76 | 1174.23 | 13143.0 |
| 2010-11-15 22:00:00 | ES | Futures | 1174.23 | 1175.7 | 1173.49 | 1175.46 | 7429.0 |
| 2010-11-15 23:00:00 | ES | Futures | 1175.46 | 1176.69 | 1175.21 | 1176.44 | 4199.0 |
| 2010-11-15 00:00:00 | NQ | Futures | 2455.6 | 2456.75 | 2454.45 | 2455.31 | 360.0 |
| 2010-11-15 01:00:00 | NQ | Futures | 2455.02 | 2457.89 | 2454.16 | 2455.89 | 252.0 |
| 2010-11-15 02:00:00 | NQ | Futures | 2455.6 | 2455.89 | 2452.16 | 2452.44 | 1228.0 |
| 2010-11-15 03:00:00 | NQ | Futures | 2452.44 | 2453.02 | 2447.28 | 2449.57 | 4095.0 |
| 2010-11-15 04:00:00 | NQ | Futures | 2449.57 | 2457.03 | 2449.57 | 2456.75 | 2304.0 |
| 2010-11-15 05:00:00 | NQ | Futures | 2456.46 | 2460.76 | 2455.89 | 2456.75 | 1747.0 |
| 2010-11-15 06:00:00 | NQ | Futures | 2456.75 | 2463.34 | 2455.31 | 2459.9 | 1993.0 |
| 2010-11-15 07:00:00 | NQ | Futures | 2460.48 | 2466.21 | 2459.9 | 2465.07 | 2489.0 |
| 2010-11-15 08:00:00 | NQ | Futures | 2465.35 | 2466.5 | 2459.62 | 2463.63 | 7753.0 |
| 2010-11-15 09:00:00 | NQ | Futures | 2463.63 | 2468.51 | 2449.29 | 2450.15 | 49975.0 |
| 2010-11-15 10:00:00 | NQ | Futures | 2450.72 | 2455.6 | 2444.12 | 2452.73 | 43660.0 |
| 2010-11-15 11:00:00 | NQ | Futures | 2452.73 | 2458.75 | 2445.27 | 2457.03 | 31846.0 |
| 2010-11-15 12:00:00 | NQ | Futures | 2456.75 | 2458.75 | 2450.72 | 2457.89 | 20753.0 |
| 2010-11-15 13:00:00 | NQ | Futures | 2457.61 | 2461.34 | 2453.3 | 2457.61 | 14761.0 |
| 2010-11-15 14:00:00 | NQ | Futures | 2457.61 | 2459.04 | 2449.86 | 2454.45 | 21011.0 |
| 2010-11-15 15:00:00 | NQ | Futures | 2454.74 | 2455.02 | 2440.39 | 2441.83 | 40876.0 |
| 2010-11-15 16:00:00 | NQ | Futures | 2441.83 | 2446.7 | 2436.09 | 2438.38 | 11844.0 |
| 2010-11-15 17:00:00 | NQ | Futures | 2438.38 | 2438.67 | 2436.38 | 2436.95 | 199.0 |
| 2010-11-15 18:00:00 | NQ | Futures | 2437.52 | 2439.25 | 2436.95 | 2437.52 | 308.0 |
| 2010-11-15 19:00:00 | NQ | Futures | 2437.52 | 2438.96 | 2426.33 | 2430.06 | 2408.0 |
| 2010-11-15 20:00:00 | NQ | Futures | 2430.06 | 2433.79 | 2428.06 | 2428.63 | 964.0 |
| 2010-11-15 21:00:00 | NQ | Futures | 2428.63 | 2430.06 | 2424.61 | 2428.34 | 1122.0 |
| 2010-11-15 22:00:00 | NQ | Futures | 2428.34 | 2431.21 | 2427.2 | 2430.35 | 925.0 |
| 2010-11-15 23:00:00 | NQ | Futures | 2430.35 | 2432.93 | 2430.06 | 2432.65 | 669.0 |
| 2010-11-15 00:00:00 | YM | Futures | 10639.2 | 10644.9 | 10633.5 | 10640.1 | 303.0 |
| 2010-11-15 01:00:00 | YM | Futures | 10641.1 | 10651.6 | 10638.2 | 10644.0 | 171.0 |
> showing 50 of 1,406 rows — these rows as CSV