PREVIEW / futures_1hour / 2015-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-25.parquet
  size:    50 KB
  rows:    1,543

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-25 00:00:00	ES	Futures	2201.69	2201.69	2200.37	2201.42	3625.0
2015-03-25 01:00:00	ES	Futures	2201.69	2202.74	2201.16	2201.95	2432.0
2015-03-25 02:00:00	ES	Futures	2201.95	2202.74	2201.42	2201.69	2019.0
2015-03-25 03:00:00	ES	Futures	2201.69	2202.48	2200.89	2202.21	5318.0
2015-03-25 04:00:00	ES	Futures	2201.95	2204.86	2201.42	2203.8	15360.0
2015-03-25 05:00:00	ES	Futures	2203.8	2206.18	2202.48	2205.38	10613.0
2015-03-25 06:00:00	ES	Futures	2205.38	2205.91	2203.27	2204.06	5347.0
2015-03-25 07:00:00	ES	Futures	2204.06	2204.06	2199.04	2200.89	22561.0
2015-03-25 08:00:00	ES	Futures	2200.63	2204.06	2200.1	2203.53	24275.0
2015-03-25 09:00:00	ES	Futures	2203.27	2207.23	2196.14	2198.25	207478.0
2015-03-25 10:00:00	ES	Futures	2198.52	2203.27	2196.14	2200.89	192554.0
2015-03-25 11:00:00	ES	Futures	2200.89	2202.21	2183.2	2186.1	309764.0
2015-03-25 12:00:00	ES	Futures	2186.1	2186.63	2178.44	2182.67	222651.0
2015-03-25 13:00:00	ES	Futures	2182.67	2183.73	2176.59	2180.82	166009.0
2015-03-25 14:00:00	ES	Futures	2181.08	2183.46	2178.18	2179.24	122678.0
2015-03-25 15:00:00	ES	Futures	2179.24	2179.5	2168.14	2168.67	334006.0
2015-03-25 16:00:00	ES	Futures	2168.67	2171.31	2168.14	2171.05	112126.0
2015-03-25 17:00:00	ES	Futures	2171.31	2172.37	2170.78	2172.37	2864.0
2015-03-25 18:00:00	ES	Futures	2172.1	2172.63	2169.73	2171.58	5838.0
2015-03-25 19:00:00	ES	Futures	2171.58	2172.1	2170.78	2171.84	2706.0
2015-03-25 20:00:00	ES	Futures	2171.84	2172.1	2168.41	2168.94	10493.0
2015-03-25 21:00:00	ES	Futures	2168.94	2169.73	2168.41	2169.2	4647.0
2015-03-25 22:00:00	ES	Futures	2169.2	2171.58	2168.67	2169.2	6857.0
2015-03-25 23:00:00	ES	Futures	2169.2	2170.78	2168.41	2169.73	4804.0
2015-03-25 00:00:00	NQ	Futures	5210.81	5210.81	5206.39	5209.04	526.0
2015-03-25 01:00:00	NQ	Futures	5209.34	5212.28	5207.87	5210.51	603.0
2015-03-25 02:00:00	NQ	Futures	5209.92	5212.57	5209.04	5209.92	419.0
2015-03-25 03:00:00	NQ	Futures	5209.63	5211.39	5206.69	5209.04	995.0
2015-03-25 04:00:00	NQ	Futures	5209.04	5216.69	5207.28	5214.92	2714.0
2015-03-25 05:00:00	NQ	Futures	5215.22	5219.33	5211.98	5218.45	1724.0
2015-03-25 06:00:00	NQ	Futures	5218.75	5219.63	5214.33	5214.92	1083.0
2015-03-25 07:00:00	NQ	Futures	5215.22	5215.22	5204.34	5209.04	3750.0
2015-03-25 08:00:00	NQ	Futures	5208.75	5215.8	5207.87	5214.33	4279.0
2015-03-25 09:00:00	NQ	Futures	5214.04	5220.8	5172.58	5177.58	44272.0
2015-03-25 10:00:00	NQ	Futures	5177.28	5193.16	5170.52	5183.46	35859.0
2015-03-25 11:00:00	NQ	Futures	5183.75	5186.4	5127.88	5138.17	60635.0
2015-03-25 12:00:00	NQ	Futures	5137.88	5138.47	5112.29	5123.76	43205.0
2015-03-25 13:00:00	NQ	Futures	5123.47	5127.0	5106.12	5118.18	30144.0
2015-03-25 14:00:00	NQ	Futures	5118.18	5125.53	5108.77	5110.24	23837.0
2015-03-25 15:00:00	NQ	Futures	5110.53	5111.12	5081.42	5082.89	51814.0
2015-03-25 16:00:00	NQ	Futures	5082.3	5092.0	5082.01	5088.48	11648.0
2015-03-25 17:00:00	NQ	Futures	5088.77	5090.83	5088.18	5090.24	260.0
2015-03-25 18:00:00	NQ	Futures	5089.65	5093.77	5086.12	5089.36	996.0
2015-03-25 19:00:00	NQ	Futures	5089.36	5089.95	5087.3	5089.36	544.0
2015-03-25 20:00:00	NQ	Futures	5089.95	5090.53	5082.01	5082.59	1766.0
2015-03-25 21:00:00	NQ	Futures	5082.3	5083.77	5080.24	5081.71	961.0
2015-03-25 22:00:00	NQ	Futures	5081.71	5087.59	5080.54	5082.3	1396.0
2015-03-25 23:00:00	NQ	Futures	5082.01	5084.65	5080.54	5083.18	620.0
2015-03-25 00:00:00	YM	Futures	18808.9	18809.9	18799.4	18809.9	358.0
2015-03-25 01:00:00	YM	Futures	18808.9	18818.3	18805.7	18811.0	377.0

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

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