PREVIEW / futures_1hour / 2015-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-30.parquet
  size:    54 KB
  rows:    1,606

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-30 00:00:00	ES	Futures	2217.27	2217.53	2214.89	2214.89	4194.0
2015-04-30 01:00:00	ES	Futures	2215.16	2217.27	2214.36	2217.0	5658.0
2015-04-30 02:00:00	ES	Futures	2217.0	2218.85	2215.16	2218.59	11160.0
2015-04-30 03:00:00	ES	Futures	2218.59	2218.85	2211.72	2213.31	41237.0
2015-04-30 04:00:00	ES	Futures	2213.04	2215.16	2208.29	2214.1	36817.0
2015-04-30 05:00:00	ES	Futures	2214.1	2214.36	2208.82	2211.19	22010.0
2015-04-30 06:00:00	ES	Futures	2211.19	2213.31	2210.4	2212.51	12981.0
2015-04-30 07:00:00	ES	Futures	2212.51	2214.1	2210.67	2213.04	16469.0
2015-04-30 08:00:00	ES	Futures	2212.78	2217.53	2212.51	2214.36	57411.0
2015-04-30 09:00:00	ES	Futures	2214.1	2216.48	2204.86	2205.38	251093.0
2015-04-30 10:00:00	ES	Futures	2205.12	2207.76	2201.16	2204.86	279205.0
2015-04-30 11:00:00	ES	Futures	2204.86	2214.89	2204.59	2206.7	197663.0
2015-04-30 12:00:00	ES	Futures	2206.7	2209.87	2201.69	2205.65	124788.0
2015-04-30 13:00:00	ES	Futures	2205.38	2207.76	2204.06	2204.59	97924.0
2015-04-30 14:00:00	ES	Futures	2204.59	2206.7	2193.23	2193.5	202977.0
2015-04-30 15:00:00	ES	Futures	2193.5	2196.93	2187.16	2196.14	491145.0
2015-04-30 16:00:00	ES	Futures	2196.14	2200.63	2195.88	2199.84	141226.0
2015-04-30 17:00:00	ES	Futures	2199.84	2201.42	2199.84	2200.63	3974.0
2015-04-30 18:00:00	ES	Futures	2200.37	2201.16	2198.52	2199.31	5201.0
2015-04-30 19:00:00	ES	Futures	2199.57	2199.84	2197.99	2198.78	3936.0
2015-04-30 20:00:00	ES	Futures	2198.78	2201.69	2198.52	2201.42	7312.0
2015-04-30 21:00:00	ES	Futures	2201.42	2201.42	2200.1	2200.1	2541.0
2015-04-30 22:00:00	ES	Futures	2200.1	2200.63	2199.84	2199.84	2449.0
2015-04-30 23:00:00	ES	Futures	2199.84	2201.16	2199.84	2200.89	1467.0
2015-04-30 00:00:00	NQ	Futures	5259.62	5260.21	5254.62	5254.92	686.0
2015-04-30 01:00:00	NQ	Futures	5254.33	5261.09	5251.68	5260.21	984.0
2015-04-30 02:00:00	NQ	Futures	5260.5	5263.15	5256.68	5262.27	1173.0
2015-04-30 03:00:00	NQ	Futures	5262.86	5263.15	5244.04	5245.21	4942.0
2015-04-30 04:00:00	NQ	Futures	5244.92	5250.8	5236.68	5247.56	6622.0
2015-04-30 05:00:00	NQ	Futures	5247.86	5247.86	5236.98	5243.45	3596.0
2015-04-30 06:00:00	NQ	Futures	5243.45	5246.68	5240.8	5245.51	2564.0
2015-04-30 07:00:00	NQ	Futures	5245.51	5249.62	5239.04	5244.33	2770.0
2015-04-30 08:00:00	NQ	Futures	5244.04	5255.5	5243.15	5250.21	8447.0
2015-04-30 09:00:00	NQ	Futures	5250.8	5263.15	5231.1	5231.39	48950.0
2015-04-30 10:00:00	NQ	Futures	5231.1	5239.04	5211.1	5216.98	57808.0
2015-04-30 11:00:00	NQ	Futures	5216.98	5244.04	5216.98	5218.75	37097.0
2015-04-30 12:00:00	NQ	Futures	5218.75	5228.16	5201.4	5210.51	25471.0
2015-04-30 13:00:00	NQ	Futures	5210.51	5216.69	5202.87	5202.87	22735.0
2015-04-30 14:00:00	NQ	Futures	5202.87	5209.04	5178.46	5179.64	37893.0
2015-04-30 15:00:00	NQ	Futures	5179.34	5186.69	5159.64	5186.4	74646.0
2015-04-30 16:00:00	NQ	Futures	5186.1	5198.16	5186.1	5192.57	12114.0
2015-04-30 17:00:00	NQ	Futures	5192.57	5195.81	5192.28	5192.57	701.0
2015-04-30 18:00:00	NQ	Futures	5191.99	5194.93	5189.34	5191.99	1060.0
2015-04-30 19:00:00	NQ	Futures	5191.69	5192.28	5187.28	5188.46	676.0
2015-04-30 20:00:00	NQ	Futures	5187.87	5193.16	5187.87	5192.28	1017.0
2015-04-30 21:00:00	NQ	Futures	5192.28	5192.28	5189.34	5189.34	520.0
2015-04-30 22:00:00	NQ	Futures	5189.34	5190.22	5187.87	5188.46	271.0
2015-04-30 23:00:00	NQ	Futures	5188.46	5190.52	5188.46	5189.93	142.0
2015-04-30 00:00:00	YM	Futures	18824.6	18825.7	18802.6	18802.6	1093.0
2015-04-30 01:00:00	YM	Futures	18803.6	18821.5	18785.8	18820.4	3139.0

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

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