PREVIEW / futures_1hour / 2015-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-23.parquet
  size:    49 KB
  rows:    1,518

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-02-23 00:00:00	ES	Futures	2217.32	2217.32	2216.79	2217.05	1101.0
2015-02-23 01:00:00	ES	Futures	2217.32	2217.58	2216.79	2217.32	1141.0
2015-02-23 02:00:00	ES	Futures	2217.05	2217.32	2215.48	2216.0	5785.0
2015-02-23 03:00:00	ES	Futures	2216.0	2216.53	2213.63	2214.42	15513.0
2015-02-23 04:00:00	ES	Futures	2214.16	2214.42	2212.58	2213.37	13445.0
2015-02-23 05:00:00	ES	Futures	2213.37	2213.9	2212.84	2213.63	5703.0
2015-02-23 06:00:00	ES	Futures	2213.37	2213.63	2211.79	2213.63	7403.0
2015-02-23 07:00:00	ES	Futures	2213.37	2214.95	2212.32	2214.16	12728.0
2015-02-23 08:00:00	ES	Futures	2214.16	2214.95	2213.11	2213.9	12898.0
2015-02-23 09:00:00	ES	Futures	2213.9	2216.0	2210.21	2213.11	138698.0
2015-02-23 10:00:00	ES	Futures	2213.37	2215.21	2210.48	2214.42	134255.0
2015-02-23 11:00:00	ES	Futures	2214.69	2217.05	2214.16	2216.26	83058.0
2015-02-23 12:00:00	ES	Futures	2216.26	2216.53	2212.05	2213.63	74370.0
2015-02-23 13:00:00	ES	Futures	2213.9	2216.79	2212.84	2214.95	59953.0
2015-02-23 14:00:00	ES	Futures	2214.95	2216.26	2212.32	2213.37	67232.0
2015-02-23 15:00:00	ES	Futures	2213.11	2218.11	2210.74	2217.84	134150.0
2015-02-23 16:00:00	ES	Futures	2218.11	2219.16	2217.05	2217.58	56019.0
2015-02-23 17:00:00	ES	Futures	2217.58	2217.84	2217.05	2217.05	1336.0
2015-02-23 18:00:00	ES	Futures	2217.05	2217.58	2216.26	2216.53	3962.0
2015-02-23 19:00:00	ES	Futures	2216.79	2217.32	2216.26	2217.05	2827.0
2015-02-23 20:00:00	ES	Futures	2217.05	2217.58	2216.53	2217.05	2157.0
2015-02-23 21:00:00	ES	Futures	2217.05	2217.58	2216.53	2216.53	1914.0
2015-02-23 22:00:00	ES	Futures	2216.79	2217.58	2216.53	2217.32	1703.0
2015-02-23 23:00:00	ES	Futures	2217.32	2218.11	2217.05	2218.11	3503.0
2015-02-23 00:00:00	NQ	Futures	5216.79	5217.67	5216.2	5217.37	127.0
2015-02-23 01:00:00	NQ	Futures	5217.37	5218.26	5216.49	5217.37	268.0
2015-02-23 02:00:00	NQ	Futures	5217.67	5217.67	5214.44	5214.73	504.0
2015-02-23 03:00:00	NQ	Futures	5215.02	5216.2	5210.33	5212.97	2671.0
2015-02-23 04:00:00	NQ	Futures	5212.97	5214.14	5209.15	5211.79	2078.0
2015-02-23 05:00:00	NQ	Futures	5211.79	5213.56	5211.21	5212.68	752.0
2015-02-23 06:00:00	NQ	Futures	5212.68	5214.14	5210.33	5213.85	1299.0
2015-02-23 07:00:00	NQ	Futures	5213.85	5217.67	5211.5	5215.61	2479.0
2015-02-23 08:00:00	NQ	Futures	5215.32	5216.49	5212.97	5214.44	2670.0
2015-02-23 09:00:00	NQ	Futures	5214.44	5220.31	5209.15	5215.61	23552.0
2015-02-23 10:00:00	NQ	Futures	5215.91	5217.67	5203.86	5212.09	24815.0
2015-02-23 11:00:00	NQ	Futures	5212.09	5219.43	5211.5	5217.08	11983.0
2015-02-23 12:00:00	NQ	Futures	5217.37	5220.31	5210.62	5215.61	9502.0
2015-02-23 13:00:00	NQ	Futures	5215.61	5219.43	5212.97	5215.61	7425.0
2015-02-23 14:00:00	NQ	Futures	5216.2	5221.78	5213.85	5214.14	10487.0
2015-02-23 15:00:00	NQ	Futures	5214.14	5225.01	5205.63	5224.13	23096.0
2015-02-23 16:00:00	NQ	Futures	5224.42	5226.77	5221.49	5222.95	5091.0
2015-02-23 17:00:00	NQ	Futures	5222.95	5223.54	5222.37	5222.37	121.0
2015-02-23 18:00:00	NQ	Futures	5222.07	5223.25	5220.31	5220.9	466.0
2015-02-23 19:00:00	NQ	Futures	5220.9	5222.37	5220.31	5221.78	216.0
2015-02-23 20:00:00	NQ	Futures	5221.49	5222.95	5221.19	5222.37	159.0
2015-02-23 21:00:00	NQ	Futures	5222.66	5223.54	5220.6	5220.9	239.0
2015-02-23 22:00:00	NQ	Futures	5220.9	5222.66	5220.6	5222.07	142.0
2015-02-23 23:00:00	NQ	Futures	5222.37	5223.54	5222.07	5223.25	223.0
2015-02-23 00:00:00	YM	Futures	18892.1	18895.2	18891.0	18895.2	195.0
2015-02-23 01:00:00	YM	Futures	18894.2	18896.3	18891.0	18896.3	240.0

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

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