PREVIEW / futures_1hour / 2019-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-21.parquet
  size:    16 KB
  rows:    352

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
2019-07-21 18:00:00	ES	Futures	3220.85	3224.37	3218.68	3223.83	10891.0
2019-07-21 19:00:00	ES	Futures	3223.83	3227.35	3223.83	3225.99	6694.0
2019-07-21 20:00:00	ES	Futures	3225.99	3226.8	3221.66	3222.47	13543.0
2019-07-21 21:00:00	ES	Futures	3222.74	3225.18	3220.85	3222.2	16114.0
2019-07-21 22:00:00	ES	Futures	3222.2	3224.37	3221.39	3222.74	8240.0
2019-07-21 23:00:00	ES	Futures	3222.74	3223.56	3222.2	3222.74	3946.0
2019-07-21 18:00:00	NQ	Futures	9087.26	9107.57	9082.91	9105.54	5224.0
2019-07-21 19:00:00	NQ	Futures	9105.83	9115.4	9104.67	9111.34	2604.0
2019-07-21 20:00:00	NQ	Futures	9111.63	9114.24	9095.68	9098.87	4992.0
2019-07-21 21:00:00	NQ	Futures	9099.16	9106.41	9090.45	9095.39	6166.0
2019-07-21 22:00:00	NQ	Futures	9095.68	9102.35	9092.77	9097.71	2872.0
2019-07-21 23:00:00	NQ	Futures	9097.42	9100.61	9095.68	9097.42	1316.0
2019-07-21 18:00:00	YM	Futures	29477.8	29521.3	29463.6	29519.1	2959.0
2019-07-21 19:00:00	YM	Futures	29516.9	29538.7	29508.2	29527.8	1115.0
2019-07-21 20:00:00	YM	Futures	29528.9	29536.5	29490.8	29500.6	2339.0
2019-07-21 21:00:00	YM	Futures	29503.9	29528.9	29490.8	29506.1	2406.0
2019-07-21 22:00:00	YM	Futures	29505.0	29523.5	29498.4	29512.6	1646.0
2019-07-21 23:00:00	YM	Futures	29512.6	29518.0	29506.1	29509.3	652.0
2019-07-21 18:00:00	CL	Futures	49.89	50.25	49.8	49.96	6686.0
2019-07-21 19:00:00	CL	Futures	49.96	49.98	49.88	49.93	1825.0
2019-07-21 20:00:00	CL	Futures	49.93	49.95	49.61	49.7	9085.0
2019-07-21 21:00:00	CL	Futures	49.71	50.08	49.6	50.02	18110.0
2019-07-21 22:00:00	CL	Futures	50.02	50.04	49.88	50.01	7241.0
2019-07-21 23:00:00	CL	Futures	50.02	50.04	49.9	49.95	3591.0
2019-07-21 18:00:00	GC	Futures	1826.2	1827.3	1821.2	1822.5	4339.0
2019-07-21 19:00:00	GC	Futures	1822.5	1824.7	1821.0	1822.9	3087.0
2019-07-21 20:00:00	GC	Futures	1822.9	1825.3	1821.9	1822.2	4885.0
2019-07-21 21:00:00	GC	Futures	1822.2	1824.5	1819.2	1824.2	14352.0
2019-07-21 22:00:00	GC	Futures	1824.0	1827.6	1823.5	1826.2	9871.0
2019-07-21 23:00:00	GC	Futures	1826.2	1826.8	1824.3	1825.3	4525.0
2019-07-21 18:00:00	ZN	Futures	128.261356	128.292797	128.182755	128.198476	11569.0
2019-07-21 19:00:00	ZN	Futures	128.182755	128.198476	128.151315	128.198476	7283.0
2019-07-21 20:00:00	ZN	Futures	128.198476	128.229916	128.198476	128.214196	8900.0
2019-07-21 21:00:00	ZN	Futures	128.214196	128.214196	128.119874	128.167035	14809.0
2019-07-21 22:00:00	ZN	Futures	128.167035	128.214196	128.151315	128.198476	3543.0
2019-07-21 23:00:00	ZN	Futures	128.214196	128.245636	128.214196	128.229916	3333.0

> showing 36 of 352 rows — these rows as CSV

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