PREVIEW / futures_1hour / 2014-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-25.parquet
  size:    48 KB
  rows:    1,528

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-25 00:00:00	ES	Futures	2022.89	2023.41	2022.63	2022.89	1549.0
2014-06-25 01:00:00	ES	Futures	2023.15	2023.67	2022.89	2023.15	2225.0
2014-06-25 02:00:00	ES	Futures	2023.15	2025.75	2022.63	2025.75	9916.0
2014-06-25 03:00:00	ES	Futures	2025.75	2026.01	2023.67	2024.97	22597.0
2014-06-25 04:00:00	ES	Futures	2025.23	2027.32	2024.97	2026.53	18939.0
2014-06-25 05:00:00	ES	Futures	2026.53	2027.32	2025.49	2025.75	9836.0
2014-06-25 06:00:00	ES	Futures	2025.75	2028.36	2025.49	2027.84	12448.0
2014-06-25 07:00:00	ES	Futures	2028.1	2028.36	2025.75	2026.27	15238.0
2014-06-25 08:00:00	ES	Futures	2026.27	2026.53	2019.76	2022.89	96657.0
2014-06-25 09:00:00	ES	Futures	2022.63	2028.88	2019.5	2026.79	297668.0
2014-06-25 10:00:00	ES	Futures	2026.79	2031.49	2024.19	2030.96	273672.0
2014-06-25 11:00:00	ES	Futures	2030.96	2031.75	2027.32	2028.62	183231.0
2014-06-25 12:00:00	ES	Futures	2028.88	2029.92	2028.1	2028.88	73128.0
2014-06-25 13:00:00	ES	Futures	2028.88	2033.31	2028.88	2032.79	106961.0
2014-06-25 14:00:00	ES	Futures	2032.53	2033.83	2031.49	2031.75	99166.0
2014-06-25 15:00:00	ES	Futures	2031.75	2036.18	2030.96	2033.57	195999.0
2014-06-25 16:00:00	ES	Futures	2033.57	2034.09	2031.23	2031.75	86231.0
2014-06-25 17:00:00	ES	Futures	2031.49	2032.01	2031.23	2031.49	1385.0
2014-06-25 18:00:00	ES	Futures	2031.49	2032.79	2030.7	2032.27	4708.0
2014-06-25 19:00:00	ES	Futures	2032.53	2032.53	2031.75	2032.27	1276.0
2014-06-25 20:00:00	ES	Futures	2032.27	2032.53	2030.44	2030.44	4845.0
2014-06-25 21:00:00	ES	Futures	2030.44	2032.79	2030.44	2032.53	4824.0
2014-06-25 22:00:00	ES	Futures	2032.27	2033.05	2032.01	2032.79	2501.0
2014-06-25 23:00:00	ES	Futures	2032.53	2033.05	2032.27	2032.27	843.0
2014-06-25 00:00:00	NQ	Futures	4423.15	4424.31	4422.27	4422.27	477.0
2014-06-25 01:00:00	NQ	Futures	4422.27	4423.15	4421.69	4422.27	586.0
2014-06-25 02:00:00	NQ	Futures	4422.56	4430.74	4421.98	4429.28	1537.0
2014-06-25 03:00:00	NQ	Futures	4429.28	4429.86	4424.61	4427.82	2459.0
2014-06-25 04:00:00	NQ	Futures	4427.82	4433.37	4427.23	4431.03	2609.0
2014-06-25 05:00:00	NQ	Futures	4431.32	4433.07	4428.99	4429.57	1106.0
2014-06-25 06:00:00	NQ	Futures	4429.57	4433.37	4428.11	4433.07	1858.0
2014-06-25 07:00:00	NQ	Futures	4433.07	4433.66	4428.69	4430.45	2463.0
2014-06-25 08:00:00	NQ	Futures	4430.74	4431.03	4418.77	4425.19	12226.0
2014-06-25 09:00:00	NQ	Futures	4425.48	4440.67	4418.77	4431.32	48144.0
2014-06-25 10:00:00	NQ	Futures	4431.32	4441.54	4424.9	4440.08	53685.0
2014-06-25 11:00:00	NQ	Futures	4440.38	4448.55	4436.58	4440.38	33487.0
2014-06-25 12:00:00	NQ	Futures	4440.08	4445.05	4438.92	4443.3	11807.0
2014-06-25 13:00:00	NQ	Futures	4443.3	4456.73	4443.3	4455.27	18021.0
2014-06-25 14:00:00	NQ	Futures	4455.27	4459.06	4451.76	4454.68	18825.0
2014-06-25 15:00:00	NQ	Futures	4454.68	4466.07	4453.52	4458.77	29505.0
2014-06-25 16:00:00	NQ	Futures	4459.06	4459.94	4454.68	4455.27	5832.0
2014-06-25 17:00:00	NQ	Futures	4454.98	4455.27	4453.22	4454.68	477.0
2014-06-25 18:00:00	NQ	Futures	4453.52	4456.14	4452.64	4455.85	415.0
2014-06-25 19:00:00	NQ	Futures	4455.85	4456.14	4454.98	4455.85	183.0
2014-06-25 20:00:00	NQ	Futures	4455.85	4456.73	4453.22	4453.22	601.0
2014-06-25 21:00:00	NQ	Futures	4453.52	4457.31	4452.93	4456.73	429.0
2014-06-25 22:00:00	NQ	Futures	4456.73	4457.6	4455.85	4457.31	344.0
2014-06-25 23:00:00	NQ	Futures	4457.6	4457.6	4456.44	4457.02	120.0
2014-06-25 00:00:00	YM	Futures	17304.2	17308.3	17303.1	17306.3	312.0
2014-06-25 01:00:00	YM	Futures	17306.3	17310.4	17305.2	17307.3	425.0

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

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