PREVIEW / futures_1hour / 2009-02-26
file: by_date/futures_1hour/2009/2009-02-26.parquet size: 43 KB rows: 1,256
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-02-26 00:00:00 | ES | Futures | 724.84 | 725.31 | 721.76 | 724.6 | 4851.0 |
| 2009-02-26 01:00:00 | ES | Futures | 724.36 | 725.79 | 722.23 | 722.94 | 2701.0 |
| 2009-02-26 02:00:00 | ES | Futures | 722.94 | 728.87 | 722.7 | 728.16 | 9574.0 |
| 2009-02-26 03:00:00 | ES | Futures | 728.16 | 734.8 | 727.45 | 733.85 | 36597.0 |
| 2009-02-26 04:00:00 | ES | Futures | 734.09 | 734.09 | 727.21 | 729.58 | 19090.0 |
| 2009-02-26 05:00:00 | ES | Futures | 729.58 | 730.29 | 724.84 | 726.02 | 17403.0 |
| 2009-02-26 06:00:00 | ES | Futures | 726.02 | 733.85 | 725.79 | 731.01 | 26018.0 |
| 2009-02-26 07:00:00 | ES | Futures | 731.24 | 737.88 | 730.06 | 736.22 | 35431.0 |
| 2009-02-26 08:00:00 | ES | Futures | 736.46 | 736.7 | 730.06 | 733.61 | 69597.0 |
| 2009-02-26 09:00:00 | ES | Futures | 733.85 | 735.75 | 728.87 | 733.38 | 230409.0 |
| 2009-02-26 10:00:00 | ES | Futures | 733.38 | 739.07 | 730.53 | 737.41 | 394705.0 |
| 2009-02-26 11:00:00 | ES | Futures | 737.41 | 738.12 | 728.16 | 731.01 | 262282.0 |
| 2009-02-26 12:00:00 | ES | Futures | 731.01 | 732.67 | 725.08 | 727.21 | 165448.0 |
| 2009-02-26 13:00:00 | ES | Futures | 727.21 | 728.87 | 721.28 | 726.97 | 236481.0 |
| 2009-02-26 14:00:00 | ES | Futures | 727.21 | 728.16 | 716.3 | 718.2 | 284639.0 |
| 2009-02-26 15:00:00 | ES | Futures | 717.96 | 719.62 | 711.79 | 713.22 | 543773.0 |
| 2009-02-26 16:00:00 | ES | Futures | 713.22 | 714.64 | 712.03 | 713.45 | 110191.0 |
| 2009-02-26 17:00:00 | ES | Futures | 713.45 | 714.17 | 712.5 | 712.74 | 2465.0 |
| 2009-02-26 18:00:00 | ES | Futures | 712.98 | 713.93 | 712.03 | 713.69 | 4081.0 |
| 2009-02-26 19:00:00 | ES | Futures | 713.93 | 713.93 | 711.56 | 713.45 | 6083.0 |
| 2009-02-26 20:00:00 | ES | Futures | 713.69 | 715.59 | 713.22 | 714.88 | 4342.0 |
| 2009-02-26 21:00:00 | ES | Futures | 715.11 | 716.06 | 713.69 | 715.35 | 2293.0 |
| 2009-02-26 22:00:00 | ES | Futures | 715.11 | 716.3 | 712.5 | 714.64 | 5189.0 |
| 2009-02-26 23:00:00 | ES | Futures | 714.64 | 716.3 | 714.64 | 714.88 | 4725.0 |
| 2009-02-26 00:00:00 | NQ | Futures | 1307.42 | 1307.99 | 1301.77 | 1306.29 | 115.0 |
| 2009-02-26 01:00:00 | NQ | Futures | 1306.86 | 1309.4 | 1303.75 | 1304.32 | 116.0 |
| 2009-02-26 02:00:00 | NQ | Futures | 1303.75 | 1314.2 | 1303.75 | 1312.51 | 394.0 |
| 2009-02-26 03:00:00 | NQ | Futures | 1312.79 | 1324.37 | 1311.94 | 1323.8 | 2000.0 |
| 2009-02-26 04:00:00 | NQ | Futures | 1324.08 | 1324.37 | 1311.94 | 1315.61 | 1805.0 |
| 2009-02-26 05:00:00 | NQ | Futures | 1315.61 | 1317.02 | 1307.7 | 1309.4 | 999.0 |
| 2009-02-26 06:00:00 | NQ | Futures | 1309.12 | 1322.11 | 1308.55 | 1316.74 | 1455.0 |
| 2009-02-26 07:00:00 | NQ | Futures | 1316.74 | 1325.78 | 1315.05 | 1323.24 | 3073.0 |
| 2009-02-26 08:00:00 | NQ | Futures | 1322.67 | 1323.24 | 1313.07 | 1319.28 | 4421.0 |
| 2009-02-26 09:00:00 | NQ | Futures | 1318.72 | 1321.82 | 1303.19 | 1311.09 | 39560.0 |
| 2009-02-26 10:00:00 | NQ | Futures | 1311.09 | 1327.19 | 1307.42 | 1324.08 | 52599.0 |
| 2009-02-26 11:00:00 | NQ | Futures | 1324.08 | 1325.49 | 1305.73 | 1311.09 | 36032.0 |
| 2009-02-26 12:00:00 | NQ | Futures | 1311.09 | 1313.92 | 1300.08 | 1301.77 | 31406.0 |
| 2009-02-26 13:00:00 | NQ | Futures | 1302.06 | 1303.47 | 1291.61 | 1299.52 | 40287.0 |
| 2009-02-26 14:00:00 | NQ | Futures | 1299.23 | 1300.93 | 1279.75 | 1283.42 | 50122.0 |
| 2009-02-26 15:00:00 | NQ | Futures | 1283.7 | 1285.96 | 1272.69 | 1274.95 | 82405.0 |
| 2009-02-26 16:00:00 | NQ | Futures | 1274.95 | 1278.9 | 1274.1 | 1277.77 | 15300.0 |
| 2009-02-26 17:00:00 | NQ | Futures | 1277.49 | 1279.18 | 1273.25 | 1275.51 | 378.0 |
| 2009-02-26 18:00:00 | NQ | Futures | 1275.8 | 1276.64 | 1274.1 | 1276.64 | 326.0 |
| 2009-02-26 19:00:00 | NQ | Futures | 1276.36 | 1276.36 | 1272.69 | 1276.08 | 214.0 |
| 2009-02-26 20:00:00 | NQ | Futures | 1276.08 | 1281.73 | 1274.95 | 1281.73 | 398.0 |
| 2009-02-26 21:00:00 | NQ | Futures | 1280.88 | 1282.57 | 1278.05 | 1281.73 | 240.0 |
| 2009-02-26 22:00:00 | NQ | Futures | 1281.16 | 1282.86 | 1277.21 | 1280.03 | 135.0 |
| 2009-02-26 23:00:00 | NQ | Futures | 1280.88 | 1286.24 | 1280.88 | 1281.73 | 364.0 |
| 2009-02-26 00:00:00 | YM | Futures | 6606.7 | 6610.4 | 6584.9 | 6604.9 | 339.0 |
| 2009-02-26 01:00:00 | YM | Futures | 6604.0 | 6611.3 | 6584.0 | 6590.3 | 177.0 |
> showing 50 of 1,256 rows — these rows as CSV