PREVIEW / futures_1hour / 2008-04-10
file: by_date/futures_1hour/2008/2008-04-10.parquet size: 43 KB rows: 1,224
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-04-10 00:00:00 | ES | Futures | 1265.74 | 1267.6 | 1265.51 | 1267.37 | 1059.0 |
| 2008-04-10 01:00:00 | ES | Futures | 1267.37 | 1267.37 | 1265.74 | 1266.2 | 847.0 |
| 2008-04-10 02:00:00 | ES | Futures | 1266.44 | 1267.83 | 1265.27 | 1267.6 | 3328.0 |
| 2008-04-10 03:00:00 | ES | Futures | 1267.37 | 1268.3 | 1265.51 | 1266.2 | 8772.0 |
| 2008-04-10 04:00:00 | ES | Futures | 1266.2 | 1266.44 | 1260.85 | 1261.78 | 18237.0 |
| 2008-04-10 05:00:00 | ES | Futures | 1261.78 | 1262.94 | 1259.68 | 1261.55 | 19708.0 |
| 2008-04-10 06:00:00 | ES | Futures | 1261.31 | 1262.94 | 1259.45 | 1262.71 | 13043.0 |
| 2008-04-10 07:00:00 | ES | Futures | 1262.71 | 1263.18 | 1259.92 | 1260.85 | 21810.0 |
| 2008-04-10 08:00:00 | ES | Futures | 1260.85 | 1264.57 | 1258.99 | 1263.18 | 51380.0 |
| 2008-04-10 09:00:00 | ES | Futures | 1263.18 | 1265.97 | 1259.22 | 1260.38 | 199817.0 |
| 2008-04-10 10:00:00 | ES | Futures | 1260.62 | 1270.86 | 1258.52 | 1270.4 | 374794.0 |
| 2008-04-10 11:00:00 | ES | Futures | 1270.4 | 1274.59 | 1268.07 | 1273.89 | 272439.0 |
| 2008-04-10 12:00:00 | ES | Futures | 1274.12 | 1275.28 | 1269.7 | 1270.16 | 170453.0 |
| 2008-04-10 13:00:00 | ES | Futures | 1269.93 | 1275.05 | 1269.93 | 1271.33 | 132315.0 |
| 2008-04-10 14:00:00 | ES | Futures | 1271.33 | 1273.66 | 1267.37 | 1272.72 | 191369.0 |
| 2008-04-10 15:00:00 | ES | Futures | 1272.72 | 1273.89 | 1264.34 | 1268.07 | 239023.0 |
| 2008-04-10 16:00:00 | ES | Futures | 1268.07 | 1271.09 | 1267.37 | 1270.4 | 54249.0 |
| 2008-04-10 17:00:00 | ES | Futures | 1270.4 | 1271.33 | 1270.16 | 1271.09 | 1811.0 |
| 2008-04-10 18:00:00 | ES | Futures | 1271.09 | 1271.33 | 1269.93 | 1270.86 | 1378.0 |
| 2008-04-10 19:00:00 | ES | Futures | 1270.63 | 1272.72 | 1270.4 | 1272.49 | 2173.0 |
| 2008-04-10 20:00:00 | ES | Futures | 1272.26 | 1272.96 | 1271.79 | 1271.79 | 1659.0 |
| 2008-04-10 21:00:00 | ES | Futures | 1272.03 | 1272.72 | 1271.09 | 1272.03 | 1574.0 |
| 2008-04-10 22:00:00 | ES | Futures | 1272.03 | 1273.19 | 1271.56 | 1272.72 | 1735.0 |
| 2008-04-10 23:00:00 | ES | Futures | 1272.96 | 1273.66 | 1271.79 | 1273.42 | 1327.0 |
| 2008-04-10 00:00:00 | NQ | Futures | 2079.64 | 2082.75 | 2078.79 | 2082.75 | 144.0 |
| 2008-04-10 01:00:00 | NQ | Futures | 2081.62 | 2082.75 | 2080.2 | 2081.62 | 72.0 |
| 2008-04-10 02:00:00 | NQ | Futures | 2080.49 | 2081.34 | 2079.07 | 2080.77 | 507.0 |
| 2008-04-10 03:00:00 | NQ | Futures | 2080.77 | 2082.47 | 2078.51 | 2079.36 | 528.0 |
| 2008-04-10 04:00:00 | NQ | Futures | 2079.36 | 2080.2 | 2072.57 | 2073.42 | 928.0 |
| 2008-04-10 05:00:00 | NQ | Futures | 2073.98 | 2075.68 | 2066.91 | 2070.02 | 1830.0 |
| 2008-04-10 06:00:00 | NQ | Futures | 2069.74 | 2072.57 | 2066.35 | 2072.0 | 788.0 |
| 2008-04-10 07:00:00 | NQ | Futures | 2071.72 | 2074.55 | 2066.35 | 2072.85 | 2409.0 |
| 2008-04-10 08:00:00 | NQ | Futures | 2072.85 | 2073.7 | 2063.23 | 2072.85 | 6858.0 |
| 2008-04-10 09:00:00 | NQ | Futures | 2072.85 | 2087.28 | 2071.72 | 2077.66 | 38907.0 |
| 2008-04-10 10:00:00 | NQ | Futures | 2077.66 | 2107.64 | 2074.27 | 2106.79 | 65762.0 |
| 2008-04-10 11:00:00 | NQ | Futures | 2106.79 | 2112.73 | 2102.27 | 2109.9 | 43830.0 |
| 2008-04-10 12:00:00 | NQ | Futures | 2109.62 | 2111.6 | 2103.96 | 2105.66 | 24512.0 |
| 2008-04-10 13:00:00 | NQ | Futures | 2105.66 | 2115.84 | 2104.81 | 2107.36 | 32184.0 |
| 2008-04-10 14:00:00 | NQ | Futures | 2107.64 | 2112.16 | 2100.57 | 2111.03 | 33568.0 |
| 2008-04-10 15:00:00 | NQ | Futures | 2111.32 | 2113.01 | 2096.04 | 2102.55 | 40883.0 |
| 2008-04-10 16:00:00 | NQ | Futures | 2102.55 | 2105.66 | 2098.59 | 2104.81 | 11530.0 |
| 2008-04-10 17:00:00 | NQ | Futures | 2104.81 | 2106.22 | 2104.53 | 2105.94 | 180.0 |
| 2008-04-10 18:00:00 | NQ | Futures | 2104.53 | 2106.22 | 2104.53 | 2105.94 | 98.0 |
| 2008-04-10 19:00:00 | NQ | Futures | 2105.94 | 2109.05 | 2105.94 | 2109.05 | 167.0 |
| 2008-04-10 20:00:00 | NQ | Futures | 2107.36 | 2109.34 | 2107.07 | 2108.2 | 190.0 |
| 2008-04-10 21:00:00 | NQ | Futures | 2108.2 | 2109.05 | 2106.22 | 2108.2 | 117.0 |
| 2008-04-10 22:00:00 | NQ | Futures | 2108.2 | 2109.9 | 2106.79 | 2109.62 | 144.0 |
| 2008-04-10 23:00:00 | NQ | Futures | 2109.62 | 2111.6 | 2107.92 | 2111.32 | 57.0 |
| 2008-04-10 00:00:00 | YM | Futures | 11411.8 | 11424.5 | 11411.8 | 11424.5 | 103.0 |
| 2008-04-10 01:00:00 | YM | Futures | 11424.5 | 11424.5 | 11412.7 | 11412.7 | 160.0 |
> showing 50 of 1,224 rows — these rows as CSV