PREVIEW / futures_1hour / 2015-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-13.parquet
  size:    52 KB
  rows:    1,580

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-05-13 00:00:00	ES	Futures	2219.38	2219.91	2218.59	2218.59	1072.0
2015-05-13 01:00:00	ES	Futures	2218.85	2220.17	2217.53	2219.12	2900.0
2015-05-13 02:00:00	ES	Futures	2219.38	2221.23	2218.33	2218.59	7718.0
2015-05-13 03:00:00	ES	Futures	2218.85	2222.82	2216.74	2222.82	19487.0
2015-05-13 04:00:00	ES	Futures	2222.82	2224.66	2221.76	2222.29	19074.0
2015-05-13 05:00:00	ES	Futures	2222.29	2223.87	2220.7	2221.49	10695.0
2015-05-13 06:00:00	ES	Futures	2221.49	2222.02	2219.12	2219.38	9946.0
2015-05-13 07:00:00	ES	Futures	2219.65	2220.7	2217.53	2220.44	15554.0
2015-05-13 08:00:00	ES	Futures	2220.7	2222.82	2214.89	2217.0	80353.0
2015-05-13 09:00:00	ES	Futures	2216.74	2225.46	2214.1	2221.23	237277.0
2015-05-13 10:00:00	ES	Futures	2220.97	2222.82	2212.78	2213.04	227204.0
2015-05-13 11:00:00	ES	Futures	2213.04	2217.27	2210.93	2214.89	172358.0
2015-05-13 12:00:00	ES	Futures	2215.16	2217.0	2211.46	2214.63	78937.0
2015-05-13 13:00:00	ES	Futures	2214.36	2218.85	2214.36	2216.21	78577.0
2015-05-13 14:00:00	ES	Futures	2216.48	2216.74	2210.93	2211.99	104955.0
2015-05-13 15:00:00	ES	Futures	2212.25	2214.89	2209.61	2213.04	193025.0
2015-05-13 16:00:00	ES	Futures	2213.04	2214.89	2211.46	2214.63	54981.0
2015-05-13 17:00:00	ES	Futures	2214.63	2214.89	2213.84	2214.1	1021.0
2015-05-13 18:00:00	ES	Futures	2214.36	2217.0	2214.1	2214.89	4626.0
2015-05-13 19:00:00	ES	Futures	2214.89	2215.16	2214.36	2214.63	1415.0
2015-05-13 20:00:00	ES	Futures	2214.63	2215.42	2213.84	2213.84	3793.0
2015-05-13 21:00:00	ES	Futures	2213.84	2214.36	2212.78	2213.57	2942.0
2015-05-13 22:00:00	ES	Futures	2213.57	2214.1	2212.51	2214.1	2590.0
2015-05-13 23:00:00	ES	Futures	2214.1	2214.1	2213.31	2213.31	1256.0
2015-05-13 00:00:00	NQ	Futures	5216.69	5217.28	5213.75	5214.33	332.0
2015-05-13 01:00:00	NQ	Futures	5214.63	5217.57	5211.69	5215.22	599.0
2015-05-13 02:00:00	NQ	Futures	5214.92	5218.75	5212.28	5213.45	1311.0
2015-05-13 03:00:00	NQ	Futures	5213.45	5226.39	5207.87	5225.8	3628.0
2015-05-13 04:00:00	NQ	Futures	5226.1	5231.68	5225.21	5226.1	3878.0
2015-05-13 05:00:00	NQ	Futures	5226.1	5230.51	5223.45	5224.63	2488.0
2015-05-13 06:00:00	NQ	Futures	5224.63	5225.8	5217.86	5219.33	2323.0
2015-05-13 07:00:00	NQ	Futures	5219.63	5221.69	5214.33	5221.69	2668.0
2015-05-13 08:00:00	NQ	Futures	5221.39	5227.57	5209.63	5218.16	13135.0
2015-05-13 09:00:00	NQ	Futures	5218.16	5243.45	5208.45	5229.33	41535.0
2015-05-13 10:00:00	NQ	Futures	5229.63	5236.68	5210.22	5212.86	31585.0
2015-05-13 11:00:00	NQ	Futures	5213.16	5216.69	5201.69	5211.39	27291.0
2015-05-13 12:00:00	NQ	Futures	5211.39	5214.92	5200.81	5208.16	12509.0
2015-05-13 13:00:00	NQ	Futures	5208.16	5219.04	5206.98	5216.39	12304.0
2015-05-13 14:00:00	NQ	Futures	5216.39	5217.57	5199.34	5203.16	15448.0
2015-05-13 15:00:00	NQ	Futures	5203.45	5208.45	5196.1	5202.57	21285.0
2015-05-13 16:00:00	NQ	Futures	5202.57	5207.87	5198.16	5207.57	5260.0
2015-05-13 17:00:00	NQ	Futures	5207.87	5208.45	5205.51	5206.1	100.0
2015-05-13 18:00:00	NQ	Futures	5205.81	5211.39	5204.63	5207.28	754.0
2015-05-13 19:00:00	NQ	Futures	5207.57	5208.16	5206.1	5207.28	235.0
2015-05-13 20:00:00	NQ	Futures	5207.57	5209.92	5206.98	5206.98	481.0
2015-05-13 21:00:00	NQ	Futures	5206.69	5207.57	5203.75	5205.51	492.0
2015-05-13 22:00:00	NQ	Futures	5206.1	5206.39	5200.51	5204.92	634.0
2015-05-13 23:00:00	NQ	Futures	5205.22	5205.22	5201.69	5202.57	325.0
2015-05-13 00:00:00	YM	Futures	18957.8	18962.0	18951.5	18952.6	288.0
2015-05-13 01:00:00	YM	Futures	18952.6	18960.9	18941.0	18954.6	739.0

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

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