PREVIEW / futures_1hour / 2021-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-04.parquet
  size:    65 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-03-04 00:00:00	ES	Futures	4259.39	4267.81	4259.39	4260.52	14212.0
2021-03-04 01:00:00	ES	Futures	4260.8	4272.02	4259.67	4269.5	12181.0
2021-03-04 02:00:00	ES	Futures	4270.06	4281.57	4268.09	4276.51	19349.0
2021-03-04 03:00:00	ES	Futures	4276.51	4287.18	4273.15	4277.08	34162.0
2021-03-04 04:00:00	ES	Futures	4277.36	4282.41	4258.55	4266.41	31342.0
2021-03-04 05:00:00	ES	Futures	4266.13	4269.78	4253.78	4262.76	32881.0
2021-03-04 06:00:00	ES	Futures	4263.04	4271.74	4254.9	4270.34	35914.0
2021-03-04 07:00:00	ES	Futures	4270.06	4278.76	4268.94	4277.92	32950.0
2021-03-04 08:00:00	ES	Futures	4277.64	4290.83	4272.3	4283.25	59649.0
2021-03-04 09:00:00	ES	Futures	4283.25	4306.26	4270.34	4278.2	277191.0
2021-03-04 10:00:00	ES	Futures	4278.2	4295.88	4252.66	4289.42	410531.0
2021-03-04 11:00:00	ES	Futures	4289.42	4309.63	4282.41	4301.77	257356.0
2021-03-04 12:00:00	ES	Futures	4302.05	4313.56	4227.4	4234.69	463870.0
2021-03-04 13:00:00	ES	Futures	4234.69	4244.8	4176.88	4177.72	439701.0
2021-03-04 14:00:00	ES	Futures	4177.44	4239.75	4177.44	4236.94	374404.0
2021-03-04 15:00:00	ES	Futures	4236.94	4239.75	4204.38	4231.89	423562.0
2021-03-04 16:00:00	ES	Futures	4231.89	4237.5	4227.96	4228.8	83580.0
2021-03-04 18:00:00	ES	Futures	4227.4	4233.57	4218.7	4219.26	16761.0
2021-03-04 19:00:00	ES	Futures	4219.26	4220.94	4201.01	4201.3	29200.0
2021-03-04 20:00:00	ES	Futures	4201.3	4206.91	4188.95	4202.42	36702.0
2021-03-04 21:00:00	ES	Futures	4202.14	4215.05	4194.28	4215.05	23807.0
2021-03-04 22:00:00	ES	Futures	4215.05	4226.56	4210.56	4225.99	19038.0
2021-03-04 23:00:00	ES	Futures	4226.27	4227.68	4213.36	4213.64	11470.0
2021-03-04 00:00:00	NQ	Futures	14553.31	14586.59	14544.91	14559.1	7795.0
2021-03-04 01:00:00	NQ	Futures	14559.39	14616.4	14548.39	14612.35	9967.0
2021-03-04 02:00:00	NQ	Futures	14611.48	14673.71	14602.22	14662.71	12413.0
2021-03-04 03:00:00	NQ	Futures	14662.71	14713.36	14636.09	14646.5	19944.0
2021-03-04 04:00:00	NQ	Futures	14646.5	14681.53	14566.33	14608.3	18031.0
2021-03-04 05:00:00	NQ	Futures	14607.43	14626.24	14542.31	14577.91	15687.0
2021-03-04 06:00:00	NQ	Futures	14578.78	14643.32	14534.2	14630.3	14355.0
2021-03-04 07:00:00	NQ	Futures	14629.72	14666.19	14612.35	14653.16	15967.0
2021-03-04 08:00:00	NQ	Futures	14653.16	14711.92	14625.96	14670.82	23980.0
2021-03-04 09:00:00	NQ	Futures	14670.82	14778.49	14550.7	14575.3	106184.0
2021-03-04 10:00:00	NQ	Futures	14575.01	14768.65	14481.82	14731.6	154949.0
2021-03-04 11:00:00	NQ	Futures	14729.86	14815.53	14675.16	14749.54	95864.0
2021-03-04 12:00:00	NQ	Futures	14749.83	14799.9	14406.56	14453.74	153931.0
2021-03-04 13:00:00	NQ	Futures	14453.16	14496.0	14247.67	14251.72	125135.0
2021-03-04 14:00:00	NQ	Futures	14250.85	14511.63	14250.27	14485.29	101961.0
2021-03-04 15:00:00	NQ	Futures	14484.13	14507.87	14356.78	14438.4	84442.0
2021-03-04 16:00:00	NQ	Futures	14438.98	14464.74	14391.22	14392.96	14254.0
2021-03-04 18:00:00	NQ	Futures	14396.43	14424.51	14360.83	14363.73	7900.0
2021-03-04 19:00:00	NQ	Futures	14362.86	14372.41	14280.95	14283.55	11923.0
2021-03-04 20:00:00	NQ	Futures	14282.4	14316.55	14245.35	14292.24	15319.0
2021-03-04 21:00:00	NQ	Futures	14291.66	14360.54	14255.19	14360.25	11120.0
2021-03-04 22:00:00	NQ	Futures	14359.97	14404.25	14329.57	14403.38	9528.0
2021-03-04 23:00:00	NQ	Futures	14403.09	14415.83	14351.86	14353.31	7054.0
2021-03-04 00:00:00	YM	Futures	34514.8	34575.8	34513.7	34520.4	3092.0
2021-03-04 01:00:00	YM	Futures	34520.4	34603.6	34515.9	34580.3	3002.0
2021-03-04 02:00:00	YM	Futures	34581.4	34655.7	34570.3	34606.9	3998.0
2021-03-04 03:00:00	YM	Futures	34608.0	34683.4	34586.9	34633.5	7365.0

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

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