PREVIEW / futures_1hour / 2008-03-28
file: by_date/futures_1hour/2008/2008-03-28.parquet size: 36 KB rows: 993
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-03-28 00:00:00 | ES | Futures | 1246.18 | 1247.11 | 1244.55 | 1245.71 | 2372.0 |
| 2008-03-28 01:00:00 | ES | Futures | 1245.95 | 1246.41 | 1243.15 | 1243.85 | 1781.0 |
| 2008-03-28 02:00:00 | ES | Futures | 1243.62 | 1245.71 | 1243.39 | 1245.25 | 1568.0 |
| 2008-03-28 03:00:00 | ES | Futures | 1245.25 | 1246.65 | 1242.92 | 1245.71 | 4827.0 |
| 2008-03-28 04:00:00 | ES | Futures | 1245.71 | 1246.41 | 1243.39 | 1245.95 | 13855.0 |
| 2008-03-28 05:00:00 | ES | Futures | 1245.95 | 1248.51 | 1245.48 | 1246.41 | 14375.0 |
| 2008-03-28 06:00:00 | ES | Futures | 1246.41 | 1247.58 | 1244.55 | 1245.71 | 6444.0 |
| 2008-03-28 07:00:00 | ES | Futures | 1245.71 | 1246.88 | 1243.62 | 1243.85 | 10654.0 |
| 2008-03-28 08:00:00 | ES | Futures | 1243.85 | 1247.58 | 1240.13 | 1241.99 | 58708.0 |
| 2008-03-28 09:00:00 | ES | Futures | 1242.22 | 1243.85 | 1237.8 | 1240.59 | 187963.0 |
| 2008-03-28 10:00:00 | ES | Futures | 1240.59 | 1245.02 | 1236.4 | 1238.96 | 265482.0 |
| 2008-03-28 11:00:00 | ES | Futures | 1238.96 | 1243.15 | 1237.33 | 1241.52 | 154346.0 |
| 2008-03-28 12:00:00 | ES | Futures | 1241.52 | 1241.76 | 1235.0 | 1236.17 | 140951.0 |
| 2008-03-28 13:00:00 | ES | Futures | 1236.17 | 1238.26 | 1232.21 | 1233.37 | 139383.0 |
| 2008-03-28 14:00:00 | ES | Futures | 1233.61 | 1235.47 | 1229.88 | 1232.91 | 164273.0 |
| 2008-03-28 15:00:00 | ES | Futures | 1232.91 | 1232.91 | 1223.59 | 1226.85 | 270265.0 |
| 2008-03-28 16:00:00 | ES | Futures | 1226.85 | 1228.72 | 1226.39 | 1228.02 | 66128.0 |
| 2008-03-28 00:00:00 | NQ | Futures | 2037.5 | 2037.5 | 2032.41 | 2034.95 | 159.0 |
| 2008-03-28 01:00:00 | NQ | Futures | 2035.52 | 2036.93 | 2032.41 | 2034.95 | 161.0 |
| 2008-03-28 02:00:00 | NQ | Futures | 2034.1 | 2036.65 | 2034.1 | 2036.37 | 38.0 |
| 2008-03-28 03:00:00 | NQ | Futures | 2036.37 | 2040.89 | 2034.39 | 2038.63 | 838.0 |
| 2008-03-28 04:00:00 | NQ | Futures | 2038.91 | 2040.61 | 2034.39 | 2039.19 | 776.0 |
| 2008-03-28 05:00:00 | NQ | Futures | 2038.63 | 2043.44 | 2038.35 | 2040.04 | 937.0 |
| 2008-03-28 06:00:00 | NQ | Futures | 2040.33 | 2042.02 | 2036.08 | 2037.78 | 539.0 |
| 2008-03-28 07:00:00 | NQ | Futures | 2037.21 | 2038.91 | 2035.23 | 2035.8 | 756.0 |
| 2008-03-28 08:00:00 | NQ | Futures | 2035.52 | 2041.74 | 2031.84 | 2033.54 | 6937.0 |
| 2008-03-28 09:00:00 | NQ | Futures | 2033.82 | 2044.57 | 2029.01 | 2040.33 | 38907.0 |
| 2008-03-28 10:00:00 | NQ | Futures | 2040.33 | 2047.11 | 2029.58 | 2032.97 | 45509.0 |
| 2008-03-28 11:00:00 | NQ | Futures | 2032.97 | 2038.06 | 2030.43 | 2035.52 | 30470.0 |
| 2008-03-28 12:00:00 | NQ | Futures | 2035.52 | 2036.08 | 2022.22 | 2025.62 | 28022.0 |
| 2008-03-28 13:00:00 | NQ | Futures | 2025.34 | 2029.01 | 2014.87 | 2017.42 | 27719.0 |
| 2008-03-28 14:00:00 | NQ | Futures | 2017.42 | 2021.94 | 2009.21 | 2016.85 | 33230.0 |
| 2008-03-28 15:00:00 | NQ | Futures | 2016.57 | 2016.57 | 2000.16 | 2008.08 | 58819.0 |
| 2008-03-28 16:00:00 | NQ | Futures | 2008.08 | 2014.02 | 2004.97 | 2013.17 | 11069.0 |
| 2008-03-28 00:00:00 | YM | Futures | 11247.3 | 11255.5 | 11228.2 | 11250.0 | 379.0 |
| 2008-03-28 01:00:00 | YM | Futures | 11250.0 | 11252.7 | 11234.6 | 11237.3 | 123.0 |
| 2008-03-28 02:00:00 | YM | Futures | 11237.3 | 11250.0 | 11234.6 | 11248.2 | 41.0 |
| 2008-03-28 03:00:00 | YM | Futures | 11248.2 | 11260.9 | 11231.8 | 11249.1 | 386.0 |
| 2008-03-28 04:00:00 | YM | Futures | 11249.1 | 11255.5 | 11233.7 | 11250.9 | 708.0 |
| 2008-03-28 05:00:00 | YM | Futures | 11249.1 | 11267.3 | 11245.5 | 11250.0 | 1036.0 |
| 2008-03-28 06:00:00 | YM | Futures | 11250.0 | 11261.8 | 11234.6 | 11240.0 | 603.0 |
| 2008-03-28 07:00:00 | YM | Futures | 11240.9 | 11251.8 | 11227.3 | 11228.2 | 914.0 |
| 2008-03-28 08:00:00 | YM | Futures | 11228.2 | 11263.6 | 11198.2 | 11216.4 | 3657.0 |
| 2008-03-28 09:00:00 | YM | Futures | 11218.2 | 11235.5 | 11183.7 | 11210.0 | 17075.0 |
| 2008-03-28 10:00:00 | YM | Futures | 11210.9 | 11246.4 | 11175.5 | 11194.6 | 24745.0 |
| 2008-03-28 11:00:00 | YM | Futures | 11193.7 | 11221.8 | 11182.8 | 11210.9 | 15544.0 |
| 2008-03-28 12:00:00 | YM | Futures | 11210.9 | 11214.6 | 11160.1 | 11165.5 | 14407.0 |
| 2008-03-28 13:00:00 | YM | Futures | 11164.6 | 11184.6 | 11141.0 | 11154.6 | 14041.0 |
| 2008-03-28 14:00:00 | YM | Futures | 11156.4 | 11171.0 | 11124.6 | 11150.1 | 16290.0 |
| 2008-03-28 15:00:00 | YM | Futures | 11150.1 | 11151.0 | 11077.4 | 11097.4 | 23655.0 |
> showing 50 of 993 rows — these rows as CSV