PREVIEW / futures_1hour / 2021-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-16.parquet
  size:    60 KB
  rows:    1,874

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-03-16 00:00:00	ES	Futures	4449.43	4450.27	4446.62	4449.99	2823.0
2021-03-16 01:00:00	ES	Futures	4449.99	4451.68	4447.18	4450.55	3776.0
2021-03-16 02:00:00	ES	Futures	4450.84	4453.64	4446.62	4453.64	5888.0
2021-03-16 03:00:00	ES	Futures	4453.36	4455.05	4448.87	4451.12	8837.0
2021-03-16 04:00:00	ES	Futures	4451.12	4451.4	4444.37	4447.18	23322.0
2021-03-16 05:00:00	ES	Futures	4446.9	4449.15	4444.93	4447.18	11390.0
2021-03-16 06:00:00	ES	Futures	4447.46	4450.55	4446.06	4450.27	8979.0
2021-03-16 07:00:00	ES	Futures	4450.27	4454.77	4449.43	4453.93	14841.0
2021-03-16 08:00:00	ES	Futures	4454.21	4457.3	4449.99	4451.96	27994.0
2021-03-16 09:00:00	ES	Futures	4451.96	4460.39	4449.99	4458.14	147850.0
2021-03-16 10:00:00	ES	Futures	4458.42	4462.64	4453.64	4456.45	177362.0
2021-03-16 11:00:00	ES	Futures	4456.45	4458.42	4449.99	4453.36	138310.0
2021-03-16 12:00:00	ES	Futures	4453.36	4455.05	4442.13	4451.12	157560.0
2021-03-16 13:00:00	ES	Futures	4451.12	4457.86	4442.41	4444.37	96540.0
2021-03-16 14:00:00	ES	Futures	4444.65	4448.87	4431.17	4441.0	193295.0
2021-03-16 15:00:00	ES	Futures	4440.72	4453.36	4435.38	4441.28	190727.0
2021-03-16 16:00:00	ES	Futures	4441.0	4448.59	4439.88	4447.74	41821.0
2021-03-16 18:00:00	ES	Futures	4447.46	4450.84	4446.34	4448.87	5403.0
2021-03-16 19:00:00	ES	Futures	4449.15	4450.27	4444.09	4444.65	4269.0
2021-03-16 20:00:00	ES	Futures	4444.65	4446.34	4439.6	4443.81	8328.0
2021-03-16 21:00:00	ES	Futures	4443.81	4445.22	4435.1	4439.88	11608.0
2021-03-16 22:00:00	ES	Futures	4440.16	4441.56	4436.22	4440.72	6697.0
2021-03-16 23:00:00	ES	Futures	4440.44	4441.56	4437.35	4439.6	4592.0
2021-03-16 00:00:00	NQ	Futures	15188.37	15198.21	15176.79	15197.34	2298.0
2021-03-16 01:00:00	NQ	Futures	15196.77	15207.48	15183.45	15204.87	3252.0
2021-03-16 02:00:00	NQ	Futures	15206.03	15233.24	15182.0	15229.48	4602.0
2021-03-16 03:00:00	NQ	Futures	15228.61	15248.3	15196.48	15206.9	5990.0
2021-03-16 04:00:00	NQ	Futures	15206.61	15208.35	15159.42	15177.95	8475.0
2021-03-16 05:00:00	NQ	Futures	15176.79	15199.08	15168.11	15197.92	4332.0
2021-03-16 06:00:00	NQ	Futures	15197.05	15212.4	15182.87	15212.11	2898.0
2021-03-16 07:00:00	NQ	Futures	15211.24	15226.0	15196.48	15219.35	5587.0
2021-03-16 08:00:00	NQ	Futures	15219.35	15238.45	15195.9	15215.29	8461.0
2021-03-16 09:00:00	NQ	Futures	15214.42	15319.51	15206.03	15314.3	56119.0
2021-03-16 10:00:00	NQ	Futures	15314.01	15386.38	15299.25	15371.04	65622.0
2021-03-16 11:00:00	NQ	Futures	15371.33	15382.04	15329.93	15337.46	41061.0
2021-03-16 12:00:00	NQ	Futures	15337.46	15350.78	15249.74	15298.38	53500.0
2021-03-16 13:00:00	NQ	Futures	15298.96	15334.57	15240.19	15262.77	46397.0
2021-03-16 14:00:00	NQ	Futures	15262.19	15280.72	15143.21	15197.34	71083.0
2021-03-16 15:00:00	NQ	Futures	15197.63	15270.88	15169.84	15214.42	56340.0
2021-03-16 16:00:00	NQ	Futures	15214.14	15242.22	15210.08	15231.22	8228.0
2021-03-16 18:00:00	NQ	Futures	15238.45	15254.95	15232.37	15248.01	2428.0
2021-03-16 19:00:00	NQ	Futures	15246.27	15253.51	15223.4	15225.14	2315.0
2021-03-16 20:00:00	NQ	Futures	15225.14	15228.32	15168.39	15210.95	7287.0
2021-03-16 21:00:00	NQ	Futures	15211.24	15219.64	15177.08	15203.71	5479.0
2021-03-16 22:00:00	NQ	Futures	15203.71	15214.42	15186.63	15207.77	4302.0
2021-03-16 23:00:00	NQ	Futures	15207.19	15213.85	15183.45	15193.58	3016.0
2021-03-16 00:00:00	YM	Futures	36546.6	36551.1	36523.2	36545.5	608.0
2021-03-16 01:00:00	YM	Futures	36543.3	36554.4	36527.7	36544.4	792.0
2021-03-16 02:00:00	YM	Futures	36545.5	36553.3	36517.6	36553.3	1317.0
2021-03-16 03:00:00	YM	Futures	36551.1	36553.3	36524.3	36541.0	1806.0

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

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