PREVIEW / futures_1hour / 2021-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-22.parquet
  size:    55 KB
  rows:    1,599

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
2021-10-22 00:00:00	ES	Futures	5123.85	5124.13	5118.2	5121.31	4421.0
2021-10-22 01:00:00	ES	Futures	5121.31	5122.44	5117.64	5118.77	3854.0
2021-10-22 02:00:00	ES	Futures	5118.49	5122.72	5117.36	5121.03	6732.0
2021-10-22 03:00:00	ES	Futures	5121.03	5128.08	5115.95	5121.59	24523.0
2021-10-22 04:00:00	ES	Futures	5121.59	5126.11	5117.92	5124.13	12173.0
2021-10-22 05:00:00	ES	Futures	5124.13	5124.98	5121.87	5123.85	6408.0
2021-10-22 06:00:00	ES	Futures	5124.13	5132.03	5122.72	5130.62	12401.0
2021-10-22 07:00:00	ES	Futures	5130.9	5134.01	5129.77	5132.88	12504.0
2021-10-22 08:00:00	ES	Futures	5132.6	5133.16	5123.28	5124.98	25348.0
2021-10-22 09:00:00	ES	Futures	5124.69	5132.88	5117.92	5128.93	159298.0
2021-10-22 10:00:00	ES	Futures	5128.65	5137.96	5123.0	5124.69	159654.0
2021-10-22 11:00:00	ES	Futures	5124.69	5129.77	5097.04	5105.79	271751.0
2021-10-22 12:00:00	ES	Futures	5105.5	5123.57	5100.14	5115.66	134283.0
2021-10-22 13:00:00	ES	Futures	5115.66	5122.44	5113.12	5113.97	75027.0
2021-10-22 14:00:00	ES	Futures	5113.97	5131.47	5113.97	5120.74	92601.0
2021-10-22 15:00:00	ES	Futures	5121.03	5126.95	5115.66	5120.74	175858.0
2021-10-22 16:00:00	ES	Futures	5120.74	5122.16	5111.43	5112.84	44418.0
2021-10-22 00:00:00	NQ	Futures	17862.3	17865.49	17844.91	17854.48	2114.0
2021-10-22 01:00:00	NQ	Futures	17854.77	17860.85	17842.3	17848.68	2303.0
2021-10-22 02:00:00	NQ	Futures	17848.39	17868.1	17844.33	17867.23	4343.0
2021-10-22 03:00:00	NQ	Futures	17867.52	17890.7	17848.68	17875.34	10593.0
2021-10-22 04:00:00	NQ	Futures	17875.92	17892.73	17857.37	17883.75	5236.0
2021-10-22 05:00:00	NQ	Futures	17884.62	17888.38	17874.18	17888.09	2656.0
2021-10-22 06:00:00	NQ	Futures	17887.8	17914.76	17881.43	17907.51	5505.0
2021-10-22 07:00:00	NQ	Futures	17907.51	17921.42	17900.27	17911.86	5878.0
2021-10-22 08:00:00	NQ	Futures	17911.57	17913.31	17890.12	17895.05	10183.0
2021-10-22 09:00:00	NQ	Futures	17894.47	17920.26	17835.93	17881.14	76705.0
2021-10-22 10:00:00	NQ	Futures	17881.14	17926.35	17847.81	17858.24	74022.0
2021-10-22 11:00:00	NQ	Futures	17858.24	17869.84	17706.38	17754.2	108192.0
2021-10-22 12:00:00	NQ	Futures	17754.49	17827.81	17734.49	17783.76	61642.0
2021-10-22 13:00:00	NQ	Futures	17783.76	17800.57	17750.14	17752.17	40367.0
2021-10-22 14:00:00	NQ	Futures	17752.17	17833.61	17750.72	17791.01	37148.0
2021-10-22 15:00:00	NQ	Futures	17791.3	17807.82	17771.59	17785.5	51901.0
2021-10-22 16:00:00	NQ	Futures	17785.21	17791.3	17757.68	17764.63	11328.0
2021-10-22 00:00:00	YM	Futures	39811.3	39813.5	39765.3	39787.7	1707.0
2021-10-22 01:00:00	YM	Futures	39790.0	39795.6	39753.0	39761.9	1291.0
2021-10-22 02:00:00	YM	Futures	39760.8	39788.9	39744.0	39767.6	2251.0
2021-10-22 03:00:00	YM	Futures	39765.3	39828.1	39739.5	39766.4	5540.0
2021-10-22 04:00:00	YM	Futures	39763.1	39806.8	39740.7	39790.0	2869.0
2021-10-22 05:00:00	YM	Futures	39792.2	39796.7	39772.0	39782.1	1968.0
2021-10-22 06:00:00	YM	Futures	39782.1	39819.1	39770.9	39812.4	3012.0
2021-10-22 07:00:00	YM	Futures	39813.5	39867.3	39813.5	39851.6	5389.0
2021-10-22 08:00:00	YM	Futures	39851.6	39861.7	39787.7	39802.3	5102.0
2021-10-22 09:00:00	YM	Futures	39801.2	39946.9	39742.9	39911.0	31147.0
2021-10-22 10:00:00	YM	Futures	39909.9	39954.7	39852.7	39856.1	19152.0
2021-10-22 11:00:00	YM	Futures	39856.1	39898.7	39693.6	39746.3	30487.0
2021-10-22 12:00:00	YM	Futures	39746.3	39864.0	39711.5	39820.2	13963.0
2021-10-22 13:00:00	YM	Futures	39821.4	39890.9	39815.8	39825.8	9694.0
2021-10-22 14:00:00	YM	Futures	39827.0	39946.9	39827.0	39868.4	10518.0
2021-10-22 15:00:00	YM	Futures	39869.6	39904.3	39830.3	39853.9	15487.0

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

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