PREVIEW / futures_1hour / 2021-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-19.parquet
  size:    62 KB
  rows:    1,946

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-01-19 00:00:00	ES	Futures	4254.34	4255.46	4245.92	4247.61	8679.0
2021-01-19 01:00:00	ES	Futures	4247.89	4253.22	4246.48	4252.1	6249.0
2021-01-19 02:00:00	ES	Futures	4252.1	4257.71	4250.13	4256.59	8698.0
2021-01-19 03:00:00	ES	Futures	4256.59	4257.71	4247.32	4248.17	13161.0
2021-01-19 04:00:00	ES	Futures	4248.45	4254.34	4246.48	4252.94	10311.0
2021-01-19 05:00:00	ES	Futures	4252.94	4255.46	4249.85	4253.22	8858.0
2021-01-19 06:00:00	ES	Futures	4253.5	4257.43	4253.22	4256.87	8252.0
2021-01-19 07:00:00	ES	Futures	4256.87	4257.15	4250.41	4254.62	17323.0
2021-01-19 08:00:00	ES	Futures	4254.62	4255.46	4250.41	4250.97	14330.0
2021-01-19 09:00:00	ES	Futures	4250.97	4257.71	4238.34	4245.92	178834.0
2021-01-19 10:00:00	ES	Futures	4245.92	4250.69	4238.06	4245.64	178144.0
2021-01-19 11:00:00	ES	Futures	4245.92	4248.73	4234.98	4245.08	128604.0
2021-01-19 12:00:00	ES	Futures	4245.08	4257.99	4243.96	4256.87	85925.0
2021-01-19 13:00:00	ES	Futures	4257.15	4262.76	4256.31	4261.36	80804.0
2021-01-19 14:00:00	ES	Futures	4261.64	4261.92	4254.9	4258.27	71252.0
2021-01-19 15:00:00	ES	Futures	4257.99	4261.64	4254.9	4255.46	178006.0
2021-01-19 16:00:00	ES	Futures	4255.46	4259.67	4252.66	4259.39	46802.0
2021-01-19 18:00:00	ES	Futures	4262.48	4270.34	4259.11	4270.06	11112.0
2021-01-19 19:00:00	ES	Futures	4269.78	4270.06	4263.32	4264.16	7384.0
2021-01-19 20:00:00	ES	Futures	4263.88	4265.57	4255.18	4260.8	12966.0
2021-01-19 21:00:00	ES	Futures	4260.8	4265.57	4260.8	4264.73	5969.0
2021-01-19 22:00:00	ES	Futures	4264.73	4265.01	4257.99	4260.8	5940.0
2021-01-19 23:00:00	ES	Futures	4260.52	4260.52	4253.22	4259.39	7575.0
2021-01-19 00:00:00	NQ	Futures	14974.14	14979.06	14947.52	14951.86	3891.0
2021-01-19 01:00:00	NQ	Futures	14952.15	14965.46	14939.7	14952.15	2628.0
2021-01-19 02:00:00	NQ	Futures	14952.15	14981.09	14946.65	14977.62	4414.0
2021-01-19 03:00:00	NQ	Futures	14977.04	14978.77	14943.46	14948.09	6133.0
2021-01-19 04:00:00	NQ	Futures	14948.09	14968.07	14944.91	14964.3	4788.0
2021-01-19 05:00:00	NQ	Futures	14965.46	14972.7	14957.94	14965.17	3050.0
2021-01-19 06:00:00	NQ	Futures	14965.46	14975.3	14964.01	14972.12	2700.0
2021-01-19 07:00:00	NQ	Futures	14972.41	14972.7	14927.26	14942.88	7915.0
2021-01-19 08:00:00	NQ	Futures	14942.31	14946.94	14924.94	14931.31	6184.0
2021-01-19 09:00:00	NQ	Futures	14930.73	14969.8	14889.05	14916.55	73832.0
2021-01-19 10:00:00	NQ	Futures	14916.84	14951.57	14885.87	14910.76	69719.0
2021-01-19 11:00:00	NQ	Futures	14910.76	14943.17	14876.03	14934.78	47504.0
2021-01-19 12:00:00	NQ	Futures	14934.78	15001.64	14930.44	14998.75	37718.0
2021-01-19 13:00:00	NQ	Futures	14998.75	15040.71	14997.3	15037.53	28604.0
2021-01-19 14:00:00	NQ	Futures	15037.53	15045.34	15017.56	15033.77	26195.0
2021-01-19 15:00:00	NQ	Futures	15034.06	15058.08	15029.43	15033.19	43139.0
2021-01-19 16:00:00	NQ	Futures	15032.32	15088.47	15010.03	15088.47	15116.0
2021-01-19 18:00:00	NQ	Futures	15085.29	15113.65	15083.55	15108.73	5072.0
2021-01-19 19:00:00	NQ	Futures	15109.02	15109.02	15090.21	15096.0	2437.0
2021-01-19 20:00:00	NQ	Futures	15096.57	15102.65	15070.24	15095.42	4298.0
2021-01-19 21:00:00	NQ	Futures	15095.71	15107.28	15095.42	15104.39	2214.0
2021-01-19 22:00:00	NQ	Futures	15104.97	15109.02	15082.97	15091.94	2551.0
2021-01-19 23:00:00	NQ	Futures	15091.94	15092.23	15075.45	15086.44	2164.0
2021-01-19 00:00:00	YM	Futures	34257.5	34264.1	34195.4	34215.3	1750.0
2021-01-19 01:00:00	YM	Futures	34216.5	34250.8	34205.4	34242.0	1374.0
2021-01-19 02:00:00	YM	Futures	34243.1	34278.6	34225.3	34274.1	2576.0
2021-01-19 03:00:00	YM	Futures	34273.0	34279.7	34224.2	34232.0	3708.0

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

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