PREVIEW / futures_1hour / 2021-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-16.parquet
  size:    63 KB
  rows:    1,939

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-06-16 00:00:00	ES	Futures	4772.82	4773.38	4770.57	4771.97	2563.0
2021-06-16 01:00:00	ES	Futures	4771.97	4773.66	4770.85	4771.97	4966.0
2021-06-16 02:00:00	ES	Futures	4771.69	4774.51	4770.28	4772.82	6114.0
2021-06-16 03:00:00	ES	Futures	4772.82	4775.92	4770.0	4770.28	12811.0
2021-06-16 04:00:00	ES	Futures	4770.28	4770.57	4766.06	4770.28	11338.0
2021-06-16 05:00:00	ES	Futures	4770.57	4771.41	4766.34	4769.16	7709.0
2021-06-16 06:00:00	ES	Futures	4769.44	4775.63	4769.16	4770.0	9966.0
2021-06-16 07:00:00	ES	Futures	4770.0	4771.13	4768.31	4769.16	8573.0
2021-06-16 08:00:00	ES	Futures	4768.88	4772.82	4767.19	4771.69	17697.0
2021-06-16 09:00:00	ES	Futures	4771.97	4777.32	4768.88	4771.13	95363.0
2021-06-16 10:00:00	ES	Futures	4771.13	4773.94	4767.75	4769.72	91406.0
2021-06-16 11:00:00	ES	Futures	4769.72	4773.94	4768.59	4770.0	59403.0
2021-06-16 12:00:00	ES	Futures	4769.72	4770.85	4758.46	4761.84	96606.0
2021-06-16 13:00:00	ES	Futures	4761.56	4762.68	4750.86	4757.33	79501.0
2021-06-16 14:00:00	ES	Futures	4757.33	4757.33	4719.6	4740.44	461588.0
2021-06-16 15:00:00	ES	Futures	4740.44	4762.12	4737.34	4746.07	318150.0
2021-06-16 16:00:00	ES	Futures	4745.79	4749.73	4732.27	4733.4	57065.0
2021-06-16 18:00:00	ES	Futures	4735.37	4736.49	4730.58	4733.4	11084.0
2021-06-16 19:00:00	ES	Futures	4733.12	4733.96	4726.08	4726.64	9022.0
2021-06-16 20:00:00	ES	Futures	4726.64	4726.64	4711.43	4719.32	26261.0
2021-06-16 21:00:00	ES	Futures	4719.6	4726.36	4715.66	4725.51	15501.0
2021-06-16 22:00:00	ES	Futures	4725.79	4728.33	4723.26	4726.92	9168.0
2021-06-16 23:00:00	ES	Futures	4727.2	4730.86	4724.67	4729.17	8542.0
2021-06-16 00:00:00	NQ	Futures	16263.86	16267.92	16258.07	16263.29	1303.0
2021-06-16 01:00:00	NQ	Futures	16263.57	16269.95	16255.17	16260.68	1565.0
2021-06-16 02:00:00	NQ	Futures	16260.1	16273.71	16255.17	16268.21	2189.0
2021-06-16 03:00:00	NQ	Futures	16268.5	16278.64	16256.91	16265.31	4495.0
2021-06-16 04:00:00	NQ	Futures	16265.02	16267.05	16252.57	16265.02	3884.0
2021-06-16 05:00:00	NQ	Futures	16265.31	16268.21	16249.96	16260.68	2981.0
2021-06-16 06:00:00	NQ	Futures	16260.97	16276.32	16257.2	16261.55	3813.0
2021-06-16 07:00:00	NQ	Futures	16262.13	16273.13	16255.75	16257.2	4017.0
2021-06-16 08:00:00	NQ	Futures	16257.49	16274.0	16243.59	16273.71	6907.0
2021-06-16 09:00:00	NQ	Futures	16273.42	16323.54	16269.08	16314.27	56269.0
2021-06-16 10:00:00	NQ	Futures	16314.56	16333.1	16278.64	16291.96	51701.0
2021-06-16 11:00:00	NQ	Futures	16291.67	16295.15	16249.67	16251.41	38482.0
2021-06-16 12:00:00	NQ	Futures	16251.41	16255.75	16194.05	16241.27	46763.0
2021-06-16 13:00:00	NQ	Futures	16241.85	16267.92	16227.65	16238.95	32321.0
2021-06-16 14:00:00	NQ	Futures	16238.37	16238.37	16025.46	16125.4	160824.0
2021-06-16 15:00:00	NQ	Futures	16125.69	16257.78	16114.39	16194.05	88239.0
2021-06-16 16:00:00	NQ	Futures	16194.34	16203.32	16141.62	16141.91	11475.0
2021-06-16 18:00:00	NQ	Futures	16153.79	16153.79	16122.5	16123.37	6602.0
2021-06-16 19:00:00	NQ	Futures	16123.37	16128.87	16088.9	16090.64	6029.0
2021-06-16 20:00:00	NQ	Futures	16091.21	16094.11	16038.78	16070.94	10518.0
2021-06-16 21:00:00	NQ	Futures	16070.94	16107.73	16052.4	16103.09	7716.0
2021-06-16 22:00:00	NQ	Futures	16103.09	16117.29	16095.56	16110.91	4268.0
2021-06-16 23:00:00	NQ	Futures	16111.49	16117.0	16096.14	16109.46	3075.0
2021-06-16 00:00:00	YM	Futures	38167.6	38168.7	38146.3	38150.8	629.0
2021-06-16 01:00:00	YM	Futures	38151.9	38177.6	38151.9	38165.3	857.0
2021-06-16 02:00:00	YM	Futures	38163.1	38181.0	38151.9	38164.2	1056.0
2021-06-16 03:00:00	YM	Futures	38165.3	38189.9	38128.5	38128.5	2117.0

> showing 50 of 1,939 rows — these rows as CSV

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