PREVIEW / futures_1hour / 2015-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-04.parquet
  size:    49 KB
  rows:    1,537

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-03-04 00:00:00	ES	Futures	2214.16	2214.69	2213.37	2214.69	2162.0
2015-03-04 01:00:00	ES	Futures	2214.42	2214.69	2213.37	2214.16	1467.0
2015-03-04 02:00:00	ES	Futures	2214.16	2214.95	2213.63	2213.9	3014.0
2015-03-04 03:00:00	ES	Futures	2213.9	2214.42	2209.69	2209.95	20179.0
2015-03-04 04:00:00	ES	Futures	2209.95	2210.21	2207.32	2209.69	25769.0
2015-03-04 05:00:00	ES	Futures	2209.69	2210.74	2207.32	2207.58	12121.0
2015-03-04 06:00:00	ES	Futures	2207.58	2209.16	2207.05	2208.9	10664.0
2015-03-04 07:00:00	ES	Futures	2208.9	2209.69	2207.58	2209.42	17737.0
2015-03-04 08:00:00	ES	Futures	2209.42	2210.21	2208.37	2209.42	22073.0
2015-03-04 09:00:00	ES	Futures	2209.42	2209.95	2198.11	2201.27	288783.0
2015-03-04 10:00:00	ES	Futures	2201.27	2202.32	2194.95	2200.74	341080.0
2015-03-04 11:00:00	ES	Futures	2200.74	2207.05	2200.21	2205.21	196605.0
2015-03-04 12:00:00	ES	Futures	2204.95	2210.21	2204.42	2207.05	104878.0
2015-03-04 13:00:00	ES	Futures	2207.32	2209.16	2203.37	2204.16	82918.0
2015-03-04 14:00:00	ES	Futures	2204.16	2207.84	2202.58	2207.58	97327.0
2015-03-04 15:00:00	ES	Futures	2207.32	2208.9	2204.69	2207.58	162337.0
2015-03-04 16:00:00	ES	Futures	2207.32	2207.84	2206.0	2206.27	57328.0
2015-03-04 17:00:00	ES	Futures	2206.27	2206.79	2206.0	2206.53	1434.0
2015-03-04 18:00:00	ES	Futures	2206.79	2207.05	2204.95	2205.74	3860.0
2015-03-04 19:00:00	ES	Futures	2205.74	2206.79	2204.69	2206.79	4273.0
2015-03-04 20:00:00	ES	Futures	2206.53	2207.32	2206.0	2206.79	2912.0
2015-03-04 21:00:00	ES	Futures	2207.05	2207.05	2206.53	2207.05	1079.0
2015-03-04 22:00:00	ES	Futures	2207.05	2208.37	2206.53	2208.37	2392.0
2015-03-04 23:00:00	ES	Futures	2208.37	2208.63	2207.84	2208.37	1410.0
2015-03-04 00:00:00	NQ	Futures	5234.41	5235.29	5231.18	5235.29	312.0
2015-03-04 01:00:00	NQ	Futures	5234.41	5235.0	5231.18	5232.35	242.0
2015-03-04 02:00:00	NQ	Futures	5232.35	5234.7	5232.35	5232.94	429.0
2015-03-04 03:00:00	NQ	Futures	5232.94	5233.82	5225.01	5225.6	3798.0
2015-03-04 04:00:00	NQ	Futures	5225.89	5225.89	5219.43	5223.54	3843.0
2015-03-04 05:00:00	NQ	Futures	5223.84	5225.89	5218.55	5219.14	2076.0
2015-03-04 06:00:00	NQ	Futures	5218.84	5223.25	5217.67	5222.37	1905.0
2015-03-04 07:00:00	NQ	Futures	5222.37	5223.54	5219.14	5222.95	2588.0
2015-03-04 08:00:00	NQ	Futures	5222.95	5225.3	5220.9	5222.95	3148.0
2015-03-04 09:00:00	NQ	Futures	5222.95	5225.01	5194.17	5201.81	43448.0
2015-03-04 10:00:00	NQ	Futures	5201.81	5211.79	5191.53	5210.03	45759.0
2015-03-04 11:00:00	NQ	Futures	5209.74	5227.07	5208.86	5220.31	29894.0
2015-03-04 12:00:00	NQ	Futures	5220.02	5230.59	5218.26	5223.25	15931.0
2015-03-04 13:00:00	NQ	Futures	5222.95	5230.0	5215.91	5218.26	11928.0
2015-03-04 14:00:00	NQ	Futures	5217.96	5228.24	5211.79	5227.65	14766.0
2015-03-04 15:00:00	NQ	Futures	5227.65	5228.53	5218.84	5221.19	23948.0
2015-03-04 16:00:00	NQ	Futures	5221.49	5223.25	5219.14	5219.72	4995.0
2015-03-04 17:00:00	NQ	Futures	5220.31	5221.19	5219.43	5221.19	82.0
2015-03-04 18:00:00	NQ	Futures	5220.9	5221.78	5216.79	5218.26	526.0
2015-03-04 19:00:00	NQ	Futures	5218.55	5220.6	5216.49	5220.6	475.0
2015-03-04 20:00:00	NQ	Futures	5220.9	5220.9	5219.14	5220.31	264.0
2015-03-04 21:00:00	NQ	Futures	5219.43	5220.9	5219.14	5220.6	150.0
2015-03-04 22:00:00	NQ	Futures	5220.31	5222.37	5219.72	5222.07	225.0
2015-03-04 23:00:00	NQ	Futures	5222.37	5223.54	5221.19	5222.66	227.0
2015-03-04 00:00:00	YM	Futures	18971.4	18974.6	18956.8	18972.5	1852.0
2015-03-04 01:00:00	YM	Futures	18972.5	18972.5	18962.0	18966.2	214.0

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

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