PREVIEW / futures_1hour / 2011-12-12
file: by_date/futures_1hour/2011/2011-12-12.parquet size: 45 KB rows: 1,354
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-12 00:00:00 | ES | Futures | 1258.3 | 1260.81 | 1258.3 | 1259.56 | 1122.0 |
| 2011-12-12 01:00:00 | ES | Futures | 1259.81 | 1260.31 | 1258.05 | 1259.31 | 1898.0 |
| 2011-12-12 02:00:00 | ES | Futures | 1259.31 | 1259.31 | 1253.29 | 1255.8 | 6815.0 |
| 2011-12-12 03:00:00 | ES | Futures | 1255.8 | 1257.55 | 1252.29 | 1254.54 | 14835.0 |
| 2011-12-12 04:00:00 | ES | Futures | 1254.54 | 1256.55 | 1249.03 | 1250.53 | 16408.0 |
| 2011-12-12 05:00:00 | ES | Futures | 1250.53 | 1253.79 | 1249.03 | 1251.03 | 9976.0 |
| 2011-12-12 06:00:00 | ES | Futures | 1251.03 | 1255.04 | 1251.03 | 1252.54 | 9692.0 |
| 2011-12-12 07:00:00 | ES | Futures | 1252.54 | 1254.29 | 1251.78 | 1253.04 | 6259.0 |
| 2011-12-12 08:00:00 | ES | Futures | 1253.04 | 1253.29 | 1249.03 | 1250.28 | 12890.0 |
| 2011-12-12 09:00:00 | ES | Futures | 1250.28 | 1250.78 | 1239.0 | 1240.0 | 59501.0 |
| 2011-12-12 10:00:00 | ES | Futures | 1240.0 | 1241.5 | 1235.99 | 1238.24 | 44877.0 |
| 2011-12-12 11:00:00 | ES | Futures | 1237.99 | 1239.0 | 1229.72 | 1231.97 | 45628.0 |
| 2011-12-12 12:00:00 | ES | Futures | 1231.97 | 1234.23 | 1230.72 | 1233.23 | 18419.0 |
| 2011-12-12 13:00:00 | ES | Futures | 1233.23 | 1234.73 | 1230.72 | 1233.73 | 20344.0 |
| 2011-12-12 14:00:00 | ES | Futures | 1233.48 | 1235.23 | 1230.97 | 1234.98 | 21669.0 |
| 2011-12-12 15:00:00 | ES | Futures | 1234.98 | 1240.75 | 1232.48 | 1239.75 | 55638.0 |
| 2011-12-12 16:00:00 | ES | Futures | 1240.0 | 1240.5 | 1238.24 | 1238.49 | 24005.0 |
| 2011-12-12 17:00:00 | ES | Futures | 1238.49 | 1238.49 | 1237.49 | 1238.24 | 539.0 |
| 2011-12-12 18:00:00 | ES | Futures | 1238.24 | 1241.0 | 1238.24 | 1239.75 | 1861.0 |
| 2011-12-12 19:00:00 | ES | Futures | 1240.0 | 1242.76 | 1238.74 | 1241.75 | 2349.0 |
| 2011-12-12 20:00:00 | ES | Futures | 1241.5 | 1242.51 | 1239.5 | 1240.75 | 1614.0 |
| 2011-12-12 21:00:00 | ES | Futures | 1241.0 | 1241.25 | 1240.0 | 1240.75 | 411.0 |
| 2011-12-12 22:00:00 | ES | Futures | 1240.75 | 1243.01 | 1239.75 | 1242.26 | 890.0 |
| 2011-12-12 23:00:00 | ES | Futures | 1242.51 | 1242.51 | 1241.0 | 1241.5 | 538.0 |
| 2011-12-12 00:00:00 | NQ | Futures | 2671.31 | 2675.92 | 2671.31 | 2674.19 | 50.0 |
| 2011-12-12 01:00:00 | NQ | Futures | 2675.34 | 2675.34 | 2672.17 | 2674.48 | 36.0 |
| 2011-12-12 02:00:00 | NQ | Futures | 2673.04 | 2673.04 | 2664.96 | 2669.0 | 303.0 |
| 2011-12-12 03:00:00 | NQ | Futures | 2669.0 | 2670.44 | 2661.79 | 2668.42 | 518.0 |
| 2011-12-12 04:00:00 | NQ | Futures | 2668.42 | 2670.73 | 2651.7 | 2656.31 | 676.0 |
| 2011-12-12 05:00:00 | NQ | Futures | 2654.3 | 2661.22 | 2652.57 | 2656.6 | 354.0 |
| 2011-12-12 06:00:00 | NQ | Futures | 2656.31 | 2666.98 | 2656.31 | 2663.52 | 311.0 |
| 2011-12-12 07:00:00 | NQ | Futures | 2662.95 | 2665.54 | 2659.49 | 2662.08 | 213.0 |
| 2011-12-12 08:00:00 | NQ | Futures | 2662.95 | 2663.52 | 2656.03 | 2658.33 | 487.0 |
| 2011-12-12 09:00:00 | NQ | Futures | 2659.2 | 2659.2 | 2629.5 | 2632.1 | 6834.0 |
| 2011-12-12 10:00:00 | NQ | Futures | 2631.81 | 2636.42 | 2624.31 | 2633.25 | 7219.0 |
| 2011-12-12 11:00:00 | NQ | Futures | 2633.54 | 2640.46 | 2621.72 | 2627.77 | 3618.0 |
| 2011-12-12 12:00:00 | NQ | Futures | 2627.19 | 2633.83 | 2624.6 | 2630.65 | 2048.0 |
| 2011-12-12 13:00:00 | NQ | Futures | 2630.94 | 2635.56 | 2626.91 | 2633.83 | 1275.0 |
| 2011-12-12 14:00:00 | NQ | Futures | 2633.54 | 2636.42 | 2627.77 | 2634.11 | 1658.0 |
| 2011-12-12 15:00:00 | NQ | Futures | 2634.69 | 2646.8 | 2628.92 | 2644.49 | 5176.0 |
| 2011-12-12 16:00:00 | NQ | Futures | 2645.07 | 2649.11 | 2642.48 | 2646.22 | 1414.0 |
| 2011-12-12 17:00:00 | NQ | Futures | 2645.65 | 2645.65 | 2644.49 | 2644.78 | 20.0 |
| 2011-12-12 18:00:00 | NQ | Futures | 2644.78 | 2649.97 | 2644.49 | 2648.82 | 29.0 |
| 2011-12-12 19:00:00 | NQ | Futures | 2647.95 | 2652.86 | 2647.95 | 2651.13 | 45.0 |
| 2011-12-12 20:00:00 | NQ | Futures | 2651.13 | 2651.41 | 2647.38 | 2648.53 | 44.0 |
| 2011-12-12 21:00:00 | NQ | Futures | 2649.4 | 2650.26 | 2647.95 | 2648.53 | 24.0 |
| 2011-12-12 22:00:00 | NQ | Futures | 2649.11 | 2653.72 | 2648.24 | 2653.14 | 33.0 |
| 2011-12-12 23:00:00 | NQ | Futures | 2651.7 | 2652.86 | 2650.26 | 2650.84 | 23.0 |
| 2011-12-12 00:00:00 | YM | Futures | 11998.7 | 12018.5 | 11998.7 | 12005.6 | 213.0 |
| 2011-12-12 01:00:00 | YM | Futures | 12005.6 | 12010.6 | 11995.7 | 12004.6 | 336.0 |
> showing 50 of 1,354 rows — these rows as CSV