PREVIEW / futures_1hour / 2009-02-25
file: by_date/futures_1hour/2009/2009-02-25.parquet size: 43 KB rows: 1,260
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-25 00:00:00 | ES | Futures | 725.08 | 727.45 | 724.84 | 726.74 | 3479.0 |
| 2009-02-25 01:00:00 | ES | Futures | 726.74 | 728.63 | 726.26 | 726.5 | 2470.0 |
| 2009-02-25 02:00:00 | ES | Futures | 726.26 | 731.24 | 726.02 | 730.77 | 9796.0 |
| 2009-02-25 03:00:00 | ES | Futures | 730.77 | 731.01 | 726.5 | 727.92 | 18922.0 |
| 2009-02-25 04:00:00 | ES | Futures | 727.92 | 730.53 | 725.31 | 730.53 | 13999.0 |
| 2009-02-25 05:00:00 | ES | Futures | 730.53 | 731.72 | 729.11 | 729.82 | 11541.0 |
| 2009-02-25 06:00:00 | ES | Futures | 729.82 | 732.43 | 723.89 | 725.08 | 24359.0 |
| 2009-02-25 07:00:00 | ES | Futures | 725.08 | 728.63 | 723.65 | 727.92 | 27031.0 |
| 2009-02-25 08:00:00 | ES | Futures | 727.68 | 730.29 | 724.13 | 726.02 | 41917.0 |
| 2009-02-25 09:00:00 | ES | Futures | 725.79 | 729.34 | 721.76 | 722.47 | 283107.0 |
| 2009-02-25 10:00:00 | ES | Futures | 722.47 | 722.47 | 712.74 | 714.88 | 507867.0 |
| 2009-02-25 11:00:00 | ES | Futures | 714.88 | 726.02 | 714.64 | 719.62 | 360395.0 |
| 2009-02-25 12:00:00 | ES | Futures | 719.38 | 721.28 | 713.93 | 717.25 | 263981.0 |
| 2009-02-25 13:00:00 | ES | Futures | 717.25 | 731.24 | 716.54 | 729.58 | 324914.0 |
| 2009-02-25 14:00:00 | ES | Futures | 729.58 | 731.01 | 718.43 | 727.92 | 540532.0 |
| 2009-02-25 15:00:00 | ES | Futures | 728.16 | 739.54 | 723.89 | 724.6 | 582091.0 |
| 2009-02-25 16:00:00 | ES | Futures | 724.6 | 726.26 | 721.28 | 721.99 | 121921.0 |
| 2009-02-25 17:00:00 | ES | Futures | 721.99 | 726.02 | 721.99 | 724.84 | 5504.0 |
| 2009-02-25 18:00:00 | ES | Futures | 725.08 | 725.55 | 723.65 | 724.36 | 3044.0 |
| 2009-02-25 19:00:00 | ES | Futures | 724.36 | 729.82 | 723.89 | 729.34 | 8532.0 |
| 2009-02-25 20:00:00 | ES | Futures | 729.11 | 729.82 | 726.97 | 729.11 | 3490.0 |
| 2009-02-25 21:00:00 | ES | Futures | 729.11 | 729.11 | 726.02 | 726.26 | 2256.0 |
| 2009-02-25 22:00:00 | ES | Futures | 726.74 | 727.45 | 721.52 | 724.6 | 5865.0 |
| 2009-02-25 23:00:00 | ES | Futures | 724.6 | 726.02 | 723.89 | 725.08 | 2109.0 |
| 2009-02-25 00:00:00 | NQ | Futures | 1308.55 | 1312.79 | 1307.14 | 1310.53 | 188.0 |
| 2009-02-25 01:00:00 | NQ | Futures | 1311.94 | 1313.35 | 1308.83 | 1308.83 | 87.0 |
| 2009-02-25 02:00:00 | NQ | Futures | 1308.83 | 1318.44 | 1308.83 | 1317.02 | 314.0 |
| 2009-02-25 03:00:00 | NQ | Futures | 1317.31 | 1317.31 | 1310.53 | 1313.07 | 956.0 |
| 2009-02-25 04:00:00 | NQ | Futures | 1313.07 | 1317.31 | 1307.99 | 1317.31 | 776.0 |
| 2009-02-25 05:00:00 | NQ | Futures | 1317.31 | 1318.44 | 1313.63 | 1314.48 | 681.0 |
| 2009-02-25 06:00:00 | NQ | Futures | 1313.92 | 1319.56 | 1306.86 | 1307.14 | 1700.0 |
| 2009-02-25 07:00:00 | NQ | Futures | 1307.7 | 1312.51 | 1305.45 | 1311.94 | 1408.0 |
| 2009-02-25 08:00:00 | NQ | Futures | 1311.38 | 1318.72 | 1309.12 | 1310.81 | 5183.0 |
| 2009-02-25 09:00:00 | NQ | Futures | 1310.81 | 1315.33 | 1306.58 | 1307.7 | 42401.0 |
| 2009-02-25 10:00:00 | NQ | Futures | 1307.7 | 1309.12 | 1289.91 | 1295.84 | 67307.0 |
| 2009-02-25 11:00:00 | NQ | Futures | 1295.56 | 1313.35 | 1295.0 | 1299.8 | 45744.0 |
| 2009-02-25 12:00:00 | NQ | Futures | 1300.08 | 1303.75 | 1294.43 | 1300.65 | 34748.0 |
| 2009-02-25 13:00:00 | NQ | Futures | 1300.65 | 1320.69 | 1299.23 | 1317.59 | 45241.0 |
| 2009-02-25 14:00:00 | NQ | Futures | 1317.87 | 1320.13 | 1303.19 | 1315.05 | 75916.0 |
| 2009-02-25 15:00:00 | NQ | Futures | 1314.48 | 1337.64 | 1310.25 | 1310.81 | 80236.0 |
| 2009-02-25 16:00:00 | NQ | Futures | 1310.81 | 1311.66 | 1302.06 | 1304.6 | 14798.0 |
| 2009-02-25 17:00:00 | NQ | Futures | 1304.32 | 1309.68 | 1304.32 | 1308.55 | 545.0 |
| 2009-02-25 18:00:00 | NQ | Futures | 1308.55 | 1309.4 | 1306.58 | 1307.7 | 183.0 |
| 2009-02-25 19:00:00 | NQ | Futures | 1307.14 | 1315.33 | 1306.58 | 1314.76 | 422.0 |
| 2009-02-25 20:00:00 | NQ | Futures | 1313.63 | 1316.18 | 1310.81 | 1314.76 | 231.0 |
| 2009-02-25 21:00:00 | NQ | Futures | 1315.05 | 1315.05 | 1309.68 | 1310.25 | 95.0 |
| 2009-02-25 22:00:00 | NQ | Futures | 1309.68 | 1312.22 | 1302.34 | 1306.29 | 299.0 |
| 2009-02-25 23:00:00 | NQ | Futures | 1307.99 | 1309.12 | 1306.86 | 1307.42 | 107.0 |
| 2009-02-25 00:00:00 | YM | Futures | 6618.6 | 6643.2 | 6616.8 | 6634.1 | 331.0 |
| 2009-02-25 01:00:00 | YM | Futures | 6637.7 | 6652.3 | 6635.0 | 6636.8 | 191.0 |
> showing 50 of 1,260 rows — these rows as CSV