PREVIEW / futures_1hour / 2014-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-10.parquet
  size:    45 KB
  rows:    1,434

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-10 00:00:00	ES	Futures	2023.36	2023.62	2021.8	2022.06	4324.0
2014-06-10 01:00:00	ES	Futures	2022.32	2023.1	2021.8	2022.58	5111.0
2014-06-10 02:00:00	ES	Futures	2022.32	2022.58	2021.28	2022.32	5178.0
2014-06-10 03:00:00	ES	Futures	2022.32	2022.84	2019.98	2020.5	18810.0
2014-06-10 04:00:00	ES	Futures	2020.76	2022.84	2020.5	2022.06	17426.0
2014-06-10 05:00:00	ES	Futures	2022.32	2022.58	2021.28	2021.28	7043.0
2014-06-10 06:00:00	ES	Futures	2021.54	2022.84	2021.02	2022.58	10153.0
2014-06-10 07:00:00	ES	Futures	2022.84	2023.1	2020.5	2021.28	17208.0
2014-06-10 08:00:00	ES	Futures	2021.02	2021.8	2020.76	2021.02	16353.0
2014-06-10 09:00:00	ES	Futures	2021.02	2024.14	2021.02	2021.54	145440.0
2014-06-10 10:00:00	ES	Futures	2021.8	2024.4	2018.16	2023.88	171789.0
2014-06-10 11:00:00	ES	Futures	2023.88	2024.14	2022.32	2022.58	80513.0
2014-06-10 12:00:00	ES	Futures	2022.58	2022.84	2020.5	2022.32	70167.0
2014-06-10 13:00:00	ES	Futures	2022.06	2023.62	2020.5	2023.1	56083.0
2014-06-10 14:00:00	ES	Futures	2023.36	2024.4	2022.32	2022.84	66446.0
2014-06-10 15:00:00	ES	Futures	2022.58	2025.69	2022.58	2025.44	113798.0
2014-06-10 16:00:00	ES	Futures	2025.69	2026.99	2025.18	2026.99	79952.0
2014-06-10 17:00:00	ES	Futures	2026.73	2027.25	2026.47	2026.99	1502.0
2014-06-10 18:00:00	ES	Futures	2026.21	2026.47	2024.66	2024.92	4451.0
2014-06-10 19:00:00	ES	Futures	2025.18	2025.18	2024.4	2024.66	821.0
2014-06-10 20:00:00	ES	Futures	2024.66	2024.92	2024.14	2024.66	2270.0
2014-06-10 21:00:00	ES	Futures	2024.4	2024.92	2024.4	2024.66	1201.0
2014-06-10 22:00:00	ES	Futures	2024.4	2024.66	2024.4	2024.4	864.0
2014-06-10 23:00:00	ES	Futures	2024.66	2024.92	2024.4	2024.66	1249.0
2014-06-10 00:00:00	NQ	Futures	4414.64	4415.51	4412.02	4412.89	384.0
2014-06-10 01:00:00	NQ	Futures	4412.6	4414.64	4412.02	4413.18	386.0
2014-06-10 02:00:00	NQ	Futures	4413.76	4414.06	4411.73	4413.47	523.0
2014-06-10 03:00:00	NQ	Futures	4413.76	4414.64	4408.81	4410.27	2226.0
2014-06-10 04:00:00	NQ	Futures	4409.98	4414.35	4409.69	4411.73	2325.0
2014-06-10 05:00:00	NQ	Futures	4411.73	4413.18	4410.56	4411.44	824.0
2014-06-10 06:00:00	NQ	Futures	4411.14	4414.93	4410.56	4414.64	928.0
2014-06-10 07:00:00	NQ	Futures	4414.93	4415.51	4409.98	4410.27	2077.0
2014-06-10 08:00:00	NQ	Futures	4409.98	4412.6	4408.81	4410.27	2972.0
2014-06-10 09:00:00	NQ	Futures	4410.27	4426.58	4410.27	4417.84	35513.0
2014-06-10 10:00:00	NQ	Futures	4417.84	4427.74	4410.27	4425.41	34633.0
2014-06-10 11:00:00	NQ	Futures	4425.7	4429.2	4421.05	4424.54	15378.0
2014-06-10 12:00:00	NQ	Futures	4424.25	4424.54	4415.22	4419.88	11427.0
2014-06-10 13:00:00	NQ	Futures	4419.88	4425.41	4416.09	4423.96	9623.0
2014-06-10 14:00:00	NQ	Futures	4423.96	4426.87	4421.34	4422.5	8509.0
2014-06-10 15:00:00	NQ	Futures	4422.5	4427.16	4422.21	4425.7	14839.0
2014-06-10 16:00:00	NQ	Futures	4425.7	4429.78	4425.41	4429.49	5130.0
2014-06-10 17:00:00	NQ	Futures	4429.49	4430.07	4428.62	4428.91	374.0
2014-06-10 18:00:00	NQ	Futures	4428.91	4428.91	4424.25	4425.12	551.0
2014-06-10 19:00:00	NQ	Futures	4425.12	4425.12	4423.96	4423.96	282.0
2014-06-10 20:00:00	NQ	Futures	4424.25	4425.7	4423.67	4424.25	361.0
2014-06-10 21:00:00	NQ	Futures	4424.54	4425.12	4423.08	4423.38	270.0
2014-06-10 22:00:00	NQ	Futures	4423.96	4424.25	4423.08	4423.38	120.0
2014-06-10 23:00:00	NQ	Futures	4423.38	4424.54	4423.38	4424.25	105.0
2014-06-10 00:00:00	YM	Futures	17426.3	17426.3	17423.2	17423.2	4.0
2014-06-10 01:00:00	YM	Futures	17421.1	17429.4	17421.1	17424.2	16.0

> showing 50 of 1,434 rows — these rows as CSV

> unlock the full archive -- $79 one-time