PREVIEW / futures_1hour / 2015-05-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	2215.16	2216.21	2214.89	2215.95	1892.0
2015-05-12 01:00:00	ES	Futures	2215.95	2218.33	2215.68	2218.06	4776.0
2015-05-12 02:00:00	ES	Futures	2218.06	2219.65	2212.51	2213.57	18367.0
2015-05-12 03:00:00	ES	Futures	2213.57	2213.84	2208.82	2210.4	28713.0
2015-05-12 04:00:00	ES	Futures	2210.4	2210.4	2200.37	2200.63	40050.0
2015-05-12 05:00:00	ES	Futures	2200.63	2202.48	2196.67	2200.89	44201.0
2015-05-12 06:00:00	ES	Futures	2200.89	2203.53	2199.04	2199.57	24764.0
2015-05-12 07:00:00	ES	Futures	2199.84	2204.33	2197.2	2201.95	48234.0
2015-05-12 08:00:00	ES	Futures	2201.95	2206.7	2200.89	2205.65	52612.0
2015-05-12 09:00:00	ES	Futures	2205.65	2209.08	2197.72	2202.21	307520.0
2015-05-12 10:00:00	ES	Futures	2202.21	2214.63	2199.04	2209.87	276408.0
2015-05-12 11:00:00	ES	Futures	2209.87	2215.42	2209.87	2212.78	137209.0
2015-05-12 12:00:00	ES	Futures	2212.51	2215.42	2208.02	2213.84	82871.0
2015-05-12 13:00:00	ES	Futures	2213.84	2217.8	2211.46	2213.57	85028.0
2015-05-12 14:00:00	ES	Futures	2213.31	2219.38	2211.72	2214.36	104526.0
2015-05-12 15:00:00	ES	Futures	2214.36	2216.74	2211.99	2211.99	139483.0
2015-05-12 16:00:00	ES	Futures	2211.99	2215.16	2211.19	2213.84	50353.0
2015-05-12 17:00:00	ES	Futures	2213.84	2215.42	2213.84	2214.63	2110.0
2015-05-12 18:00:00	ES	Futures	2214.63	2216.48	2214.1	2216.48	3178.0
2015-05-12 19:00:00	ES	Futures	2216.21	2216.74	2215.42	2216.74	1362.0
2015-05-12 20:00:00	ES	Futures	2216.74	2217.8	2215.42	2217.0	4361.0
2015-05-12 21:00:00	ES	Futures	2216.74	2220.7	2216.48	2218.59	6457.0
2015-05-12 22:00:00	ES	Futures	2218.59	2218.85	2217.27	2218.33	1789.0
2015-05-12 23:00:00	ES	Futures	2218.59	2220.17	2218.33	2219.65	2724.0
2015-05-12 00:00:00	NQ	Futures	5208.45	5209.92	5206.98	5209.34	351.0
2015-05-12 01:00:00	NQ	Futures	5209.92	5215.51	5209.34	5215.51	1256.0
2015-05-12 02:00:00	NQ	Futures	5215.8	5219.63	5201.4	5205.81	2793.0
2015-05-12 03:00:00	NQ	Futures	5206.1	5206.98	5190.52	5193.16	5142.0
2015-05-12 04:00:00	NQ	Futures	5193.16	5193.16	5168.46	5169.05	5524.0
2015-05-12 05:00:00	NQ	Futures	5168.46	5173.17	5160.52	5170.52	5407.0
2015-05-12 06:00:00	NQ	Futures	5170.52	5175.22	5164.64	5167.87	3247.0
2015-05-12 07:00:00	NQ	Futures	5168.46	5179.34	5161.7	5172.28	6263.0
2015-05-12 08:00:00	NQ	Futures	5172.28	5179.05	5168.46	5177.58	6136.0
2015-05-12 09:00:00	NQ	Futures	5177.58	5186.99	5145.52	5160.23	55898.0
2015-05-12 10:00:00	NQ	Futures	5160.23	5196.98	5153.76	5187.87	50325.0
2015-05-12 11:00:00	NQ	Futures	5187.57	5204.92	5187.57	5195.81	26326.0
2015-05-12 12:00:00	NQ	Futures	5196.1	5208.45	5184.63	5204.63	16128.0
2015-05-12 13:00:00	NQ	Futures	5204.34	5218.16	5199.63	5205.22	20293.0
2015-05-12 14:00:00	NQ	Futures	5205.51	5220.22	5200.51	5204.34	18443.0
2015-05-12 15:00:00	NQ	Futures	5204.34	5208.16	5194.34	5194.34	25204.0
2015-05-12 16:00:00	NQ	Futures	5194.34	5203.16	5192.57	5200.81	5153.0
2015-05-12 17:00:00	NQ	Futures	5201.1	5203.45	5200.51	5201.4	223.0
2015-05-12 18:00:00	NQ	Futures	5202.57	5206.98	5200.51	5206.39	536.0
2015-05-12 19:00:00	NQ	Futures	5206.69	5208.45	5204.63	5208.16	289.0
2015-05-12 20:00:00	NQ	Futures	5208.45	5211.69	5204.63	5209.63	662.0
2015-05-12 21:00:00	NQ	Futures	5209.34	5216.69	5208.75	5214.04	870.0
2015-05-12 22:00:00	NQ	Futures	5213.45	5214.33	5210.81	5213.75	374.0
2015-05-12 23:00:00	NQ	Futures	5214.04	5217.86	5213.16	5216.69	455.0
2015-05-12 00:00:00	YM	Futures	18906.4	18919.0	18903.3	18915.8	766.0
2015-05-12 01:00:00	YM	Futures	18915.8	18934.7	18913.8	18934.7	1158.0

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

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