PREVIEW / futures_1hour / 2016-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-10.parquet
  size:    45 KB
  rows:    1,292

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-10 00:00:00	ES	Futures	2280.52	2281.6	2280.52	2280.79	1326.0
2016-06-10 01:00:00	ES	Futures	2280.79	2281.33	2280.25	2280.52	1849.0
2016-06-10 02:00:00	ES	Futures	2280.25	2281.87	2278.63	2278.9	6978.0
2016-06-10 03:00:00	ES	Futures	2278.63	2278.9	2272.42	2272.42	22623.0
2016-06-10 04:00:00	ES	Futures	2272.42	2274.58	2271.07	2272.15	15742.0
2016-06-10 05:00:00	ES	Futures	2272.15	2272.42	2268.1	2268.91	20529.0
2016-06-10 06:00:00	ES	Futures	2268.91	2271.07	2268.1	2270.26	13976.0
2016-06-10 07:00:00	ES	Futures	2270.26	2272.42	2268.91	2269.45	17073.0
2016-06-10 08:00:00	ES	Futures	2269.45	2270.26	2265.94	2266.75	28377.0
2016-06-10 09:00:00	ES	Futures	2266.75	2268.37	2263.24	2265.13	97507.0
2016-06-10 10:00:00	ES	Futures	2265.4	2271.07	2262.7	2267.83	108061.0
2016-06-10 11:00:00	ES	Futures	2267.83	2271.07	2265.67	2267.83	67563.0
2016-06-10 12:00:00	ES	Futures	2268.1	2268.64	2261.89	2265.4	45862.0
2016-06-10 13:00:00	ES	Futures	2265.4	2266.75	2258.38	2259.46	54533.0
2016-06-10 14:00:00	ES	Futures	2259.19	2259.73	2255.95	2258.11	76320.0
2016-06-10 15:00:00	ES	Futures	2258.11	2264.59	2255.41	2262.7	111347.0
2016-06-10 16:00:00	ES	Futures	2262.7	2265.13	2262.16	2263.24	40363.0
2016-06-10 00:00:00	NQ	Futures	5363.87	5366.84	5363.87	5365.06	51.0
2016-06-10 01:00:00	NQ	Futures	5364.16	5366.25	5363.57	5365.06	196.0
2016-06-10 02:00:00	NQ	Futures	5364.76	5367.14	5360.59	5361.78	411.0
2016-06-10 03:00:00	NQ	Futures	5361.78	5361.78	5338.58	5339.17	2932.0
2016-06-10 04:00:00	NQ	Futures	5339.17	5344.23	5334.41	5337.09	1436.0
2016-06-10 05:00:00	NQ	Futures	5336.79	5337.98	5327.27	5329.95	1657.0
2016-06-10 06:00:00	NQ	Futures	5329.95	5334.41	5327.57	5333.82	835.0
2016-06-10 07:00:00	NQ	Futures	5333.82	5338.87	5331.14	5331.73	1520.0
2016-06-10 08:00:00	NQ	Futures	5331.43	5335.01	5324.0	5325.48	2520.0
2016-06-10 09:00:00	NQ	Futures	5325.48	5328.46	5313.29	5320.43	15419.0
2016-06-10 10:00:00	NQ	Futures	5320.72	5332.33	5311.5	5319.24	15642.0
2016-06-10 11:00:00	NQ	Futures	5319.24	5328.76	5317.75	5324.89	7111.0
2016-06-10 12:00:00	NQ	Futures	5325.19	5326.67	5312.99	5323.4	5569.0
2016-06-10 13:00:00	NQ	Futures	5323.7	5326.08	5303.76	5305.55	7630.0
2016-06-10 14:00:00	NQ	Futures	5306.14	5306.14	5293.65	5298.11	9026.0
2016-06-10 15:00:00	NQ	Futures	5298.11	5311.8	5291.57	5310.01	9953.0
2016-06-10 16:00:00	NQ	Futures	5310.31	5317.15	5310.01	5315.07	2578.0
2016-06-10 00:00:00	YM	Futures	19215.6	19225.3	19215.6	19216.7	392.0
2016-06-10 01:00:00	YM	Futures	19216.7	19222.1	19213.5	19218.9	506.0
2016-06-10 02:00:00	YM	Futures	19218.9	19229.6	19211.3	19213.5	1258.0
2016-06-10 03:00:00	YM	Futures	19213.5	19213.5	19165.1	19165.1	3829.0
2016-06-10 04:00:00	YM	Futures	19166.1	19179.0	19152.1	19159.7	2514.0
2016-06-10 05:00:00	YM	Futures	19159.7	19164.0	19132.8	19142.5	3316.0
2016-06-10 06:00:00	YM	Futures	19141.4	19157.5	19136.0	19155.4	1580.0
2016-06-10 07:00:00	YM	Futures	19155.4	19164.0	19136.0	19139.2	2205.0
2016-06-10 08:00:00	YM	Futures	19139.2	19144.6	19114.5	19119.9	3228.0
2016-06-10 09:00:00	YM	Futures	19118.8	19136.0	19090.8	19109.1	17211.0
2016-06-10 10:00:00	YM	Futures	19111.2	19181.2	19084.3	19162.9	23920.0
2016-06-10 11:00:00	YM	Futures	19161.8	19181.2	19142.5	19164.0	13202.0
2016-06-10 12:00:00	YM	Futures	19164.0	19170.4	19115.6	19144.6	10854.0
2016-06-10 13:00:00	YM	Futures	19145.7	19155.4	19076.8	19086.5	12250.0
2016-06-10 14:00:00	YM	Futures	19086.5	19095.1	19062.8	19085.4	14764.0
2016-06-10 15:00:00	YM	Futures	19085.4	19141.4	19067.1	19124.2	14851.0

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

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