PREVIEW / futures_1hour / 2010-12-07
file: by_date/futures_1hour/2010/2010-12-07.parquet size: 50 KB rows: 1,452
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-07 00:00:00 | ES | Futures | 1207.5 | 1207.75 | 1206.51 | 1207.25 | 2381.0 |
| 2010-12-07 01:00:00 | ES | Futures | 1207.01 | 1208.24 | 1206.76 | 1207.75 | 4521.0 |
| 2010-12-07 02:00:00 | ES | Futures | 1207.99 | 1208.24 | 1206.51 | 1207.75 | 7850.0 |
| 2010-12-07 03:00:00 | ES | Futures | 1207.75 | 1210.21 | 1207.5 | 1209.96 | 27765.0 |
| 2010-12-07 04:00:00 | ES | Futures | 1209.72 | 1215.88 | 1209.47 | 1215.39 | 46212.0 |
| 2010-12-07 05:00:00 | ES | Futures | 1215.39 | 1216.87 | 1214.4 | 1216.62 | 35621.0 |
| 2010-12-07 06:00:00 | ES | Futures | 1216.62 | 1216.62 | 1214.4 | 1215.39 | 39555.0 |
| 2010-12-07 07:00:00 | ES | Futures | 1215.39 | 1216.62 | 1214.65 | 1215.63 | 25789.0 |
| 2010-12-07 08:00:00 | ES | Futures | 1215.63 | 1217.36 | 1215.39 | 1216.62 | 47463.0 |
| 2010-12-07 09:00:00 | ES | Futures | 1216.87 | 1217.61 | 1213.66 | 1213.91 | 274272.0 |
| 2010-12-07 10:00:00 | ES | Futures | 1213.66 | 1214.4 | 1210.7 | 1212.92 | 372874.0 |
| 2010-12-07 11:00:00 | ES | Futures | 1212.92 | 1213.66 | 1210.7 | 1211.2 | 218348.0 |
| 2010-12-07 12:00:00 | ES | Futures | 1211.2 | 1212.68 | 1209.47 | 1212.18 | 163617.0 |
| 2010-12-07 13:00:00 | ES | Futures | 1212.43 | 1214.4 | 1211.69 | 1212.92 | 156738.0 |
| 2010-12-07 14:00:00 | ES | Futures | 1212.92 | 1215.88 | 1208.73 | 1209.47 | 259299.0 |
| 2010-12-07 15:00:00 | ES | Futures | 1209.47 | 1210.46 | 1205.28 | 1205.77 | 503440.0 |
| 2010-12-07 16:00:00 | ES | Futures | 1206.02 | 1207.25 | 1204.05 | 1204.3 | 102663.0 |
| 2010-12-07 17:00:00 | ES | Futures | 1204.3 | 1204.54 | 1202.08 | 1202.82 | 8510.0 |
| 2010-12-07 18:00:00 | ES | Futures | 1202.57 | 1205.28 | 1202.32 | 1204.79 | 8500.0 |
| 2010-12-07 19:00:00 | ES | Futures | 1204.79 | 1206.51 | 1204.54 | 1206.02 | 5122.0 |
| 2010-12-07 20:00:00 | ES | Futures | 1206.02 | 1206.76 | 1204.54 | 1205.53 | 6847.0 |
| 2010-12-07 21:00:00 | ES | Futures | 1205.77 | 1206.02 | 1203.8 | 1204.05 | 3700.0 |
| 2010-12-07 22:00:00 | ES | Futures | 1204.05 | 1204.79 | 1202.82 | 1204.54 | 5362.0 |
| 2010-12-07 23:00:00 | ES | Futures | 1204.3 | 1204.79 | 1202.08 | 1202.57 | 5945.0 |
| 2010-12-07 00:00:00 | NQ | Futures | 2519.58 | 2519.86 | 2516.71 | 2517.86 | 279.0 |
| 2010-12-07 01:00:00 | NQ | Futures | 2517.86 | 2519.58 | 2517.57 | 2519.0 | 416.0 |
| 2010-12-07 02:00:00 | NQ | Futures | 2518.43 | 2519.29 | 2516.13 | 2518.14 | 651.0 |
| 2010-12-07 03:00:00 | NQ | Futures | 2517.86 | 2519.58 | 2515.27 | 2519.0 | 2408.0 |
| 2010-12-07 04:00:00 | NQ | Futures | 2519.29 | 2535.07 | 2519.0 | 2534.5 | 4705.0 |
| 2010-12-07 05:00:00 | NQ | Futures | 2534.78 | 2538.23 | 2532.49 | 2537.65 | 3807.0 |
| 2010-12-07 06:00:00 | NQ | Futures | 2537.65 | 2537.94 | 2533.92 | 2535.36 | 2294.0 |
| 2010-12-07 07:00:00 | NQ | Futures | 2535.64 | 2537.94 | 2533.64 | 2536.22 | 1810.0 |
| 2010-12-07 08:00:00 | NQ | Futures | 2536.22 | 2543.96 | 2535.36 | 2542.82 | 6987.0 |
| 2010-12-07 09:00:00 | NQ | Futures | 2542.82 | 2544.25 | 2532.49 | 2532.49 | 35161.0 |
| 2010-12-07 10:00:00 | NQ | Futures | 2532.49 | 2532.78 | 2523.02 | 2529.33 | 41879.0 |
| 2010-12-07 11:00:00 | NQ | Futures | 2529.33 | 2531.34 | 2525.89 | 2527.32 | 19055.0 |
| 2010-12-07 12:00:00 | NQ | Futures | 2527.61 | 2528.47 | 2524.46 | 2528.18 | 15773.0 |
| 2010-12-07 13:00:00 | NQ | Futures | 2528.18 | 2533.35 | 2527.04 | 2530.77 | 15386.0 |
| 2010-12-07 14:00:00 | NQ | Futures | 2530.77 | 2537.65 | 2523.02 | 2524.74 | 23724.0 |
| 2010-12-07 15:00:00 | NQ | Futures | 2524.46 | 2526.75 | 2511.26 | 2513.55 | 49617.0 |
| 2010-12-07 16:00:00 | NQ | Futures | 2513.55 | 2515.27 | 2510.68 | 2511.26 | 7951.0 |
| 2010-12-07 17:00:00 | NQ | Futures | 2511.26 | 2511.83 | 2508.39 | 2508.96 | 205.0 |
| 2010-12-07 18:00:00 | NQ | Futures | 2508.39 | 2512.69 | 2507.24 | 2511.83 | 398.0 |
| 2010-12-07 19:00:00 | NQ | Futures | 2511.83 | 2515.85 | 2511.54 | 2515.27 | 331.0 |
| 2010-12-07 20:00:00 | NQ | Futures | 2514.99 | 2515.56 | 2511.26 | 2513.27 | 470.0 |
| 2010-12-07 21:00:00 | NQ | Futures | 2513.27 | 2514.13 | 2509.82 | 2510.4 | 259.0 |
| 2010-12-07 22:00:00 | NQ | Futures | 2510.4 | 2512.69 | 2507.81 | 2511.83 | 306.0 |
| 2010-12-07 23:00:00 | NQ | Futures | 2511.83 | 2511.83 | 2507.24 | 2507.81 | 341.0 |
| 2010-12-07 00:00:00 | YM | Futures | 10836.4 | 10836.4 | 10830.7 | 10831.6 | 197.0 |
| 2010-12-07 01:00:00 | YM | Futures | 10832.6 | 10837.3 | 10828.8 | 10833.5 | 624.0 |
> showing 50 of 1,452 rows — these rows as CSV