PREVIEW / futures_1hour / 2014-10-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-08.parquet
  size:    53 KB
  rows:    1,618

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-10-08 00:00:00	ES	Futures	2023.44	2023.96	2022.65	2023.96	2848.0
2014-10-08 01:00:00	ES	Futures	2023.96	2025.01	2021.6	2021.6	5503.0
2014-10-08 02:00:00	ES	Futures	2021.86	2023.96	2021.34	2023.7	10683.0
2014-10-08 03:00:00	ES	Futures	2023.96	2025.53	2021.6	2022.39	36968.0
2014-10-08 04:00:00	ES	Futures	2022.39	2023.7	2018.98	2020.29	24180.0
2014-10-08 05:00:00	ES	Futures	2020.29	2020.55	2018.2	2019.51	23599.0
2014-10-08 06:00:00	ES	Futures	2019.51	2024.22	2019.51	2024.22	21993.0
2014-10-08 07:00:00	ES	Futures	2024.22	2026.58	2023.17	2024.75	34120.0
2014-10-08 08:00:00	ES	Futures	2024.75	2026.06	2020.29	2021.34	45221.0
2014-10-08 09:00:00	ES	Futures	2021.34	2026.32	2018.2	2019.24	250520.0
2014-10-08 10:00:00	ES	Futures	2019.24	2024.48	2011.91	2012.43	394942.0
2014-10-08 11:00:00	ES	Futures	2012.43	2022.65	2009.81	2021.86	344417.0
2014-10-08 12:00:00	ES	Futures	2022.13	2024.75	2019.24	2021.34	134770.0
2014-10-08 13:00:00	ES	Futures	2021.34	2030.25	2020.82	2029.2	135932.0
2014-10-08 14:00:00	ES	Futures	2029.2	2049.11	2028.94	2044.39	485569.0
2014-10-08 15:00:00	ES	Futures	2044.39	2058.02	2044.13	2054.87	382977.0
2014-10-08 16:00:00	ES	Futures	2055.13	2057.49	2053.82	2056.97	139606.0
2014-10-08 17:00:00	ES	Futures	2056.71	2056.97	2055.66	2055.66	1458.0
2014-10-08 18:00:00	ES	Futures	2055.4	2055.4	2053.56	2055.4	6880.0
2014-10-08 19:00:00	ES	Futures	2055.13	2055.66	2053.3	2053.56	4829.0
2014-10-08 20:00:00	ES	Futures	2053.56	2056.44	2053.04	2056.44	7031.0
2014-10-08 21:00:00	ES	Futures	2056.18	2060.37	2055.4	2058.8	8791.0
2014-10-08 22:00:00	ES	Futures	2058.8	2060.11	2056.18	2058.28	5968.0
2014-10-08 23:00:00	ES	Futures	2058.28	2059.33	2057.49	2058.02	3238.0
2014-10-08 00:00:00	NQ	Futures	4642.97	4645.31	4640.92	4645.31	511.0
2014-10-08 01:00:00	NQ	Futures	4645.31	4647.07	4638.57	4639.45	774.0
2014-10-08 02:00:00	NQ	Futures	4639.16	4643.85	4638.87	4642.68	1462.0
2014-10-08 03:00:00	NQ	Futures	4642.68	4646.48	4637.69	4639.16	6043.0
2014-10-08 04:00:00	NQ	Futures	4639.45	4642.97	4631.83	4635.64	3774.0
2014-10-08 05:00:00	NQ	Futures	4635.35	4635.94	4629.2	4632.42	4301.0
2014-10-08 06:00:00	NQ	Futures	4632.42	4645.61	4632.42	4645.31	3443.0
2014-10-08 07:00:00	NQ	Futures	4645.31	4648.54	4640.62	4644.43	6095.0
2014-10-08 08:00:00	NQ	Futures	4644.43	4647.66	4634.76	4637.4	7533.0
2014-10-08 09:00:00	NQ	Futures	4637.4	4647.95	4625.1	4626.56	47723.0
2014-10-08 10:00:00	NQ	Futures	4626.56	4643.26	4612.2	4613.67	76200.0
2014-10-08 11:00:00	NQ	Futures	4613.67	4644.14	4606.93	4643.26	58096.0
2014-10-08 12:00:00	NQ	Futures	4643.55	4649.41	4637.99	4644.14	25600.0
2014-10-08 13:00:00	NQ	Futures	4644.14	4663.77	4642.09	4663.19	25921.0
2014-10-08 14:00:00	NQ	Futures	4662.6	4712.41	4662.31	4707.72	104781.0
2014-10-08 15:00:00	NQ	Futures	4707.72	4737.02	4707.14	4724.42	73405.0
2014-10-08 16:00:00	NQ	Futures	4724.42	4728.53	4720.03	4727.35	15199.0
2014-10-08 17:00:00	NQ	Futures	4727.35	4727.94	4724.42	4724.42	144.0
2014-10-08 18:00:00	NQ	Futures	4722.08	4725.01	4719.74	4725.01	1237.0
2014-10-08 19:00:00	NQ	Futures	4724.42	4725.01	4720.91	4721.2	411.0
2014-10-08 20:00:00	NQ	Futures	4720.91	4729.11	4720.32	4729.11	1009.0
2014-10-08 21:00:00	NQ	Futures	4728.53	4740.25	4727.06	4735.56	1807.0
2014-10-08 22:00:00	NQ	Futures	4735.27	4738.78	4729.99	4734.68	1073.0
2014-10-08 23:00:00	NQ	Futures	4734.97	4738.2	4732.92	4735.56	576.0
2014-10-08 00:00:00	YM	Futures	17332.9	17339.1	17327.7	17339.1	445.0
2014-10-08 01:00:00	YM	Futures	17338.1	17346.4	17319.3	17322.5	893.0

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

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