PREVIEW / futures_1hour / 2021-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-19.parquet
  size:    62 KB
  rows:    1,931

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-19 00:00:00	ES	Futures	4686.57	4689.1	4685.73	4687.13	3435.0
2021-04-19 01:00:00	ES	Futures	4687.13	4688.82	4684.6	4686.85	4896.0
2021-04-19 02:00:00	ES	Futures	4686.85	4687.13	4682.07	4684.6	6857.0
2021-04-19 03:00:00	ES	Futures	4684.6	4689.66	4684.32	4687.97	11647.0
2021-04-19 04:00:00	ES	Futures	4687.97	4691.91	4687.97	4689.1	13933.0
2021-04-19 05:00:00	ES	Futures	4688.82	4689.38	4683.48	4686.01	7985.0
2021-04-19 06:00:00	ES	Futures	4685.73	4687.69	4678.98	4683.2	11539.0
2021-04-19 07:00:00	ES	Futures	4683.2	4685.44	4680.67	4681.51	15765.0
2021-04-19 08:00:00	ES	Futures	4681.79	4685.44	4679.83	4684.88	21599.0
2021-04-19 09:00:00	ES	Futures	4684.6	4688.25	4679.54	4686.85	144188.0
2021-04-19 10:00:00	ES	Futures	4686.85	4687.41	4661.56	4672.52	330767.0
2021-04-19 11:00:00	ES	Futures	4672.52	4676.73	4659.88	4666.9	205248.0
2021-04-19 12:00:00	ES	Futures	4666.62	4671.68	4654.82	4659.88	200042.0
2021-04-19 13:00:00	ES	Futures	4659.88	4669.71	4657.91	4664.93	121712.0
2021-04-19 14:00:00	ES	Futures	4664.93	4669.71	4661.56	4669.43	131432.0
2021-04-19 15:00:00	ES	Futures	4669.43	4673.64	4659.03	4672.24	249441.0
2021-04-19 16:00:00	ES	Futures	4672.24	4674.21	4670.27	4671.4	53543.0
2021-04-19 18:00:00	ES	Futures	4671.12	4675.33	4670.27	4674.49	4219.0
2021-04-19 19:00:00	ES	Futures	4674.77	4678.14	4671.96	4677.58	5859.0
2021-04-19 20:00:00	ES	Futures	4677.3	4679.54	4675.33	4676.17	11206.0
2021-04-19 21:00:00	ES	Futures	4676.17	4680.95	4675.33	4679.54	10966.0
2021-04-19 22:00:00	ES	Futures	4679.54	4680.67	4677.58	4678.98	6559.0
2021-04-19 23:00:00	ES	Futures	4679.26	4682.63	4678.7	4680.11	5628.0
2021-04-19 00:00:00	NQ	Futures	16262.11	16269.35	16257.48	16261.82	1858.0
2021-04-19 01:00:00	NQ	Futures	16262.11	16268.48	16254.0	16262.69	2172.0
2021-04-19 02:00:00	NQ	Futures	16262.11	16262.11	16243.29	16251.69	3618.0
2021-04-19 03:00:00	NQ	Futures	16250.82	16266.45	16247.63	16258.92	3851.0
2021-04-19 04:00:00	NQ	Futures	16260.66	16264.13	16237.21	16248.21	5036.0
2021-04-19 05:00:00	NQ	Futures	16249.08	16253.71	16229.68	16236.63	4029.0
2021-04-19 06:00:00	NQ	Futures	16236.34	16238.37	16182.79	16199.58	8184.0
2021-04-19 07:00:00	NQ	Futures	16198.71	16209.42	16189.44	16191.76	7847.0
2021-04-19 08:00:00	NQ	Futures	16192.34	16193.21	16160.78	16173.81	14032.0
2021-04-19 09:00:00	NQ	Futures	16173.81	16227.08	16149.2	16206.24	73157.0
2021-04-19 10:00:00	NQ	Futures	16206.52	16220.42	16050.78	16125.18	127355.0
2021-04-19 11:00:00	NQ	Futures	16125.18	16152.68	16043.83	16071.91	88745.0
2021-04-19 12:00:00	NQ	Futures	16071.62	16094.2	16004.46	16037.17	75152.0
2021-04-19 13:00:00	NQ	Futures	16037.46	16095.07	16027.33	16069.01	47169.0
2021-04-19 14:00:00	NQ	Futures	16068.73	16091.6	16043.83	16079.44	43740.0
2021-04-19 15:00:00	NQ	Futures	16079.15	16102.31	16038.62	16100.57	63427.0
2021-04-19 16:00:00	NQ	Futures	16099.99	16104.91	16081.75	16088.99	10164.0
2021-04-19 18:00:00	NQ	Futures	16095.94	16112.15	16091.88	16104.62	2322.0
2021-04-19 19:00:00	NQ	Futures	16104.91	16121.99	16092.75	16115.62	3099.0
2021-04-19 20:00:00	NQ	Futures	16116.2	16126.91	16100.57	16104.91	4415.0
2021-04-19 21:00:00	NQ	Futures	16105.2	16132.41	16102.6	16117.94	4970.0
2021-04-19 22:00:00	NQ	Futures	16118.81	16121.99	16103.46	16108.39	2793.0
2021-04-19 23:00:00	NQ	Futures	16107.52	16128.94	16106.07	16114.47	2863.0
2021-04-19 00:00:00	YM	Futures	37854.2	37882.1	37848.7	37863.1	818.0
2021-04-19 01:00:00	YM	Futures	37863.1	37875.4	37836.4	37854.2	1268.0
2021-04-19 02:00:00	YM	Futures	37855.3	37858.7	37817.5	37842.0	2100.0
2021-04-19 03:00:00	YM	Futures	37842.0	37888.8	37838.6	37867.6	3151.0

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

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