PREVIEW / futures_1hour / 2020-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-20.parquet
  size:    59 KB
  rows:    1,847

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-08-20 00:00:00	ES	Futures	3747.17	3749.68	3744.38	3745.21	8631.0
2020-08-20 01:00:00	ES	Futures	3745.21	3750.8	3743.26	3746.33	9748.0
2020-08-20 02:00:00	ES	Futures	3746.33	3753.59	3744.66	3749.96	14458.0
2020-08-20 03:00:00	ES	Futures	3749.68	3758.06	3745.21	3754.15	31431.0
2020-08-20 04:00:00	ES	Futures	3754.15	3754.43	3741.03	3751.08	31660.0
2020-08-20 05:00:00	ES	Futures	3750.8	3755.55	3749.4	3753.31	16582.0
2020-08-20 06:00:00	ES	Futures	3753.31	3761.97	3752.47	3760.57	16715.0
2020-08-20 07:00:00	ES	Futures	3760.57	3761.69	3753.59	3754.71	19835.0
2020-08-20 08:00:00	ES	Futures	3754.43	3755.55	3748.56	3750.52	32562.0
2020-08-20 09:00:00	ES	Futures	3750.8	3760.85	3743.26	3760.29	150637.0
2020-08-20 10:00:00	ES	Futures	3760.01	3769.23	3757.78	3765.04	159956.0
2020-08-20 11:00:00	ES	Futures	3765.32	3772.58	3760.57	3771.18	127383.0
2020-08-20 12:00:00	ES	Futures	3771.18	3772.86	3766.16	3767.0	64123.0
2020-08-20 13:00:00	ES	Futures	3767.0	3772.02	3764.76	3769.79	56274.0
2020-08-20 14:00:00	ES	Futures	3769.79	3777.05	3769.23	3777.05	95179.0
2020-08-20 15:00:00	ES	Futures	3776.77	3783.19	3772.02	3777.61	209006.0
2020-08-20 16:00:00	ES	Futures	3777.61	3780.68	3775.37	3779.0	44852.0
2020-08-20 18:00:00	ES	Futures	3779.28	3784.59	3779.28	3782.35	5015.0
2020-08-20 19:00:00	ES	Futures	3782.35	3786.26	3781.52	3785.98	4380.0
2020-08-20 20:00:00	ES	Futures	3785.98	3790.45	3785.7	3788.22	15011.0
2020-08-20 21:00:00	ES	Futures	3788.5	3789.33	3780.4	3782.91	15209.0
2020-08-20 22:00:00	ES	Futures	3782.91	3784.31	3780.96	3784.03	6125.0
2020-08-20 23:00:00	ES	Futures	3783.75	3787.38	3783.75	3785.43	5354.0
2020-08-20 00:00:00	NQ	Futures	13021.71	13032.99	13013.9	13016.5	3248.0
2020-08-20 01:00:00	NQ	Futures	13015.35	13051.21	13014.48	13036.17	3866.0
2020-08-20 02:00:00	NQ	Futures	13035.59	13052.65	13024.89	13035.3	4523.0
2020-08-20 03:00:00	NQ	Futures	13035.88	13070.87	13022.58	13062.19	8101.0
2020-08-20 04:00:00	NQ	Futures	13062.77	13070.58	13024.89	13062.48	7976.0
2020-08-20 05:00:00	NQ	Futures	13062.19	13089.96	13054.97	13083.59	4851.0
2020-08-20 06:00:00	NQ	Futures	13083.3	13113.38	13079.26	13108.46	6150.0
2020-08-20 07:00:00	NQ	Futures	13108.46	13110.49	13084.17	13097.47	6780.0
2020-08-20 08:00:00	NQ	Futures	13097.19	13101.81	13067.11	13076.08	11556.0
2020-08-20 09:00:00	NQ	Futures	13075.5	13161.09	13032.7	13149.82	64846.0
2020-08-20 10:00:00	NQ	Futures	13150.1	13185.96	13128.13	13179.02	55905.0
2020-08-20 11:00:00	NQ	Futures	13179.31	13215.46	13146.63	13209.96	42342.0
2020-08-20 12:00:00	NQ	Futures	13209.96	13214.88	13181.63	13185.67	25868.0
2020-08-20 13:00:00	NQ	Futures	13185.96	13217.48	13174.11	13212.86	23324.0
2020-08-20 14:00:00	NQ	Futures	13212.57	13261.15	13208.23	13259.41	32119.0
2020-08-20 15:00:00	NQ	Futures	13259.41	13298.16	13244.96	13272.14	57309.0
2020-08-20 16:00:00	NQ	Futures	13272.14	13288.62	13265.78	13279.08	10123.0
2020-08-20 18:00:00	NQ	Futures	13279.08	13301.06	13279.08	13292.38	2174.0
2020-08-20 19:00:00	NQ	Futures	13293.25	13304.82	13289.78	13301.63	1636.0
2020-08-20 20:00:00	NQ	Futures	13301.92	13323.32	13301.63	13322.74	4834.0
2020-08-20 21:00:00	NQ	Futures	13323.32	13329.97	13296.43	13303.37	5757.0
2020-08-20 22:00:00	NQ	Futures	13303.95	13308.57	13293.25	13304.82	2000.0
2020-08-20 23:00:00	NQ	Futures	13305.97	13315.8	13302.79	13306.84	1693.0
2020-08-20 00:00:00	YM	Futures	30261.5	30291.3	30245.0	30252.7	1561.0
2020-08-20 01:00:00	YM	Futures	30250.5	30295.7	30219.7	30243.9	2367.0
2020-08-20 02:00:00	YM	Futures	30241.7	30319.9	30232.9	30300.1	2962.0
2020-08-20 03:00:00	YM	Futures	30299.0	30382.7	30253.8	30343.0	6485.0

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

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