PREVIEW / futures_1hour / 2020-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-18.parquet
  size:    58 KB
  rows:    1,834

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-18 00:00:00	ES	Futures	3775.93	3777.33	3775.09	3776.49	3319.0
2020-08-18 01:00:00	ES	Futures	3776.21	3777.89	3774.26	3775.65	7059.0
2020-08-18 02:00:00	ES	Futures	3775.65	3778.16	3770.63	3771.18	12159.0
2020-08-18 03:00:00	ES	Futures	3771.18	3773.14	3765.88	3770.63	27050.0
2020-08-18 04:00:00	ES	Futures	3770.63	3777.89	3770.35	3776.21	17192.0
2020-08-18 05:00:00	ES	Futures	3776.49	3781.79	3775.37	3781.24	15231.0
2020-08-18 06:00:00	ES	Futures	3780.96	3784.87	3779.84	3784.03	12576.0
2020-08-18 07:00:00	ES	Futures	3784.31	3785.15	3778.16	3779.0	18517.0
2020-08-18 08:00:00	ES	Futures	3779.0	3782.07	3778.72	3780.96	21141.0
2020-08-18 09:00:00	ES	Futures	3780.96	3786.54	3775.93	3779.0	139714.0
2020-08-18 10:00:00	ES	Futures	3779.0	3779.56	3758.9	3772.02	222698.0
2020-08-18 11:00:00	ES	Futures	3772.3	3779.84	3770.9	3778.72	104644.0
2020-08-18 12:00:00	ES	Futures	3779.0	3783.75	3777.33	3782.63	61771.0
2020-08-18 13:00:00	ES	Futures	3782.63	3785.15	3779.84	3782.63	52944.0
2020-08-18 14:00:00	ES	Futures	3782.63	3785.7	3780.4	3784.59	50205.0
2020-08-18 15:00:00	ES	Futures	3784.59	3787.38	3778.16	3781.79	143645.0
2020-08-18 16:00:00	ES	Futures	3781.79	3784.87	3779.28	3784.59	35039.0
2020-08-18 18:00:00	ES	Futures	3785.15	3785.7	3781.79	3784.59	3844.0
2020-08-18 19:00:00	ES	Futures	3784.87	3786.26	3784.31	3785.43	3101.0
2020-08-18 20:00:00	ES	Futures	3785.43	3785.43	3780.96	3783.19	8354.0
2020-08-18 21:00:00	ES	Futures	3783.47	3789.61	3782.91	3787.1	11647.0
2020-08-18 22:00:00	ES	Futures	3787.1	3788.78	3786.54	3786.82	5291.0
2020-08-18 23:00:00	ES	Futures	3786.82	3790.73	3786.54	3789.06	7127.0
2020-08-18 00:00:00	NQ	Futures	13061.62	13070.29	13058.72	13065.66	1179.0
2020-08-18 01:00:00	NQ	Futures	13064.8	13069.42	13054.39	13060.46	1831.0
2020-08-18 02:00:00	NQ	Futures	13060.46	13067.69	13048.02	13053.23	3263.0
2020-08-18 03:00:00	NQ	Futures	13053.23	13059.3	13038.48	13049.47	5868.0
2020-08-18 04:00:00	NQ	Futures	13049.18	13066.53	13048.31	13062.48	3746.0
2020-08-18 05:00:00	NQ	Futures	13062.77	13101.52	13060.75	13099.79	6154.0
2020-08-18 06:00:00	NQ	Futures	13100.08	13109.62	13092.85	13103.55	4123.0
2020-08-18 07:00:00	NQ	Futures	13103.84	13111.93	13089.38	13090.82	5571.0
2020-08-18 08:00:00	NQ	Futures	13090.82	13125.24	13076.94	13109.04	12638.0
2020-08-18 09:00:00	NQ	Futures	13108.46	13165.72	13096.32	13118.87	56973.0
2020-08-18 10:00:00	NQ	Futures	13119.16	13125.81	13033.86	13117.43	64769.0
2020-08-18 11:00:00	NQ	Futures	13117.72	13139.98	13105.86	13135.07	30900.0
2020-08-18 12:00:00	NQ	Futures	13135.36	13169.77	13131.02	13153.0	23432.0
2020-08-18 13:00:00	NQ	Futures	13152.13	13171.79	13144.32	13159.36	18690.0
2020-08-18 14:00:00	NQ	Futures	13159.36	13187.99	13146.63	13182.78	22045.0
2020-08-18 15:00:00	NQ	Futures	13183.07	13204.18	13170.64	13179.6	38375.0
2020-08-18 16:00:00	NQ	Futures	13179.6	13203.02	13174.97	13201.87	8273.0
2020-08-18 18:00:00	NQ	Futures	13203.02	13229.34	13189.14	13199.55	2265.0
2020-08-18 19:00:00	NQ	Futures	13199.55	13209.39	13198.4	13205.63	1500.0
2020-08-18 20:00:00	NQ	Futures	13205.34	13205.34	13184.81	13193.77	3152.0
2020-08-18 21:00:00	NQ	Futures	13193.48	13215.46	13192.61	13203.6	3572.0
2020-08-18 22:00:00	NQ	Futures	13202.74	13212.57	13200.71	13205.34	2180.0
2020-08-18 23:00:00	NQ	Futures	13204.18	13220.95	13203.89	13214.01	1963.0
2020-08-18 00:00:00	YM	Futures	30575.4	30585.3	30557.7	30572.1	594.0
2020-08-18 01:00:00	YM	Futures	30570.9	30589.7	30552.2	30564.3	1193.0
2020-08-18 02:00:00	YM	Futures	30564.3	30588.6	30500.5	30504.9	3119.0
2020-08-18 03:00:00	YM	Futures	30504.9	30542.3	30448.7	30525.8	5550.0

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

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