PREVIEW / futures_1hour / 2016-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-27.parquet
  size:    44 KB
  rows:    1,328

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
2016-05-27 00:00:00	ES	Futures	2257.57	2258.11	2256.76	2257.3	1175.0
2016-05-27 01:00:00	ES	Futures	2257.03	2258.92	2256.49	2258.65	3607.0
2016-05-27 02:00:00	ES	Futures	2258.65	2258.92	2255.95	2256.22	6356.0
2016-05-27 03:00:00	ES	Futures	2256.22	2258.38	2254.87	2256.76	20886.0
2016-05-27 04:00:00	ES	Futures	2256.76	2258.11	2256.22	2256.49	9851.0
2016-05-27 05:00:00	ES	Futures	2256.49	2259.73	2255.95	2258.92	15316.0
2016-05-27 06:00:00	ES	Futures	2258.92	2259.73	2258.11	2258.92	9305.0
2016-05-27 07:00:00	ES	Futures	2258.92	2259.73	2258.11	2258.65	8918.0
2016-05-27 08:00:00	ES	Futures	2258.65	2259.73	2256.76	2257.03	16909.0
2016-05-27 09:00:00	ES	Futures	2256.76	2260.27	2255.95	2258.65	128657.0
2016-05-27 10:00:00	ES	Futures	2258.38	2261.35	2258.11	2259.46	164663.0
2016-05-27 11:00:00	ES	Futures	2259.19	2262.97	2258.38	2261.62	140028.0
2016-05-27 12:00:00	ES	Futures	2261.62	2262.7	2261.08	2261.35	48928.0
2016-05-27 13:00:00	ES	Futures	2261.62	2261.89	2256.76	2258.65	112399.0
2016-05-27 14:00:00	ES	Futures	2258.38	2261.62	2256.76	2260.54	110381.0
2016-05-27 15:00:00	ES	Futures	2260.54	2264.32	2259.73	2264.32	133111.0
2016-05-27 16:00:00	ES	Futures	2264.32	2266.48	2263.78	2266.21	68422.0
2016-05-27 00:00:00	NQ	Futures	5350.18	5351.67	5348.69	5349.88	318.0
2016-05-27 01:00:00	NQ	Futures	5350.18	5353.45	5348.39	5353.45	656.0
2016-05-27 02:00:00	NQ	Futures	5353.15	5354.05	5347.2	5347.5	723.0
2016-05-27 03:00:00	NQ	Futures	5347.2	5354.94	5343.93	5351.96	2858.0
2016-05-27 04:00:00	NQ	Futures	5351.96	5354.34	5351.07	5351.67	1313.0
2016-05-27 05:00:00	NQ	Futures	5351.96	5359.7	5349.88	5358.21	1884.0
2016-05-27 06:00:00	NQ	Futures	5357.91	5359.7	5356.43	5357.02	1433.0
2016-05-27 07:00:00	NQ	Futures	5357.32	5358.51	5353.75	5354.64	1632.0
2016-05-27 08:00:00	NQ	Futures	5354.64	5356.72	5347.8	5347.8	3568.0
2016-05-27 09:00:00	NQ	Futures	5347.5	5359.7	5343.93	5356.72	23621.0
2016-05-27 10:00:00	NQ	Futures	5356.43	5368.92	5350.77	5358.81	27883.0
2016-05-27 11:00:00	NQ	Futures	5358.81	5371.01	5356.43	5367.14	19084.0
2016-05-27 12:00:00	NQ	Futures	5367.44	5368.63	5363.87	5366.25	8262.0
2016-05-27 13:00:00	NQ	Futures	5366.25	5367.44	5354.34	5355.24	14357.0
2016-05-27 14:00:00	NQ	Futures	5355.24	5364.76	5349.88	5362.97	13415.0
2016-05-27 15:00:00	NQ	Futures	5363.27	5369.52	5358.81	5368.92	16747.0
2016-05-27 16:00:00	NQ	Futures	5369.22	5371.6	5366.25	5371.01	6771.0
2016-05-27 00:00:00	YM	Futures	19077.6	19081.8	19072.2	19074.3	228.0
2016-05-27 01:00:00	YM	Futures	19074.3	19087.2	19071.1	19086.1	791.0
2016-05-27 02:00:00	YM	Futures	19088.3	19088.3	19064.7	19064.7	815.0
2016-05-27 03:00:00	YM	Futures	19065.8	19082.9	19055.1	19073.3	2787.0
2016-05-27 04:00:00	YM	Futures	19073.3	19080.8	19067.9	19070.1	992.0
2016-05-27 05:00:00	YM	Futures	19069.0	19096.8	19062.6	19087.2	2162.0
2016-05-27 06:00:00	YM	Futures	19087.2	19095.8	19082.9	19088.3	1087.0
2016-05-27 07:00:00	YM	Futures	19088.3	19095.8	19085.1	19087.2	937.0
2016-05-27 08:00:00	YM	Futures	19087.2	19093.6	19071.1	19072.2	1845.0
2016-05-27 09:00:00	YM	Futures	19072.2	19096.8	19065.8	19085.1	12225.0
2016-05-27 10:00:00	YM	Futures	19085.1	19103.2	19075.4	19086.1	13975.0
2016-05-27 11:00:00	YM	Futures	19085.1	19111.8	19077.6	19100.0	9855.0
2016-05-27 12:00:00	YM	Futures	19100.0	19106.5	19094.7	19096.8	4152.0
2016-05-27 13:00:00	YM	Futures	19096.8	19100.0	19055.1	19072.2	9146.0
2016-05-27 14:00:00	YM	Futures	19071.1	19095.8	19059.4	19082.9	8249.0
2016-05-27 15:00:00	YM	Futures	19082.9	19104.3	19076.5	19104.3	8388.0

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

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