PREVIEW / futures_1hour / 2019-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-24.parquet
  size:    16 KB
  rows:    344

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-03-24 18:00:00	ES	Futures	3050.44	3056.41	3046.11	3048.27	18764.0
2019-03-24 19:00:00	ES	Futures	3048.55	3050.44	3046.65	3048.27	8020.0
2019-03-24 20:00:00	ES	Futures	3048.27	3049.36	3029.3	3030.38	44362.0
2019-03-24 21:00:00	ES	Futures	3030.65	3036.35	3027.13	3035.53	29625.0
2019-03-24 22:00:00	ES	Futures	3035.8	3037.43	3030.38	3035.26	15871.0
2019-03-24 23:00:00	ES	Futures	3034.99	3035.26	3032.01	3034.45	8582.0
2019-03-24 18:00:00	NQ	Futures	8585.9	8607.16	8572.22	8578.33	7058.0
2019-03-24 19:00:00	NQ	Futures	8578.33	8583.28	8571.63	8576.87	3351.0
2019-03-24 20:00:00	NQ	Futures	8576.0	8579.2	8505.83	8509.04	18935.0
2019-03-24 21:00:00	NQ	Futures	8509.04	8527.38	8495.64	8525.05	12786.0
2019-03-24 22:00:00	NQ	Futures	8525.34	8531.45	8506.71	8523.59	7715.0
2019-03-24 23:00:00	NQ	Futures	8523.59	8524.76	8513.69	8523.01	3578.0
2019-03-24 18:00:00	YM	Futures	27814.9	27895.4	27798.6	27830.1	3511.0
2019-03-24 19:00:00	YM	Futures	27831.2	27846.5	27811.6	27830.1	1549.0
2019-03-24 20:00:00	YM	Futures	27830.1	27837.8	27639.8	27652.9	8396.0
2019-03-24 21:00:00	YM	Futures	27653.9	27719.2	27626.7	27708.3	6159.0
2019-03-24 22:00:00	YM	Futures	27708.3	27726.8	27664.8	27699.6	3219.0
2019-03-24 23:00:00	YM	Futures	27698.5	27702.9	27673.5	27698.5	2257.0
2019-03-24 18:00:00	CL	Futures	52.84	53.01	52.65	52.75	3767.0
2019-03-24 19:00:00	CL	Futures	52.74	52.75	52.64	52.69	1801.0
2019-03-24 20:00:00	CL	Futures	52.7	52.71	52.36	52.37	9082.0
2019-03-24 21:00:00	CL	Futures	52.38	52.43	52.26	52.38	11987.0
2019-03-24 22:00:00	CL	Futures	52.38	52.41	52.28	52.36	7416.0
2019-03-24 23:00:00	CL	Futures	52.36	52.46	52.33	52.43	4609.0
2019-03-24 18:00:00	GC	Futures	1693.5	1694.3	1692.0	1692.0	2216.0
2019-03-24 19:00:00	GC	Futures	1692.1	1692.1	1690.8	1690.9	2473.0
2019-03-24 20:00:00	GC	Futures	1690.8	1693.8	1690.0	1693.4	5460.0
2019-03-24 21:00:00	GC	Futures	1693.5	1695.7	1692.6	1694.8	7087.0
2019-03-24 22:00:00	GC	Futures	1694.8	1696.3	1694.5	1695.2	4217.0
2019-03-24 23:00:00	GC	Futures	1695.3	1696.2	1695.2	1695.8	2334.0
2019-03-24 18:00:00	ZN	Futures	124.726398	124.789232	124.663563	124.742106	23932.0
2019-03-24 19:00:00	ZN	Futures	124.742106	124.742106	124.679272	124.69498	11555.0
2019-03-24 20:00:00	ZN	Futures	124.69498	124.899192	124.679272	124.883484	46811.0
2019-03-24 21:00:00	ZN	Futures	124.883484	124.899192	124.804941	124.804941	29566.0
2019-03-24 22:00:00	ZN	Futures	124.804941	124.836358	124.757815	124.773523	18170.0
2019-03-24 23:00:00	ZN	Futures	124.789232	124.820649	124.773523	124.789232	8505.0

> showing 36 of 344 rows — these rows as CSV

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