PREVIEW / futures_1hour / 2021-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-18.parquet
  size:    64 KB
  rows:    2,004

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-11-18 00:00:00	ES	Futures	5295.72	5298.54	5295.43	5296.0	5316.0
2021-11-18 01:00:00	ES	Futures	5296.28	5298.26	5295.72	5297.69	2868.0
2021-11-18 02:00:00	ES	Futures	5297.69	5300.8	5296.84	5300.23	4304.0
2021-11-18 03:00:00	ES	Futures	5299.95	5304.75	5298.82	5304.46	10648.0
2021-11-18 04:00:00	ES	Futures	5304.46	5310.11	5303.9	5304.18	15915.0
2021-11-18 05:00:00	ES	Futures	5304.18	5306.72	5301.92	5306.72	7244.0
2021-11-18 06:00:00	ES	Futures	5306.44	5308.98	5304.18	5306.72	6619.0
2021-11-18 07:00:00	ES	Futures	5306.72	5307.0	5301.64	5302.21	11811.0
2021-11-18 08:00:00	ES	Futures	5302.49	5305.03	5300.8	5302.21	21012.0
2021-11-18 09:00:00	ES	Futures	5302.21	5305.31	5291.48	5293.74	136954.0
2021-11-18 10:00:00	ES	Futures	5294.02	5296.28	5269.47	5282.73	247189.0
2021-11-18 11:00:00	ES	Futures	5282.45	5302.49	5278.22	5299.38	155145.0
2021-11-18 12:00:00	ES	Futures	5299.67	5310.67	5296.84	5299.67	116091.0
2021-11-18 13:00:00	ES	Futures	5299.95	5306.16	5298.26	5303.62	70212.0
2021-11-18 14:00:00	ES	Futures	5303.62	5305.88	5295.72	5305.31	86567.0
2021-11-18 15:00:00	ES	Futures	5305.03	5311.24	5303.62	5307.85	159287.0
2021-11-18 16:00:00	ES	Futures	5307.85	5312.93	5303.9	5311.52	45444.0
2021-11-18 18:00:00	ES	Futures	5311.52	5314.34	5308.7	5311.24	6052.0
2021-11-18 19:00:00	ES	Futures	5311.24	5314.06	5310.11	5312.65	5140.0
2021-11-18 20:00:00	ES	Futures	5312.37	5321.68	5309.54	5318.57	11594.0
2021-11-18 21:00:00	ES	Futures	5318.86	5327.04	5317.73	5327.04	12532.0
2021-11-18 22:00:00	ES	Futures	5326.76	5330.43	5325.35	5327.89	9030.0
2021-11-18 23:00:00	ES	Futures	5327.89	5330.15	5327.32	5327.61	3800.0
2021-11-18 00:00:00	NQ	Futures	18950.56	18957.81	18944.48	18949.69	2273.0
2021-11-18 01:00:00	NQ	Futures	18949.4	18963.03	18944.77	18958.97	1811.0
2021-11-18 02:00:00	NQ	Futures	18959.26	18979.26	18955.2	18975.49	2850.0
2021-11-18 03:00:00	NQ	Futures	18975.78	18996.07	18971.14	18992.59	6467.0
2021-11-18 04:00:00	NQ	Futures	18992.3	19023.89	18989.69	18997.8	9444.0
2021-11-18 05:00:00	NQ	Futures	18997.22	19014.03	18989.98	19012.58	3762.0
2021-11-18 06:00:00	NQ	Futures	19012.58	19022.15	18999.83	19012.01	4632.0
2021-11-18 07:00:00	NQ	Futures	19011.43	19014.61	19000.12	19003.89	5360.0
2021-11-18 08:00:00	NQ	Futures	19004.18	19018.09	18994.62	19008.82	9676.0
2021-11-18 09:00:00	NQ	Futures	19009.11	19036.35	18957.81	19007.95	89097.0
2021-11-18 10:00:00	NQ	Futures	19008.24	19034.03	18900.14	18965.05	118608.0
2021-11-18 11:00:00	NQ	Futures	18964.19	19103.59	18934.62	19074.9	82017.0
2021-11-18 12:00:00	NQ	Futures	19075.48	19116.34	19039.25	19056.93	59517.0
2021-11-18 13:00:00	NQ	Futures	19056.93	19082.14	19042.15	19054.9	38694.0
2021-11-18 14:00:00	NQ	Futures	19054.32	19078.95	19018.96	19066.78	44731.0
2021-11-18 15:00:00	NQ	Futures	19066.49	19131.7	19058.38	19105.91	88685.0
2021-11-18 16:00:00	NQ	Futures	19106.2	19137.21	19102.43	19134.31	12561.0
2021-11-18 18:00:00	NQ	Futures	19131.7	19133.73	19116.63	19123.3	3365.0
2021-11-18 19:00:00	NQ	Futures	19123.58	19133.73	19120.11	19131.41	2089.0
2021-11-18 20:00:00	NQ	Futures	19131.41	19173.43	19121.56	19161.55	5412.0
2021-11-18 21:00:00	NQ	Futures	19162.13	19204.73	19154.89	19202.7	7287.0
2021-11-18 22:00:00	NQ	Futures	19202.42	19232.27	19194.59	19215.75	6168.0
2021-11-18 23:00:00	NQ	Futures	19214.88	19222.99	19205.6	19210.53	3223.0
2021-11-18 00:00:00	YM	Futures	40205.8	40226.0	40204.7	40206.9	1143.0
2021-11-18 01:00:00	YM	Futures	40208.1	40218.2	40205.8	40212.6	474.0
2021-11-18 02:00:00	YM	Futures	40213.7	40239.5	40206.9	40235.0	1627.0
2021-11-18 03:00:00	YM	Futures	40233.9	40269.7	40213.7	40268.6	2573.0

> showing 50 of 2,004 rows — these rows as CSV

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