PREVIEW / futures_1hour / 2014-10-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	2018.72	2019.24	2015.84	2017.15	1918.0
2014-10-23 01:00:00	ES	Futures	2017.15	2018.98	2016.1	2018.98	2817.0
2014-10-23 02:00:00	ES	Futures	2018.98	2020.82	2017.67	2020.55	8983.0
2014-10-23 03:00:00	ES	Futures	2020.55	2024.22	2014.53	2022.91	53430.0
2014-10-23 04:00:00	ES	Futures	2022.91	2031.82	2022.91	2027.63	50192.0
2014-10-23 05:00:00	ES	Futures	2027.89	2029.2	2026.58	2027.63	15120.0
2014-10-23 06:00:00	ES	Futures	2027.37	2028.15	2020.82	2021.86	29260.0
2014-10-23 07:00:00	ES	Futures	2021.86	2031.56	2021.34	2031.03	40625.0
2014-10-23 08:00:00	ES	Futures	2031.3	2034.44	2029.46	2033.39	71438.0
2014-10-23 09:00:00	ES	Futures	2033.39	2036.01	2029.72	2031.56	218378.0
2014-10-23 10:00:00	ES	Futures	2031.82	2042.56	2031.3	2042.3	313290.0
2014-10-23 11:00:00	ES	Futures	2042.56	2045.44	2039.15	2040.73	217623.0
2014-10-23 12:00:00	ES	Futures	2040.46	2043.61	2038.63	2039.68	113547.0
2014-10-23 13:00:00	ES	Futures	2039.42	2044.92	2039.15	2043.35	93908.0
2014-10-23 14:00:00	ES	Futures	2043.61	2049.89	2037.06	2042.04	254615.0
2014-10-23 15:00:00	ES	Futures	2042.04	2042.82	2034.44	2036.8	417245.0
2014-10-23 16:00:00	ES	Futures	2037.06	2039.68	2036.27	2039.42	79028.0
2014-10-23 17:00:00	ES	Futures	2039.42	2039.94	2039.42	2039.42	2282.0
2014-10-23 18:00:00	ES	Futures	2039.15	2040.46	2038.11	2038.63	5851.0
2014-10-23 19:00:00	ES	Futures	2038.63	2039.94	2038.11	2039.94	2291.0
2014-10-23 20:00:00	ES	Futures	2039.94	2039.94	2024.22	2026.06	39780.0
2014-10-23 21:00:00	ES	Futures	2026.06	2032.87	2024.22	2032.87	25148.0
2014-10-23 22:00:00	ES	Futures	2032.87	2033.13	2026.84	2029.99	12101.0
2014-10-23 23:00:00	ES	Futures	2030.25	2032.08	2029.2	2029.99	3734.0
2014-10-23 00:00:00	NQ	Futures	4628.61	4628.9	4621.87	4624.8	412.0
2014-10-23 01:00:00	NQ	Futures	4625.1	4630.37	4622.46	4630.37	456.0
2014-10-23 02:00:00	NQ	Futures	4630.37	4635.64	4627.73	4635.06	975.0
2014-10-23 03:00:00	NQ	Futures	4635.35	4643.26	4620.7	4641.8	8097.0
2014-10-23 04:00:00	NQ	Futures	4641.21	4658.2	4641.21	4650.59	9122.0
2014-10-23 05:00:00	NQ	Futures	4650.88	4653.52	4648.24	4650.59	2009.0
2014-10-23 06:00:00	NQ	Futures	4650.88	4651.76	4637.11	4640.33	3890.0
2014-10-23 07:00:00	NQ	Futures	4640.33	4662.01	4639.75	4661.13	6148.0
2014-10-23 08:00:00	NQ	Futures	4661.13	4671.39	4657.33	4665.82	13480.0
2014-10-23 09:00:00	NQ	Futures	4665.53	4675.2	4658.5	4671.39	46683.0
2014-10-23 10:00:00	NQ	Futures	4671.98	4698.05	4670.22	4696.88	54666.0
2014-10-23 11:00:00	NQ	Futures	4697.17	4701.57	4691.02	4696.3	33836.0
2014-10-23 12:00:00	NQ	Futures	4696.3	4705.38	4692.19	4694.83	21110.0
2014-10-23 13:00:00	NQ	Futures	4695.12	4707.43	4694.24	4705.09	17779.0
2014-10-23 14:00:00	NQ	Futures	4705.09	4717.1	4690.14	4699.81	38411.0
2014-10-23 15:00:00	NQ	Futures	4699.81	4700.98	4685.16	4691.31	71254.0
2014-10-23 16:00:00	NQ	Futures	4691.61	4698.35	4683.99	4693.66	13681.0
2014-10-23 17:00:00	NQ	Futures	4693.95	4694.83	4691.02	4691.02	608.0
2014-10-23 18:00:00	NQ	Futures	4683.11	4691.02	4681.65	4686.33	1688.0
2014-10-23 19:00:00	NQ	Futures	4686.04	4688.97	4683.7	4688.38	544.0
2014-10-23 20:00:00	NQ	Futures	4688.38	4688.68	4653.52	4657.91	7517.0
2014-10-23 21:00:00	NQ	Futures	4658.2	4671.98	4655.57	4671.68	4672.0
2014-10-23 22:00:00	NQ	Futures	4671.98	4673.44	4661.72	4669.63	2051.0
2014-10-23 23:00:00	NQ	Futures	4669.93	4673.73	4667.58	4669.93	568.0
2014-10-23 00:00:00	YM	Futures	17097.9	17097.9	17072.9	17082.3	314.0
2014-10-23 01:00:00	YM	Futures	17082.3	17097.9	17076.0	17095.8	546.0

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

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