PREVIEW / futures_1hour / 2010-12-08
file: by_date/futures_1hour/2010/2010-12-08.parquet size: 49 KB rows: 1,439
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-08 00:00:00 | ES | Futures | 1202.32 | 1202.82 | 1201.34 | 1201.83 | 5562.0 |
| 2010-12-08 01:00:00 | ES | Futures | 1201.58 | 1203.31 | 1200.6 | 1201.58 | 10656.0 |
| 2010-12-08 02:00:00 | ES | Futures | 1201.58 | 1202.82 | 1200.11 | 1202.32 | 14669.0 |
| 2010-12-08 03:00:00 | ES | Futures | 1202.57 | 1204.79 | 1201.83 | 1202.82 | 33751.0 |
| 2010-12-08 04:00:00 | ES | Futures | 1202.82 | 1206.02 | 1201.34 | 1205.53 | 24581.0 |
| 2010-12-08 05:00:00 | ES | Futures | 1205.28 | 1205.77 | 1203.8 | 1204.3 | 34010.0 |
| 2010-12-08 06:00:00 | ES | Futures | 1204.3 | 1205.28 | 1203.31 | 1203.56 | 24133.0 |
| 2010-12-08 07:00:00 | ES | Futures | 1203.56 | 1206.27 | 1203.06 | 1204.79 | 36960.0 |
| 2010-12-08 08:00:00 | ES | Futures | 1204.79 | 1209.23 | 1204.79 | 1207.99 | 57252.0 |
| 2010-12-08 09:00:00 | ES | Futures | 1207.99 | 1211.44 | 1206.51 | 1208.98 | 205867.0 |
| 2010-12-08 10:00:00 | ES | Futures | 1208.98 | 1208.98 | 1201.83 | 1205.04 | 447275.0 |
| 2010-12-08 11:00:00 | ES | Futures | 1204.79 | 1208.73 | 1204.3 | 1208.24 | 190233.0 |
| 2010-12-08 12:00:00 | ES | Futures | 1208.49 | 1208.98 | 1205.28 | 1206.51 | 132029.0 |
| 2010-12-08 13:00:00 | ES | Futures | 1206.51 | 1209.96 | 1206.02 | 1208.73 | 166077.0 |
| 2010-12-08 14:00:00 | ES | Futures | 1208.98 | 1211.44 | 1207.75 | 1209.72 | 138088.0 |
| 2010-12-08 15:00:00 | ES | Futures | 1209.72 | 1211.44 | 1207.5 | 1210.21 | 227667.0 |
| 2010-12-08 16:00:00 | ES | Futures | 1210.46 | 1212.92 | 1209.47 | 1212.68 | 92345.0 |
| 2010-12-08 17:00:00 | ES | Futures | 1212.68 | 1212.92 | 1212.43 | 1212.43 | 1521.0 |
| 2010-12-08 18:00:00 | ES | Futures | 1212.68 | 1215.63 | 1211.69 | 1215.63 | 13587.0 |
| 2010-12-08 19:00:00 | ES | Futures | 1215.14 | 1216.37 | 1214.65 | 1216.13 | 9154.0 |
| 2010-12-08 20:00:00 | ES | Futures | 1215.88 | 1216.37 | 1214.65 | 1215.39 | 7749.0 |
| 2010-12-08 21:00:00 | ES | Futures | 1215.63 | 1216.62 | 1215.39 | 1215.88 | 3953.0 |
| 2010-12-08 22:00:00 | ES | Futures | 1215.63 | 1215.88 | 1214.65 | 1215.39 | 3162.0 |
| 2010-12-08 23:00:00 | ES | Futures | 1215.39 | 1217.11 | 1215.39 | 1216.62 | 3588.0 |
| 2010-12-08 00:00:00 | NQ | Futures | 2507.81 | 2508.1 | 2505.52 | 2505.81 | 244.0 |
| 2010-12-08 01:00:00 | NQ | Futures | 2505.52 | 2507.53 | 2501.79 | 2505.81 | 660.0 |
| 2010-12-08 02:00:00 | NQ | Futures | 2505.81 | 2508.1 | 2501.79 | 2506.95 | 734.0 |
| 2010-12-08 03:00:00 | NQ | Futures | 2507.24 | 2512.98 | 2505.52 | 2508.39 | 2194.0 |
| 2010-12-08 04:00:00 | NQ | Futures | 2508.39 | 2515.27 | 2506.09 | 2514.7 | 1900.0 |
| 2010-12-08 05:00:00 | NQ | Futures | 2514.7 | 2514.99 | 2512.41 | 2513.55 | 2555.0 |
| 2010-12-08 06:00:00 | NQ | Futures | 2513.55 | 2515.56 | 2510.68 | 2510.97 | 1874.0 |
| 2010-12-08 07:00:00 | NQ | Futures | 2510.97 | 2518.14 | 2510.4 | 2515.27 | 2360.0 |
| 2010-12-08 08:00:00 | NQ | Futures | 2514.99 | 2523.02 | 2514.99 | 2520.73 | 5594.0 |
| 2010-12-08 09:00:00 | NQ | Futures | 2520.73 | 2527.04 | 2518.14 | 2520.44 | 30890.0 |
| 2010-12-08 10:00:00 | NQ | Futures | 2520.73 | 2520.73 | 2504.95 | 2512.12 | 41366.0 |
| 2010-12-08 11:00:00 | NQ | Futures | 2512.12 | 2520.73 | 2510.97 | 2519.0 | 16828.0 |
| 2010-12-08 12:00:00 | NQ | Futures | 2519.29 | 2520.44 | 2512.98 | 2514.41 | 11264.0 |
| 2010-12-08 13:00:00 | NQ | Futures | 2514.41 | 2521.01 | 2513.55 | 2519.0 | 15343.0 |
| 2010-12-08 14:00:00 | NQ | Futures | 2519.0 | 2525.32 | 2517.0 | 2522.45 | 16481.0 |
| 2010-12-08 15:00:00 | NQ | Futures | 2522.45 | 2525.6 | 2517.57 | 2524.17 | 24234.0 |
| 2010-12-08 16:00:00 | NQ | Futures | 2524.46 | 2528.47 | 2523.02 | 2528.18 | 8111.0 |
| 2010-12-08 17:00:00 | NQ | Futures | 2528.18 | 2528.47 | 2526.75 | 2526.75 | 104.0 |
| 2010-12-08 18:00:00 | NQ | Futures | 2527.04 | 2532.2 | 2525.89 | 2531.91 | 363.0 |
| 2010-12-08 19:00:00 | NQ | Futures | 2531.91 | 2534.5 | 2530.77 | 2533.92 | 618.0 |
| 2010-12-08 20:00:00 | NQ | Futures | 2533.92 | 2534.5 | 2531.34 | 2532.78 | 770.0 |
| 2010-12-08 21:00:00 | NQ | Futures | 2533.06 | 2535.36 | 2533.06 | 2533.64 | 287.0 |
| 2010-12-08 22:00:00 | NQ | Futures | 2533.35 | 2533.64 | 2530.48 | 2531.91 | 447.0 |
| 2010-12-08 23:00:00 | NQ | Futures | 2532.2 | 2535.07 | 2532.2 | 2534.78 | 254.0 |
| 2010-12-08 00:00:00 | YM | Futures | 10790.7 | 10793.5 | 10784.0 | 10784.9 | 190.0 |
| 2010-12-08 01:00:00 | YM | Futures | 10784.9 | 10792.6 | 10749.7 | 10770.6 | 2154.0 |
> showing 50 of 1,439 rows — these rows as CSV