PREVIEW / futures_1hour / 2015-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-23.parquet
  size:    45 KB
  rows:    1,306

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-10-23 00:00:00	ES	Futures	2201.89	2202.42	2200.82	2200.82	3059.0
2015-10-23 01:00:00	ES	Futures	2201.09	2202.42	2200.55	2202.16	3927.0
2015-10-23 02:00:00	ES	Futures	2202.16	2202.42	2198.14	2199.75	15462.0
2015-10-23 03:00:00	ES	Futures	2199.48	2201.09	2197.61	2199.21	26382.0
2015-10-23 04:00:00	ES	Futures	2198.94	2200.55	2198.94	2200.02	11361.0
2015-10-23 05:00:00	ES	Futures	2200.02	2205.9	2199.21	2205.63	21724.0
2015-10-23 06:00:00	ES	Futures	2205.37	2208.31	2204.83	2205.63	19991.0
2015-10-23 07:00:00	ES	Futures	2205.9	2220.35	2205.1	2215.8	120930.0
2015-10-23 08:00:00	ES	Futures	2215.53	2217.41	2212.86	2215.27	71306.0
2015-10-23 09:00:00	ES	Futures	2215.53	2217.14	2207.24	2216.07	340614.0
2015-10-23 10:00:00	ES	Futures	2216.34	2217.14	2206.17	2208.85	390601.0
2015-10-23 11:00:00	ES	Futures	2208.85	2212.06	2201.35	2203.49	224656.0
2015-10-23 12:00:00	ES	Futures	2203.49	2209.11	2201.89	2208.85	122099.0
2015-10-23 13:00:00	ES	Futures	2208.58	2213.93	2205.37	2212.32	128123.0
2015-10-23 14:00:00	ES	Futures	2212.59	2219.28	2210.72	2216.34	169210.0
2015-10-23 15:00:00	ES	Futures	2216.34	2218.21	2210.99	2214.46	240969.0
2015-10-23 16:00:00	ES	Futures	2214.46	2215.0	2209.38	2210.18	89311.0
2015-10-23 00:00:00	NQ	Futures	5421.93	5422.82	5419.86	5421.34	554.0
2015-10-23 01:00:00	NQ	Futures	5421.04	5426.38	5419.86	5426.08	844.0
2015-10-23 02:00:00	NQ	Futures	5425.79	5426.08	5416.0	5418.97	2967.0
2015-10-23 03:00:00	NQ	Futures	5418.97	5422.82	5413.63	5420.45	4090.0
2015-10-23 04:00:00	NQ	Futures	5420.15	5425.19	5418.67	5423.71	2568.0
2015-10-23 05:00:00	NQ	Futures	5423.71	5437.35	5421.63	5436.46	3159.0
2015-10-23 06:00:00	NQ	Futures	5436.46	5445.06	5435.27	5438.24	3777.0
2015-10-23 07:00:00	NQ	Futures	5438.53	5488.64	5437.65	5485.08	21804.0
2015-10-23 08:00:00	NQ	Futures	5484.79	5485.38	5468.78	5473.22	12269.0
2015-10-23 09:00:00	NQ	Futures	5473.52	5480.64	5444.17	5476.49	64656.0
2015-10-23 10:00:00	NQ	Futures	5476.49	5478.26	5443.58	5453.06	68215.0
2015-10-23 11:00:00	NQ	Futures	5453.06	5461.96	5445.35	5448.02	40387.0
2015-10-23 12:00:00	NQ	Futures	5448.32	5470.26	5442.09	5467.29	27031.0
2015-10-23 13:00:00	NQ	Futures	5466.7	5487.75	5458.4	5483.01	23699.0
2015-10-23 14:00:00	NQ	Futures	5483.01	5499.91	5478.86	5490.72	25611.0
2015-10-23 15:00:00	NQ	Futures	5491.01	5496.65	5471.74	5476.49	34712.0
2015-10-23 16:00:00	NQ	Futures	5476.49	5478.56	5467.89	5468.18	7025.0
2015-10-23 00:00:00	YM	Futures	18484.0	18485.0	18472.3	18479.7	577.0
2015-10-23 01:00:00	YM	Futures	18477.6	18493.5	18474.4	18492.4	841.0
2015-10-23 02:00:00	YM	Futures	18491.4	18492.4	18459.6	18470.2	1927.0
2015-10-23 03:00:00	YM	Futures	18470.2	18484.0	18454.3	18464.9	2896.0
2015-10-23 04:00:00	YM	Futures	18463.8	18475.5	18458.5	18464.9	1525.0
2015-10-23 05:00:00	YM	Futures	18466.0	18520.0	18458.5	18517.9	2803.0
2015-10-23 06:00:00	YM	Futures	18518.9	18534.8	18511.5	18516.8	2671.0
2015-10-23 07:00:00	YM	Futures	18516.8	18639.7	18508.3	18602.6	14513.0
2015-10-23 08:00:00	YM	Futures	18601.5	18619.6	18589.9	18607.9	6565.0
2015-10-23 09:00:00	YM	Futures	18609.0	18613.2	18549.6	18602.6	26582.0
2015-10-23 10:00:00	YM	Futures	18603.7	18611.1	18531.6	18548.6	25055.0
2015-10-23 11:00:00	YM	Futures	18547.5	18578.2	18504.1	18517.9	18006.0
2015-10-23 12:00:00	YM	Futures	18520.0	18565.5	18505.2	18560.2	8559.0
2015-10-23 13:00:00	YM	Futures	18560.2	18597.3	18532.7	18587.8	9333.0
2015-10-23 14:00:00	YM	Futures	18587.8	18638.6	18578.2	18621.7	12262.0
2015-10-23 15:00:00	YM	Futures	18621.7	18635.4	18586.7	18607.9	14465.0

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

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