PREVIEW / futures_1hour / 2015-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-15.parquet
  size:    52 KB
  rows:    1,579

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
2015-04-15 00:00:00	ES	Futures	2208.29	2208.55	2208.02	2208.02	705.0
2015-04-15 01:00:00	ES	Futures	2208.29	2208.29	2206.18	2206.18	3314.0
2015-04-15 02:00:00	ES	Futures	2206.44	2207.76	2205.38	2205.65	5583.0
2015-04-15 03:00:00	ES	Futures	2205.91	2208.82	2205.12	2207.5	11921.0
2015-04-15 04:00:00	ES	Futures	2207.23	2213.84	2206.97	2212.51	19127.0
2015-04-15 05:00:00	ES	Futures	2212.78	2213.31	2211.19	2212.25	9830.0
2015-04-15 06:00:00	ES	Futures	2212.25	2215.42	2211.99	2213.31	11053.0
2015-04-15 07:00:00	ES	Futures	2213.31	2214.89	2213.04	2214.63	11764.0
2015-04-15 08:00:00	ES	Futures	2214.63	2216.21	2213.84	2214.63	21172.0
2015-04-15 09:00:00	ES	Futures	2214.89	2220.97	2212.51	2218.06	191731.0
2015-04-15 10:00:00	ES	Futures	2218.06	2220.17	2215.95	2220.17	134545.0
2015-04-15 11:00:00	ES	Futures	2220.17	2220.44	2213.84	2217.53	109975.0
2015-04-15 12:00:00	ES	Futures	2217.53	2219.12	2215.68	2218.59	60710.0
2015-04-15 13:00:00	ES	Futures	2218.85	2223.61	2218.06	2222.02	101418.0
2015-04-15 14:00:00	ES	Futures	2222.02	2224.4	2220.97	2222.82	88413.0
2015-04-15 15:00:00	ES	Futures	2222.82	2223.61	2217.53	2218.06	178953.0
2015-04-15 16:00:00	ES	Futures	2218.06	2221.23	2217.8	2219.65	68622.0
2015-04-15 17:00:00	ES	Futures	2219.38	2220.7	2219.38	2220.44	989.0
2015-04-15 18:00:00	ES	Futures	2220.17	2220.97	2218.85	2219.12	2916.0
2015-04-15 19:00:00	ES	Futures	2219.12	2219.65	2218.06	2219.65	1228.0
2015-04-15 20:00:00	ES	Futures	2219.12	2219.91	2218.59	2219.38	3062.0
2015-04-15 21:00:00	ES	Futures	2219.65	2220.44	2218.06	2219.38	4421.0
2015-04-15 22:00:00	ES	Futures	2219.38	2220.97	2219.12	2220.17	2239.0
2015-04-15 23:00:00	ES	Futures	2220.17	2221.49	2219.38	2220.97	2127.0
2015-04-15 00:00:00	NQ	Futures	5170.52	5170.81	5169.05	5169.93	133.0
2015-04-15 01:00:00	NQ	Futures	5170.23	5170.23	5164.05	5164.05	408.0
2015-04-15 02:00:00	NQ	Futures	5164.05	5168.46	5163.17	5165.52	645.0
2015-04-15 03:00:00	NQ	Futures	5165.52	5170.23	5162.29	5167.87	1676.0
2015-04-15 04:00:00	NQ	Futures	5167.58	5182.58	5166.4	5180.22	2536.0
2015-04-15 05:00:00	NQ	Futures	5179.93	5182.28	5176.99	5179.93	1176.0
2015-04-15 06:00:00	NQ	Futures	5179.64	5186.69	5179.64	5182.28	2025.0
2015-04-15 07:00:00	NQ	Futures	5182.28	5185.52	5181.69	5184.93	1754.0
2015-04-15 08:00:00	NQ	Futures	5184.63	5188.16	5180.81	5184.34	3878.0
2015-04-15 09:00:00	NQ	Futures	5184.34	5190.22	5173.75	5183.75	35685.0
2015-04-15 10:00:00	NQ	Futures	5183.75	5187.87	5177.28	5187.57	21806.0
2015-04-15 11:00:00	NQ	Futures	5187.87	5189.34	5173.17	5186.4	21307.0
2015-04-15 12:00:00	NQ	Futures	5186.4	5188.46	5180.52	5187.87	10921.0
2015-04-15 13:00:00	NQ	Futures	5187.57	5201.98	5185.81	5198.75	17345.0
2015-04-15 14:00:00	NQ	Futures	5198.75	5209.63	5196.98	5206.39	19509.0
2015-04-15 15:00:00	NQ	Futures	5206.1	5208.75	5195.81	5197.28	20006.0
2015-04-15 16:00:00	NQ	Futures	5197.57	5206.98	5196.98	5203.16	6917.0
2015-04-15 17:00:00	NQ	Futures	5203.45	5206.98	5203.16	5206.98	225.0
2015-04-15 18:00:00	NQ	Futures	5206.39	5206.39	5202.28	5203.75	369.0
2015-04-15 19:00:00	NQ	Futures	5203.16	5204.34	5201.4	5203.75	140.0
2015-04-15 20:00:00	NQ	Futures	5204.04	5204.92	5202.57	5204.63	188.0
2015-04-15 21:00:00	NQ	Futures	5204.63	5206.39	5201.69	5204.63	475.0
2015-04-15 22:00:00	NQ	Futures	5204.34	5208.45	5204.34	5206.39	264.0
2015-04-15 23:00:00	NQ	Futures	5206.69	5209.63	5205.51	5208.75	245.0
2015-04-15 00:00:00	YM	Futures	18830.9	18833.0	18827.8	18829.9	122.0
2015-04-15 01:00:00	YM	Futures	18828.8	18832.0	18813.1	18814.1	508.0

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

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