PREVIEW / futures_1hour / 2019-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-20.parquet
  size:    17 KB
  rows:    360

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-10-20 18:00:00	ES	Futures	3243.0	3249.79	3241.92	3247.08	10662.0
2019-10-20 19:00:00	ES	Futures	3247.08	3250.61	3245.99	3250.34	3849.0
2019-10-20 20:00:00	ES	Futures	3250.34	3254.68	3250.34	3253.87	9820.0
2019-10-20 21:00:00	ES	Futures	3253.87	3255.5	3252.51	3253.87	8579.0
2019-10-20 22:00:00	ES	Futures	3253.87	3256.58	3253.05	3254.68	6613.0
2019-10-20 23:00:00	ES	Futures	3254.68	3254.95	3253.87	3254.68	2920.0
2019-10-20 18:00:00	NQ	Futures	9149.64	9170.84	9139.76	9161.84	4233.0
2019-10-20 19:00:00	NQ	Futures	9162.13	9173.17	9160.67	9172.88	1818.0
2019-10-20 20:00:00	NQ	Futures	9172.88	9186.24	9172.0	9184.2	3931.0
2019-10-20 21:00:00	NQ	Futures	9183.91	9189.72	9180.43	9183.33	4240.0
2019-10-20 22:00:00	NQ	Futures	9183.33	9191.18	9180.14	9184.79	3384.0
2019-10-20 23:00:00	NQ	Futures	9185.08	9187.4	9182.75	9185.37	1389.0
2019-10-20 18:00:00	YM	Futures	29086.2	29141.7	29075.3	29115.6	1756.0
2019-10-20 19:00:00	YM	Futures	29115.6	29151.5	29108.0	29150.4	705.0
2019-10-20 20:00:00	YM	Futures	29149.3	29184.2	29146.1	29177.6	1814.0
2019-10-20 21:00:00	YM	Futures	29177.6	29189.6	29165.7	29178.7	1557.0
2019-10-20 22:00:00	YM	Futures	29177.6	29199.4	29172.2	29182.0	1028.0
2019-10-20 23:00:00	YM	Futures	29182.0	29186.3	29175.5	29182.0	425.0
2019-10-20 18:00:00	CL	Futures	47.77	47.77	47.43	47.66	3107.0
2019-10-20 19:00:00	CL	Futures	47.66	47.68	47.62	47.63	1232.0
2019-10-20 20:00:00	CL	Futures	47.63	47.74	47.62	47.74	2496.0
2019-10-20 21:00:00	CL	Futures	47.74	47.79	47.65	47.73	4218.0
2019-10-20 22:00:00	CL	Futures	47.74	47.78	47.69	47.74	2608.0
2019-10-20 23:00:00	CL	Futures	47.74	47.75	47.71	47.72	1231.0
2019-10-20 18:00:00	GC	Futures	1894.7	1895.2	1892.7	1893.8	2722.0
2019-10-20 19:00:00	GC	Futures	1893.7	1894.6	1893.1	1894.2	1153.0
2019-10-20 20:00:00	GC	Futures	1894.1	1894.7	1892.3	1892.8	3011.0
2019-10-20 21:00:00	GC	Futures	1892.9	1893.8	1890.9	1891.6	6598.0
2019-10-20 22:00:00	GC	Futures	1891.4	1892.4	1891.0	1892.3	2574.0
2019-10-20 23:00:00	GC	Futures	1892.3	1892.9	1891.8	1892.4	1730.0
2019-10-20 18:00:00	ZN	Futures	130.170217	130.201485	130.123315	130.154583	12085.0
2019-10-20 19:00:00	ZN	Futures	130.154583	130.201485	130.138949	130.170217	3919.0
2019-10-20 20:00:00	ZN	Futures	130.154583	130.185851	130.076412	130.076412	11611.0
2019-10-20 21:00:00	ZN	Futures	130.092046	130.092046	130.013875	130.076412	15897.0
2019-10-20 22:00:00	ZN	Futures	130.060778	130.092046	130.013875	130.045144	3198.0
2019-10-20 23:00:00	ZN	Futures	130.045144	130.045144	129.998241	130.013875	4037.0

> showing 36 of 360 rows — these rows as CSV

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