PREVIEW / futures_1hour / 2010-12-01
file: by_date/futures_1hour/2010/2010-12-01.parquet size: 49 KB rows: 1,446
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-12-01 00:00:00 | ES | Futures | 1164.12 | 1167.08 | 1164.12 | 1166.34 | 7086.0 |
| 2010-12-01 01:00:00 | ES | Futures | 1166.34 | 1166.58 | 1165.35 | 1165.85 | 4128.0 |
| 2010-12-01 02:00:00 | ES | Futures | 1165.85 | 1167.82 | 1165.6 | 1166.83 | 19034.0 |
| 2010-12-01 03:00:00 | ES | Futures | 1167.08 | 1172.25 | 1166.09 | 1171.27 | 56455.0 |
| 2010-12-01 04:00:00 | ES | Futures | 1171.27 | 1172.5 | 1169.3 | 1172.25 | 27367.0 |
| 2010-12-01 05:00:00 | ES | Futures | 1172.25 | 1174.96 | 1171.27 | 1174.23 | 34211.0 |
| 2010-12-01 06:00:00 | ES | Futures | 1174.47 | 1177.92 | 1173.73 | 1176.94 | 55499.0 |
| 2010-12-01 07:00:00 | ES | Futures | 1176.69 | 1178.17 | 1174.72 | 1177.18 | 54860.0 |
| 2010-12-01 08:00:00 | ES | Futures | 1177.18 | 1179.65 | 1176.44 | 1179.65 | 100752.0 |
| 2010-12-01 09:00:00 | ES | Futures | 1179.65 | 1185.32 | 1178.42 | 1184.82 | 337591.0 |
| 2010-12-01 10:00:00 | ES | Futures | 1184.58 | 1186.06 | 1181.37 | 1182.85 | 334586.0 |
| 2010-12-01 11:00:00 | ES | Futures | 1183.1 | 1189.51 | 1182.36 | 1188.77 | 289576.0 |
| 2010-12-01 12:00:00 | ES | Futures | 1189.01 | 1190.74 | 1187.54 | 1188.27 | 182457.0 |
| 2010-12-01 13:00:00 | ES | Futures | 1188.27 | 1190.25 | 1186.55 | 1188.27 | 208106.0 |
| 2010-12-01 14:00:00 | ES | Futures | 1188.27 | 1190.25 | 1186.8 | 1189.75 | 147926.0 |
| 2010-12-01 15:00:00 | ES | Futures | 1189.75 | 1189.75 | 1186.8 | 1188.27 | 282169.0 |
| 2010-12-01 16:00:00 | ES | Futures | 1188.27 | 1188.77 | 1185.81 | 1187.54 | 143678.0 |
| 2010-12-01 17:00:00 | ES | Futures | 1187.29 | 1188.03 | 1186.8 | 1187.54 | 1807.0 |
| 2010-12-01 18:00:00 | ES | Futures | 1187.78 | 1189.01 | 1187.54 | 1189.01 | 6517.0 |
| 2010-12-01 19:00:00 | ES | Futures | 1189.26 | 1189.51 | 1187.04 | 1188.03 | 7552.0 |
| 2010-12-01 20:00:00 | ES | Futures | 1188.03 | 1188.27 | 1187.29 | 1187.78 | 4989.0 |
| 2010-12-01 21:00:00 | ES | Futures | 1187.54 | 1188.03 | 1187.04 | 1187.54 | 1755.0 |
| 2010-12-01 22:00:00 | ES | Futures | 1187.29 | 1188.03 | 1187.04 | 1187.54 | 2451.0 |
| 2010-12-01 23:00:00 | ES | Futures | 1187.78 | 1188.03 | 1186.8 | 1187.54 | 2521.0 |
| 2010-12-01 00:00:00 | NQ | Futures | 2430.64 | 2436.66 | 2430.64 | 2436.38 | 583.0 |
| 2010-12-01 01:00:00 | NQ | Futures | 2436.09 | 2436.66 | 2434.37 | 2434.37 | 431.0 |
| 2010-12-01 02:00:00 | NQ | Futures | 2434.94 | 2437.81 | 2434.65 | 2436.38 | 829.0 |
| 2010-12-01 03:00:00 | NQ | Futures | 2436.38 | 2446.7 | 2435.23 | 2444.7 | 3774.0 |
| 2010-12-01 04:00:00 | NQ | Futures | 2444.12 | 2446.13 | 2440.11 | 2444.98 | 1922.0 |
| 2010-12-01 05:00:00 | NQ | Futures | 2444.7 | 2450.72 | 2443.84 | 2449.86 | 1945.0 |
| 2010-12-01 06:00:00 | NQ | Futures | 2449.86 | 2456.46 | 2448.71 | 2453.59 | 3191.0 |
| 2010-12-01 07:00:00 | NQ | Futures | 2453.88 | 2458.18 | 2449.86 | 2455.6 | 3403.0 |
| 2010-12-01 08:00:00 | NQ | Futures | 2455.31 | 2465.07 | 2454.16 | 2464.78 | 11737.0 |
| 2010-12-01 09:00:00 | NQ | Futures | 2464.78 | 2486.3 | 2461.91 | 2485.44 | 68474.0 |
| 2010-12-01 10:00:00 | NQ | Futures | 2485.15 | 2487.44 | 2477.4 | 2483.71 | 46459.0 |
| 2010-12-01 11:00:00 | NQ | Futures | 2484.0 | 2493.18 | 2481.71 | 2491.75 | 35895.0 |
| 2010-12-01 12:00:00 | NQ | Futures | 2491.75 | 2494.9 | 2488.31 | 2490.89 | 29085.0 |
| 2010-12-01 13:00:00 | NQ | Futures | 2490.89 | 2494.04 | 2486.3 | 2487.73 | 27210.0 |
| 2010-12-01 14:00:00 | NQ | Futures | 2488.02 | 2490.6 | 2484.58 | 2488.88 | 19227.0 |
| 2010-12-01 15:00:00 | NQ | Futures | 2488.59 | 2488.88 | 2480.56 | 2481.42 | 37332.0 |
| 2010-12-01 16:00:00 | NQ | Futures | 2481.42 | 2481.71 | 2475.11 | 2477.98 | 13185.0 |
| 2010-12-01 17:00:00 | NQ | Futures | 2477.69 | 2478.84 | 2477.4 | 2478.26 | 134.0 |
| 2010-12-01 18:00:00 | NQ | Futures | 2478.84 | 2481.13 | 2477.98 | 2481.13 | 310.0 |
| 2010-12-01 19:00:00 | NQ | Futures | 2481.13 | 2482.28 | 2476.83 | 2477.98 | 891.0 |
| 2010-12-01 20:00:00 | NQ | Futures | 2477.98 | 2479.41 | 2477.12 | 2477.98 | 265.0 |
| 2010-12-01 21:00:00 | NQ | Futures | 2477.98 | 2477.98 | 2476.54 | 2477.12 | 162.0 |
| 2010-12-01 22:00:00 | NQ | Futures | 2477.12 | 2478.26 | 2476.83 | 2478.26 | 81.0 |
| 2010-12-01 23:00:00 | NQ | Futures | 2477.98 | 2477.98 | 2476.54 | 2477.4 | 129.0 |
| 2010-12-01 00:00:00 | YM | Futures | 10483.9 | 10507.7 | 10483.9 | 10503.9 | 479.0 |
| 2010-12-01 01:00:00 | YM | Futures | 10504.9 | 10508.7 | 10499.2 | 10501.1 | 492.0 |
> showing 50 of 1,446 rows — these rows as CSV