PREVIEW / futures_1hour / 2020-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-19.parquet
  size:    15 KB
  rows:    320

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
2020-01-19 18:00:00	ES	Futures	3604.2	3607.4	3602.3	3607.4	8611.0
2020-01-19 19:00:00	ES	Futures	3607.4	3608.0	3605.0	3606.3	5377.0
2020-01-19 20:00:00	ES	Futures	3606.3	3607.2	3605.3	3606.1	4055.0
2020-01-19 21:00:00	ES	Futures	3606.1	3606.9	3605.0	3605.5	3156.0
2020-01-19 22:00:00	ES	Futures	3605.5	3606.3	3605.3	3606.1	2114.0
2020-01-19 23:00:00	ES	Futures	3606.1	3606.3	3605.3	3605.5	988.0
2020-01-19 18:00:00	NQ	Futures	10611.5	10623.94	10604.56	10623.65	4243.0
2020-01-19 19:00:00	NQ	Futures	10623.94	10626.54	10614.39	10620.76	3978.0
2020-01-19 20:00:00	NQ	Futures	10620.76	10623.36	10616.42	10619.6	2609.0
2020-01-19 21:00:00	NQ	Futures	10619.89	10620.18	10614.97	10617.86	1758.0
2020-01-19 22:00:00	NQ	Futures	10617.29	10620.18	10617.0	10618.73	1039.0
2020-01-19 23:00:00	NQ	Futures	10618.73	10619.89	10617.0	10617.58	470.0
2020-01-19 18:00:00	YM	Futures	31878.4	31906.7	31859.9	31906.7	1684.0
2020-01-19 19:00:00	YM	Futures	31907.8	31919.8	31891.4	31901.2	1879.0
2020-01-19 20:00:00	YM	Futures	31902.3	31908.9	31893.6	31900.2	772.0
2020-01-19 21:00:00	YM	Futures	31902.3	31906.7	31889.3	31895.8	684.0
2020-01-19 22:00:00	YM	Futures	31894.7	31905.6	31893.6	31902.3	494.0
2020-01-19 23:00:00	YM	Futures	31902.3	31905.6	31898.0	31899.1	325.0
2020-01-19 18:00:00	CL	Futures	52.58	52.95	52.4	52.5	11969.0
2020-01-19 19:00:00	CL	Futures	52.51	52.54	52.44	52.48	3215.0
2020-01-19 20:00:00	CL	Futures	52.47	52.47	52.33	52.43	6496.0
2020-01-19 21:00:00	CL	Futures	52.43	52.47	52.37	52.41	2147.0
2020-01-19 22:00:00	CL	Futures	52.4	52.43	52.38	52.42	1241.0
2020-01-19 23:00:00	CL	Futures	52.42	52.46	52.38	52.46	1729.0
2020-01-19 18:00:00	GC	Futures	1963.5	1965.7	1961.7	1963.2	3400.0
2020-01-19 19:00:00	GC	Futures	1963.2	1964.7	1962.7	1963.0	2684.0
2020-01-19 20:00:00	GC	Futures	1963.0	1965.4	1962.6	1963.9	4085.0
2020-01-19 21:00:00	GC	Futures	1963.9	1964.5	1963.0	1964.1	2545.0
2020-01-19 22:00:00	GC	Futures	1964.1	1965.5	1964.0	1965.4	2316.0
2020-01-19 23:00:00	GC	Futures	1965.4	1966.6	1965.4	1966.4	1586.0
2020-01-19 18:00:00	ZN	Futures	129.279215	129.326146	129.263571	129.310502	6376.0
2020-01-19 19:00:00	ZN	Futures	129.294859	129.310502	129.279215	129.279215	2688.0
2020-01-19 20:00:00	ZN	Futures	129.263571	129.310502	129.263571	129.294859	1924.0
2020-01-19 21:00:00	ZN	Futures	129.294859	129.326146	129.294859	129.310502	1490.0
2020-01-19 22:00:00	ZN	Futures	129.326146	129.326146	129.294859	129.326146	2293.0
2020-01-19 23:00:00	ZN	Futures	129.310502	129.326146	129.294859	129.310502	533.0

> showing 36 of 320 rows — these rows as CSV

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