PREVIEW / futures_1hour / 2010-11-30
file: by_date/futures_1hour/2010/2010-11-30.parquet size: 48 KB rows: 1,449
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-30 00:00:00 | ES | Futures | 1165.85 | 1167.08 | 1165.11 | 1165.11 | 7457.0 |
| 2010-11-30 01:00:00 | ES | Futures | 1165.11 | 1167.82 | 1164.61 | 1167.57 | 6766.0 |
| 2010-11-30 02:00:00 | ES | Futures | 1167.32 | 1169.3 | 1165.85 | 1168.31 | 14774.0 |
| 2010-11-30 03:00:00 | ES | Futures | 1168.31 | 1171.02 | 1164.86 | 1165.11 | 76526.0 |
| 2010-11-30 04:00:00 | ES | Futures | 1165.11 | 1167.57 | 1164.12 | 1167.08 | 52774.0 |
| 2010-11-30 05:00:00 | ES | Futures | 1166.83 | 1171.27 | 1165.35 | 1170.28 | 52089.0 |
| 2010-11-30 06:00:00 | ES | Futures | 1170.04 | 1171.02 | 1166.34 | 1168.06 | 57203.0 |
| 2010-11-30 07:00:00 | ES | Futures | 1168.06 | 1168.31 | 1161.9 | 1161.9 | 63846.0 |
| 2010-11-30 08:00:00 | ES | Futures | 1162.15 | 1163.38 | 1156.97 | 1158.94 | 125294.0 |
| 2010-11-30 09:00:00 | ES | Futures | 1158.7 | 1162.89 | 1156.48 | 1162.64 | 340306.0 |
| 2010-11-30 10:00:00 | ES | Futures | 1162.39 | 1167.08 | 1160.67 | 1163.13 | 435398.0 |
| 2010-11-30 11:00:00 | ES | Futures | 1163.38 | 1165.85 | 1161.16 | 1164.86 | 294210.0 |
| 2010-11-30 12:00:00 | ES | Futures | 1164.86 | 1166.09 | 1162.89 | 1165.85 | 183464.0 |
| 2010-11-30 13:00:00 | ES | Futures | 1165.6 | 1170.28 | 1165.11 | 1167.82 | 331174.0 |
| 2010-11-30 14:00:00 | ES | Futures | 1168.06 | 1169.79 | 1163.63 | 1166.83 | 314895.0 |
| 2010-11-30 15:00:00 | ES | Futures | 1167.08 | 1168.8 | 1162.39 | 1162.89 | 460739.0 |
| 2010-11-30 16:00:00 | ES | Futures | 1163.13 | 1163.13 | 1158.94 | 1161.65 | 223599.0 |
| 2010-11-30 17:00:00 | ES | Futures | 1161.65 | 1162.15 | 1160.92 | 1161.65 | 3767.0 |
| 2010-11-30 18:00:00 | ES | Futures | 1161.9 | 1162.15 | 1159.68 | 1160.42 | 7313.0 |
| 2010-11-30 19:00:00 | ES | Futures | 1160.42 | 1161.9 | 1160.42 | 1161.16 | 5703.0 |
| 2010-11-30 20:00:00 | ES | Futures | 1161.16 | 1162.64 | 1159.93 | 1161.65 | 6826.0 |
| 2010-11-30 21:00:00 | ES | Futures | 1161.9 | 1162.89 | 1161.41 | 1162.89 | 4089.0 |
| 2010-11-30 22:00:00 | ES | Futures | 1162.89 | 1163.87 | 1160.67 | 1163.63 | 6813.0 |
| 2010-11-30 23:00:00 | ES | Futures | 1163.87 | 1165.11 | 1163.63 | 1163.87 | 5749.0 |
| 2010-11-30 00:00:00 | NQ | Futures | 2452.73 | 2454.45 | 2451.87 | 2451.87 | 211.0 |
| 2010-11-30 01:00:00 | NQ | Futures | 2451.58 | 2457.32 | 2448.71 | 2457.32 | 349.0 |
| 2010-11-30 02:00:00 | NQ | Futures | 2456.17 | 2459.04 | 2452.73 | 2458.18 | 576.0 |
| 2010-11-30 03:00:00 | NQ | Futures | 2457.89 | 2462.48 | 2450.43 | 2450.43 | 3940.0 |
| 2010-11-30 04:00:00 | NQ | Futures | 2450.72 | 2455.6 | 2448.71 | 2454.16 | 2404.0 |
| 2010-11-30 05:00:00 | NQ | Futures | 2454.16 | 2463.63 | 2451.3 | 2461.91 | 1973.0 |
| 2010-11-30 06:00:00 | NQ | Futures | 2461.62 | 2462.77 | 2455.02 | 2455.89 | 2907.0 |
| 2010-11-30 07:00:00 | NQ | Futures | 2456.17 | 2456.46 | 2441.54 | 2441.54 | 4837.0 |
| 2010-11-30 08:00:00 | NQ | Futures | 2441.54 | 2444.12 | 2431.79 | 2435.52 | 9370.0 |
| 2010-11-30 09:00:00 | NQ | Futures | 2435.52 | 2438.1 | 2420.6 | 2435.52 | 53843.0 |
| 2010-11-30 10:00:00 | NQ | Futures | 2435.52 | 2445.84 | 2429.49 | 2436.09 | 45370.0 |
| 2010-11-30 11:00:00 | NQ | Futures | 2436.09 | 2438.67 | 2427.48 | 2432.65 | 39222.0 |
| 2010-11-30 12:00:00 | NQ | Futures | 2432.65 | 2434.37 | 2427.48 | 2431.5 | 25073.0 |
| 2010-11-30 13:00:00 | NQ | Futures | 2431.5 | 2442.69 | 2429.78 | 2436.66 | 32080.0 |
| 2010-11-30 14:00:00 | NQ | Futures | 2436.66 | 2440.68 | 2428.34 | 2435.8 | 29298.0 |
| 2010-11-30 15:00:00 | NQ | Futures | 2436.09 | 2441.25 | 2427.77 | 2429.2 | 45740.0 |
| 2010-11-30 16:00:00 | NQ | Futures | 2429.2 | 2430.06 | 2422.03 | 2427.2 | 20644.0 |
| 2010-11-30 17:00:00 | NQ | Futures | 2427.2 | 2427.77 | 2426.62 | 2426.91 | 155.0 |
| 2010-11-30 18:00:00 | NQ | Futures | 2428.34 | 2428.34 | 2422.32 | 2423.75 | 540.0 |
| 2010-11-30 19:00:00 | NQ | Futures | 2424.04 | 2426.05 | 2423.75 | 2425.19 | 583.0 |
| 2010-11-30 20:00:00 | NQ | Futures | 2426.05 | 2428.92 | 2422.6 | 2426.05 | 579.0 |
| 2010-11-30 21:00:00 | NQ | Futures | 2426.62 | 2428.34 | 2424.61 | 2427.2 | 243.0 |
| 2010-11-30 22:00:00 | NQ | Futures | 2427.48 | 2430.06 | 2424.9 | 2430.06 | 296.0 |
| 2010-11-30 23:00:00 | NQ | Futures | 2429.49 | 2432.93 | 2428.92 | 2430.64 | 599.0 |
| 2010-11-30 00:00:00 | YM | Futures | 10483.0 | 10492.5 | 10472.5 | 10472.5 | 258.0 |
| 2010-11-30 01:00:00 | YM | Futures | 10471.5 | 10495.4 | 10464.9 | 10491.5 | 585.0 |
> showing 50 of 1,449 rows — these rows as CSV