PREVIEW / futures_1hour / 2021-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-31.parquet
  size:    19 KB
  rows:    418

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
2021-01-31 18:00:00	ES	Futures	4145.16	4146.85	4105.03	4128.32	48314.0
2021-01-31 19:00:00	ES	Futures	4127.76	4142.64	4127.2	4141.51	26324.0
2021-01-31 20:00:00	ES	Futures	4141.23	4152.18	4134.5	4146.28	21509.0
2021-01-31 21:00:00	ES	Futures	4146.28	4157.51	4145.44	4155.55	19219.0
2021-01-31 22:00:00	ES	Futures	4155.27	4174.91	4153.86	4173.23	19142.0
2021-01-31 23:00:00	ES	Futures	4173.23	4180.53	4168.74	4179.68	12277.0
2021-01-31 18:00:00	NQ	Futures	14875.74	14890.21	14734.78	14812.64	17019.0
2021-01-31 19:00:00	NQ	Futures	14811.48	14867.05	14801.06	14852.87	8905.0
2021-01-31 20:00:00	NQ	Futures	14852.87	14909.31	14836.37	14877.47	8556.0
2021-01-31 21:00:00	NQ	Futures	14878.05	14930.15	14873.42	14912.2	6717.0
2021-01-31 22:00:00	NQ	Futures	14913.07	14981.09	14902.94	14973.56	8122.0
2021-01-31 23:00:00	NQ	Futures	14974.14	14999.9	14952.44	14997.01	6153.0
2021-01-31 18:00:00	YM	Futures	33065.1	33070.7	32778.9	32938.7	6357.0
2021-01-31 19:00:00	YM	Futures	32935.3	33054.0	32934.2	33049.6	4269.0
2021-01-31 20:00:00	YM	Futures	33050.7	33105.0	33003.0	33071.8	3138.0
2021-01-31 21:00:00	YM	Futures	33069.5	33143.9	33066.2	33131.7	3087.0
2021-01-31 22:00:00	YM	Futures	33130.5	33262.5	33123.9	33242.6	3674.0
2021-01-31 23:00:00	YM	Futures	33239.3	33295.8	33214.8	33289.2	2366.0
2021-01-31 18:00:00	CL	Futures	35.19	35.3	34.95	35.18	9984.0
2021-01-31 19:00:00	CL	Futures	35.18	35.26	35.14	35.22	5211.0
2021-01-31 20:00:00	CL	Futures	35.22	35.37	35.11	35.28	7221.0
2021-01-31 21:00:00	CL	Futures	35.28	35.36	35.26	35.34	3363.0
2021-01-31 22:00:00	CL	Futures	35.34	35.52	35.34	35.48	5726.0
2021-01-31 23:00:00	CL	Futures	35.48	35.51	35.44	35.49	2306.0
2021-01-31 18:00:00	GC	Futures	2255.9	2261.9	2243.8	2247.9	10973.0
2021-01-31 19:00:00	GC	Futures	2247.6	2248.5	2241.4	2246.2	5784.0
2021-01-31 20:00:00	GC	Futures	2246.2	2248.0	2239.8	2244.1	8094.0
2021-01-31 21:00:00	GC	Futures	2244.0	2255.5	2244.0	2254.7	6915.0
2021-01-31 22:00:00	GC	Futures	2254.8	2257.6	2253.4	2254.1	4943.0
2021-01-31 23:00:00	GC	Futures	2254.2	2256.0	2252.8	2253.1	2663.0
2021-01-31 18:00:00	ZN	Futures	137.429807	137.523733	137.429807	137.47677	44793.0
2021-01-31 19:00:00	ZN	Futures	137.47677	137.492424	137.429807	137.445461	18035.0
2021-01-31 20:00:00	ZN	Futures	137.429807	137.445461	137.414152	137.414152	16830.0
2021-01-31 21:00:00	ZN	Futures	137.414152	137.429807	137.398498	137.414152	7908.0
2021-01-31 22:00:00	ZN	Futures	137.429807	137.429807	137.382844	137.382844	7813.0
2021-01-31 23:00:00	ZN	Futures	137.382844	137.398498	137.367189	137.382844	8289.0

> showing 36 of 418 rows — these rows as CSV

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