PREVIEW / futures_1hour / 2017-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-28.parquet
  size:    52 KB
  rows:    1,616

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-28 00:00:00	ES	Futures	2740.24	2741.06	2739.96	2741.06	2112.0
2017-09-28 01:00:00	ES	Futures	2740.78	2741.6	2740.51	2741.06	5615.0
2017-09-28 02:00:00	ES	Futures	2741.33	2741.33	2739.69	2740.24	9841.0
2017-09-28 03:00:00	ES	Futures	2740.24	2740.51	2738.05	2739.14	21366.0
2017-09-28 04:00:00	ES	Futures	2739.14	2740.24	2738.05	2739.42	18781.0
2017-09-28 05:00:00	ES	Futures	2739.42	2740.24	2738.32	2738.87	11706.0
2017-09-28 06:00:00	ES	Futures	2738.87	2739.96	2738.32	2738.87	7853.0
2017-09-28 07:00:00	ES	Futures	2738.6	2739.14	2735.31	2736.41	20322.0
2017-09-28 08:00:00	ES	Futures	2736.41	2736.68	2734.49	2736.68	31724.0
2017-09-28 09:00:00	ES	Futures	2736.68	2739.96	2735.59	2738.05	189156.0
2017-09-28 10:00:00	ES	Futures	2738.05	2741.88	2735.59	2739.69	175165.0
2017-09-28 11:00:00	ES	Futures	2739.69	2742.15	2738.32	2740.24	120051.0
2017-09-28 12:00:00	ES	Futures	2740.24	2743.25	2739.69	2742.43	96511.0
2017-09-28 13:00:00	ES	Futures	2742.7	2744.34	2741.6	2744.34	58563.0
2017-09-28 14:00:00	ES	Futures	2744.07	2744.61	2741.6	2742.43	62173.0
2017-09-28 15:00:00	ES	Futures	2742.7	2743.79	2740.51	2743.25	173949.0
2017-09-28 16:00:00	ES	Futures	2743.52	2744.61	2742.7	2743.79	60603.0
2017-09-28 18:00:00	ES	Futures	2744.07	2744.07	2741.88	2742.15	7805.0
2017-09-28 19:00:00	ES	Futures	2742.15	2742.43	2741.6	2741.88	3487.0
2017-09-28 20:00:00	ES	Futures	2741.88	2742.97	2741.6	2742.7	6974.0
2017-09-28 21:00:00	ES	Futures	2742.7	2743.25	2742.15	2742.7	9168.0
2017-09-28 22:00:00	ES	Futures	2742.7	2743.25	2742.43	2742.7	4935.0
2017-09-28 23:00:00	ES	Futures	2742.7	2743.25	2742.43	2743.25	4957.0
2017-09-28 00:00:00	NQ	Futures	7068.99	7075.24	7068.7	7074.94	1007.0
2017-09-28 01:00:00	NQ	Futures	7074.64	7076.43	7072.27	7075.24	2149.0
2017-09-28 02:00:00	NQ	Futures	7074.94	7075.24	7068.99	7070.78	1865.0
2017-09-28 03:00:00	NQ	Futures	7071.08	7072.27	7059.77	7064.24	3651.0
2017-09-28 04:00:00	NQ	Futures	7064.24	7067.21	7061.26	7065.13	3845.0
2017-09-28 05:00:00	NQ	Futures	7065.43	7067.8	7060.96	7063.94	2480.0
2017-09-28 06:00:00	NQ	Futures	7063.64	7066.32	7059.48	7060.37	2789.0
2017-09-28 07:00:00	NQ	Futures	7060.37	7063.05	7045.5	7047.88	3975.0
2017-09-28 08:00:00	NQ	Futures	7047.88	7048.17	7038.95	7047.88	8818.0
2017-09-28 09:00:00	NQ	Futures	7047.88	7057.69	7032.41	7052.64	54808.0
2017-09-28 10:00:00	NQ	Futures	7052.64	7070.48	7041.93	7055.02	54111.0
2017-09-28 11:00:00	NQ	Futures	7055.31	7059.48	7045.5	7049.07	32873.0
2017-09-28 12:00:00	NQ	Futures	7049.36	7060.07	7045.2	7054.42	18241.0
2017-09-28 13:00:00	NQ	Futures	7054.42	7066.61	7047.88	7063.34	15941.0
2017-09-28 14:00:00	NQ	Futures	7063.34	7064.83	7050.26	7055.02	14793.0
2017-09-28 15:00:00	NQ	Futures	7055.02	7063.94	7046.09	7062.75	31019.0
2017-09-28 16:00:00	NQ	Futures	7062.45	7068.4	7061.56	7066.61	7008.0
2017-09-28 18:00:00	NQ	Futures	7065.72	7065.72	7059.77	7061.26	1247.0
2017-09-28 19:00:00	NQ	Futures	7061.26	7062.15	7059.18	7059.77	655.0
2017-09-28 20:00:00	NQ	Futures	7059.48	7063.94	7059.48	7063.34	1423.0
2017-09-28 21:00:00	NQ	Futures	7063.34	7066.61	7062.45	7065.13	1861.0
2017-09-28 22:00:00	NQ	Futures	7064.83	7066.61	7062.45	7066.02	1000.0
2017-09-28 23:00:00	NQ	Futures	7066.32	7068.4	7065.13	7067.21	1009.0
2017-09-28 00:00:00	YM	Futures	24247.7	24253.2	24245.6	24253.2	668.0
2017-09-28 01:00:00	YM	Futures	24253.2	24264.1	24247.7	24260.8	2043.0
2017-09-28 02:00:00	YM	Futures	24259.7	24261.9	24240.1	24244.5	1558.0
2017-09-28 03:00:00	YM	Futures	24245.6	24247.7	24224.9	24233.6	1936.0

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

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