PREVIEW / futures_1hour / 2016-02-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-16.parquet
  size:    53 KB
  rows:    1,581

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
2016-02-16 00:00:00	ES	Futures	2034.13	2034.4	2031.44	2031.71	5859.0
2016-02-16 01:00:00	ES	Futures	2031.44	2032.25	2030.37	2031.44	4264.0
2016-02-16 02:00:00	ES	Futures	2031.44	2032.52	2028.75	2032.52	16422.0
2016-02-16 03:00:00	ES	Futures	2032.25	2032.78	2027.68	2031.44	37409.0
2016-02-16 04:00:00	ES	Futures	2031.44	2031.44	2020.96	2022.84	45193.0
2016-02-16 05:00:00	ES	Futures	2023.11	2023.92	2018.27	2020.42	31621.0
2016-02-16 06:00:00	ES	Futures	2020.69	2025.53	2018.81	2024.99	21220.0
2016-02-16 07:00:00	ES	Futures	2024.99	2026.6	2022.3	2022.3	23690.0
2016-02-16 08:00:00	ES	Futures	2022.3	2022.57	2015.86	2019.08	58582.0
2016-02-16 09:00:00	ES	Futures	2019.08	2025.53	2015.86	2017.47	233695.0
2016-02-16 10:00:00	ES	Futures	2017.74	2020.96	2012.63	2015.05	218057.0
2016-02-16 11:00:00	ES	Futures	2014.78	2024.45	2010.21	2024.19	178249.0
2016-02-16 12:00:00	ES	Futures	2024.19	2030.37	2023.38	2029.83	133098.0
2016-02-16 13:00:00	ES	Futures	2029.83	2033.05	2028.22	2030.1	117906.0
2016-02-16 14:00:00	ES	Futures	2029.83	2033.59	2029.02	2029.83	130122.0
2016-02-16 15:00:00	ES	Futures	2029.56	2033.59	2026.87	2033.32	250987.0
2016-02-16 16:00:00	ES	Futures	2033.05	2034.13	2028.22	2030.37	75618.0
2016-02-16 18:00:00	ES	Futures	2029.56	2030.63	2026.87	2030.37	5572.0
2016-02-16 19:00:00	ES	Futures	2030.63	2039.5	2030.37	2037.89	16999.0
2016-02-16 20:00:00	ES	Futures	2038.16	2038.43	2032.78	2036.28	14526.0
2016-02-16 21:00:00	ES	Futures	2036.01	2036.81	2032.52	2033.32	7553.0
2016-02-16 22:00:00	ES	Futures	2033.32	2033.32	2027.41	2027.41	11446.0
2016-02-16 23:00:00	ES	Futures	2027.68	2029.02	2023.92	2025.53	12525.0
2016-02-16 00:00:00	NQ	Futures	4871.16	4872.64	4862.84	4863.44	1255.0
2016-02-16 01:00:00	NQ	Futures	4863.74	4865.81	4859.88	4863.44	1069.0
2016-02-16 02:00:00	NQ	Futures	4863.74	4869.97	4856.02	4869.97	3014.0
2016-02-16 03:00:00	NQ	Futures	4869.67	4871.46	4855.72	4867.3	5547.0
2016-02-16 04:00:00	NQ	Futures	4866.7	4866.7	4836.12	4839.98	7489.0
2016-02-16 05:00:00	NQ	Futures	4840.28	4842.06	4827.21	4833.15	3973.0
2016-02-16 06:00:00	NQ	Futures	4833.15	4845.33	4829.29	4844.14	2288.0
2016-02-16 07:00:00	NQ	Futures	4844.43	4847.4	4834.34	4835.53	3333.0
2016-02-16 08:00:00	NQ	Futures	4835.23	4836.42	4819.49	4828.4	7080.0
2016-02-16 09:00:00	NQ	Futures	4828.4	4861.36	4825.43	4841.76	42380.0
2016-02-16 10:00:00	NQ	Futures	4841.47	4848.89	4821.87	4825.13	40506.0
2016-02-16 11:00:00	NQ	Futures	4824.54	4845.33	4806.72	4843.25	28854.0
2016-02-16 12:00:00	NQ	Futures	4843.84	4858.09	4838.5	4855.72	22825.0
2016-02-16 13:00:00	NQ	Futures	4855.72	4864.63	4852.16	4858.69	14895.0
2016-02-16 14:00:00	NQ	Futures	4858.69	4869.08	4855.72	4859.28	19203.0
2016-02-16 15:00:00	NQ	Futures	4859.58	4870.56	4850.67	4870.27	39396.0
2016-02-16 16:00:00	NQ	Futures	4870.27	4875.32	4854.83	4859.58	9427.0
2016-02-16 18:00:00	NQ	Futures	4857.5	4860.77	4851.86	4858.98	1223.0
2016-02-16 19:00:00	NQ	Futures	4859.28	4880.36	4858.98	4877.99	2302.0
2016-02-16 20:00:00	NQ	Futures	4878.29	4879.18	4864.33	4872.64	1783.0
2016-02-16 21:00:00	NQ	Futures	4872.64	4874.72	4864.63	4865.52	601.0
2016-02-16 22:00:00	NQ	Futures	4865.22	4865.81	4849.78	4849.78	1518.0
2016-02-16 23:00:00	NQ	Futures	4850.08	4853.05	4841.17	4843.25	1794.0
2016-02-16 00:00:00	YM	Futures	17239.2	17245.6	17217.9	17220.1	1141.0
2016-02-16 01:00:00	YM	Futures	17220.1	17227.5	17213.7	17220.1	852.0
2016-02-16 02:00:00	YM	Futures	17220.1	17233.9	17199.8	17232.8	1861.0
2016-02-16 03:00:00	YM	Futures	17231.8	17232.8	17194.5	17225.4	6264.0

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

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