PREVIEW / futures_1hour / 2020-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-27.parquet
  size:    62 KB
  rows:    1,866

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-10-27 00:00:00	ES	Futures	3805.64	3811.81	3805.64	3810.41	6173.0
2020-10-27 01:00:00	ES	Futures	3810.69	3813.21	3808.44	3812.65	8730.0
2020-10-27 02:00:00	ES	Futures	3812.65	3818.53	3810.97	3814.61	11662.0
2020-10-27 03:00:00	ES	Futures	3814.89	3816.01	3809.01	3814.89	12319.0
2020-10-27 04:00:00	ES	Futures	3814.61	3815.17	3800.88	3809.57	34066.0
2020-10-27 05:00:00	ES	Futures	3809.29	3810.41	3801.72	3808.16	28725.0
2020-10-27 06:00:00	ES	Futures	3808.16	3820.49	3808.16	3817.97	30957.0
2020-10-27 07:00:00	ES	Futures	3818.25	3820.49	3814.89	3820.21	22073.0
2020-10-27 08:00:00	ES	Futures	3820.49	3820.49	3807.32	3807.88	28919.0
2020-10-27 09:00:00	ES	Futures	3808.16	3810.97	3795.28	3805.92	191422.0
2020-10-27 10:00:00	ES	Futures	3806.2	3810.41	3788.28	3795.56	248497.0
2020-10-27 11:00:00	ES	Futures	3795.84	3807.88	3789.12	3807.04	168658.0
2020-10-27 12:00:00	ES	Futures	3807.04	3810.13	3792.76	3798.36	158205.0
2020-10-27 13:00:00	ES	Futures	3798.36	3810.97	3793.6	3805.64	132998.0
2020-10-27 14:00:00	ES	Futures	3805.92	3807.6	3789.96	3793.6	136943.0
2020-10-27 15:00:00	ES	Futures	3793.6	3802.28	3786.88	3790.52	206667.0
2020-10-27 16:00:00	ES	Futures	3790.24	3794.72	3773.71	3773.99	59733.0
2020-10-27 18:00:00	ES	Futures	3774.55	3775.95	3762.23	3764.75	17824.0
2020-10-27 19:00:00	ES	Futures	3765.03	3772.59	3764.75	3771.19	7422.0
2020-10-27 20:00:00	ES	Futures	3771.47	3772.59	3766.43	3767.55	11300.0
2020-10-27 21:00:00	ES	Futures	3767.83	3772.59	3767.55	3768.95	8204.0
2020-10-27 22:00:00	ES	Futures	3768.67	3771.19	3765.03	3770.07	8793.0
2020-10-27 23:00:00	ES	Futures	3770.07	3771.19	3767.55	3768.39	4547.0
2020-10-27 00:00:00	NQ	Futures	13308.03	13337.56	13306.3	13332.06	2248.0
2020-10-27 01:00:00	NQ	Futures	13332.64	13338.43	13323.38	13333.22	2670.0
2020-10-27 02:00:00	NQ	Futures	13332.93	13365.35	13327.43	13354.06	5358.0
2020-10-27 03:00:00	NQ	Futures	13354.64	13371.43	13337.27	13361.59	5989.0
2020-10-27 04:00:00	NQ	Futures	13361.59	13363.03	13317.59	13347.98	9034.0
2020-10-27 05:00:00	NQ	Futures	13348.27	13364.19	13323.95	13346.82	6309.0
2020-10-27 06:00:00	NQ	Futures	13346.82	13391.98	13344.8	13372.88	7697.0
2020-10-27 07:00:00	NQ	Futures	13372.01	13388.22	13362.45	13387.93	5367.0
2020-10-27 08:00:00	NQ	Futures	13387.64	13391.4	13354.06	13357.24	14261.0
2020-10-27 09:00:00	NQ	Futures	13357.53	13405.87	13313.53	13375.19	78483.0
2020-10-27 10:00:00	NQ	Futures	13375.48	13401.82	13299.35	13377.22	86911.0
2020-10-27 11:00:00	NQ	Futures	13377.51	13438.29	13358.98	13432.8	59077.0
2020-10-27 12:00:00	NQ	Futures	13432.8	13441.19	13369.98	13401.53	53661.0
2020-10-27 13:00:00	NQ	Futures	13401.82	13440.61	13379.82	13419.77	52991.0
2020-10-27 14:00:00	NQ	Futures	13419.48	13429.03	13361.88	13385.61	63883.0
2020-10-27 15:00:00	NQ	Futures	13385.32	13457.98	13362.16	13415.43	56866.0
2020-10-27 16:00:00	NQ	Futures	13414.27	13452.19	13376.93	13378.95	15750.0
2020-10-27 18:00:00	NQ	Futures	13383.3	13384.45	13323.67	13339.59	7000.0
2020-10-27 19:00:00	NQ	Futures	13339.88	13362.45	13338.43	13359.85	3466.0
2020-10-27 20:00:00	NQ	Futures	13360.14	13362.16	13333.22	13348.27	3562.0
2020-10-27 21:00:00	NQ	Futures	13348.85	13371.14	13348.27	13351.74	3202.0
2020-10-27 22:00:00	NQ	Futures	13351.74	13363.03	13343.64	13359.85	3435.0
2020-10-27 23:00:00	NQ	Futures	13359.85	13366.8	13352.9	13357.24	1952.0
2020-10-27 00:00:00	YM	Futures	30529.5	30578.1	30528.4	30569.3	1139.0
2020-10-27 01:00:00	YM	Futures	30570.4	30600.2	30552.7	30595.8	1463.0
2020-10-27 02:00:00	YM	Futures	30595.8	30640.0	30571.5	30595.8	2986.0
2020-10-27 03:00:00	YM	Futures	30599.1	30612.4	30550.5	30599.1	3209.0

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

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