PREVIEW / futures_1hour / 2014-06-11
file: by_date/futures_1hour/2014/2014-06-11.parquet size: 45 KB rows: 1,450
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-11 00:00:00 | ES | Futures | 2024.66 | 2024.66 | 2024.14 | 2024.4 | 456.0 |
| 2014-06-11 01:00:00 | ES | Futures | 2024.4 | 2024.66 | 2023.88 | 2024.14 | 1894.0 |
| 2014-06-11 02:00:00 | ES | Futures | 2024.4 | 2024.66 | 2023.62 | 2024.14 | 3826.0 |
| 2014-06-11 03:00:00 | ES | Futures | 2024.14 | 2024.66 | 2022.06 | 2022.58 | 12607.0 |
| 2014-06-11 04:00:00 | ES | Futures | 2022.58 | 2023.36 | 2021.8 | 2022.06 | 8614.0 |
| 2014-06-11 05:00:00 | ES | Futures | 2022.32 | 2022.32 | 2018.68 | 2018.94 | 22357.0 |
| 2014-06-11 06:00:00 | ES | Futures | 2018.94 | 2020.24 | 2017.13 | 2017.65 | 23322.0 |
| 2014-06-11 07:00:00 | ES | Futures | 2017.65 | 2017.9 | 2015.05 | 2016.61 | 40117.0 |
| 2014-06-11 08:00:00 | ES | Futures | 2016.61 | 2017.65 | 2016.09 | 2016.87 | 26548.0 |
| 2014-06-11 09:00:00 | ES | Futures | 2016.87 | 2020.5 | 2016.35 | 2018.68 | 154707.0 |
| 2014-06-11 10:00:00 | ES | Futures | 2018.68 | 2020.24 | 2015.83 | 2016.61 | 179012.0 |
| 2014-06-11 11:00:00 | ES | Futures | 2016.61 | 2019.72 | 2016.61 | 2019.72 | 94578.0 |
| 2014-06-11 12:00:00 | ES | Futures | 2019.72 | 2020.24 | 2018.68 | 2019.46 | 62589.0 |
| 2014-06-11 13:00:00 | ES | Futures | 2019.46 | 2019.72 | 2016.09 | 2016.09 | 59183.0 |
| 2014-06-11 14:00:00 | ES | Futures | 2016.09 | 2017.39 | 2013.49 | 2016.61 | 118963.0 |
| 2014-06-11 15:00:00 | ES | Futures | 2016.61 | 2020.24 | 2016.35 | 2018.68 | 187778.0 |
| 2014-06-11 16:00:00 | ES | Futures | 2018.68 | 2019.72 | 2018.16 | 2018.94 | 60751.0 |
| 2014-06-11 17:00:00 | ES | Futures | 2018.94 | 2019.46 | 2018.94 | 2019.46 | 867.0 |
| 2014-06-11 18:00:00 | ES | Futures | 2018.94 | 2019.46 | 2017.9 | 2019.46 | 3410.0 |
| 2014-06-11 19:00:00 | ES | Futures | 2019.46 | 2019.98 | 2019.2 | 2019.46 | 1478.0 |
| 2014-06-11 20:00:00 | ES | Futures | 2019.46 | 2019.98 | 2018.16 | 2018.42 | 3496.0 |
| 2014-06-11 21:00:00 | ES | Futures | 2018.42 | 2023.1 | 2018.16 | 2021.28 | 11436.0 |
| 2014-06-11 22:00:00 | ES | Futures | 2021.28 | 2022.84 | 2019.46 | 2019.46 | 7651.0 |
| 2014-06-11 23:00:00 | ES | Futures | 2019.72 | 2020.76 | 2019.46 | 2019.98 | 2243.0 |
| 2014-06-11 00:00:00 | NQ | Futures | 4424.25 | 4424.54 | 4423.67 | 4424.25 | 115.0 |
| 2014-06-11 01:00:00 | NQ | Futures | 4424.25 | 4425.12 | 4423.67 | 4425.12 | 252.0 |
| 2014-06-11 02:00:00 | NQ | Futures | 4424.54 | 4424.83 | 4422.79 | 4424.25 | 414.0 |
| 2014-06-11 03:00:00 | NQ | Futures | 4424.54 | 4424.83 | 4420.46 | 4422.21 | 2094.0 |
| 2014-06-11 04:00:00 | NQ | Futures | 4422.21 | 4423.08 | 4419.59 | 4420.17 | 1167.0 |
| 2014-06-11 05:00:00 | NQ | Futures | 4420.17 | 4420.46 | 4412.31 | 4412.6 | 3147.0 |
| 2014-06-11 06:00:00 | NQ | Futures | 4412.6 | 4414.93 | 4409.69 | 4409.98 | 3296.0 |
| 2014-06-11 07:00:00 | NQ | Futures | 4409.98 | 4411.14 | 4402.7 | 4406.78 | 5790.0 |
| 2014-06-11 08:00:00 | NQ | Futures | 4407.07 | 4410.56 | 4406.48 | 4407.36 | 4540.0 |
| 2014-06-11 09:00:00 | NQ | Futures | 4407.07 | 4427.16 | 4406.19 | 4423.08 | 34315.0 |
| 2014-06-11 10:00:00 | NQ | Futures | 4422.79 | 4429.78 | 4418.72 | 4422.5 | 35072.0 |
| 2014-06-11 11:00:00 | NQ | Futures | 4422.21 | 4432.11 | 4421.05 | 4429.2 | 21166.0 |
| 2014-06-11 12:00:00 | NQ | Futures | 4429.49 | 4430.66 | 4425.7 | 4430.36 | 9124.0 |
| 2014-06-11 13:00:00 | NQ | Futures | 4430.36 | 4430.66 | 4416.39 | 4416.68 | 13126.0 |
| 2014-06-11 14:00:00 | NQ | Futures | 4416.09 | 4418.72 | 4407.36 | 4417.26 | 23793.0 |
| 2014-06-11 15:00:00 | NQ | Futures | 4417.26 | 4427.74 | 4415.51 | 4423.96 | 23935.0 |
| 2014-06-11 16:00:00 | NQ | Futures | 4424.25 | 4427.16 | 4422.79 | 4426.0 | 4812.0 |
| 2014-06-11 17:00:00 | NQ | Futures | 4426.0 | 4426.58 | 4424.83 | 4426.29 | 143.0 |
| 2014-06-11 18:00:00 | NQ | Futures | 4423.67 | 4426.0 | 4422.5 | 4425.12 | 327.0 |
| 2014-06-11 19:00:00 | NQ | Futures | 4425.41 | 4427.16 | 4425.12 | 4425.7 | 208.0 |
| 2014-06-11 20:00:00 | NQ | Futures | 4425.7 | 4426.87 | 4422.79 | 4423.08 | 453.0 |
| 2014-06-11 21:00:00 | NQ | Futures | 4423.38 | 4434.15 | 4423.08 | 4429.49 | 1817.0 |
| 2014-06-11 22:00:00 | NQ | Futures | 4429.78 | 4433.28 | 4425.41 | 4425.7 | 1726.0 |
| 2014-06-11 23:00:00 | NQ | Futures | 4426.0 | 4428.62 | 4425.41 | 4427.16 | 447.0 |
| 2014-06-11 00:00:00 | YM | Futures | 17441.8 | 17443.8 | 17441.8 | 17442.8 | 7.0 |
| 2014-06-11 01:00:00 | YM | Futures | 17442.8 | 17444.9 | 17440.7 | 17442.8 | 32.0 |
> showing 50 of 1,450 rows — these rows as CSV