PREVIEW / futures_1hour / 2021-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-09.parquet
  size:    54 KB
  rows:    1,572

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-07-09 00:00:00	ES	Futures	4845.47	4850.82	4843.78	4849.69	6822.0
2021-07-09 01:00:00	ES	Futures	4849.41	4856.73	4849.13	4854.48	12991.0
2021-07-09 02:00:00	ES	Futures	4854.48	4864.33	4852.51	4858.7	16766.0
2021-07-09 03:00:00	ES	Futures	4858.7	4870.81	4858.14	4864.61	32376.0
2021-07-09 04:00:00	ES	Futures	4864.61	4874.75	4864.61	4872.78	22720.0
2021-07-09 05:00:00	ES	Futures	4872.5	4878.98	4869.68	4870.25	26176.0
2021-07-09 06:00:00	ES	Futures	4869.96	4875.31	4865.46	4873.91	19947.0
2021-07-09 07:00:00	ES	Futures	4873.91	4883.76	4872.78	4881.79	33929.0
2021-07-09 08:00:00	ES	Futures	4882.07	4883.76	4877.85	4879.26	20655.0
2021-07-09 09:00:00	ES	Futures	4878.98	4890.24	4875.03	4889.68	166141.0
2021-07-09 10:00:00	ES	Futures	4889.68	4899.25	4889.68	4895.59	206093.0
2021-07-09 11:00:00	ES	Futures	4895.59	4908.26	4895.31	4902.63	145154.0
2021-07-09 12:00:00	ES	Futures	4902.63	4906.57	4900.38	4903.75	72994.0
2021-07-09 13:00:00	ES	Futures	4903.75	4905.73	4900.94	4905.16	59531.0
2021-07-09 14:00:00	ES	Futures	4905.16	4913.05	4905.16	4912.2	66582.0
2021-07-09 15:00:00	ES	Futures	4912.2	4915.3	4909.1	4911.08	227458.0
2021-07-09 16:00:00	ES	Futures	4910.79	4913.05	4908.82	4913.05	59365.0
2021-07-09 00:00:00	NQ	Futures	17004.87	17017.33	16989.52	17011.53	3269.0
2021-07-09 01:00:00	NQ	Futures	17010.37	17043.4	17009.79	17029.78	5016.0
2021-07-09 02:00:00	NQ	Futures	17030.07	17046.87	17021.09	17025.44	4830.0
2021-07-09 03:00:00	NQ	Futures	17026.31	17082.79	17018.77	17048.9	10189.0
2021-07-09 04:00:00	NQ	Futures	17048.9	17081.06	17048.61	17061.36	7060.0
2021-07-09 05:00:00	NQ	Futures	17061.07	17077.58	17025.15	17031.81	8329.0
2021-07-09 06:00:00	NQ	Futures	17031.81	17033.55	16995.89	17023.41	9774.0
2021-07-09 07:00:00	NQ	Futures	17023.41	17065.99	17023.41	17063.96	9406.0
2021-07-09 08:00:00	NQ	Futures	17063.67	17078.45	17028.91	17039.05	11227.0
2021-07-09 09:00:00	NQ	Futures	17038.18	17062.23	16996.18	17046.87	73346.0
2021-07-09 10:00:00	NQ	Futures	17047.45	17120.45	17034.13	17118.42	71046.0
2021-07-09 11:00:00	NQ	Futures	17118.71	17161.59	17114.08	17146.52	48344.0
2021-07-09 12:00:00	NQ	Futures	17146.52	17186.21	17146.23	17170.86	32789.0
2021-07-09 13:00:00	NQ	Futures	17170.57	17171.73	17146.52	17160.43	26381.0
2021-07-09 14:00:00	NQ	Futures	17160.14	17176.65	17145.36	17173.17	21269.0
2021-07-09 15:00:00	NQ	Futures	17173.46	17181.57	17151.16	17161.01	39490.0
2021-07-09 16:00:00	NQ	Futures	17160.72	17165.64	17152.32	17165.64	9996.0
2021-07-09 00:00:00	YM	Futures	38225.7	38279.3	38220.1	38272.6	1589.0
2021-07-09 01:00:00	YM	Futures	38272.6	38335.2	38270.4	38315.0	2677.0
2021-07-09 02:00:00	YM	Futures	38315.0	38402.2	38298.3	38360.8	3888.0
2021-07-09 03:00:00	YM	Futures	38359.7	38450.2	38353.0	38403.3	6118.0
2021-07-09 04:00:00	YM	Futures	38403.3	38496.0	38403.3	38477.0	4258.0
2021-07-09 05:00:00	YM	Futures	38475.9	38541.8	38474.8	38482.6	5419.0
2021-07-09 06:00:00	YM	Futures	38479.3	38551.9	38467.0	38532.9	3430.0
2021-07-09 07:00:00	YM	Futures	38531.8	38611.1	38524.0	38599.9	5826.0
2021-07-09 08:00:00	YM	Futures	38599.9	38621.2	38587.7	38602.2	4785.0
2021-07-09 09:00:00	YM	Futures	38602.2	38732.9	38499.4	38709.4	27657.0
2021-07-09 10:00:00	YM	Futures	38709.4	38795.5	38709.4	38724.0	25850.0
2021-07-09 11:00:00	YM	Futures	38725.1	38849.1	38724.0	38805.5	15248.0
2021-07-09 12:00:00	YM	Futures	38806.6	38829.0	38766.4	38779.8	7121.0
2021-07-09 13:00:00	YM	Futures	38778.7	38815.6	38765.3	38806.6	5084.0
2021-07-09 14:00:00	YM	Futures	38805.5	38856.9	38803.3	38849.1	6344.0
2021-07-09 15:00:00	YM	Futures	38849.1	38862.5	38815.6	38827.9	15463.0

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

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