PREVIEW / futures_1hour / 2015-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-20.parquet
  size:    44 KB
  rows:    1,286

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-20 00:00:00	ES	Futures	2201.42	2201.95	2201.16	2201.69	1215.0
2015-03-20 01:00:00	ES	Futures	2201.95	2203.01	2201.69	2202.74	1823.0
2015-03-20 02:00:00	ES	Futures	2203.01	2203.8	2201.69	2202.74	2819.0
2015-03-20 03:00:00	ES	Futures	2203.01	2203.8	2201.69	2202.74	8461.0
2015-03-20 04:00:00	ES	Futures	2202.48	2205.91	2202.48	2204.86	19510.0
2015-03-20 05:00:00	ES	Futures	2205.12	2206.18	2204.06	2205.12	9405.0
2015-03-20 06:00:00	ES	Futures	2205.12	2207.23	2203.53	2205.65	13332.0
2015-03-20 07:00:00	ES	Futures	2205.65	2210.4	2205.12	2210.14	22341.0
2015-03-20 08:00:00	ES	Futures	2210.14	2214.89	2209.61	2213.84	48560.0
2015-03-20 09:00:00	ES	Futures	2214.1	2215.95	2210.14	2212.51	252523.0
2015-03-20 10:00:00	ES	Futures	2212.78	2218.59	2211.99	2217.27	187239.0
2015-03-20 11:00:00	ES	Futures	2217.53	2221.49	2217.0	2219.65	124904.0
2015-03-20 12:00:00	ES	Futures	2219.65	2223.61	2219.12	2223.08	118935.0
2015-03-20 13:00:00	ES	Futures	2223.08	2225.72	2222.29	2223.87	93312.0
2015-03-20 14:00:00	ES	Futures	2223.61	2225.19	2221.49	2224.93	75413.0
2015-03-20 15:00:00	ES	Futures	2224.93	2225.46	2218.33	2218.85	239700.0
2015-03-20 16:00:00	ES	Futures	2218.85	2219.91	2215.68	2217.27	142955.0
2015-03-20 17:00:00	ES	Futures	2217.27	2218.33	2216.21	2218.33	3581.0
2015-03-20 00:00:00	NQ	Futures	5209.63	5210.22	5207.57	5209.92	393.0
2015-03-20 01:00:00	NQ	Futures	5210.22	5211.1	5208.45	5209.92	414.0
2015-03-20 02:00:00	NQ	Futures	5209.92	5211.69	5208.45	5210.22	416.0
2015-03-20 03:00:00	NQ	Futures	5210.51	5212.57	5209.92	5211.98	1071.0
2015-03-20 04:00:00	NQ	Futures	5211.69	5219.63	5211.69	5217.28	3123.0
2015-03-20 05:00:00	NQ	Futures	5217.57	5218.45	5214.63	5217.28	1372.0
2015-03-20 06:00:00	NQ	Futures	5217.28	5220.8	5214.63	5218.16	2187.0
2015-03-20 07:00:00	NQ	Futures	5218.16	5229.33	5216.98	5228.74	3233.0
2015-03-20 08:00:00	NQ	Futures	5229.04	5244.04	5228.16	5241.68	7376.0
2015-03-20 09:00:00	NQ	Futures	5241.98	5247.56	5232.27	5238.74	41745.0
2015-03-20 10:00:00	NQ	Futures	5238.74	5247.27	5232.27	5239.33	31943.0
2015-03-20 11:00:00	NQ	Futures	5239.62	5253.45	5239.33	5247.56	22532.0
2015-03-20 12:00:00	NQ	Futures	5247.56	5254.92	5244.62	5252.27	14736.0
2015-03-20 13:00:00	NQ	Futures	5252.27	5260.5	5252.27	5255.8	14143.0
2015-03-20 14:00:00	NQ	Futures	5255.8	5257.56	5248.15	5254.92	12310.0
2015-03-20 15:00:00	NQ	Futures	5255.21	5256.39	5235.8	5236.39	32504.0
2015-03-20 16:00:00	NQ	Futures	5236.1	5238.74	5228.16	5230.8	12046.0
2015-03-20 17:00:00	NQ	Futures	5230.8	5233.74	5228.74	5233.74	407.0
2015-03-20 00:00:00	YM	Futures	18799.4	18806.8	18799.4	18805.7	272.0
2015-03-20 01:00:00	YM	Futures	18806.8	18817.3	18803.6	18816.2	400.0
2015-03-20 02:00:00	YM	Futures	18816.2	18822.5	18801.5	18811.0	553.0
2015-03-20 03:00:00	YM	Futures	18813.1	18819.4	18806.8	18814.1	1021.0
2015-03-20 04:00:00	YM	Futures	18813.1	18839.3	18812.0	18830.9	2890.0
2015-03-20 05:00:00	YM	Futures	18828.8	18839.3	18822.5	18832.0	1335.0
2015-03-20 06:00:00	YM	Futures	18830.9	18850.8	18820.4	18840.3	1452.0
2015-03-20 07:00:00	YM	Futures	18840.3	18882.3	18839.3	18880.2	2293.0
2015-03-20 08:00:00	YM	Futures	18880.2	18917.9	18878.1	18907.5	4721.0
2015-03-20 09:00:00	YM	Futures	18907.5	18916.9	18836.1	18865.5	21732.0
2015-03-20 10:00:00	YM	Futures	18867.6	18931.6	18864.5	18923.2	17051.0
2015-03-20 11:00:00	YM	Futures	18924.2	18956.7	18921.1	18946.3	11092.0
2015-03-20 12:00:00	YM	Futures	18945.2	18967.2	18934.7	18962.0	9343.0
2015-03-20 13:00:00	YM	Futures	18962.0	18995.5	18958.8	18983.0	6913.0

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

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