PREVIEW / futures_1hour / 2021-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-15.parquet
  size:    63 KB
  rows:    1,951

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-15 00:00:00	ES	Futures	5012.66	5017.74	5012.66	5017.17	4890.0
2021-09-15 01:00:00	ES	Futures	5017.17	5017.74	5010.12	5011.81	8973.0
2021-09-15 02:00:00	ES	Futures	5012.09	5015.48	5007.29	5013.79	10600.0
2021-09-15 03:00:00	ES	Futures	5013.79	5017.17	5010.68	5013.5	17688.0
2021-09-15 04:00:00	ES	Futures	5013.5	5020.84	5013.5	5018.02	12168.0
2021-09-15 05:00:00	ES	Futures	5017.74	5021.69	5016.33	5019.99	8008.0
2021-09-15 06:00:00	ES	Futures	5020.28	5021.12	5011.25	5012.94	10274.0
2021-09-15 07:00:00	ES	Futures	5012.94	5014.07	5006.17	5010.4	23314.0
2021-09-15 08:00:00	ES	Futures	5010.12	5013.79	5001.65	5012.94	39434.0
2021-09-15 09:00:00	ES	Futures	5012.66	5020.56	4997.98	5016.33	216272.0
2021-09-15 10:00:00	ES	Futures	5016.61	5021.97	5003.34	5016.33	252449.0
2021-09-15 11:00:00	ES	Futures	5016.04	5022.25	5012.94	5020.28	129706.0
2021-09-15 12:00:00	ES	Futures	5020.28	5040.03	5016.33	5037.77	132525.0
2021-09-15 13:00:00	ES	Futures	5038.06	5049.34	5037.77	5043.14	106748.0
2021-09-15 14:00:00	ES	Futures	5043.14	5046.8	5040.31	5042.01	94817.0
2021-09-15 15:00:00	ES	Futures	5042.01	5054.71	5040.88	5048.5	188818.0
2021-09-15 16:00:00	ES	Futures	5048.78	5054.42	5046.24	5053.3	60218.0
2021-09-15 18:00:00	ES	Futures	5052.73	5054.14	5051.6	5053.58	3680.0
2021-09-15 19:00:00	ES	Futures	5053.3	5053.58	5050.19	5051.88	3808.0
2021-09-15 20:00:00	ES	Futures	5051.88	5052.45	5049.34	5051.04	6837.0
2021-09-15 21:00:00	ES	Futures	5051.04	5055.55	5046.24	5046.52	9166.0
2021-09-15 22:00:00	ES	Futures	5046.52	5049.63	5044.55	5048.22	7624.0
2021-09-15 23:00:00	ES	Futures	5048.22	5049.91	5043.14	5043.42	5929.0
2021-09-15 00:00:00	NQ	Futures	17852.16	17867.23	17850.42	17864.62	2196.0
2021-09-15 01:00:00	NQ	Futures	17864.91	17866.36	17844.62	17852.74	4339.0
2021-09-15 02:00:00	NQ	Futures	17852.16	17867.81	17837.67	17860.85	5808.0
2021-09-15 03:00:00	NQ	Futures	17861.43	17879.69	17859.4	17869.26	7127.0
2021-09-15 04:00:00	NQ	Futures	17868.97	17887.51	17868.68	17884.04	3421.0
2021-09-15 05:00:00	NQ	Futures	17883.75	17890.41	17876.79	17885.49	3256.0
2021-09-15 06:00:00	NQ	Futures	17884.91	17886.36	17862.88	17869.84	3279.0
2021-09-15 07:00:00	NQ	Futures	17870.71	17872.44	17844.04	17859.11	6594.0
2021-09-15 08:00:00	NQ	Futures	17858.24	17870.71	17840.56	17864.04	12369.0
2021-09-15 09:00:00	NQ	Futures	17864.33	17891.57	17773.04	17801.73	90182.0
2021-09-15 10:00:00	NQ	Futures	17802.31	17826.94	17745.79	17812.74	87459.0
2021-09-15 11:00:00	NQ	Futures	17811.87	17823.75	17775.36	17805.79	48036.0
2021-09-15 12:00:00	NQ	Futures	17805.5	17903.74	17797.67	17897.66	47558.0
2021-09-15 13:00:00	NQ	Futures	17898.24	17931.28	17892.73	17913.89	33263.0
2021-09-15 14:00:00	NQ	Futures	17913.89	17947.22	17911.28	17941.71	31251.0
2021-09-15 15:00:00	NQ	Futures	17941.42	17985.47	17937.07	17965.48	57224.0
2021-09-15 16:00:00	NQ	Futures	17965.77	17980.55	17961.13	17978.23	9269.0
2021-09-15 18:00:00	NQ	Futures	17979.97	17982.57	17971.85	17975.04	1519.0
2021-09-15 19:00:00	NQ	Futures	17975.33	17975.62	17965.77	17970.98	1394.0
2021-09-15 20:00:00	NQ	Futures	17970.69	17977.94	17962.0	17973.88	2587.0
2021-09-15 21:00:00	NQ	Futures	17973.88	17992.72	17957.07	17957.36	4700.0
2021-09-15 22:00:00	NQ	Futures	17957.07	17972.14	17948.96	17963.45	3438.0
2021-09-15 23:00:00	NQ	Futures	17962.87	17969.24	17946.35	17946.64	2126.0
2021-09-15 00:00:00	YM	Futures	38694.8	38733.0	38692.6	38720.6	1484.0
2021-09-15 01:00:00	YM	Futures	38721.7	38727.4	38659.0	38675.8	2022.0
2021-09-15 02:00:00	YM	Futures	38676.9	38700.4	38638.8	38687.0	2416.0
2021-09-15 03:00:00	YM	Futures	38685.9	38719.5	38647.8	38665.7	3366.0

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

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