PREVIEW / futures_30min / 2008-02-22
file: by_date/futures_30min/2008/2008-02-22.parquet size: 43 KB rows: 1,389
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.68 | 1252.75 | 1252.98 | 508.0 |
| 2008-02-22 00:30:00 | ES | Futures | 1252.75 | 1253.91 | 1252.75 | 1253.68 | 517.0 |
| 2008-02-22 01:00:00 | ES | Futures | 1253.91 | 1254.85 | 1253.45 | 1254.85 | 529.0 |
| 2008-02-22 01:30:00 | ES | Futures | 1254.85 | 1255.55 | 1253.68 | 1255.08 | 1425.0 |
| 2008-02-22 02:00:00 | ES | Futures | 1255.08 | 1255.78 | 1252.98 | 1253.91 | 2218.0 |
| 2008-02-22 02:30:00 | ES | Futures | 1254.15 | 1254.85 | 1251.35 | 1253.91 | 5693.0 |
| 2008-02-22 03:00:00 | ES | Futures | 1253.91 | 1256.25 | 1252.28 | 1255.08 | 11383.0 |
| 2008-02-22 03:30:00 | ES | Futures | 1254.85 | 1258.11 | 1254.38 | 1255.31 | 8910.0 |
| 2008-02-22 04:00:00 | ES | Futures | 1255.08 | 1256.71 | 1253.68 | 1253.91 | 9656.0 |
| 2008-02-22 04:30:00 | ES | Futures | 1253.91 | 1255.78 | 1251.35 | 1254.85 | 6585.0 |
| 2008-02-22 05:00:00 | ES | Futures | 1255.08 | 1256.71 | 1253.68 | 1255.31 | 5746.0 |
| 2008-02-22 05:30:00 | ES | Futures | 1255.55 | 1257.64 | 1255.08 | 1255.78 | 4048.0 |
| 2008-02-22 06:00:00 | ES | Futures | 1255.78 | 1257.41 | 1255.08 | 1255.31 | 6053.0 |
| 2008-02-22 06:30:00 | ES | Futures | 1255.31 | 1255.78 | 1253.21 | 1253.91 | 6425.0 |
| 2008-02-22 07:00:00 | ES | Futures | 1253.68 | 1255.78 | 1253.21 | 1254.38 | 4917.0 |
| 2008-02-22 07:30:00 | ES | Futures | 1254.15 | 1254.61 | 1251.58 | 1253.68 | 9756.0 |
| 2008-02-22 08:00:00 | ES | Futures | 1253.68 | 1257.18 | 1253.21 | 1255.78 | 14953.0 |
| 2008-02-22 08:30:00 | ES | Futures | 1255.55 | 1260.44 | 1255.55 | 1259.98 | 28017.0 |
| 2008-02-22 09:00:00 | ES | Futures | 1259.98 | 1260.21 | 1257.41 | 1257.64 | 19491.0 |
| 2008-02-22 09:30:00 | ES | Futures | 1257.64 | 1258.58 | 1251.12 | 1252.75 | 140211.0 |
| 2008-02-22 10:00:00 | ES | Futures | 1252.98 | 1252.98 | 1244.59 | 1247.15 | 207802.0 |
| 2008-02-22 10:30:00 | ES | Futures | 1247.15 | 1247.85 | 1241.32 | 1244.12 | 188030.0 |
| 2008-02-22 11:00:00 | ES | Futures | 1244.12 | 1247.85 | 1242.96 | 1245.99 | 109497.0 |
| 2008-02-22 11:30:00 | ES | Futures | 1245.99 | 1248.32 | 1243.42 | 1245.29 | 75658.0 |
| 2008-02-22 12:00:00 | ES | Futures | 1245.29 | 1245.75 | 1239.69 | 1241.32 | 94246.0 |
| 2008-02-22 12:30:00 | ES | Futures | 1241.32 | 1243.89 | 1238.99 | 1242.02 | 70150.0 |
| 2008-02-22 13:00:00 | ES | Futures | 1242.26 | 1245.52 | 1240.39 | 1241.32 | 65754.0 |
| 2008-02-22 13:30:00 | ES | Futures | 1241.56 | 1244.12 | 1239.46 | 1242.02 | 81260.0 |
| 2008-02-22 14:00:00 | ES | Futures | 1242.26 | 1242.96 | 1239.23 | 1240.86 | 73373.0 |
| 2008-02-22 14:30:00 | ES | Futures | 1240.86 | 1245.52 | 1239.46 | 1242.96 | 95858.0 |
| 2008-02-22 15:00:00 | ES | Futures | 1242.96 | 1245.29 | 1237.59 | 1244.82 | 132008.0 |
| 2008-02-22 15:30:00 | ES | Futures | 1244.82 | 1265.11 | 1243.89 | 1264.64 | 410731.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 | 2013.87 | 2013.87 | 2013.87 | 1.0 |
| 2008-02-22 00:30:00 | NQ | Futures | 2013.87 | 2015.01 | 2012.17 | 2014.72 | 59.0 |
| 2008-02-22 01:00:00 | NQ | Futures | 2014.15 | 2015.86 | 2013.02 | 2015.86 | 32.0 |
| 2008-02-22 01:30:00 | NQ | Futures | 2015.86 | 2017.56 | 2015.57 | 2016.71 | 56.0 |
| 2008-02-22 02:00:00 | NQ | Futures | 2016.99 | 2018.13 | 2013.3 | 2015.29 | 148.0 |
| 2008-02-22 02:30:00 | NQ | Futures | 2015.29 | 2015.57 | 2010.46 | 2014.15 | 264.0 |
| 2008-02-22 03:00:00 | NQ | Futures | 2014.15 | 2018.41 | 2011.32 | 2016.71 | 499.0 |
| 2008-02-22 03:30:00 | NQ | Futures | 2016.43 | 2021.53 | 2014.72 | 2015.29 | 387.0 |
| 2008-02-22 04:00:00 | NQ | Futures | 2014.72 | 2017.84 | 2013.02 | 2013.3 | 1454.0 |
| 2008-02-22 04:30:00 | NQ | Futures | 2012.74 | 2016.99 | 2009.9 | 2015.86 | 541.0 |
| 2008-02-22 05:00:00 | NQ | Futures | 2015.29 | 2020.4 | 2015.01 | 2017.84 | 680.0 |
| 2008-02-22 05:30:00 | NQ | Futures | 2018.13 | 2021.82 | 2016.43 | 2016.99 | 628.0 |
| 2008-02-22 06:00:00 | NQ | Futures | 2016.99 | 2020.12 | 2016.14 | 2016.99 | 325.0 |
| 2008-02-22 06:30:00 | NQ | Futures | 2016.43 | 2018.7 | 2013.87 | 2014.72 | 610.0 |
| 2008-02-22 07:00:00 | NQ | Futures | 2014.44 | 2016.99 | 2013.59 | 2015.86 | 487.0 |
| 2008-02-22 07:30:00 | NQ | Futures | 2015.57 | 2016.14 | 2013.02 | 2014.15 | 1744.0 |
| 2008-02-22 08:00:00 | NQ | Futures | 2014.72 | 2020.97 | 2014.44 | 2018.7 | 1544.0 |
> showing 50 of 1,389 rows — these rows as CSV