PREVIEW / futures_1hour / 2009-03-11
file: by_date/futures_1hour/2009/2009-03-11.parquet size: 40 KB rows: 1,180
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-11 00:00:00 | ES | Futures | 680.96 | 685.7 | 680.72 | 684.28 | 4821.0 |
| 2009-03-11 01:00:00 | ES | Futures | 684.28 | 685.7 | 683.57 | 684.28 | 2922.0 |
| 2009-03-11 02:00:00 | ES | Futures | 684.28 | 684.99 | 681.67 | 681.91 | 4500.0 |
| 2009-03-11 03:00:00 | ES | Futures | 681.91 | 682.38 | 679.54 | 680.96 | 10998.0 |
| 2009-03-11 04:00:00 | ES | Futures | 680.96 | 681.2 | 675.98 | 676.22 | 31113.0 |
| 2009-03-11 05:00:00 | ES | Futures | 676.22 | 687.13 | 675.5 | 686.65 | 36396.0 |
| 2009-03-11 06:00:00 | ES | Futures | 686.65 | 692.58 | 685.7 | 688.07 | 57819.0 |
| 2009-03-11 07:00:00 | ES | Futures | 688.07 | 690.45 | 685.7 | 686.18 | 31610.0 |
| 2009-03-11 08:00:00 | ES | Futures | 685.94 | 689.97 | 684.52 | 687.84 | 58916.0 |
| 2009-03-11 09:00:00 | ES | Futures | 687.6 | 694.95 | 680.96 | 692.58 | 419578.0 |
| 2009-03-11 10:00:00 | ES | Futures | 692.58 | 693.77 | 687.36 | 689.73 | 417747.0 |
| 2009-03-11 11:00:00 | ES | Futures | 689.73 | 691.87 | 683.81 | 687.36 | 326170.0 |
| 2009-03-11 12:00:00 | ES | Futures | 687.36 | 688.31 | 680.01 | 680.25 | 225983.0 |
| 2009-03-11 13:00:00 | ES | Futures | 680.01 | 686.41 | 680.01 | 684.28 | 284491.0 |
| 2009-03-11 14:00:00 | ES | Futures | 684.28 | 686.18 | 676.69 | 681.67 | 358915.0 |
| 2009-03-11 15:00:00 | ES | Futures | 681.91 | 690.68 | 681.67 | 683.81 | 452231.0 |
| 2009-03-11 16:00:00 | ES | Futures | 683.81 | 684.75 | 682.62 | 683.81 | 92150.0 |
| 2009-03-11 17:00:00 | ES | Futures | 683.57 | 684.52 | 683.57 | 684.28 | 2030.0 |
| 2009-03-11 18:00:00 | ES | Futures | 683.81 | 684.75 | 683.57 | 684.04 | 1067.0 |
| 2009-03-11 19:00:00 | ES | Futures | 684.04 | 684.28 | 679.77 | 680.25 | 3255.0 |
| 2009-03-11 20:00:00 | ES | Futures | 680.01 | 681.2 | 678.82 | 681.2 | 4196.0 |
| 2009-03-11 21:00:00 | ES | Futures | 681.2 | 681.2 | 678.59 | 679.06 | 2095.0 |
| 2009-03-11 22:00:00 | ES | Futures | 679.06 | 680.48 | 678.82 | 679.3 | 1709.0 |
| 2009-03-11 23:00:00 | ES | Futures | 679.3 | 680.01 | 678.11 | 678.11 | 3234.0 |
| 2009-03-11 00:00:00 | NQ | Futures | 1254.9 | 1260.55 | 1253.77 | 1258.01 | 211.0 |
| 2009-03-11 01:00:00 | NQ | Futures | 1258.57 | 1260.83 | 1257.16 | 1258.57 | 157.0 |
| 2009-03-11 02:00:00 | NQ | Futures | 1258.29 | 1258.57 | 1253.49 | 1254.05 | 425.0 |
| 2009-03-11 03:00:00 | NQ | Futures | 1254.05 | 1254.9 | 1250.95 | 1254.62 | 650.0 |
| 2009-03-11 04:00:00 | NQ | Futures | 1254.05 | 1256.03 | 1248.69 | 1248.97 | 2688.0 |
| 2009-03-11 05:00:00 | NQ | Futures | 1248.69 | 1262.81 | 1248.12 | 1262.52 | 2636.0 |
| 2009-03-11 06:00:00 | NQ | Futures | 1262.52 | 1271.56 | 1261.11 | 1263.37 | 4547.0 |
| 2009-03-11 07:00:00 | NQ | Futures | 1263.37 | 1268.17 | 1261.11 | 1264.22 | 3543.0 |
| 2009-03-11 08:00:00 | NQ | Futures | 1264.22 | 1269.02 | 1261.68 | 1265.63 | 7029.0 |
| 2009-03-11 09:00:00 | NQ | Futures | 1265.63 | 1276.93 | 1249.53 | 1275.23 | 65478.0 |
| 2009-03-11 10:00:00 | NQ | Futures | 1275.51 | 1282.86 | 1268.45 | 1277.49 | 70975.0 |
| 2009-03-11 11:00:00 | NQ | Futures | 1277.77 | 1280.31 | 1265.91 | 1270.71 | 43003.0 |
| 2009-03-11 12:00:00 | NQ | Futures | 1271.0 | 1271.84 | 1260.55 | 1260.83 | 36449.0 |
| 2009-03-11 13:00:00 | NQ | Futures | 1260.83 | 1274.38 | 1260.55 | 1271.84 | 38346.0 |
| 2009-03-11 14:00:00 | NQ | Futures | 1271.84 | 1274.67 | 1258.57 | 1266.76 | 52366.0 |
| 2009-03-11 15:00:00 | NQ | Futures | 1266.48 | 1282.29 | 1266.48 | 1271.0 | 60110.0 |
| 2009-03-11 16:00:00 | NQ | Futures | 1271.0 | 1272.69 | 1268.45 | 1270.15 | 9409.0 |
| 2009-03-11 17:00:00 | NQ | Futures | 1270.15 | 1271.28 | 1268.17 | 1270.71 | 77.0 |
| 2009-03-11 18:00:00 | NQ | Futures | 1270.71 | 1271.28 | 1269.3 | 1271.0 | 59.0 |
| 2009-03-11 19:00:00 | NQ | Futures | 1270.43 | 1270.43 | 1263.94 | 1264.78 | 247.0 |
| 2009-03-11 20:00:00 | NQ | Futures | 1264.22 | 1266.48 | 1262.52 | 1266.48 | 154.0 |
| 2009-03-11 21:00:00 | NQ | Futures | 1265.91 | 1265.91 | 1261.68 | 1262.81 | 177.0 |
| 2009-03-11 22:00:00 | NQ | Futures | 1262.24 | 1265.07 | 1261.96 | 1263.09 | 70.0 |
| 2009-03-11 23:00:00 | NQ | Futures | 1262.81 | 1263.37 | 1261.11 | 1261.11 | 97.0 |
| 2009-03-11 00:00:00 | YM | Futures | 6297.6 | 6331.6 | 6297.6 | 6328.8 | 35.0 |
| 2009-03-11 01:00:00 | YM | Futures | 6328.8 | 6328.8 | 6323.3 | 6323.3 | 2.0 |
> showing 50 of 1,180 rows — these rows as CSV