PREVIEW / futures_1hour / 2008-05-02
file: by_date/futures_1hour/2008/2008-05-02.parquet size: 37 KB rows: 1,035
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-02 00:00:00 | ES | Futures | 1316.5 | 1317.2 | 1315.8 | 1316.27 | 1306.0 |
| 2008-05-02 01:00:00 | ES | Futures | 1316.27 | 1316.5 | 1313.47 | 1313.7 | 2546.0 |
| 2008-05-02 02:00:00 | ES | Futures | 1313.7 | 1314.87 | 1312.77 | 1314.4 | 5763.0 |
| 2008-05-02 03:00:00 | ES | Futures | 1314.17 | 1314.64 | 1312.54 | 1312.77 | 12213.0 |
| 2008-05-02 04:00:00 | ES | Futures | 1312.77 | 1314.17 | 1312.31 | 1314.17 | 7479.0 |
| 2008-05-02 05:00:00 | ES | Futures | 1314.17 | 1314.87 | 1313.94 | 1314.4 | 9251.0 |
| 2008-05-02 06:00:00 | ES | Futures | 1314.64 | 1315.8 | 1314.17 | 1315.1 | 7126.0 |
| 2008-05-02 07:00:00 | ES | Futures | 1315.33 | 1317.43 | 1314.87 | 1316.03 | 16392.0 |
| 2008-05-02 08:00:00 | ES | Futures | 1316.03 | 1329.07 | 1313.7 | 1325.58 | 204808.0 |
| 2008-05-02 09:00:00 | ES | Futures | 1325.81 | 1326.98 | 1319.99 | 1323.02 | 255883.0 |
| 2008-05-02 10:00:00 | ES | Futures | 1323.02 | 1325.81 | 1316.27 | 1317.43 | 344193.0 |
| 2008-05-02 11:00:00 | ES | Futures | 1317.2 | 1322.32 | 1317.2 | 1318.36 | 215934.0 |
| 2008-05-02 12:00:00 | ES | Futures | 1318.36 | 1318.36 | 1313.47 | 1315.1 | 183276.0 |
| 2008-05-02 13:00:00 | ES | Futures | 1314.87 | 1316.5 | 1310.21 | 1314.17 | 185517.0 |
| 2008-05-02 14:00:00 | ES | Futures | 1314.17 | 1316.27 | 1309.51 | 1312.07 | 166922.0 |
| 2008-05-02 15:00:00 | ES | Futures | 1312.07 | 1317.9 | 1311.61 | 1316.73 | 231176.0 |
| 2008-05-02 16:00:00 | ES | Futures | 1316.73 | 1319.99 | 1316.73 | 1319.06 | 59078.0 |
| 2008-05-02 00:00:00 | NQ | Futures | 2247.64 | 2247.92 | 2245.09 | 2245.09 | 247.0 |
| 2008-05-02 01:00:00 | NQ | Futures | 2245.66 | 2246.22 | 2241.98 | 2243.11 | 206.0 |
| 2008-05-02 02:00:00 | NQ | Futures | 2242.27 | 2244.25 | 2240.85 | 2243.4 | 416.0 |
| 2008-05-02 03:00:00 | NQ | Futures | 2243.4 | 2243.4 | 2237.74 | 2237.74 | 1339.0 |
| 2008-05-02 04:00:00 | NQ | Futures | 2238.02 | 2241.13 | 2236.89 | 2240.85 | 1181.0 |
| 2008-05-02 05:00:00 | NQ | Futures | 2241.13 | 2245.38 | 2241.13 | 2244.25 | 1226.0 |
| 2008-05-02 06:00:00 | NQ | Futures | 2243.96 | 2245.66 | 2243.68 | 2244.81 | 262.0 |
| 2008-05-02 07:00:00 | NQ | Futures | 2244.53 | 2248.49 | 2243.68 | 2245.09 | 1572.0 |
| 2008-05-02 08:00:00 | NQ | Futures | 2245.38 | 2271.68 | 2239.72 | 2267.44 | 32123.0 |
| 2008-05-02 09:00:00 | NQ | Futures | 2267.15 | 2269.7 | 2248.2 | 2254.14 | 65981.0 |
| 2008-05-02 10:00:00 | NQ | Futures | 2254.14 | 2263.19 | 2236.61 | 2238.31 | 76289.0 |
| 2008-05-02 11:00:00 | NQ | Futures | 2238.59 | 2249.34 | 2238.59 | 2240.29 | 37749.0 |
| 2008-05-02 12:00:00 | NQ | Futures | 2240.29 | 2241.7 | 2234.63 | 2238.31 | 31023.0 |
| 2008-05-02 13:00:00 | NQ | Futures | 2238.02 | 2240.29 | 2228.69 | 2235.48 | 34207.0 |
| 2008-05-02 14:00:00 | NQ | Futures | 2235.48 | 2240.0 | 2229.26 | 2230.67 | 34494.0 |
| 2008-05-02 15:00:00 | NQ | Futures | 2230.95 | 2247.36 | 2229.26 | 2246.79 | 42061.0 |
| 2008-05-02 16:00:00 | NQ | Futures | 2247.07 | 2253.3 | 2246.22 | 2252.73 | 10882.0 |
| 2008-05-02 00:00:00 | YM | Futures | 11826.1 | 11831.6 | 11823.4 | 11827.0 | 77.0 |
| 2008-05-02 01:00:00 | YM | Futures | 11825.2 | 11825.2 | 11807.9 | 11807.9 | 147.0 |
| 2008-05-02 02:00:00 | YM | Futures | 11809.7 | 11818.8 | 11803.4 | 11816.1 | 284.0 |
| 2008-05-02 03:00:00 | YM | Futures | 11814.3 | 11815.2 | 11802.5 | 11803.4 | 485.0 |
| 2008-05-02 04:00:00 | YM | Futures | 11802.5 | 11816.1 | 11800.7 | 11814.3 | 320.0 |
| 2008-05-02 05:00:00 | YM | Futures | 11815.2 | 11822.5 | 11813.4 | 11820.6 | 434.0 |
| 2008-05-02 06:00:00 | YM | Futures | 11821.6 | 11825.2 | 11817.0 | 11820.6 | 403.0 |
| 2008-05-02 07:00:00 | YM | Futures | 11819.7 | 11833.4 | 11818.8 | 11825.2 | 758.0 |
| 2008-05-02 08:00:00 | YM | Futures | 11825.2 | 11933.3 | 11823.4 | 11917.9 | 12651.0 |
| 2008-05-02 09:00:00 | YM | Futures | 11917.0 | 11931.5 | 11864.3 | 11899.7 | 25033.0 |
| 2008-05-02 10:00:00 | YM | Futures | 11900.6 | 11920.6 | 11835.2 | 11842.5 | 29925.0 |
| 2008-05-02 11:00:00 | YM | Futures | 11843.4 | 11878.8 | 11842.5 | 11854.3 | 20615.0 |
| 2008-05-02 12:00:00 | YM | Futures | 11853.4 | 11853.4 | 11812.5 | 11827.9 | 18918.0 |
| 2008-05-02 13:00:00 | YM | Futures | 11827.0 | 11841.5 | 11788.8 | 11821.6 | 17853.0 |
| 2008-05-02 14:00:00 | YM | Futures | 11820.6 | 11838.8 | 11781.6 | 11804.3 | 22051.0 |
| 2008-05-02 15:00:00 | YM | Futures | 11804.3 | 11857.0 | 11797.9 | 11852.5 | 18818.0 |
> showing 50 of 1,035 rows — these rows as CSV