PREVIEW / futures_1hour / 2020-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-19.parquet
  size:    60 KB
  rows:    1,846

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-19 00:00:00	ES	Futures	3789.33	3789.89	3786.54	3787.94	3591.0
2020-08-19 01:00:00	ES	Futures	3787.94	3789.89	3785.43	3787.1	9541.0
2020-08-19 02:00:00	ES	Futures	3787.1	3789.33	3784.31	3785.7	13633.0
2020-08-19 03:00:00	ES	Futures	3785.7	3790.17	3779.0	3787.94	30716.0
2020-08-19 04:00:00	ES	Futures	3788.22	3789.33	3785.7	3786.26	16288.0
2020-08-19 05:00:00	ES	Futures	3786.26	3790.17	3785.98	3789.61	10649.0
2020-08-19 06:00:00	ES	Futures	3789.89	3790.45	3786.82	3789.61	8460.0
2020-08-19 07:00:00	ES	Futures	3789.61	3790.17	3785.98	3787.66	8227.0
2020-08-19 08:00:00	ES	Futures	3787.38	3788.5	3782.07	3784.59	19201.0
2020-08-19 09:00:00	ES	Futures	3784.31	3788.22	3781.52	3783.47	109000.0
2020-08-19 10:00:00	ES	Futures	3783.47	3789.61	3782.91	3788.5	100512.0
2020-08-19 11:00:00	ES	Futures	3788.22	3792.96	3785.7	3791.57	116457.0
2020-08-19 12:00:00	ES	Futures	3791.85	3791.85	3786.26	3787.66	73723.0
2020-08-19 13:00:00	ES	Futures	3787.66	3790.45	3786.82	3789.61	43278.0
2020-08-19 14:00:00	ES	Futures	3789.61	3792.41	3771.74	3781.52	353261.0
2020-08-19 15:00:00	ES	Futures	3781.52	3783.47	3759.18	3766.16	318705.0
2020-08-19 16:00:00	ES	Futures	3765.88	3769.23	3761.69	3763.09	59332.0
2020-08-19 18:00:00	ES	Futures	3764.48	3764.48	3761.69	3761.97	5327.0
2020-08-19 19:00:00	ES	Futures	3761.97	3763.09	3754.15	3755.55	9198.0
2020-08-19 20:00:00	ES	Futures	3755.83	3758.9	3752.2	3756.1	15254.0
2020-08-19 21:00:00	ES	Futures	3756.1	3756.94	3742.7	3743.54	19985.0
2020-08-19 22:00:00	ES	Futures	3743.54	3745.21	3736.0	3741.03	25218.0
2020-08-19 23:00:00	ES	Futures	3741.03	3748.01	3739.63	3747.17	13739.0
2020-08-19 00:00:00	NQ	Futures	13214.59	13215.75	13202.45	13206.78	1659.0
2020-08-19 01:00:00	NQ	Futures	13206.78	13213.15	13193.48	13201.29	2391.0
2020-08-19 02:00:00	NQ	Futures	13201.58	13209.68	13192.32	13194.93	3026.0
2020-08-19 03:00:00	NQ	Futures	13194.93	13219.22	13177.87	13212.57	6713.0
2020-08-19 04:00:00	NQ	Futures	13213.15	13218.35	13205.63	13207.07	3225.0
2020-08-19 05:00:00	NQ	Futures	13206.78	13220.38	13205.92	13216.91	2206.0
2020-08-19 06:00:00	NQ	Futures	13216.91	13218.35	13206.49	13214.01	2414.0
2020-08-19 07:00:00	NQ	Futures	13214.01	13217.19	13181.91	13188.57	5721.0
2020-08-19 08:00:00	NQ	Futures	13187.99	13194.06	13156.47	13163.99	11133.0
2020-08-19 09:00:00	NQ	Futures	13163.7	13203.89	13108.46	13132.18	63989.0
2020-08-19 10:00:00	NQ	Futures	13131.89	13201.29	13124.08	13193.77	52779.0
2020-08-19 11:00:00	NQ	Futures	13194.06	13224.13	13170.64	13221.82	38344.0
2020-08-19 12:00:00	NQ	Futures	13222.11	13230.5	13195.79	13212.86	24142.0
2020-08-19 13:00:00	NQ	Futures	13213.15	13224.13	13201.29	13216.04	14840.0
2020-08-19 14:00:00	NQ	Futures	13215.46	13222.98	13083.88	13154.15	86695.0
2020-08-19 15:00:00	NQ	Futures	13154.15	13157.91	13069.71	13092.85	61481.0
2020-08-19 16:00:00	NQ	Futures	13092.85	13113.38	13084.17	13095.74	9547.0
2020-08-19 18:00:00	NQ	Futures	13102.1	13107.02	13085.33	13092.27	2193.0
2020-08-19 19:00:00	NQ	Futures	13091.98	13096.03	13052.36	13059.01	3985.0
2020-08-19 20:00:00	NQ	Futures	13059.59	13073.76	13046.29	13063.64	4063.0
2020-08-19 21:00:00	NQ	Futures	13063.64	13064.8	13021.42	13022.58	5594.0
2020-08-19 22:00:00	NQ	Futures	13023.44	13033.28	12980.07	13004.65	7486.0
2020-08-19 23:00:00	NQ	Futures	13004.94	13025.47	13000.02	13022.0	4175.0
2020-08-19 00:00:00	YM	Futures	30562.1	30569.8	30534.6	30551.1	743.0
2020-08-19 01:00:00	YM	Futures	30547.8	30568.7	30528.0	30544.5	1867.0
2020-08-19 02:00:00	YM	Futures	30543.4	30565.4	30521.4	30533.5	1585.0
2020-08-19 03:00:00	YM	Futures	30533.5	30576.5	30466.3	30556.6	4866.0

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

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