PREVIEW / futures_1hour / 2022-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-14.parquet
  size:    57 KB
  rows:    1,625

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
2022-04-14 00:00:00	ES	Futures	5040.42	5049.49	5040.42	5047.79	5289.0
2022-04-14 01:00:00	ES	Futures	5048.07	5051.75	5046.65	5046.94	4650.0
2022-04-14 02:00:00	ES	Futures	5046.94	5048.92	5040.7	5041.27	7991.0
2022-04-14 03:00:00	ES	Futures	5041.55	5042.68	5031.91	5036.73	18709.0
2022-04-14 04:00:00	ES	Futures	5036.73	5038.72	5030.5	5035.03	12050.0
2022-04-14 05:00:00	ES	Futures	5035.03	5037.3	5029.65	5036.45	12977.0
2022-04-14 06:00:00	ES	Futures	5036.45	5039.0	5030.21	5034.75	15894.0
2022-04-14 07:00:00	ES	Futures	5034.46	5040.42	5025.39	5027.38	22703.0
2022-04-14 08:00:00	ES	Futures	5027.38	5036.17	5022.56	5023.41	37554.0
2022-04-14 09:00:00	ES	Futures	5023.41	5051.75	5016.89	5021.71	207425.0
2022-04-14 10:00:00	ES	Futures	5022.28	5031.35	5004.14	5014.06	213866.0
2022-04-14 11:00:00	ES	Futures	5013.77	5023.98	5004.42	5006.69	130827.0
2022-04-14 12:00:00	ES	Futures	5006.69	5011.79	4991.95	4998.75	96543.0
2022-04-14 13:00:00	ES	Futures	4998.47	5013.21	4993.65	5012.92	91957.0
2022-04-14 14:00:00	ES	Futures	5012.92	5019.44	4990.25	4990.53	99478.0
2022-04-14 15:00:00	ES	Futures	4990.25	4998.18	4971.82	4974.09	252208.0
2022-04-14 16:00:00	ES	Futures	4973.81	4976.93	4971.54	4976.08	62995.0
2022-04-14 00:00:00	NQ	Futures	16539.6	16577.0	16537.86	16568.01	3595.0
2022-04-14 01:00:00	NQ	Futures	16568.3	16582.22	16552.94	16555.26	3739.0
2022-04-14 02:00:00	NQ	Futures	16556.13	16568.59	16535.83	16542.5	5355.0
2022-04-14 03:00:00	NQ	Futures	16543.37	16545.11	16492.91	16529.16	8593.0
2022-04-14 04:00:00	NQ	Futures	16528.29	16543.66	16498.13	16516.98	6204.0
2022-04-14 05:00:00	NQ	Futures	16516.69	16522.78	16485.95	16515.82	5462.0
2022-04-14 06:00:00	NQ	Futures	16514.95	16527.71	16472.32	16496.1	8977.0
2022-04-14 07:00:00	NQ	Futures	16494.65	16522.2	16460.14	16470.29	11447.0
2022-04-14 08:00:00	NQ	Futures	16471.45	16511.18	16449.41	16457.24	16524.0
2022-04-14 09:00:00	NQ	Futures	16457.24	16524.81	16359.23	16371.41	80573.0
2022-04-14 10:00:00	NQ	Futures	16372.28	16402.15	16257.16	16291.67	95562.0
2022-04-14 11:00:00	NQ	Futures	16291.09	16339.22	16249.91	16262.38	59097.0
2022-04-14 12:00:00	NQ	Futures	16261.51	16280.36	16192.5	16219.46	48922.0
2022-04-14 13:00:00	NQ	Futures	16219.17	16274.56	16203.23	16270.79	39926.0
2022-04-14 14:00:00	NQ	Futures	16271.95	16294.86	16168.72	16170.75	43723.0
2022-04-14 15:00:00	NQ	Futures	16171.04	16202.07	16105.79	16115.07	68462.0
2022-04-14 16:00:00	NQ	Futures	16115.65	16121.45	16095.35	16113.62	13113.0
2022-04-14 00:00:00	YM	Futures	38896.3	38954.9	38896.3	38940.3	1107.0
2022-04-14 01:00:00	YM	Futures	38940.3	38974.1	38936.9	38950.4	1188.0
2022-04-14 02:00:00	YM	Futures	38951.5	38959.4	38899.7	38904.2	2204.0
2022-04-14 03:00:00	YM	Futures	38906.4	38909.8	38843.3	38871.5	3998.0
2022-04-14 04:00:00	YM	Futures	38871.5	38881.6	38827.5	38871.5	2742.0
2022-04-14 05:00:00	YM	Futures	38870.4	38918.8	38837.7	38900.8	4461.0
2022-04-14 06:00:00	YM	Futures	38899.7	38962.8	38892.9	38941.4	4742.0
2022-04-14 07:00:00	YM	Futures	38940.3	39003.4	38905.3	38923.3	6641.0
2022-04-14 08:00:00	YM	Futures	38924.5	38948.2	38861.3	38865.9	7190.0
2022-04-14 09:00:00	YM	Futures	38864.7	39224.3	38851.2	39015.8	35989.0
2022-04-14 10:00:00	YM	Futures	39016.9	39103.7	38924.5	38975.2	25426.0
2022-04-14 11:00:00	YM	Futures	38976.3	39037.2	38880.5	38905.3	13738.0
2022-04-14 12:00:00	YM	Futures	38905.3	38944.8	38821.9	38874.9	10373.0
2022-04-14 13:00:00	YM	Futures	38873.7	38994.4	38833.2	38992.1	8792.0
2022-04-14 14:00:00	YM	Futures	38991.0	39024.8	38832.0	38832.0	10591.0
2022-04-14 15:00:00	YM	Futures	38833.2	38896.3	38715.9	38734.0	18648.0

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

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