PREVIEW / futures_1hour / 2020-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-29.parquet
  size:    58 KB
  rows:    1,819

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
2020-07-29 00:00:00	ES	Futures	3587.16	3587.72	3579.06	3581.02	7650.0
2020-07-29 01:00:00	ES	Futures	3581.02	3585.49	3579.06	3585.49	8560.0
2020-07-29 02:00:00	ES	Futures	3585.49	3593.86	3584.93	3593.31	11991.0
2020-07-29 03:00:00	ES	Futures	3593.31	3600.57	3591.91	3596.38	25479.0
2020-07-29 04:00:00	ES	Futures	3596.38	3599.45	3592.19	3594.98	14312.0
2020-07-29 05:00:00	ES	Futures	3595.26	3596.38	3590.51	3594.7	8838.0
2020-07-29 06:00:00	ES	Futures	3594.98	3598.05	3593.31	3594.14	9451.0
2020-07-29 07:00:00	ES	Futures	3594.14	3598.33	3591.91	3596.94	12513.0
2020-07-29 08:00:00	ES	Futures	3596.94	3603.36	3595.54	3599.17	24982.0
2020-07-29 09:00:00	ES	Futures	3599.45	3606.99	3596.66	3604.75	116444.0
2020-07-29 10:00:00	ES	Futures	3604.75	3615.65	3604.2	3615.37	107974.0
2020-07-29 11:00:00	ES	Futures	3615.37	3616.76	3610.9	3614.81	80347.0
2020-07-29 12:00:00	ES	Futures	3614.81	3619.83	3609.78	3617.6	83842.0
2020-07-29 13:00:00	ES	Futures	3617.6	3622.07	3615.92	3618.16	50452.0
2020-07-29 14:00:00	ES	Futures	3618.16	3634.91	3613.97	3624.3	149717.0
2020-07-29 15:00:00	ES	Futures	3624.58	3637.98	3616.76	3630.44	362113.0
2020-07-29 16:00:00	ES	Futures	3630.17	3637.71	3625.42	3637.15	53461.0
2020-07-29 18:00:00	ES	Futures	3637.71	3637.98	3632.4	3632.96	5140.0
2020-07-29 19:00:00	ES	Futures	3632.96	3636.03	3630.44	3631.28	5262.0
2020-07-29 20:00:00	ES	Futures	3631.56	3632.12	3627.09	3630.44	10930.0
2020-07-29 21:00:00	ES	Futures	3630.44	3632.4	3625.98	3628.21	8808.0
2020-07-29 22:00:00	ES	Futures	3628.21	3629.33	3625.14	3629.05	6782.0
2020-07-29 23:00:00	ES	Futures	3629.05	3631.56	3627.09	3628.49	5056.0
2020-07-29 00:00:00	NQ	Futures	12205.65	12208.83	12159.67	12172.97	3618.0
2020-07-29 01:00:00	NQ	Futures	12172.1	12198.13	12166.03	12197.55	3360.0
2020-07-29 02:00:00	NQ	Futures	12197.84	12230.52	12193.21	12226.47	5587.0
2020-07-29 03:00:00	NQ	Futures	12226.76	12268.4	12226.76	12251.34	9502.0
2020-07-29 04:00:00	NQ	Futures	12251.63	12254.23	12229.65	12240.93	6021.0
2020-07-29 05:00:00	NQ	Futures	12241.22	12249.02	12219.82	12244.69	3861.0
2020-07-29 06:00:00	NQ	Futures	12245.84	12263.48	12242.08	12244.11	3518.0
2020-07-29 07:00:00	NQ	Futures	12243.82	12260.88	12237.17	12257.12	4572.0
2020-07-29 08:00:00	NQ	Futures	12256.83	12281.41	12239.77	12259.15	13062.0
2020-07-29 09:00:00	NQ	Futures	12258.57	12274.47	12227.63	12261.46	48347.0
2020-07-29 10:00:00	NQ	Futures	12260.88	12313.51	12257.99	12304.55	44643.0
2020-07-29 11:00:00	NQ	Futures	12305.13	12309.17	12282.28	12288.64	25636.0
2020-07-29 12:00:00	NQ	Futures	12288.64	12300.21	12241.79	12289.22	31936.0
2020-07-29 13:00:00	NQ	Futures	12289.22	12298.18	12268.11	12279.97	16860.0
2020-07-29 14:00:00	NQ	Futures	12278.81	12358.91	12259.15	12304.55	46183.0
2020-07-29 15:00:00	NQ	Futures	12305.41	12347.06	12271.87	12319.29	63837.0
2020-07-29 16:00:00	NQ	Futures	12319.01	12376.55	12306.28	12376.26	11569.0
2020-07-29 18:00:00	NQ	Futures	12376.84	12379.15	12351.39	12353.13	2279.0
2020-07-29 19:00:00	NQ	Futures	12352.84	12364.12	12347.92	12353.13	2087.0
2020-07-29 20:00:00	NQ	Futures	12353.13	12355.44	12327.68	12344.45	4299.0
2020-07-29 21:00:00	NQ	Futures	12344.45	12350.53	12321.03	12327.39	5431.0
2020-07-29 22:00:00	NQ	Futures	12328.55	12345.03	12323.34	12342.72	2993.0
2020-07-29 23:00:00	NQ	Futures	12342.72	12354.86	12337.8	12347.06	3197.0
2020-07-29 00:00:00	YM	Futures	28895.0	28901.6	28835.6	28849.9	1787.0
2020-07-29 01:00:00	YM	Futures	28848.8	28892.8	28835.6	28887.3	2443.0
2020-07-29 02:00:00	YM	Futures	28888.4	28966.6	28885.1	28963.3	2899.0
2020-07-29 03:00:00	YM	Futures	28963.3	29021.6	28942.4	28980.9	4817.0

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

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