PREVIEW / futures_1hour / 2019-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-22.parquet
  size:    17 KB
  rows:    347

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-09-22 18:00:00	ES	Futures	3254.95	3268.54	3254.95	3264.73	21010.0
2019-09-22 19:00:00	ES	Futures	3264.73	3265.55	3262.29	3262.83	4778.0
2019-09-22 20:00:00	ES	Futures	3262.83	3265.0	3261.47	3263.65	4983.0
2019-09-22 21:00:00	ES	Futures	3263.65	3266.36	3260.66	3260.66	7564.0
2019-09-22 22:00:00	ES	Futures	3260.66	3263.1	3258.76	3260.39	7123.0
2019-09-22 23:00:00	ES	Futures	3260.39	3261.74	3259.84	3260.93	2721.0
2019-09-22 18:00:00	NQ	Futures	9108.97	9176.65	9108.97	9160.38	9507.0
2019-09-22 19:00:00	NQ	Futures	9160.67	9166.78	9150.22	9152.54	2639.0
2019-09-22 20:00:00	NQ	Futures	9152.25	9160.97	9149.35	9153.7	2402.0
2019-09-22 21:00:00	NQ	Futures	9153.99	9166.78	9141.5	9142.08	4284.0
2019-09-22 22:00:00	NQ	Futures	9142.08	9148.18	9134.82	9140.05	4139.0
2019-09-22 23:00:00	NQ	Futures	9140.05	9144.41	9135.98	9141.79	1691.0
2019-09-22 18:00:00	YM	Futures	29301.7	29434.5	29301.7	29400.7	4346.0
2019-09-22 19:00:00	YM	Futures	29400.7	29409.5	29381.2	29389.9	1041.0
2019-09-22 20:00:00	YM	Futures	29388.8	29412.7	29380.1	29396.4	1116.0
2019-09-22 21:00:00	YM	Futures	29395.3	29425.8	29375.7	29377.9	1568.0
2019-09-22 22:00:00	YM	Futures	29375.7	29395.3	29361.6	29373.5	1510.0
2019-09-22 23:00:00	YM	Futures	29372.5	29385.5	29368.1	29377.9	610.0
2019-09-22 18:00:00	CL	Futures	52.64	52.76	52.15	52.19	10270.0
2019-09-22 19:00:00	CL	Futures	52.19	52.25	52.11	52.13	2064.0
2019-09-22 20:00:00	CL	Futures	52.13	52.22	52.11	52.21	2695.0
2019-09-22 21:00:00	CL	Futures	52.21	52.3	52.13	52.14	5086.0
2019-09-22 22:00:00	CL	Futures	52.13	52.14	52.02	52.11	6111.0
2019-09-22 23:00:00	CL	Futures	52.11	52.17	52.05	52.14	3276.0
2019-09-22 18:00:00	GC	Futures	1927.5	1928.4	1923.0	1926.8	8291.0
2019-09-22 19:00:00	GC	Futures	1926.8	1927.9	1925.8	1927.9	2596.0
2019-09-22 20:00:00	GC	Futures	1927.8	1928.8	1927.2	1927.5	4348.0
2019-09-22 21:00:00	GC	Futures	1927.5	1932.7	1924.4	1932.7	18373.0
2019-09-22 22:00:00	GC	Futures	1932.7	1934.5	1930.4	1931.8	14095.0
2019-09-22 23:00:00	GC	Futures	1931.7	1931.7	1929.7	1931.0	3695.0
2019-09-22 18:00:00	ZN	Futures	129.841899	129.873168	129.654289	129.779362	27627.0
2019-09-22 19:00:00	ZN	Futures	129.779362	129.810631	129.763728	129.779362	4626.0
2019-09-22 20:00:00	ZN	Futures	129.794997	129.810631	129.748094	129.763728	7435.0
2019-09-22 21:00:00	ZN	Futures	129.763728	129.888802	129.73246	129.888802	9367.0
2019-09-22 22:00:00	ZN	Futures	129.888802	129.92007	129.857533	129.888802	7951.0
2019-09-22 23:00:00	ZN	Futures	129.904436	129.92007	129.873168	129.92007	3364.0

> showing 36 of 347 rows — these rows as CSV

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