PREVIEW / futures_1hour / 2008-02-04
file: by_date/futures_1hour/2008/2008-02-04.parquet size: 29 KB rows: 805
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-02-04 00:00:00 | ES | Futures | 1303.11 | 1304.51 | 1300.31 | 1301.24 | 2689.0 |
| 2008-02-04 01:00:00 | ES | Futures | 1301.48 | 1303.81 | 1301.48 | 1303.81 | 1083.0 |
| 2008-02-04 02:00:00 | ES | Futures | 1303.81 | 1305.21 | 1302.18 | 1304.51 | 5089.0 |
| 2008-02-04 03:00:00 | ES | Futures | 1304.51 | 1304.98 | 1300.55 | 1300.78 | 12052.0 |
| 2008-02-04 04:00:00 | ES | Futures | 1300.78 | 1301.71 | 1299.15 | 1300.55 | 8176.0 |
| 2008-02-04 05:00:00 | ES | Futures | 1300.55 | 1300.78 | 1298.68 | 1300.31 | 7419.0 |
| 2008-02-04 06:00:00 | ES | Futures | 1300.31 | 1305.44 | 1300.08 | 1304.04 | 12019.0 |
| 2008-02-04 07:00:00 | ES | Futures | 1304.04 | 1304.98 | 1300.55 | 1301.48 | 9677.0 |
| 2008-02-04 08:00:00 | ES | Futures | 1301.48 | 1302.18 | 1298.68 | 1301.01 | 23419.0 |
| 2008-02-04 09:00:00 | ES | Futures | 1300.78 | 1301.71 | 1292.38 | 1294.48 | 172443.0 |
| 2008-02-04 10:00:00 | ES | Futures | 1294.48 | 1295.42 | 1289.59 | 1294.02 | 223978.0 |
| 2008-02-04 11:00:00 | ES | Futures | 1294.02 | 1297.51 | 1292.62 | 1294.25 | 135229.0 |
| 2008-02-04 12:00:00 | ES | Futures | 1294.48 | 1294.72 | 1290.29 | 1293.32 | 95599.0 |
| 2008-02-04 13:00:00 | ES | Futures | 1293.08 | 1294.02 | 1288.65 | 1293.32 | 109619.0 |
| 2008-02-04 14:00:00 | ES | Futures | 1293.32 | 1293.55 | 1287.49 | 1290.52 | 122120.0 |
| 2008-02-04 15:00:00 | ES | Futures | 1290.29 | 1293.55 | 1287.26 | 1288.42 | 180403.0 |
| 2008-02-04 16:00:00 | ES | Futures | 1288.42 | 1290.05 | 1284.22 | 1284.92 | 84437.0 |
| 2008-02-04 17:00:00 | ES | Futures | 1284.92 | 1285.62 | 1284.69 | 1285.39 | 980.0 |
| 2008-02-04 18:00:00 | ES | Futures | 1285.39 | 1287.02 | 1285.16 | 1285.86 | 1714.0 |
| 2008-02-04 19:00:00 | ES | Futures | 1285.86 | 1285.86 | 1284.22 | 1284.22 | 1986.0 |
| 2008-02-04 20:00:00 | ES | Futures | 1284.22 | 1284.69 | 1282.36 | 1283.06 | 2190.0 |
| 2008-02-04 21:00:00 | ES | Futures | 1283.06 | 1283.99 | 1282.83 | 1283.99 | 1069.0 |
| 2008-02-04 22:00:00 | ES | Futures | 1283.76 | 1283.99 | 1282.83 | 1283.29 | 670.0 |
| 2008-02-04 23:00:00 | ES | Futures | 1283.52 | 1283.52 | 1282.36 | 1283.06 | 1434.0 |
| 2008-02-04 00:00:00 | NQ | Futures | 2114.07 | 2114.92 | 2110.95 | 2111.23 | 145.0 |
| 2008-02-04 01:00:00 | NQ | Futures | 2111.8 | 2114.07 | 2111.23 | 2113.5 | 23.0 |
| 2008-02-04 02:00:00 | NQ | Futures | 2113.78 | 2118.04 | 2113.5 | 2117.76 | 231.0 |
| 2008-02-04 03:00:00 | NQ | Futures | 2116.34 | 2119.18 | 2111.8 | 2112.93 | 1011.0 |
| 2008-02-04 04:00:00 | NQ | Futures | 2111.8 | 2116.62 | 2110.09 | 2115.2 | 1904.0 |
| 2008-02-04 05:00:00 | NQ | Futures | 2115.49 | 2115.77 | 2111.51 | 2113.78 | 906.0 |
| 2008-02-04 06:00:00 | NQ | Futures | 2113.22 | 2122.3 | 2112.65 | 2120.03 | 1119.0 |
| 2008-02-04 07:00:00 | NQ | Futures | 2119.74 | 2121.45 | 2113.22 | 2115.2 | 1409.0 |
| 2008-02-04 08:00:00 | NQ | Futures | 2114.35 | 2115.77 | 2110.09 | 2114.64 | 2983.0 |
| 2008-02-04 09:00:00 | NQ | Futures | 2114.92 | 2115.49 | 2102.43 | 2108.11 | 35283.0 |
| 2008-02-04 10:00:00 | NQ | Futures | 2107.82 | 2108.67 | 2092.21 | 2100.16 | 56288.0 |
| 2008-02-04 11:00:00 | NQ | Futures | 2100.16 | 2104.98 | 2094.77 | 2095.62 | 31970.0 |
| 2008-02-04 12:00:00 | NQ | Futures | 2095.62 | 2096.47 | 2087.1 | 2091.36 | 31743.0 |
| 2008-02-04 13:00:00 | NQ | Futures | 2091.08 | 2092.21 | 2083.41 | 2091.36 | 28311.0 |
| 2008-02-04 14:00:00 | NQ | Futures | 2091.08 | 2091.36 | 2081.14 | 2087.39 | 29398.0 |
| 2008-02-04 15:00:00 | NQ | Futures | 2087.1 | 2091.64 | 2081.43 | 2082.28 | 37771.0 |
| 2008-02-04 16:00:00 | NQ | Futures | 2081.99 | 2084.26 | 2070.92 | 2072.06 | 22258.0 |
| 2008-02-04 17:00:00 | NQ | Futures | 2072.06 | 2072.34 | 2070.64 | 2072.34 | 159.0 |
| 2008-02-04 18:00:00 | NQ | Futures | 2072.63 | 2074.9 | 2072.63 | 2073.19 | 199.0 |
| 2008-02-04 19:00:00 | NQ | Futures | 2073.19 | 2074.05 | 2071.77 | 2073.19 | 328.0 |
| 2008-02-04 20:00:00 | NQ | Futures | 2072.34 | 2072.34 | 2069.22 | 2069.5 | 248.0 |
| 2008-02-04 21:00:00 | NQ | Futures | 2070.07 | 2071.77 | 2070.07 | 2070.92 | 71.0 |
| 2008-02-04 22:00:00 | NQ | Futures | 2071.21 | 2071.49 | 2070.36 | 2070.92 | 43.0 |
| 2008-02-04 23:00:00 | NQ | Futures | 2071.21 | 2072.63 | 2068.94 | 2069.22 | 114.0 |
| 2008-02-04 00:00:00 | YM | Futures | 11588.8 | 11599.7 | 11568.8 | 11579.7 | 178.0 |
| 2008-02-04 01:00:00 | YM | Futures | 11579.7 | 11594.3 | 11577.9 | 11594.3 | 113.0 |
> showing 50 of 805 rows — these rows as CSV