PREVIEW / futures_1hour / 2020-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-04.parquet
  size:    66 KB
  rows:    1,944

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-11-04 00:00:00	ES	Futures	3798.36	3816.85	3782.4	3792.48	50150.0
2020-11-04 01:00:00	ES	Futures	3792.76	3799.76	3770.07	3779.6	39060.0
2020-11-04 02:00:00	ES	Futures	3779.6	3786.6	3718.53	3747.66	80820.0
2020-11-04 03:00:00	ES	Futures	3747.94	3798.92	3737.86	3784.92	77165.0
2020-11-04 04:00:00	ES	Futures	3784.92	3818.25	3777.91	3786.88	67729.0
2020-11-04 05:00:00	ES	Futures	3787.16	3790.24	3761.11	3782.12	37042.0
2020-11-04 06:00:00	ES	Futures	3782.12	3798.08	3775.39	3787.72	38171.0
2020-11-04 07:00:00	ES	Futures	3787.44	3833.93	3780.44	3828.89	56998.0
2020-11-04 08:00:00	ES	Futures	3828.89	3842.62	3821.89	3824.97	70445.0
2020-11-04 09:00:00	ES	Futures	3824.97	3837.29	3804.52	3837.01	265622.0
2020-11-04 10:00:00	ES	Futures	3837.01	3882.11	3834.77	3875.11	315494.0
2020-11-04 11:00:00	ES	Futures	3874.83	3888.55	3858.3	3884.35	205499.0
2020-11-04 12:00:00	ES	Futures	3884.35	3898.92	3880.43	3885.47	189050.0
2020-11-04 13:00:00	ES	Futures	3885.75	3890.51	3870.91	3875.39	202355.0
2020-11-04 14:00:00	ES	Futures	3875.67	3882.95	3863.62	3869.51	196897.0
2020-11-04 15:00:00	ES	Futures	3869.51	3873.71	3844.86	3848.5	309851.0
2020-11-04 16:00:00	ES	Futures	3848.5	3865.3	3844.58	3855.22	60362.0
2020-11-04 18:00:00	ES	Futures	3863.06	3863.06	3840.94	3847.94	16100.0
2020-11-04 19:00:00	ES	Futures	3847.38	3862.78	3844.02	3858.58	14460.0
2020-11-04 20:00:00	ES	Futures	3858.3	3862.5	3851.58	3856.9	11691.0
2020-11-04 21:00:00	ES	Futures	3857.46	3859.7	3842.62	3852.42	12111.0
2020-11-04 22:00:00	ES	Futures	3852.42	3884.07	3852.42	3879.31	18013.0
2020-11-04 23:00:00	ES	Futures	3879.31	3886.87	3875.39	3880.99	9684.0
2020-11-04 00:00:00	NQ	Futures	13364.48	13445.24	13317.88	13345.66	14758.0
2020-11-04 01:00:00	NQ	Futures	13342.48	13379.24	13270.4	13313.53	11569.0
2020-11-04 02:00:00	NQ	Futures	13312.95	13337.27	13088.62	13203.83	26428.0
2020-11-04 03:00:00	NQ	Futures	13208.17	13406.74	13163.01	13368.82	22323.0
2020-11-04 04:00:00	NQ	Futures	13368.82	13471.58	13328.3	13397.77	17405.0
2020-11-04 05:00:00	NQ	Futures	13396.9	13402.11	13257.67	13342.77	15702.0
2020-11-04 06:00:00	NQ	Futures	13341.9	13400.09	13269.25	13354.93	11755.0
2020-11-04 07:00:00	NQ	Futures	13353.48	13494.16	13313.53	13489.24	23048.0
2020-11-04 08:00:00	NQ	Futures	13488.08	13584.48	13469.56	13504.58	34458.0
2020-11-04 09:00:00	NQ	Futures	13504.58	13529.77	13381.56	13484.03	99192.0
2020-11-04 10:00:00	NQ	Futures	13482.29	13658.29	13469.56	13641.21	98382.0
2020-11-04 11:00:00	NQ	Futures	13640.92	13675.66	13559.87	13662.63	58307.0
2020-11-04 12:00:00	NQ	Futures	13662.34	13708.95	13629.34	13666.11	53218.0
2020-11-04 13:00:00	NQ	Futures	13666.4	13688.4	13602.13	13642.66	54781.0
2020-11-04 14:00:00	NQ	Futures	13642.66	13673.34	13592.0	13642.66	44053.0
2020-11-04 15:00:00	NQ	Futures	13642.37	13666.11	13578.98	13616.32	67249.0
2020-11-04 16:00:00	NQ	Futures	13617.48	13713.58	13608.21	13679.13	14438.0
2020-11-04 18:00:00	NQ	Futures	13697.66	13709.24	13632.82	13657.13	5307.0
2020-11-04 19:00:00	NQ	Futures	13658.87	13705.19	13651.34	13702.87	5802.0
2020-11-04 20:00:00	NQ	Futures	13702.87	13727.47	13687.24	13693.9	6017.0
2020-11-04 21:00:00	NQ	Futures	13694.19	13705.76	13629.63	13683.76	6432.0
2020-11-04 22:00:00	NQ	Futures	13683.19	13879.45	13683.19	13833.42	14426.0
2020-11-04 23:00:00	NQ	Futures	13836.02	13856.58	13797.24	13821.84	6952.0
2020-11-04 00:00:00	YM	Futures	30337.1	30467.6	30216.6	30302.8	6606.0
2020-11-04 01:00:00	YM	Futures	30300.6	30374.7	30117.1	30204.4	4270.0
2020-11-04 02:00:00	YM	Futures	30204.4	30277.4	29744.5	29941.3	13778.0
2020-11-04 03:00:00	YM	Futures	29949.0	30349.3	29863.9	30200.0	10617.0

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

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