PREVIEW / futures_1hour / 2020-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-29.parquet
  size:    18 KB
  rows:    361

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-03-29 18:00:00	ES	Futures	2699.14	2742.22	2683.77	2713.68	59701.0
2020-03-29 19:00:00	ES	Futures	2713.13	2740.3	2708.19	2729.6	28294.0
2020-03-29 20:00:00	ES	Futures	2729.6	2746.34	2724.39	2732.34	31044.0
2020-03-29 21:00:00	ES	Futures	2732.89	2743.05	2723.84	2737.56	23513.0
2020-03-29 22:00:00	ES	Futures	2737.56	2754.02	2734.26	2742.5	20493.0
2020-03-29 23:00:00	ES	Futures	2742.5	2761.98	2735.09	2758.96	15950.0
2020-03-29 18:00:00	NQ	Futures	8450.11	8577.5	8414.97	8502.38	12161.0
2020-03-29 19:00:00	NQ	Futures	8503.52	8562.08	8489.81	8529.23	5022.0
2020-03-29 20:00:00	NQ	Futures	8531.51	8569.22	8518.66	8540.66	4848.0
2020-03-29 21:00:00	NQ	Futures	8544.08	8568.65	8519.52	8558.36	3951.0
2020-03-29 22:00:00	NQ	Futures	8557.22	8620.63	8549.8	8590.36	4937.0
2020-03-29 23:00:00	NQ	Futures	8591.78	8631.77	8572.65	8621.78	3546.0
2020-03-29 18:00:00	YM	Futures	22920.6	23268.9	22758.5	23041.1	6946.0
2020-03-29 19:00:00	YM	Futures	23042.2	23243.7	22995.1	23140.8	2564.0
2020-03-29 20:00:00	YM	Futures	23151.7	23306.2	23107.9	23175.8	2458.0
2020-03-29 21:00:00	YM	Futures	23181.3	23251.4	23077.2	23205.4	1672.0
2020-03-29 22:00:00	YM	Futures	23199.9	23344.5	23179.1	23242.6	1653.0
2020-03-29 23:00:00	YM	Futures	23239.4	23409.1	23183.5	23383.9	1622.0
2020-03-29 18:00:00	CL	Futures	18.59	18.59	17.69	18.02	27266.0
2020-03-29 19:00:00	CL	Futures	18.02	18.16	17.95	18.05	7440.0
2020-03-29 20:00:00	CL	Futures	18.05	18.51	18.05	18.39	16387.0
2020-03-29 21:00:00	CL	Futures	18.39	18.43	18.02	18.07	16557.0
2020-03-29 22:00:00	CL	Futures	18.07	18.22	18.03	18.08	10895.0
2020-03-29 23:00:00	CL	Futures	18.08	18.24	17.98	18.2	7496.0
2020-03-29 18:00:00	GC	Futures	2075.5	2088.2	2066.3	2071.2	6331.0
2020-03-29 19:00:00	GC	Futures	2070.8	2084.4	2070.7	2075.1	3529.0
2020-03-29 20:00:00	GC	Futures	2075.0	2078.9	2065.2	2068.3	4032.0
2020-03-29 21:00:00	GC	Futures	2067.9	2068.4	2059.2	2062.3	6842.0
2020-03-29 22:00:00	GC	Futures	2062.4	2063.5	2053.8	2059.5	6183.0
2020-03-29 23:00:00	GC	Futures	2059.8	2060.9	2050.4	2053.3	3493.0
2020-03-29 18:00:00	ZN	Futures	138.114923	138.130457	137.944046	138.006183	10794.0
2020-03-29 19:00:00	ZN	Futures	138.021717	138.037252	137.95958	138.037252	3438.0
2020-03-29 20:00:00	ZN	Futures	138.021717	138.099389	138.006183	138.099389	11433.0
2020-03-29 21:00:00	ZN	Futures	138.083854	138.145991	138.052786	138.083854	11351.0
2020-03-29 22:00:00	ZN	Futures	138.099389	138.114923	137.990649	138.021717	8940.0
2020-03-29 23:00:00	ZN	Futures	138.021717	138.052786	137.975115	137.975115	6961.0

> showing 36 of 361 rows — these rows as CSV

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