PREVIEW / futures_1hour / 2017-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-06.parquet
  size:    51 KB
  rows:    1,602

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-09-06 00:00:00	ES	Futures	2689.93	2689.93	2687.47	2687.74	3634.0
2017-09-06 01:00:00	ES	Futures	2688.02	2689.66	2687.74	2689.11	3969.0
2017-09-06 02:00:00	ES	Futures	2689.38	2691.84	2689.11	2689.93	12683.0
2017-09-06 03:00:00	ES	Futures	2690.2	2692.94	2688.02	2692.66	25104.0
2017-09-06 04:00:00	ES	Futures	2692.66	2693.21	2689.66	2690.75	14815.0
2017-09-06 05:00:00	ES	Futures	2690.75	2691.02	2685.83	2690.75	28353.0
2017-09-06 06:00:00	ES	Futures	2690.48	2690.75	2688.02	2689.11	13955.0
2017-09-06 07:00:00	ES	Futures	2689.11	2693.21	2688.84	2692.66	17774.0
2017-09-06 08:00:00	ES	Futures	2692.66	2695.67	2692.66	2694.85	29898.0
2017-09-06 09:00:00	ES	Futures	2694.85	2696.49	2691.84	2693.48	183948.0
2017-09-06 10:00:00	ES	Futures	2693.48	2697.31	2688.02	2692.94	271823.0
2017-09-06 11:00:00	ES	Futures	2692.66	2693.76	2687.74	2691.84	130488.0
2017-09-06 12:00:00	ES	Futures	2691.84	2694.85	2689.93	2694.3	97671.0
2017-09-06 13:00:00	ES	Futures	2694.58	2696.76	2694.03	2695.12	88067.0
2017-09-06 14:00:00	ES	Futures	2694.85	2698.4	2694.85	2697.04	112600.0
2017-09-06 15:00:00	ES	Futures	2697.31	2699.5	2694.03	2695.4	230677.0
2017-09-06 16:00:00	ES	Futures	2695.12	2696.22	2694.03	2694.3	87995.0
2017-09-06 18:00:00	ES	Futures	2694.03	2694.03	2686.92	2690.2	11990.0
2017-09-06 19:00:00	ES	Futures	2689.93	2691.84	2689.93	2691.3	4051.0
2017-09-06 20:00:00	ES	Futures	2691.02	2693.76	2690.2	2693.48	13847.0
2017-09-06 21:00:00	ES	Futures	2693.48	2694.58	2692.39	2692.94	6521.0
2017-09-06 22:00:00	ES	Futures	2693.21	2693.76	2691.84	2692.39	4000.0
2017-09-06 23:00:00	ES	Futures	2692.66	2693.48	2692.39	2692.39	2262.0
2017-09-06 00:00:00	NQ	Futures	7078.14	7078.74	7072.19	7073.38	1408.0
2017-09-06 01:00:00	NQ	Futures	7073.68	7079.33	7073.08	7078.74	1242.0
2017-09-06 02:00:00	NQ	Futures	7079.04	7086.18	7078.44	7080.82	1860.0
2017-09-06 03:00:00	NQ	Futures	7081.12	7095.71	7073.97	7092.43	5021.0
2017-09-06 04:00:00	NQ	Futures	7092.43	7095.71	7083.8	7087.67	2232.0
2017-09-06 05:00:00	NQ	Futures	7087.97	7089.46	7071.59	7087.97	4507.0
2017-09-06 06:00:00	NQ	Futures	7087.97	7088.27	7077.84	7081.42	3654.0
2017-09-06 07:00:00	NQ	Futures	7081.12	7092.73	7081.12	7090.35	4743.0
2017-09-06 08:00:00	NQ	Futures	7090.35	7094.22	7087.37	7091.84	6825.0
2017-09-06 09:00:00	NQ	Futures	7091.84	7100.18	7071.89	7082.01	41513.0
2017-09-06 10:00:00	NQ	Futures	7082.01	7091.84	7045.39	7064.15	70847.0
2017-09-06 11:00:00	NQ	Futures	7063.85	7068.91	7037.95	7066.53	40989.0
2017-09-06 12:00:00	NQ	Futures	7066.23	7083.2	7062.36	7082.61	33993.0
2017-09-06 13:00:00	NQ	Futures	7082.61	7091.54	7081.42	7085.29	22108.0
2017-09-06 14:00:00	NQ	Futures	7084.99	7099.58	7084.69	7091.24	23078.0
2017-09-06 15:00:00	NQ	Futures	7091.54	7105.24	7086.78	7088.86	32361.0
2017-09-06 16:00:00	NQ	Futures	7088.56	7094.22	7087.37	7088.86	5812.0
2017-09-06 18:00:00	NQ	Futures	7088.86	7089.75	7065.34	7076.95	2957.0
2017-09-06 19:00:00	NQ	Futures	7076.95	7081.72	7076.65	7080.23	958.0
2017-09-06 20:00:00	NQ	Futures	7079.93	7088.86	7077.25	7087.67	5666.0
2017-09-06 21:00:00	NQ	Futures	7087.97	7090.95	7083.8	7087.97	7367.0
2017-09-06 22:00:00	NQ	Futures	7087.67	7088.27	7083.8	7084.4	1111.0
2017-09-06 23:00:00	NQ	Futures	7083.8	7087.97	7083.2	7085.88	932.0
2017-09-06 00:00:00	YM	Futures	23695.2	23701.7	23668.0	23676.7	3484.0
2017-09-06 01:00:00	YM	Futures	23677.7	23701.7	23676.7	23695.2	2250.0
2017-09-06 02:00:00	YM	Futures	23695.2	23707.1	23689.7	23691.9	1826.0
2017-09-06 03:00:00	YM	Futures	23691.9	23713.7	23675.6	23710.4	2615.0

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

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