PREVIEW / futures_1hour / 2016-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-01.parquet
  size:    46 KB
  rows:    1,330

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-07-01 00:00:00	ES	Futures	2265.22	2266.03	2264.41	2264.68	2892.0
2016-07-01 01:00:00	ES	Futures	2264.95	2265.22	2263.32	2265.22	4004.0
2016-07-01 02:00:00	ES	Futures	2265.22	2265.22	2261.97	2263.59	12218.0
2016-07-01 03:00:00	ES	Futures	2263.86	2264.95	2257.9	2261.42	53229.0
2016-07-01 04:00:00	ES	Futures	2261.42	2264.14	2259.8	2260.07	31625.0
2016-07-01 05:00:00	ES	Futures	2260.34	2261.42	2258.98	2261.15	18546.0
2016-07-01 06:00:00	ES	Futures	2261.15	2265.22	2258.98	2264.68	21883.0
2016-07-01 07:00:00	ES	Futures	2264.41	2268.75	2263.86	2268.2	40248.0
2016-07-01 08:00:00	ES	Futures	2268.2	2268.47	2265.49	2266.03	29852.0
2016-07-01 09:00:00	ES	Futures	2265.76	2274.98	2265.49	2273.63	227903.0
2016-07-01 10:00:00	ES	Futures	2274.17	2278.78	2273.9	2277.69	278988.0
2016-07-01 11:00:00	ES	Futures	2277.69	2278.51	2272.54	2274.71	207317.0
2016-07-01 12:00:00	ES	Futures	2274.71	2275.53	2270.37	2272.54	136315.0
2016-07-01 13:00:00	ES	Futures	2272.54	2274.98	2269.02	2271.46	115131.0
2016-07-01 14:00:00	ES	Futures	2271.46	2272.81	2268.2	2270.64	102357.0
2016-07-01 15:00:00	ES	Futures	2270.37	2275.53	2270.1	2271.46	245490.0
2016-07-01 16:00:00	ES	Futures	2271.46	2274.71	2270.37	2273.9	79944.0
2016-07-01 00:00:00	NQ	Futures	5246.6	5249.58	5246.3	5248.09	371.0
2016-07-01 01:00:00	NQ	Futures	5247.79	5248.09	5243.92	5248.09	485.0
2016-07-01 02:00:00	NQ	Futures	5248.39	5248.69	5240.04	5243.03	1517.0
2016-07-01 03:00:00	NQ	Futures	5243.03	5246.3	5229.31	5238.85	4888.0
2016-07-01 04:00:00	NQ	Futures	5239.15	5245.11	5234.38	5237.96	2640.0
2016-07-01 05:00:00	NQ	Futures	5237.36	5240.94	5235.57	5239.75	1420.0
2016-07-01 06:00:00	NQ	Futures	5240.34	5248.09	5234.98	5246.6	1752.0
2016-07-01 07:00:00	NQ	Futures	5246.01	5258.52	5244.81	5257.03	3727.0
2016-07-01 08:00:00	NQ	Futures	5256.74	5257.03	5250.77	5251.07	2351.0
2016-07-01 09:00:00	NQ	Futures	5251.07	5285.35	5249.88	5282.67	26008.0
2016-07-01 10:00:00	NQ	Futures	5282.67	5300.25	5282.67	5298.16	32672.0
2016-07-01 11:00:00	NQ	Futures	5298.16	5300.85	5284.16	5291.31	22235.0
2016-07-01 12:00:00	NQ	Futures	5291.01	5293.1	5279.98	5285.94	15488.0
2016-07-01 13:00:00	NQ	Futures	5285.35	5291.61	5273.13	5278.79	15088.0
2016-07-01 14:00:00	NQ	Futures	5278.79	5282.37	5269.85	5278.49	12968.0
2016-07-01 15:00:00	NQ	Futures	5278.49	5289.22	5276.41	5279.39	24566.0
2016-07-01 16:00:00	NQ	Futures	5279.39	5287.14	5277.9	5286.54	5493.0
2016-07-01 00:00:00	YM	Futures	19164.0	19169.4	19157.5	19160.8	475.0
2016-07-01 01:00:00	YM	Futures	19160.8	19166.1	19147.8	19165.1	713.0
2016-07-01 02:00:00	YM	Futures	19165.1	19167.2	19137.1	19146.8	1854.0
2016-07-01 03:00:00	YM	Futures	19147.8	19155.4	19115.6	19141.4	6614.0
2016-07-01 04:00:00	YM	Futures	19140.3	19159.7	19120.9	19128.5	3767.0
2016-07-01 05:00:00	YM	Futures	19127.4	19141.4	19120.9	19134.9	1929.0
2016-07-01 06:00:00	YM	Futures	19134.9	19162.9	19119.9	19158.6	2011.0
2016-07-01 07:00:00	YM	Futures	19157.5	19199.5	19154.3	19194.1	3854.0
2016-07-01 08:00:00	YM	Futures	19194.1	19194.1	19161.8	19165.1	3213.0
2016-07-01 09:00:00	YM	Futures	19164.0	19236.1	19161.8	19226.4	15936.0
2016-07-01 10:00:00	YM	Futures	19227.5	19267.3	19226.4	19250.1	20119.0
2016-07-01 11:00:00	YM	Futures	19250.1	19258.7	19214.6	19240.4	13150.0
2016-07-01 12:00:00	YM	Futures	19239.3	19246.9	19201.6	19223.2	8138.0
2016-07-01 13:00:00	YM	Futures	19222.1	19239.3	19194.1	19212.4	7158.0
2016-07-01 14:00:00	YM	Futures	19213.5	19222.1	19185.5	19207.0	7050.0
2016-07-01 15:00:00	YM	Futures	19207.0	19236.1	19197.3	19207.0	11872.0

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

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