PREVIEW / futures_1hour / 2008-03-03
file: by_date/futures_1hour/2008/2008-03-03.parquet size: 40 KB rows: 1,135
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-03 00:00:00 | ES | Futures | 1236.66 | 1237.59 | 1233.86 | 1234.1 | 2493.0 |
| 2008-03-03 01:00:00 | ES | Futures | 1234.1 | 1235.03 | 1232.46 | 1234.33 | 3770.0 |
| 2008-03-03 02:00:00 | ES | Futures | 1234.1 | 1236.19 | 1233.63 | 1234.33 | 6939.0 |
| 2008-03-03 03:00:00 | ES | Futures | 1234.33 | 1236.89 | 1232.0 | 1233.86 | 17757.0 |
| 2008-03-03 04:00:00 | ES | Futures | 1233.86 | 1238.99 | 1233.16 | 1238.76 | 17931.0 |
| 2008-03-03 05:00:00 | ES | Futures | 1238.53 | 1239.92 | 1236.43 | 1238.53 | 15066.0 |
| 2008-03-03 06:00:00 | ES | Futures | 1238.29 | 1238.29 | 1233.4 | 1235.26 | 18075.0 |
| 2008-03-03 07:00:00 | ES | Futures | 1235.49 | 1239.46 | 1234.8 | 1238.99 | 22938.0 |
| 2008-03-03 08:00:00 | ES | Futures | 1239.23 | 1242.02 | 1237.59 | 1240.39 | 63910.0 |
| 2008-03-03 09:00:00 | ES | Futures | 1240.62 | 1241.09 | 1232.93 | 1234.56 | 232790.0 |
| 2008-03-03 10:00:00 | ES | Futures | 1234.56 | 1245.29 | 1233.4 | 1237.83 | 385102.0 |
| 2008-03-03 11:00:00 | ES | Futures | 1237.83 | 1244.12 | 1235.26 | 1242.96 | 218309.0 |
| 2008-03-03 12:00:00 | ES | Futures | 1243.19 | 1245.75 | 1239.23 | 1241.09 | 147933.0 |
| 2008-03-03 13:00:00 | ES | Futures | 1241.09 | 1243.89 | 1238.53 | 1239.46 | 138480.0 |
| 2008-03-03 14:00:00 | ES | Futures | 1239.46 | 1241.32 | 1231.06 | 1232.23 | 248800.0 |
| 2008-03-03 15:00:00 | ES | Futures | 1232.23 | 1242.72 | 1232.0 | 1242.26 | 286042.0 |
| 2008-03-03 16:00:00 | ES | Futures | 1242.26 | 1244.12 | 1240.62 | 1243.89 | 58860.0 |
| 2008-03-03 17:00:00 | ES | Futures | 1243.89 | 1247.39 | 1243.66 | 1244.82 | 4722.0 |
| 2008-03-03 18:00:00 | ES | Futures | 1245.05 | 1245.05 | 1241.09 | 1243.89 | 8737.0 |
| 2008-03-03 19:00:00 | ES | Futures | 1244.12 | 1244.12 | 1241.09 | 1241.09 | 4010.0 |
| 2008-03-03 20:00:00 | ES | Futures | 1241.09 | 1243.42 | 1240.39 | 1243.42 | 4154.0 |
| 2008-03-03 21:00:00 | ES | Futures | 1243.42 | 1245.52 | 1242.96 | 1245.29 | 2946.0 |
| 2008-03-03 22:00:00 | ES | Futures | 1245.52 | 1245.99 | 1242.49 | 1242.49 | 3014.0 |
| 2008-03-03 23:00:00 | ES | Futures | 1242.72 | 1243.19 | 1239.92 | 1240.16 | 3107.0 |
| 2008-03-03 00:00:00 | NQ | Futures | 1977.82 | 1978.11 | 1973.85 | 1973.85 | 121.0 |
| 2008-03-03 01:00:00 | NQ | Futures | 1974.42 | 1975.55 | 1969.88 | 1971.58 | 322.0 |
| 2008-03-03 02:00:00 | NQ | Futures | 1971.29 | 1973.28 | 1970.44 | 1973.28 | 458.0 |
| 2008-03-03 03:00:00 | NQ | Futures | 1971.58 | 1978.96 | 1968.46 | 1971.86 | 1481.0 |
| 2008-03-03 04:00:00 | NQ | Futures | 1971.86 | 1980.38 | 1971.29 | 1980.09 | 913.0 |
| 2008-03-03 05:00:00 | NQ | Futures | 1980.09 | 1983.78 | 1974.7 | 1978.39 | 569.0 |
| 2008-03-03 06:00:00 | NQ | Futures | 1977.82 | 1977.82 | 1969.88 | 1973.57 | 409.0 |
| 2008-03-03 07:00:00 | NQ | Futures | 1973.28 | 1981.51 | 1973.0 | 1981.51 | 1500.0 |
| 2008-03-03 08:00:00 | NQ | Futures | 1981.23 | 1985.49 | 1978.96 | 1981.51 | 5512.0 |
| 2008-03-03 09:00:00 | NQ | Futures | 1981.8 | 1984.92 | 1968.74 | 1973.28 | 56613.0 |
| 2008-03-03 10:00:00 | NQ | Futures | 1973.28 | 1984.92 | 1968.46 | 1971.01 | 82437.0 |
| 2008-03-03 11:00:00 | NQ | Futures | 1970.73 | 1979.81 | 1963.06 | 1978.96 | 54635.0 |
| 2008-03-03 12:00:00 | NQ | Futures | 1978.67 | 1982.93 | 1971.86 | 1973.28 | 29365.0 |
| 2008-03-03 13:00:00 | NQ | Futures | 1973.57 | 1977.25 | 1968.17 | 1970.16 | 31328.0 |
| 2008-03-03 14:00:00 | NQ | Futures | 1970.44 | 1971.01 | 1950.86 | 1953.41 | 60782.0 |
| 2008-03-03 15:00:00 | NQ | Futures | 1953.13 | 1972.15 | 1953.13 | 1971.01 | 73702.0 |
| 2008-03-03 16:00:00 | NQ | Futures | 1971.29 | 1975.55 | 1967.04 | 1973.28 | 11773.0 |
| 2008-03-03 17:00:00 | NQ | Futures | 1973.28 | 1979.24 | 1972.71 | 1973.0 | 1531.0 |
| 2008-03-03 18:00:00 | NQ | Futures | 1972.71 | 1973.57 | 1965.9 | 1965.9 | 1235.0 |
| 2008-03-03 19:00:00 | NQ | Futures | 1966.75 | 1966.75 | 1964.77 | 1965.05 | 619.0 |
| 2008-03-03 20:00:00 | NQ | Futures | 1965.05 | 1969.59 | 1964.77 | 1968.74 | 510.0 |
| 2008-03-03 21:00:00 | NQ | Futures | 1968.74 | 1972.15 | 1968.17 | 1972.15 | 164.0 |
| 2008-03-03 22:00:00 | NQ | Futures | 1972.15 | 1973.0 | 1968.17 | 1968.17 | 57.0 |
| 2008-03-03 23:00:00 | NQ | Futures | 1968.17 | 1968.17 | 1964.77 | 1964.77 | 197.0 |
| 2008-03-03 00:00:00 | YM | Futures | 11102.8 | 11106.4 | 11087.3 | 11089.1 | 124.0 |
| 2008-03-03 01:00:00 | YM | Futures | 11089.1 | 11099.1 | 11075.5 | 11086.4 | 246.0 |
> showing 50 of 1,135 rows — these rows as CSV