PREVIEW / futures_1hour / 2015-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-14.parquet
  size:    50 KB
  rows:    1,548

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-14 00:00:00	ES	Futures	2207.5	2208.02	2207.23	2207.76	834.0
2015-04-14 01:00:00	ES	Futures	2207.76	2208.02	2207.23	2207.23	1923.0
2015-04-14 02:00:00	ES	Futures	2207.5	2210.67	2207.23	2210.4	7577.0
2015-04-14 03:00:00	ES	Futures	2210.4	2210.93	2209.08	2210.67	10731.0
2015-04-14 04:00:00	ES	Futures	2210.67	2210.93	2204.33	2205.12	17118.0
2015-04-14 05:00:00	ES	Futures	2205.12	2205.65	2196.67	2199.31	30510.0
2015-04-14 06:00:00	ES	Futures	2199.04	2203.01	2199.04	2200.37	16244.0
2015-04-14 07:00:00	ES	Futures	2200.63	2204.59	2200.1	2201.42	27459.0
2015-04-14 08:00:00	ES	Futures	2201.42	2204.33	2199.57	2202.48	39204.0
2015-04-14 09:00:00	ES	Futures	2202.48	2208.02	2197.72	2199.84	236265.0
2015-04-14 10:00:00	ES	Futures	2199.57	2199.84	2192.97	2198.25	256458.0
2015-04-14 11:00:00	ES	Futures	2197.99	2206.18	2196.14	2204.86	168080.0
2015-04-14 12:00:00	ES	Futures	2204.86	2210.14	2204.06	2206.97	92303.0
2015-04-14 13:00:00	ES	Futures	2206.7	2207.76	2204.86	2206.7	48076.0
2015-04-14 14:00:00	ES	Futures	2206.44	2207.23	2203.53	2206.7	52553.0
2015-04-14 15:00:00	ES	Futures	2206.7	2209.08	2204.59	2207.76	163277.0
2015-04-14 16:00:00	ES	Futures	2207.5	2210.14	2207.23	2208.82	71901.0
2015-04-14 17:00:00	ES	Futures	2209.08	2209.87	2208.82	2209.87	1118.0
2015-04-14 18:00:00	ES	Futures	2209.87	2210.14	2208.55	2209.35	2142.0
2015-04-14 19:00:00	ES	Futures	2209.35	2209.35	2207.76	2207.76	1866.0
2015-04-14 20:00:00	ES	Futures	2208.02	2208.55	2206.44	2208.02	2663.0
2015-04-14 21:00:00	ES	Futures	2208.02	2209.08	2206.97	2207.5	3065.0
2015-04-14 22:00:00	ES	Futures	2207.5	2208.82	2206.44	2208.02	3348.0
2015-04-14 23:00:00	ES	Futures	2207.76	2208.29	2207.23	2208.29	1294.0
2015-04-14 00:00:00	NQ	Futures	5184.93	5186.69	5184.63	5185.52	108.0
2015-04-14 01:00:00	NQ	Futures	5186.1	5186.69	5184.34	5185.22	165.0
2015-04-14 02:00:00	NQ	Futures	5185.22	5191.4	5184.34	5190.81	1169.0
2015-04-14 03:00:00	NQ	Futures	5190.81	5192.57	5187.57	5191.69	1261.0
2015-04-14 04:00:00	NQ	Futures	5191.69	5192.28	5176.4	5178.16	2095.0
2015-04-14 05:00:00	NQ	Futures	5178.46	5180.22	5159.64	5163.17	5104.0
2015-04-14 06:00:00	NQ	Futures	5163.46	5173.75	5163.17	5169.93	3232.0
2015-04-14 07:00:00	NQ	Futures	5169.93	5181.99	5169.05	5174.34	3496.0
2015-04-14 08:00:00	NQ	Futures	5174.05	5182.87	5171.11	5179.93	6055.0
2015-04-14 09:00:00	NQ	Futures	5179.93	5190.81	5151.11	5155.82	52072.0
2015-04-14 10:00:00	NQ	Futures	5155.23	5159.64	5136.41	5145.23	42890.0
2015-04-14 11:00:00	NQ	Futures	5144.94	5162.87	5140.82	5153.46	26413.0
2015-04-14 12:00:00	NQ	Futures	5153.46	5173.17	5152.88	5160.52	19312.0
2015-04-14 13:00:00	NQ	Futures	5160.23	5161.11	5152.58	5157.87	10086.0
2015-04-14 14:00:00	NQ	Futures	5157.58	5163.17	5152.88	5161.7	8749.0
2015-04-14 15:00:00	NQ	Futures	5161.4	5167.87	5158.46	5165.81	27065.0
2015-04-14 16:00:00	NQ	Futures	5165.81	5174.34	5164.93	5171.4	8687.0
2015-04-14 17:00:00	NQ	Futures	5171.4	5176.4	5171.11	5175.52	575.0
2015-04-14 18:00:00	NQ	Futures	5175.81	5176.99	5171.4	5173.46	420.0
2015-04-14 19:00:00	NQ	Futures	5173.46	5173.75	5169.34	5169.64	251.0
2015-04-14 20:00:00	NQ	Futures	5169.64	5170.81	5166.11	5170.23	431.0
2015-04-14 21:00:00	NQ	Futures	5169.93	5170.81	5167.28	5168.17	664.0
2015-04-14 22:00:00	NQ	Futures	5168.17	5170.81	5165.52	5169.64	571.0
2015-04-14 23:00:00	NQ	Futures	5169.64	5170.81	5168.46	5170.52	207.0
2015-04-14 00:00:00	YM	Futures	18809.9	18813.1	18806.8	18807.8	159.0
2015-04-14 01:00:00	YM	Futures	18811.0	18813.1	18803.6	18803.6	476.0

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

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