PREVIEW / futures_1hour / 2008-02-22
file: by_date/futures_1hour/2008/2008-02-22.parquet size: 28 KB rows: 752
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-22 00:00:00 | ES | Futures | 1252.75 | 1253.91 | 1252.75 | 1253.68 | 1025.0 |
| 2008-02-22 01:00:00 | ES | Futures | 1253.91 | 1255.55 | 1253.45 | 1255.08 | 1954.0 |
| 2008-02-22 02:00:00 | ES | Futures | 1255.08 | 1255.78 | 1251.35 | 1253.91 | 7911.0 |
| 2008-02-22 03:00:00 | ES | Futures | 1253.91 | 1258.11 | 1252.28 | 1255.31 | 20293.0 |
| 2008-02-22 04:00:00 | ES | Futures | 1255.08 | 1256.71 | 1251.35 | 1254.85 | 16241.0 |
| 2008-02-22 05:00:00 | ES | Futures | 1255.08 | 1257.64 | 1253.68 | 1255.78 | 9794.0 |
| 2008-02-22 06:00:00 | ES | Futures | 1255.78 | 1257.41 | 1253.21 | 1253.91 | 12478.0 |
| 2008-02-22 07:00:00 | ES | Futures | 1253.68 | 1255.78 | 1251.58 | 1253.68 | 14673.0 |
| 2008-02-22 08:00:00 | ES | Futures | 1253.68 | 1260.44 | 1253.21 | 1259.98 | 42970.0 |
| 2008-02-22 09:00:00 | ES | Futures | 1259.98 | 1260.21 | 1251.12 | 1252.75 | 159702.0 |
| 2008-02-22 10:00:00 | ES | Futures | 1252.98 | 1252.98 | 1241.32 | 1244.12 | 395832.0 |
| 2008-02-22 11:00:00 | ES | Futures | 1244.12 | 1248.32 | 1242.96 | 1245.29 | 185155.0 |
| 2008-02-22 12:00:00 | ES | Futures | 1245.29 | 1245.75 | 1238.99 | 1242.02 | 164396.0 |
| 2008-02-22 13:00:00 | ES | Futures | 1242.26 | 1245.52 | 1239.46 | 1242.02 | 147014.0 |
| 2008-02-22 14:00:00 | ES | Futures | 1242.26 | 1245.52 | 1239.23 | 1242.96 | 169231.0 |
| 2008-02-22 15:00:00 | ES | Futures | 1242.96 | 1265.11 | 1237.59 | 1264.64 | 542739.0 |
| 2008-02-22 16:00:00 | ES | Futures | 1264.64 | 1266.04 | 1262.07 | 1264.41 | 93444.0 |
| 2008-02-22 00:00:00 | NQ | Futures | 2013.87 | 2015.01 | 2012.17 | 2014.72 | 60.0 |
| 2008-02-22 01:00:00 | NQ | Futures | 2014.15 | 2017.56 | 2013.02 | 2016.71 | 88.0 |
| 2008-02-22 02:00:00 | NQ | Futures | 2016.99 | 2018.13 | 2010.46 | 2014.15 | 412.0 |
| 2008-02-22 03:00:00 | NQ | Futures | 2014.15 | 2021.53 | 2011.32 | 2015.29 | 886.0 |
| 2008-02-22 04:00:00 | NQ | Futures | 2014.72 | 2017.84 | 2009.9 | 2015.86 | 1995.0 |
| 2008-02-22 05:00:00 | NQ | Futures | 2015.29 | 2021.82 | 2015.01 | 2016.99 | 1308.0 |
| 2008-02-22 06:00:00 | NQ | Futures | 2016.99 | 2020.12 | 2013.87 | 2014.72 | 935.0 |
| 2008-02-22 07:00:00 | NQ | Futures | 2014.44 | 2016.99 | 2013.02 | 2014.15 | 2231.0 |
| 2008-02-22 08:00:00 | NQ | Futures | 2014.72 | 2025.22 | 2014.44 | 2024.94 | 3712.0 |
| 2008-02-22 09:00:00 | NQ | Futures | 2024.94 | 2025.22 | 2009.9 | 2013.87 | 34341.0 |
| 2008-02-22 10:00:00 | NQ | Futures | 2013.87 | 2014.15 | 1993.15 | 1994.0 | 66862.0 |
| 2008-02-22 11:00:00 | NQ | Futures | 1994.0 | 1999.11 | 1990.31 | 1994.29 | 41344.0 |
| 2008-02-22 12:00:00 | NQ | Futures | 1994.29 | 1994.57 | 1981.23 | 1987.47 | 37340.0 |
| 2008-02-22 13:00:00 | NQ | Futures | 1987.47 | 1992.01 | 1980.09 | 1983.78 | 32823.0 |
| 2008-02-22 14:00:00 | NQ | Futures | 1984.07 | 1991.45 | 1978.96 | 1987.47 | 31968.0 |
| 2008-02-22 15:00:00 | NQ | Futures | 1987.76 | 2019.26 | 1977.82 | 2018.7 | 103933.0 |
| 2008-02-22 16:00:00 | NQ | Futures | 2018.7 | 2023.81 | 2008.76 | 2022.95 | 18340.0 |
| 2008-02-22 00:00:00 | YM | Futures | 11174.5 | 11182.7 | 11172.7 | 11180.9 | 90.0 |
| 2008-02-22 01:00:00 | YM | Futures | 11180.9 | 11190.9 | 11180.9 | 11190.9 | 114.0 |
| 2008-02-22 02:00:00 | YM | Futures | 11188.2 | 11191.8 | 11159.1 | 11180.9 | 461.0 |
| 2008-02-22 03:00:00 | YM | Futures | 11180.0 | 11209.0 | 11168.2 | 11187.2 | 870.0 |
| 2008-02-22 04:00:00 | YM | Futures | 11187.2 | 11199.1 | 11159.1 | 11184.5 | 1694.0 |
| 2008-02-22 05:00:00 | YM | Futures | 11184.5 | 11205.4 | 11175.4 | 11191.8 | 939.0 |
| 2008-02-22 06:00:00 | YM | Futures | 11192.7 | 11203.6 | 11174.5 | 11177.3 | 699.0 |
| 2008-02-22 07:00:00 | YM | Futures | 11179.1 | 11190.9 | 11160.0 | 11176.3 | 673.0 |
| 2008-02-22 08:00:00 | YM | Futures | 11176.3 | 11227.2 | 11173.6 | 11224.5 | 2523.0 |
| 2008-02-22 09:00:00 | YM | Futures | 11223.6 | 11223.6 | 11158.2 | 11170.9 | 16057.0 |
| 2008-02-22 10:00:00 | YM | Futures | 11169.1 | 11170.0 | 11082.8 | 11101.8 | 39199.0 |
| 2008-02-22 11:00:00 | YM | Futures | 11101.8 | 11130.9 | 11091.9 | 11104.6 | 21826.0 |
| 2008-02-22 12:00:00 | YM | Futures | 11105.5 | 11109.1 | 11054.6 | 11075.5 | 19782.0 |
| 2008-02-22 13:00:00 | YM | Futures | 11075.5 | 11104.6 | 11054.6 | 11082.8 | 19666.0 |
| 2008-02-22 14:00:00 | YM | Futures | 11083.7 | 11108.2 | 11059.1 | 11086.4 | 21202.0 |
| 2008-02-22 15:00:00 | YM | Futures | 11087.3 | 11279.9 | 11048.2 | 11276.3 | 52020.0 |
> showing 50 of 752 rows — these rows as CSV