PREVIEW / futures_1hour / 2014-06-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	2032.27	2033.31	2032.27	2033.05	2356.0
2014-06-26 01:00:00	ES	Futures	2032.79	2033.57	2032.79	2032.79	4298.0
2014-06-26 02:00:00	ES	Futures	2032.79	2033.57	2032.27	2032.27	4897.0
2014-06-26 03:00:00	ES	Futures	2032.27	2032.53	2030.96	2032.01	16959.0
2014-06-26 04:00:00	ES	Futures	2032.01	2032.01	2029.92	2030.96	16176.0
2014-06-26 05:00:00	ES	Futures	2030.96	2032.27	2030.18	2032.01	8118.0
2014-06-26 06:00:00	ES	Futures	2032.01	2032.27	2029.66	2030.44	14037.0
2014-06-26 07:00:00	ES	Futures	2030.44	2032.27	2030.18	2032.27	9109.0
2014-06-26 08:00:00	ES	Futures	2032.27	2033.57	2031.23	2032.01	40351.0
2014-06-26 09:00:00	ES	Futures	2032.01	2035.4	2018.46	2021.84	404187.0
2014-06-26 10:00:00	ES	Futures	2021.58	2026.01	2020.8	2023.93	335465.0
2014-06-26 11:00:00	ES	Futures	2024.19	2027.32	2022.89	2026.27	162152.0
2014-06-26 12:00:00	ES	Futures	2026.53	2027.06	2024.45	2024.45	72072.0
2014-06-26 13:00:00	ES	Futures	2024.71	2031.49	2024.45	2030.18	115849.0
2014-06-26 14:00:00	ES	Futures	2029.92	2031.23	2028.62	2029.66	67951.0
2014-06-26 15:00:00	ES	Futures	2029.92	2032.79	2029.66	2032.27	132895.0
2014-06-26 16:00:00	ES	Futures	2032.27	2032.79	2030.96	2031.75	58223.0
2014-06-26 17:00:00	ES	Futures	2031.75	2032.01	2030.96	2031.23	1703.0
2014-06-26 18:00:00	ES	Futures	2030.96	2032.01	2030.44	2032.01	2662.0
2014-06-26 19:00:00	ES	Futures	2032.01	2032.01	2031.23	2031.49	626.0
2014-06-26 20:00:00	ES	Futures	2031.23	2031.23	2030.18	2030.96	3369.0
2014-06-26 21:00:00	ES	Futures	2030.96	2032.79	2030.7	2032.01	4867.0
2014-06-26 22:00:00	ES	Futures	2032.01	2032.01	2028.88	2029.4	4558.0
2014-06-26 23:00:00	ES	Futures	2029.4	2029.4	2026.01	2026.01	10630.0
2014-06-26 00:00:00	NQ	Futures	4456.73	4458.48	4456.73	4458.48	306.0
2014-06-26 01:00:00	NQ	Futures	4458.19	4459.65	4458.19	4458.48	419.0
2014-06-26 02:00:00	NQ	Futures	4458.77	4459.94	4457.02	4457.6	565.0
2014-06-26 03:00:00	NQ	Futures	4457.6	4458.48	4454.68	4458.19	2303.0
2014-06-26 04:00:00	NQ	Futures	4457.9	4457.9	4452.93	4454.98	2566.0
2014-06-26 05:00:00	NQ	Futures	4454.98	4458.48	4454.39	4457.9	1207.0
2014-06-26 06:00:00	NQ	Futures	4457.9	4459.06	4454.1	4456.14	1585.0
2014-06-26 07:00:00	NQ	Futures	4455.85	4459.36	4454.98	4458.77	1695.0
2014-06-26 08:00:00	NQ	Futures	4458.77	4460.82	4456.73	4458.77	4360.0
2014-06-26 09:00:00	NQ	Futures	4458.48	4464.32	4425.77	4436.29	69665.0
2014-06-26 10:00:00	NQ	Futures	4436.29	4443.3	4430.45	4438.33	54858.0
2014-06-26 11:00:00	NQ	Futures	4438.62	4446.51	4436.87	4444.46	28501.0
2014-06-26 12:00:00	NQ	Futures	4444.76	4445.34	4438.04	4439.21	12000.0
2014-06-26 13:00:00	NQ	Futures	4439.21	4454.1	4439.21	4451.47	18547.0
2014-06-26 14:00:00	NQ	Futures	4451.76	4454.98	4447.38	4452.35	11240.0
2014-06-26 15:00:00	NQ	Futures	4452.35	4461.4	4451.47	4460.82	21149.0
2014-06-26 16:00:00	NQ	Futures	4460.82	4461.98	4458.77	4460.52	6125.0
2014-06-26 17:00:00	NQ	Futures	4460.23	4461.11	4458.77	4459.36	189.0
2014-06-26 18:00:00	NQ	Futures	4458.48	4460.52	4457.9	4460.23	277.0
2014-06-26 19:00:00	NQ	Futures	4460.23	4460.82	4459.06	4459.36	132.0
2014-06-26 20:00:00	NQ	Futures	4459.06	4459.36	4457.31	4458.48	374.0
2014-06-26 21:00:00	NQ	Futures	4458.19	4461.98	4457.9	4460.52	676.0
2014-06-26 22:00:00	NQ	Futures	4460.23	4460.23	4455.85	4456.14	1011.0
2014-06-26 23:00:00	NQ	Futures	4456.14	4456.44	4449.14	4449.43	1571.0
2014-06-26 00:00:00	YM	Futures	17359.0	17363.1	17359.0	17363.1	185.0
2014-06-26 01:00:00	YM	Futures	17363.1	17366.3	17360.0	17362.1	529.0

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

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