PREVIEW / futures_1hour / 2017-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-20.parquet
  size:    45 KB
  rows:    1,337

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
2017-10-20 00:00:00	ES	Futures	2810.27	2810.54	2808.63	2808.9	7382.0
2017-10-20 01:00:00	ES	Futures	2809.17	2809.17	2807.81	2808.35	6656.0
2017-10-20 02:00:00	ES	Futures	2808.35	2810.54	2807.53	2809.99	10740.0
2017-10-20 03:00:00	ES	Futures	2809.99	2810.81	2807.53	2808.63	26856.0
2017-10-20 04:00:00	ES	Futures	2808.63	2809.45	2805.34	2806.16	19220.0
2017-10-20 05:00:00	ES	Futures	2806.16	2808.63	2805.62	2807.81	13574.0
2017-10-20 06:00:00	ES	Futures	2807.53	2808.9	2806.98	2808.08	10796.0
2017-10-20 07:00:00	ES	Futures	2807.81	2808.9	2806.98	2808.35	13945.0
2017-10-20 08:00:00	ES	Futures	2808.35	2808.63	2806.71	2808.35	24479.0
2017-10-20 09:00:00	ES	Futures	2808.35	2812.18	2807.81	2809.45	201038.0
2017-10-20 10:00:00	ES	Futures	2809.17	2811.64	2807.81	2808.35	127175.0
2017-10-20 11:00:00	ES	Futures	2808.35	2810.81	2808.08	2810.54	65203.0
2017-10-20 12:00:00	ES	Futures	2810.54	2812.18	2809.99	2811.91	78692.0
2017-10-20 13:00:00	ES	Futures	2811.91	2814.92	2811.64	2813.28	76321.0
2017-10-20 14:00:00	ES	Futures	2813.55	2815.74	2813.28	2813.55	89570.0
2017-10-20 15:00:00	ES	Futures	2813.82	2815.47	2811.91	2815.19	231611.0
2017-10-20 16:00:00	ES	Futures	2815.19	2817.11	2814.64	2816.01	143752.0
2017-10-20 00:00:00	NQ	Futures	7278.67	7278.67	7274.51	7277.19	1087.0
2017-10-20 01:00:00	NQ	Futures	7277.19	7277.19	7270.34	7273.62	1582.0
2017-10-20 02:00:00	NQ	Futures	7273.02	7279.56	7270.94	7278.08	2720.0
2017-10-20 03:00:00	NQ	Futures	7278.08	7279.56	7272.43	7275.1	3841.0
2017-10-20 04:00:00	NQ	Futures	7275.1	7277.19	7260.53	7262.91	3310.0
2017-10-20 05:00:00	NQ	Futures	7262.91	7270.64	7261.42	7267.37	2178.0
2017-10-20 06:00:00	NQ	Futures	7267.07	7272.13	7263.5	7270.05	1913.0
2017-10-20 07:00:00	NQ	Futures	7269.75	7274.51	7267.97	7272.72	2592.0
2017-10-20 08:00:00	NQ	Futures	7273.02	7273.91	7267.07	7269.45	3926.0
2017-10-20 09:00:00	NQ	Futures	7269.45	7284.62	7269.45	7275.7	37638.0
2017-10-20 10:00:00	NQ	Futures	7275.7	7285.51	7262.02	7262.61	34044.0
2017-10-20 11:00:00	NQ	Futures	7262.91	7273.91	7262.31	7271.83	19930.0
2017-10-20 12:00:00	NQ	Futures	7271.83	7279.27	7270.34	7277.78	13563.0
2017-10-20 13:00:00	NQ	Futures	7277.48	7281.94	7276.59	7278.08	12511.0
2017-10-20 14:00:00	NQ	Futures	7278.38	7281.65	7271.53	7272.13	16307.0
2017-10-20 15:00:00	NQ	Futures	7272.13	7275.4	7259.94	7267.07	34189.0
2017-10-20 16:00:00	NQ	Futures	7266.78	7272.43	7266.18	7267.97	9926.0
2017-10-20 00:00:00	YM	Futures	25241.9	25241.9	25227.7	25229.9	985.0
2017-10-20 01:00:00	YM	Futures	25229.9	25233.2	25219.0	25227.7	1275.0
2017-10-20 02:00:00	YM	Futures	25227.7	25250.6	25220.1	25245.2	2463.0
2017-10-20 03:00:00	YM	Futures	25244.1	25254.9	25229.9	25237.5	2557.0
2017-10-20 04:00:00	YM	Futures	25238.6	25243.0	25213.6	25219.0	2277.0
2017-10-20 05:00:00	YM	Futures	25219.0	25245.2	25216.9	25237.5	1839.0
2017-10-20 06:00:00	YM	Futures	25237.5	25246.2	25227.7	25236.5	1263.0
2017-10-20 07:00:00	YM	Futures	25236.5	25239.7	25229.9	25231.0	1573.0
2017-10-20 08:00:00	YM	Futures	25231.0	25238.6	25220.1	25234.3	3832.0
2017-10-20 09:00:00	YM	Futures	25234.3	25253.9	25183.2	25210.3	24755.0
2017-10-20 10:00:00	YM	Futures	25210.3	25229.9	25201.6	25210.3	12435.0
2017-10-20 11:00:00	YM	Futures	25210.3	25268.0	25210.3	25268.0	8943.0
2017-10-20 12:00:00	YM	Futures	25268.0	25277.8	25253.9	25272.3	6725.0
2017-10-20 13:00:00	YM	Futures	25272.3	25303.9	25272.3	25289.7	7994.0
2017-10-20 14:00:00	YM	Futures	25289.7	25310.4	25280.0	25281.0	7773.0
2017-10-20 15:00:00	YM	Futures	25281.0	25318.0	25278.9	25315.9	12643.0

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

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