PREVIEW / futures_1hour / 2021-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-30.parquet
  size:    67 KB
  rows:    1,992

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-09-30 00:00:00	ES	Futures	4936.18	4939.0	4934.77	4938.15	4722.0
2021-09-30 01:00:00	ES	Futures	4938.15	4950.29	4937.87	4940.97	18154.0
2021-09-30 02:00:00	ES	Futures	4941.26	4954.52	4940.97	4948.88	18018.0
2021-09-30 03:00:00	ES	Futures	4948.59	4953.39	4937.31	4947.18	35296.0
2021-09-30 04:00:00	ES	Futures	4946.9	4951.42	4940.41	4944.93	24937.0
2021-09-30 05:00:00	ES	Futures	4945.21	4946.9	4932.51	4933.64	19952.0
2021-09-30 06:00:00	ES	Futures	4933.35	4937.59	4925.45	4929.12	25448.0
2021-09-30 07:00:00	ES	Futures	4928.84	4934.2	4922.91	4927.43	21174.0
2021-09-30 08:00:00	ES	Futures	4927.71	4931.94	4924.89	4926.3	29442.0
2021-09-30 09:00:00	ES	Futures	4926.02	4937.02	4919.24	4926.3	196069.0
2021-09-30 10:00:00	ES	Futures	4926.02	4929.4	4897.8	4901.75	279373.0
2021-09-30 11:00:00	ES	Futures	4901.75	4918.12	4876.63	4884.81	239441.0
2021-09-30 12:00:00	ES	Futures	4885.1	4887.35	4859.13	4868.73	267755.0
2021-09-30 13:00:00	ES	Futures	4868.73	4885.1	4863.93	4880.58	184485.0
2021-09-30 14:00:00	ES	Futures	4880.3	4903.44	4879.45	4886.51	213662.0
2021-09-30 15:00:00	ES	Futures	4886.79	4900.62	4847.56	4850.38	471138.0
2021-09-30 16:00:00	ES	Futures	4850.67	4860.54	4848.41	4852.36	140129.0
2021-09-30 18:00:00	ES	Futures	4855.18	4860.83	4851.8	4857.72	12867.0
2021-09-30 19:00:00	ES	Futures	4858.0	4863.93	4856.59	4860.26	9515.0
2021-09-30 20:00:00	ES	Futures	4859.98	4866.47	4850.95	4852.08	15142.0
2021-09-30 21:00:00	ES	Futures	4852.08	4854.05	4818.78	4823.57	51039.0
2021-09-30 22:00:00	ES	Futures	4823.86	4828.09	4820.19	4823.01	15984.0
2021-09-30 23:00:00	ES	Futures	4823.29	4830.91	4821.6	4822.73	12850.0
2021-09-30 00:00:00	NQ	Futures	17199.2	17212.82	17190.79	17211.66	2889.0
2021-09-30 01:00:00	NQ	Futures	17211.37	17248.47	17209.63	17214.85	7027.0
2021-09-30 02:00:00	NQ	Futures	17213.11	17246.15	17209.92	17214.56	6938.0
2021-09-30 03:00:00	NQ	Futures	17215.14	17253.97	17174.85	17223.25	14749.0
2021-09-30 04:00:00	NQ	Futures	17222.96	17242.38	17189.64	17210.21	8610.0
2021-09-30 05:00:00	NQ	Futures	17210.79	17218.33	17158.62	17170.8	8144.0
2021-09-30 06:00:00	NQ	Futures	17169.93	17187.61	17138.92	17157.76	8257.0
2021-09-30 07:00:00	NQ	Futures	17157.47	17185.0	17143.55	17165.29	9106.0
2021-09-30 08:00:00	NQ	Futures	17165.58	17184.42	17153.7	17161.81	11907.0
2021-09-30 09:00:00	NQ	Futures	17161.23	17248.47	17129.64	17205.57	85344.0
2021-09-30 10:00:00	NQ	Futures	17205.57	17236.88	17124.14	17139.5	104135.0
2021-09-30 11:00:00	NQ	Futures	17139.21	17204.13	17060.96	17099.21	81400.0
2021-09-30 12:00:00	NQ	Futures	17099.79	17105.59	17021.25	17062.41	78875.0
2021-09-30 13:00:00	NQ	Futures	17062.41	17124.72	17048.49	17112.25	57360.0
2021-09-30 14:00:00	NQ	Futures	17111.38	17190.79	17108.2	17130.51	66159.0
2021-09-30 15:00:00	NQ	Futures	17130.8	17181.81	17006.76	17013.14	92487.0
2021-09-30 16:00:00	NQ	Futures	17014.3	17048.78	17009.08	17032.26	21200.0
2021-09-30 18:00:00	NQ	Futures	17043.86	17056.32	17026.47	17050.81	5114.0
2021-09-30 19:00:00	NQ	Futures	17051.39	17069.65	17044.15	17058.06	4046.0
2021-09-30 20:00:00	NQ	Futures	17056.61	17078.35	17018.93	17020.09	6299.0
2021-09-30 21:00:00	NQ	Futures	17020.67	17031.97	16895.76	16930.25	22146.0
2021-09-30 22:00:00	NQ	Futures	16930.54	16947.64	16910.83	16921.55	6668.0
2021-09-30 23:00:00	NQ	Futures	16921.55	16951.12	16920.68	16926.77	5685.0
2021-09-30 00:00:00	YM	Futures	38581.6	38600.7	38572.7	38592.8	842.0
2021-09-30 01:00:00	YM	Futures	38591.7	38675.8	38591.7	38616.4	3066.0
2021-09-30 02:00:00	YM	Futures	38615.3	38731.8	38613.0	38697.1	4208.0
2021-09-30 03:00:00	YM	Futures	38694.8	38727.4	38613.0	38685.9	6016.0

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

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