PREVIEW / futures_1hour / 2014-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-09.parquet
  size:    47 KB
  rows:    1,507

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-09 00:00:00	ES	Futures	2023.88	2024.14	2023.62	2024.14	1320.0
2014-06-09 01:00:00	ES	Futures	2023.88	2024.14	2023.36	2023.36	1911.0
2014-06-09 02:00:00	ES	Futures	2023.62	2023.62	2022.84	2023.1	4789.0
2014-06-09 03:00:00	ES	Futures	2022.84	2023.1	2021.54	2021.8	11903.0
2014-06-09 04:00:00	ES	Futures	2021.8	2023.1	2021.8	2022.84	6103.0
2014-06-09 05:00:00	ES	Futures	2022.58	2023.36	2022.32	2022.84	4442.0
2014-06-09 06:00:00	ES	Futures	2022.84	2023.36	2022.32	2023.1	6234.0
2014-06-09 07:00:00	ES	Futures	2023.1	2023.1	2022.06	2023.1	7643.0
2014-06-09 08:00:00	ES	Futures	2023.1	2023.1	2021.54	2022.06	14671.0
2014-06-09 09:00:00	ES	Futures	2022.32	2026.73	2021.28	2025.18	152600.0
2014-06-09 10:00:00	ES	Futures	2025.18	2027.25	2024.14	2026.47	115262.0
2014-06-09 11:00:00	ES	Futures	2026.73	2030.37	2025.95	2029.07	115569.0
2014-06-09 12:00:00	ES	Futures	2029.07	2029.33	2026.73	2027.25	62653.0
2014-06-09 13:00:00	ES	Futures	2026.99	2027.51	2024.66	2025.18	69256.0
2014-06-09 14:00:00	ES	Futures	2025.18	2025.44	2021.02	2023.88	157582.0
2014-06-09 15:00:00	ES	Futures	2024.14	2026.21	2023.62	2025.44	130572.0
2014-06-09 16:00:00	ES	Futures	2025.18	2026.47	2024.4	2024.66	77955.0
2014-06-09 17:00:00	ES	Futures	2024.4	2025.18	2024.4	2024.92	2148.0
2014-06-09 18:00:00	ES	Futures	2024.66	2024.92	2023.88	2024.14	2639.0
2014-06-09 19:00:00	ES	Futures	2023.88	2024.92	2023.88	2024.66	1967.0
2014-06-09 20:00:00	ES	Futures	2024.92	2024.92	2024.14	2024.14	3157.0
2014-06-09 21:00:00	ES	Futures	2024.4	2024.4	2023.36	2023.62	2923.0
2014-06-09 22:00:00	ES	Futures	2023.62	2024.14	2023.36	2023.88	1500.0
2014-06-09 23:00:00	ES	Futures	2023.88	2024.4	2022.84	2023.36	1703.0
2014-06-09 00:00:00	NQ	Futures	4423.08	4423.67	4422.21	4423.38	205.0
2014-06-09 01:00:00	NQ	Futures	4423.08	4423.38	4421.63	4421.63	211.0
2014-06-09 02:00:00	NQ	Futures	4421.92	4422.79	4420.75	4421.63	474.0
2014-06-09 03:00:00	NQ	Futures	4421.63	4421.63	4417.84	4419.01	1271.0
2014-06-09 04:00:00	NQ	Futures	4419.01	4422.5	4418.72	4422.21	1281.0
2014-06-09 05:00:00	NQ	Futures	4422.5	4423.38	4421.05	4422.5	884.0
2014-06-09 06:00:00	NQ	Futures	4422.21	4423.67	4421.05	4423.38	1462.0
2014-06-09 07:00:00	NQ	Futures	4423.08	4423.38	4420.46	4421.92	1981.0
2014-06-09 08:00:00	NQ	Futures	4422.21	4422.21	4418.72	4420.75	2301.0
2014-06-09 09:00:00	NQ	Futures	4421.05	4424.83	4411.73	4417.26	29013.0
2014-06-09 10:00:00	NQ	Futures	4417.26	4422.79	4412.6	4420.75	21829.0
2014-06-09 11:00:00	NQ	Futures	4420.75	4429.78	4418.42	4427.16	16139.0
2014-06-09 12:00:00	NQ	Futures	4426.87	4430.07	4426.87	4428.03	8477.0
2014-06-09 13:00:00	NQ	Futures	4428.33	4428.91	4416.68	4417.55	13038.0
2014-06-09 14:00:00	NQ	Futures	4418.13	4418.72	4406.78	4416.39	21182.0
2014-06-09 15:00:00	NQ	Futures	4416.39	4422.21	4413.76	4418.72	21003.0
2014-06-09 16:00:00	NQ	Futures	4418.72	4422.5	4416.39	4418.13	4223.0
2014-06-09 17:00:00	NQ	Futures	4418.13	4419.3	4417.84	4419.01	80.0
2014-06-09 18:00:00	NQ	Futures	4417.84	4418.72	4416.39	4416.68	184.0
2014-06-09 19:00:00	NQ	Futures	4417.26	4418.72	4417.26	4418.13	103.0
2014-06-09 20:00:00	NQ	Futures	4418.42	4418.72	4417.26	4417.26	171.0
2014-06-09 21:00:00	NQ	Futures	4416.97	4417.55	4413.76	4414.06	827.0
2014-06-09 22:00:00	NQ	Futures	4414.35	4416.09	4413.47	4416.09	222.0
2014-06-09 23:00:00	NQ	Futures	4415.51	4416.68	4414.35	4414.35	332.0
2014-06-09 00:00:00	YM	Futures	17437.6	17439.6	17433.5	17436.6	192.0
2014-06-09 01:00:00	YM	Futures	17435.5	17435.5	17430.4	17430.4	305.0

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

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