PREVIEW / futures_1hour / 2021-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-27.parquet
  size:    61 KB
  rows:    1,943

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-04-27 00:00:00	ES	Futures	4700.34	4701.46	4700.05	4701.18	1594.0
2021-04-27 01:00:00	ES	Futures	4701.18	4711.86	4700.9	4707.64	8958.0
2021-04-27 02:00:00	ES	Futures	4707.92	4708.48	4702.3	4704.55	6983.0
2021-04-27 03:00:00	ES	Futures	4704.27	4704.83	4701.74	4703.43	10193.0
2021-04-27 04:00:00	ES	Futures	4703.43	4705.39	4700.05	4703.15	8161.0
2021-04-27 05:00:00	ES	Futures	4703.15	4703.71	4693.59	4696.4	11106.0
2021-04-27 06:00:00	ES	Futures	4696.12	4702.3	4695.56	4702.3	8239.0
2021-04-27 07:00:00	ES	Futures	4702.3	4703.43	4699.77	4701.46	11839.0
2021-04-27 08:00:00	ES	Futures	4701.18	4703.99	4699.21	4699.49	16910.0
2021-04-27 09:00:00	ES	Futures	4699.49	4702.02	4687.97	4689.1	183696.0
2021-04-27 10:00:00	ES	Futures	4688.82	4694.72	4682.92	4692.47	186739.0
2021-04-27 11:00:00	ES	Futures	4692.75	4698.09	4690.22	4696.68	79069.0
2021-04-27 12:00:00	ES	Futures	4696.96	4698.93	4690.5	4691.91	70064.0
2021-04-27 13:00:00	ES	Futures	4691.91	4696.96	4691.34	4695.56	50645.0
2021-04-27 14:00:00	ES	Futures	4695.28	4699.77	4691.63	4697.53	62230.0
2021-04-27 15:00:00	ES	Futures	4697.81	4703.71	4693.31	4696.68	161664.0
2021-04-27 16:00:00	ES	Futures	4696.4	4701.74	4695.56	4698.09	53227.0
2021-04-27 18:00:00	ES	Futures	4698.09	4700.62	4697.81	4699.49	3938.0
2021-04-27 19:00:00	ES	Futures	4699.49	4701.74	4697.81	4698.09	4271.0
2021-04-27 20:00:00	ES	Futures	4698.09	4700.05	4696.12	4697.81	5080.0
2021-04-27 21:00:00	ES	Futures	4697.81	4702.58	4696.68	4702.3	8372.0
2021-04-27 22:00:00	ES	Futures	4702.3	4703.43	4701.18	4701.74	5001.0
2021-04-27 23:00:00	ES	Futures	4702.02	4703.15	4701.46	4702.86	2197.0
2021-04-27 00:00:00	NQ	Futures	16236.63	16240.69	16233.74	16240.4	1058.0
2021-04-27 01:00:00	NQ	Futures	16240.69	16269.63	16238.08	16260.37	3999.0
2021-04-27 02:00:00	NQ	Futures	16260.66	16262.98	16240.11	16247.34	2835.0
2021-04-27 03:00:00	NQ	Futures	16246.48	16254.58	16238.37	16251.11	4791.0
2021-04-27 04:00:00	NQ	Futures	16251.11	16254.58	16230.26	16251.69	5827.0
2021-04-27 05:00:00	NQ	Futures	16251.11	16257.48	16220.71	16227.08	4699.0
2021-04-27 06:00:00	NQ	Futures	16227.08	16250.53	16225.92	16246.48	4098.0
2021-04-27 07:00:00	NQ	Futures	16246.76	16253.42	16237.5	16249.66	4212.0
2021-04-27 08:00:00	NQ	Futures	16249.66	16258.06	16244.16	16247.63	6286.0
2021-04-27 09:00:00	NQ	Futures	16247.63	16251.98	16150.94	16160.21	75325.0
2021-04-27 10:00:00	NQ	Futures	16160.5	16170.05	16110.41	16148.92	92384.0
2021-04-27 11:00:00	NQ	Futures	16149.2	16179.31	16132.41	16170.34	41717.0
2021-04-27 12:00:00	NQ	Futures	16170.34	16193.21	16160.5	16166.57	33252.0
2021-04-27 13:00:00	NQ	Futures	16166.86	16178.73	16157.89	16163.39	23380.0
2021-04-27 14:00:00	NQ	Futures	16163.1	16176.42	16141.39	16163.97	27469.0
2021-04-27 15:00:00	NQ	Futures	16163.97	16184.23	16143.99	16155.57	44759.0
2021-04-27 16:00:00	NQ	Futures	16155.86	16195.23	16143.99	16154.42	16792.0
2021-04-27 18:00:00	NQ	Futures	16160.21	16176.13	16155.57	16172.36	2944.0
2021-04-27 19:00:00	NQ	Futures	16172.94	16179.89	16167.44	16168.89	2020.0
2021-04-27 20:00:00	NQ	Futures	16169.18	16176.42	16160.78	16163.39	2813.0
2021-04-27 21:00:00	NQ	Futures	16162.81	16186.26	16158.47	16184.23	3666.0
2021-04-27 22:00:00	NQ	Futures	16184.23	16187.71	16178.44	16183.08	2275.0
2021-04-27 23:00:00	NQ	Futures	16183.65	16185.68	16179.31	16180.47	1335.0
2021-04-27 00:00:00	YM	Futures	37762.9	37777.4	37761.8	37767.4	367.0
2021-04-27 01:00:00	YM	Futures	37767.4	37839.8	37767.4	37820.8	1761.0
2021-04-27 02:00:00	YM	Futures	37824.2	37829.7	37778.5	37794.1	2053.0
2021-04-27 03:00:00	YM	Futures	37793.0	37798.5	37759.6	37772.9	2146.0

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

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