PREVIEW / futures_1hour / 2008-05-26
file: by_date/futures_1hour/2008/2008-05-26.parquet size: 25 KB rows: 726
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-26 00:00:00 | ES | Futures | 1279.24 | 1280.41 | 1279.01 | 1279.71 | 415.0 |
| 2008-05-26 01:00:00 | ES | Futures | 1279.94 | 1280.17 | 1278.54 | 1279.01 | 534.0 |
| 2008-05-26 02:00:00 | ES | Futures | 1279.01 | 1279.94 | 1278.31 | 1278.78 | 1765.0 |
| 2008-05-26 03:00:00 | ES | Futures | 1278.78 | 1282.27 | 1278.54 | 1281.34 | 3317.0 |
| 2008-05-26 04:00:00 | ES | Futures | 1281.34 | 1282.74 | 1281.11 | 1281.34 | 2086.0 |
| 2008-05-26 05:00:00 | ES | Futures | 1281.57 | 1282.74 | 1280.64 | 1281.8 | 2366.0 |
| 2008-05-26 06:00:00 | ES | Futures | 1282.04 | 1282.97 | 1281.11 | 1282.27 | 1375.0 |
| 2008-05-26 07:00:00 | ES | Futures | 1282.27 | 1282.74 | 1281.11 | 1281.8 | 1230.0 |
| 2008-05-26 08:00:00 | ES | Futures | 1281.57 | 1282.74 | 1280.87 | 1281.34 | 1794.0 |
| 2008-05-26 09:00:00 | ES | Futures | 1281.57 | 1282.5 | 1280.87 | 1282.27 | 2217.0 |
| 2008-05-26 10:00:00 | ES | Futures | 1282.27 | 1282.74 | 1281.57 | 1282.5 | 1710.0 |
| 2008-05-26 11:00:00 | ES | Futures | 1282.5 | 1282.97 | 1280.17 | 1280.41 | 2262.0 |
| 2008-05-26 18:00:00 | ES | Futures | 1280.64 | 1281.34 | 1280.17 | 1281.34 | 2043.0 |
| 2008-05-26 19:00:00 | ES | Futures | 1281.34 | 1281.57 | 1280.41 | 1281.34 | 467.0 |
| 2008-05-26 20:00:00 | ES | Futures | 1281.57 | 1282.04 | 1280.64 | 1282.04 | 1465.0 |
| 2008-05-26 21:00:00 | ES | Futures | 1282.04 | 1282.74 | 1281.8 | 1282.5 | 1294.0 |
| 2008-05-26 22:00:00 | ES | Futures | 1282.5 | 1282.74 | 1282.04 | 1282.27 | 620.0 |
| 2008-05-26 23:00:00 | ES | Futures | 1282.04 | 1282.5 | 1281.11 | 1281.34 | 727.0 |
| 2008-05-26 00:00:00 | NQ | Futures | 2215.68 | 2217.09 | 2215.68 | 2217.09 | 4.0 |
| 2008-05-26 01:00:00 | NQ | Futures | 2217.38 | 2217.38 | 2216.53 | 2217.09 | 14.0 |
| 2008-05-26 02:00:00 | NQ | Futures | 2216.53 | 2217.38 | 2215.11 | 2215.11 | 89.0 |
| 2008-05-26 03:00:00 | NQ | Futures | 2215.4 | 2221.34 | 2215.4 | 2219.64 | 425.0 |
| 2008-05-26 04:00:00 | NQ | Futures | 2219.64 | 2221.34 | 2218.51 | 2221.34 | 196.0 |
| 2008-05-26 05:00:00 | NQ | Futures | 2220.77 | 2222.75 | 2220.2 | 2221.34 | 260.0 |
| 2008-05-26 06:00:00 | NQ | Futures | 2221.34 | 2223.88 | 2220.77 | 2223.32 | 201.0 |
| 2008-05-26 07:00:00 | NQ | Futures | 2223.32 | 2223.32 | 2221.05 | 2221.62 | 134.0 |
| 2008-05-26 08:00:00 | NQ | Futures | 2222.18 | 2223.32 | 2220.49 | 2221.62 | 209.0 |
| 2008-05-26 09:00:00 | NQ | Futures | 2221.9 | 2223.6 | 2220.49 | 2223.6 | 484.0 |
| 2008-05-26 10:00:00 | NQ | Futures | 2223.32 | 2224.73 | 2223.03 | 2224.16 | 463.0 |
| 2008-05-26 11:00:00 | NQ | Futures | 2224.45 | 2226.43 | 2221.05 | 2221.05 | 968.0 |
| 2008-05-26 18:00:00 | NQ | Futures | 2221.62 | 2221.62 | 2219.64 | 2220.49 | 134.0 |
| 2008-05-26 19:00:00 | NQ | Futures | 2220.49 | 2221.9 | 2219.36 | 2221.62 | 53.0 |
| 2008-05-26 20:00:00 | NQ | Futures | 2221.9 | 2222.47 | 2220.49 | 2222.47 | 35.0 |
| 2008-05-26 21:00:00 | NQ | Futures | 2222.75 | 2223.32 | 2222.47 | 2223.32 | 50.0 |
| 2008-05-26 22:00:00 | NQ | Futures | 2223.32 | 2223.6 | 2222.47 | 2222.75 | 29.0 |
| 2008-05-26 23:00:00 | NQ | Futures | 2222.47 | 2223.32 | 2220.77 | 2221.34 | 41.0 |
| 2008-05-26 00:00:00 | YM | Futures | 11332.7 | 11339.1 | 11328.2 | 11334.5 | 51.0 |
| 2008-05-26 01:00:00 | YM | Futures | 11338.2 | 11338.2 | 11322.7 | 11324.5 | 83.0 |
| 2008-05-26 02:00:00 | YM | Futures | 11324.5 | 11330.9 | 11321.8 | 11321.8 | 52.0 |
| 2008-05-26 03:00:00 | YM | Futures | 11320.9 | 11353.6 | 11318.2 | 11349.1 | 223.0 |
| 2008-05-26 04:00:00 | YM | Futures | 11348.1 | 11353.6 | 11347.2 | 11349.1 | 106.0 |
| 2008-05-26 05:00:00 | YM | Futures | 11350.0 | 11358.1 | 11347.2 | 11353.6 | 200.0 |
| 2008-05-26 06:00:00 | YM | Futures | 11351.8 | 11358.1 | 11350.9 | 11356.3 | 60.0 |
| 2008-05-26 07:00:00 | YM | Futures | 11357.2 | 11357.2 | 11347.2 | 11353.6 | 46.0 |
| 2008-05-26 08:00:00 | YM | Futures | 11354.5 | 11356.3 | 11345.4 | 11348.1 | 46.0 |
| 2008-05-26 09:00:00 | YM | Futures | 11347.2 | 11356.3 | 11344.5 | 11349.1 | 108.0 |
| 2008-05-26 10:00:00 | YM | Futures | 11351.8 | 11353.6 | 11347.2 | 11350.9 | 55.0 |
| 2008-05-26 11:00:00 | YM | Futures | 11350.9 | 11356.3 | 11339.1 | 11339.1 | 98.0 |
| 2008-05-26 18:00:00 | YM | Futures | 11340.0 | 11348.1 | 11333.6 | 11343.6 | 119.0 |
| 2008-05-26 19:00:00 | YM | Futures | 11340.9 | 11350.0 | 11340.0 | 11348.1 | 50.0 |
> showing 50 of 726 rows — these rows as CSV