PREVIEW / futures_1hour / 2016-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-03.parquet
  size:    46 KB
  rows:    1,344

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-06-03 00:00:00	ES	Futures	2271.34	2271.88	2270.53	2271.07	2496.0
2016-06-03 01:00:00	ES	Futures	2271.07	2272.15	2270.8	2271.34	2545.0
2016-06-03 02:00:00	ES	Futures	2271.07	2272.15	2270.8	2271.07	5122.0
2016-06-03 03:00:00	ES	Futures	2271.34	2272.96	2269.72	2270.53	21766.0
2016-06-03 04:00:00	ES	Futures	2270.53	2272.69	2269.72	2271.34	16981.0
2016-06-03 05:00:00	ES	Futures	2271.61	2272.15	2270.8	2271.34	7486.0
2016-06-03 06:00:00	ES	Futures	2271.61	2272.42	2271.07	2271.61	10487.0
2016-06-03 07:00:00	ES	Futures	2271.88	2274.31	2271.61	2273.5	16058.0
2016-06-03 08:00:00	ES	Futures	2273.23	2273.5	2258.38	2262.16	152805.0
2016-06-03 09:00:00	ES	Futures	2262.16	2265.67	2255.14	2257.84	252824.0
2016-06-03 10:00:00	ES	Futures	2257.57	2258.65	2249.2	2258.11	332738.0
2016-06-03 11:00:00	ES	Futures	2258.11	2264.05	2254.6	2262.97	214327.0
2016-06-03 12:00:00	ES	Futures	2262.97	2264.05	2258.65	2259.19	105059.0
2016-06-03 13:00:00	ES	Futures	2259.19	2263.51	2258.65	2262.97	96290.0
2016-06-03 14:00:00	ES	Futures	2263.24	2269.18	2260.81	2267.02	149663.0
2016-06-03 15:00:00	ES	Futures	2267.02	2268.1	2263.51	2265.13	224522.0
2016-06-03 16:00:00	ES	Futures	2265.13	2266.21	2264.05	2264.86	83584.0
2016-06-03 00:00:00	NQ	Futures	5390.35	5391.83	5389.16	5390.05	318.0
2016-06-03 01:00:00	NQ	Futures	5390.35	5393.32	5390.05	5391.83	468.0
2016-06-03 02:00:00	NQ	Futures	5392.13	5394.51	5390.94	5392.13	527.0
2016-06-03 03:00:00	NQ	Futures	5391.83	5396.89	5387.07	5388.56	2381.0
2016-06-03 04:00:00	NQ	Futures	5388.86	5393.02	5385.29	5390.05	1545.0
2016-06-03 05:00:00	NQ	Futures	5390.64	5392.73	5389.16	5390.35	503.0
2016-06-03 06:00:00	NQ	Futures	5390.64	5392.73	5388.86	5389.45	886.0
2016-06-03 07:00:00	NQ	Futures	5389.45	5394.51	5389.16	5393.32	1721.0
2016-06-03 08:00:00	NQ	Futures	5393.32	5401.65	5364.46	5371.9	19363.0
2016-06-03 09:00:00	NQ	Futures	5371.3	5383.5	5352.26	5356.13	38968.0
2016-06-03 10:00:00	NQ	Futures	5355.83	5359.7	5330.24	5356.43	49645.0
2016-06-03 11:00:00	NQ	Futures	5356.43	5368.63	5347.2	5366.54	24936.0
2016-06-03 12:00:00	NQ	Futures	5366.84	5370.11	5354.34	5354.94	17639.0
2016-06-03 13:00:00	NQ	Futures	5354.64	5366.84	5354.05	5363.57	12377.0
2016-06-03 14:00:00	NQ	Futures	5363.57	5376.96	5356.13	5372.2	18673.0
2016-06-03 15:00:00	NQ	Futures	5371.9	5373.39	5363.87	5365.95	24025.0
2016-06-03 16:00:00	NQ	Futures	5365.95	5368.63	5362.68	5366.25	7180.0
2016-06-03 00:00:00	YM	Futures	19076.5	19081.8	19067.9	19073.3	314.0
2016-06-03 01:00:00	YM	Futures	19073.3	19084.0	19072.2	19078.6	418.0
2016-06-03 02:00:00	YM	Futures	19079.7	19088.3	19076.5	19084.0	936.0
2016-06-03 03:00:00	YM	Futures	19082.9	19100.0	19071.1	19076.5	2798.0
2016-06-03 04:00:00	YM	Futures	19075.4	19090.4	19066.9	19082.9	1926.0
2016-06-03 05:00:00	YM	Futures	19082.9	19087.2	19077.6	19081.8	1045.0
2016-06-03 06:00:00	YM	Futures	19084.0	19090.4	19081.8	19085.1	908.0
2016-06-03 07:00:00	YM	Futures	19086.1	19105.4	19086.1	19101.1	1481.0
2016-06-03 08:00:00	YM	Futures	19101.1	19104.3	18981.2	19008.0	20012.0
2016-06-03 09:00:00	YM	Futures	19006.9	19034.7	18952.3	18970.5	26226.0
2016-06-03 10:00:00	YM	Futures	18970.5	19009.1	18921.3	19003.7	27809.0
2016-06-03 11:00:00	YM	Futures	19004.8	19055.1	18971.6	19048.7	17183.0
2016-06-03 12:00:00	YM	Futures	19047.6	19050.8	19002.6	19004.8	9038.0
2016-06-03 13:00:00	YM	Futures	19004.8	19038.0	18996.2	19034.7	8372.0
2016-06-03 14:00:00	YM	Futures	19034.7	19075.4	19017.6	19060.4	12093.0
2016-06-03 15:00:00	YM	Futures	19059.4	19076.5	19038.0	19049.7	15076.0

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

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