PREVIEW / futures_1hour / 2021-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-15.parquet
  size:    61 KB
  rows:    1,867

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-03-15 00:00:00	ES	Futures	4425.55	4426.67	4420.77	4425.27	3932.0
2021-03-15 01:00:00	ES	Futures	4425.27	4426.95	4417.12	4417.68	8552.0
2021-03-15 02:00:00	ES	Futures	4417.96	4421.9	4412.9	4418.8	7254.0
2021-03-15 03:00:00	ES	Futures	4418.8	4420.49	4410.38	4419.65	10415.0
2021-03-15 04:00:00	ES	Futures	4419.65	4431.73	4417.4	4430.61	19934.0
2021-03-15 05:00:00	ES	Futures	4430.61	4436.79	4430.32	4433.98	11219.0
2021-03-15 06:00:00	ES	Futures	4434.26	4434.54	4426.39	4429.76	11699.0
2021-03-15 07:00:00	ES	Futures	4429.76	4430.89	4423.86	4424.42	18644.0
2021-03-15 08:00:00	ES	Futures	4424.7	4425.27	4414.31	4417.96	22650.0
2021-03-15 09:00:00	ES	Futures	4417.96	4427.23	4415.99	4419.65	143562.0
2021-03-15 10:00:00	ES	Futures	4419.65	4421.33	4412.34	4419.37	153406.0
2021-03-15 11:00:00	ES	Futures	4419.37	4421.9	4397.73	4409.53	142194.0
2021-03-15 12:00:00	ES	Futures	4409.53	4422.18	4408.41	4421.61	82231.0
2021-03-15 13:00:00	ES	Futures	4421.33	4427.23	4418.24	4427.23	47731.0
2021-03-15 14:00:00	ES	Futures	4426.95	4436.79	4426.95	4433.42	73016.0
2021-03-15 15:00:00	ES	Futures	4433.7	4450.27	4425.27	4447.74	184607.0
2021-03-15 16:00:00	ES	Futures	4447.74	4450.84	4446.06	4446.9	53071.0
2021-03-15 18:00:00	ES	Futures	4448.03	4448.87	4440.72	4441.84	5780.0
2021-03-15 19:00:00	ES	Futures	4441.84	4444.37	4440.44	4441.56	5448.0
2021-03-15 20:00:00	ES	Futures	4441.56	4445.5	4440.44	4444.65	10315.0
2021-03-15 21:00:00	ES	Futures	4444.65	4453.36	4444.37	4450.27	11975.0
2021-03-15 22:00:00	ES	Futures	4450.55	4450.84	4444.93	4450.55	7775.0
2021-03-15 23:00:00	ES	Futures	4450.55	4451.96	4447.74	4449.43	4864.0
2021-03-15 00:00:00	NQ	Futures	14978.78	14994.12	14957.93	14988.04	3434.0
2021-03-15 01:00:00	NQ	Futures	14987.17	14994.41	14931.3	14935.64	5698.0
2021-03-15 02:00:00	NQ	Futures	14936.51	14960.83	14906.4	14942.88	5286.0
2021-03-15 03:00:00	NQ	Futures	14944.33	14948.09	14894.53	14922.9	4826.0
2021-03-15 04:00:00	NQ	Futures	14923.19	15003.96	14911.32	14997.88	6892.0
2021-03-15 05:00:00	NQ	Futures	14998.46	15039.28	14992.67	15025.38	3037.0
2021-03-15 06:00:00	NQ	Futures	15025.38	15029.15	14986.01	15009.46	4085.0
2021-03-15 07:00:00	NQ	Futures	15008.3	15023.07	14968.06	14969.22	4536.0
2021-03-15 08:00:00	NQ	Futures	14971.54	14973.56	14939.69	14961.41	7206.0
2021-03-15 09:00:00	NQ	Futures	14960.83	15023.65	14923.48	14998.46	45457.0
2021-03-15 10:00:00	NQ	Futures	14998.17	15038.99	14936.8	15014.38	48435.0
2021-03-15 11:00:00	NQ	Futures	15014.38	15029.44	14904.66	14964.3	43148.0
2021-03-15 12:00:00	NQ	Futures	14963.43	15009.46	14955.33	14997.3	23274.0
2021-03-15 13:00:00	NQ	Futures	14997.3	15026.54	14977.33	15020.75	16440.0
2021-03-15 14:00:00	NQ	Futures	15021.04	15079.52	15021.04	15076.62	20997.0
2021-03-15 15:00:00	NQ	Futures	15076.34	15140.02	15043.62	15132.79	35076.0
2021-03-15 16:00:00	NQ	Futures	15132.21	15157.1	15124.97	15137.71	9416.0
2021-03-15 18:00:00	NQ	Futures	15138.29	15146.68	15118.31	15124.97	2553.0
2021-03-15 19:00:00	NQ	Futures	15125.55	15135.97	15115.13	15117.44	2212.0
2021-03-15 20:00:00	NQ	Futures	15118.02	15142.63	15109.63	15140.6	3817.0
2021-03-15 21:00:00	NQ	Futures	15140.6	15194.74	15135.39	15185.19	5682.0
2021-03-15 22:00:00	NQ	Futures	15184.32	15186.34	15151.03	15185.48	4493.0
2021-03-15 23:00:00	NQ	Futures	15185.76	15201.4	15177.37	15189.24	3731.0
2021-03-15 00:00:00	YM	Futures	36460.8	36464.2	36426.3	36454.2	923.0
2021-03-15 01:00:00	YM	Futures	36454.2	36460.8	36408.5	36418.5	1266.0
2021-03-15 02:00:00	YM	Futures	36419.6	36445.3	36396.2	36430.8	1623.0
2021-03-15 03:00:00	YM	Futures	36430.8	36450.8	36361.7	36447.5	2771.0

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

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