PREVIEW / futures_1hour / 2021-08-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-06.parquet
  size:    53 KB
  rows:    1,578

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-08-06 00:00:00	ES	Futures	4978.37	4978.66	4976.68	4977.53	1887.0
2021-08-06 01:00:00	ES	Futures	4977.53	4979.22	4976.4	4979.22	3651.0
2021-08-06 02:00:00	ES	Futures	4978.94	4980.34	4977.81	4978.66	5778.0
2021-08-06 03:00:00	ES	Futures	4978.37	4979.22	4974.99	4977.25	12632.0
2021-08-06 04:00:00	ES	Futures	4977.25	4982.32	4975.28	4981.47	8728.0
2021-08-06 05:00:00	ES	Futures	4981.47	4982.32	4980.06	4981.75	6289.0
2021-08-06 06:00:00	ES	Futures	4981.75	4984.29	4980.63	4982.32	6901.0
2021-08-06 07:00:00	ES	Futures	4982.32	4984.01	4982.03	4982.03	6680.0
2021-08-06 08:00:00	ES	Futures	4982.32	4989.07	4975.28	4981.19	66460.0
2021-08-06 09:00:00	ES	Futures	4981.47	4993.3	4980.34	4983.16	171354.0
2021-08-06 10:00:00	ES	Futures	4983.16	4989.92	4980.34	4984.01	140955.0
2021-08-06 11:00:00	ES	Futures	4984.01	4989.07	4981.19	4989.07	100533.0
2021-08-06 12:00:00	ES	Futures	4988.79	4991.61	4986.26	4991.33	61090.0
2021-08-06 13:00:00	ES	Futures	4991.33	4992.17	4988.51	4990.2	50162.0
2021-08-06 14:00:00	ES	Futures	4989.92	4991.04	4983.16	4983.16	62302.0
2021-08-06 15:00:00	ES	Futures	4983.16	4990.48	4982.03	4988.79	137703.0
2021-08-06 16:00:00	ES	Futures	4988.79	4990.48	4987.67	4989.92	45721.0
2021-08-06 00:00:00	NQ	Futures	17575.83	17576.12	17571.2	17572.35	902.0
2021-08-06 01:00:00	NQ	Futures	17572.35	17575.25	17566.27	17572.07	1523.0
2021-08-06 02:00:00	NQ	Futures	17572.07	17573.51	17550.05	17555.55	3175.0
2021-08-06 03:00:00	NQ	Futures	17555.84	17559.32	17545.41	17551.5	4221.0
2021-08-06 04:00:00	NQ	Futures	17551.5	17565.98	17544.55	17561.93	3425.0
2021-08-06 05:00:00	NQ	Futures	17561.93	17564.53	17554.1	17560.48	2198.0
2021-08-06 06:00:00	NQ	Futures	17560.77	17561.35	17548.6	17553.24	3025.0
2021-08-06 07:00:00	NQ	Futures	17554.1	17561.06	17551.79	17553.53	2689.0
2021-08-06 08:00:00	NQ	Futures	17553.82	17557.0	17477.05	17507.18	33224.0
2021-08-06 09:00:00	NQ	Futures	17507.47	17554.68	17490.95	17510.36	79956.0
2021-08-06 10:00:00	NQ	Futures	17510.07	17532.38	17459.67	17470.68	73230.0
2021-08-06 11:00:00	NQ	Futures	17470.39	17500.8	17435.63	17500.22	59785.0
2021-08-06 12:00:00	NQ	Futures	17500.51	17503.99	17470.1	17495.01	34368.0
2021-08-06 13:00:00	NQ	Futures	17494.72	17507.76	17484.58	17493.27	24930.0
2021-08-06 14:00:00	NQ	Futures	17493.56	17503.7	17468.07	17472.13	27003.0
2021-08-06 15:00:00	NQ	Futures	17471.84	17497.33	17465.17	17492.4	40407.0
2021-08-06 16:00:00	NQ	Futures	17491.82	17492.4	17479.95	17488.35	8020.0
2021-08-06 00:00:00	YM	Futures	39010.0	39011.1	38994.3	39002.2	488.0
2021-08-06 01:00:00	YM	Futures	39001.0	39020.0	38994.3	39020.0	759.0
2021-08-06 02:00:00	YM	Futures	39018.9	39045.7	39010.0	39031.2	2007.0
2021-08-06 03:00:00	YM	Futures	39031.2	39036.8	38995.4	39020.0	2691.0
2021-08-06 04:00:00	YM	Futures	39018.9	39062.5	39002.2	39055.8	2033.0
2021-08-06 05:00:00	YM	Futures	39055.8	39068.1	39041.3	39054.7	1939.0
2021-08-06 06:00:00	YM	Futures	39053.5	39093.8	39046.8	39070.3	2427.0
2021-08-06 07:00:00	YM	Futures	39070.3	39083.7	39062.5	39064.7	1186.0
2021-08-06 08:00:00	YM	Futures	39065.8	39147.4	39039.0	39139.6	11318.0
2021-08-06 09:00:00	YM	Futures	39137.3	39256.9	39137.3	39168.6	27379.0
2021-08-06 10:00:00	YM	Futures	39169.7	39211.1	39139.6	39189.8	13348.0
2021-08-06 11:00:00	YM	Futures	39188.7	39236.8	39176.4	39198.8	11813.0
2021-08-06 12:00:00	YM	Futures	39199.9	39233.4	39188.7	39230.1	5736.0
2021-08-06 13:00:00	YM	Futures	39230.1	39231.2	39205.5	39216.7	4873.0
2021-08-06 14:00:00	YM	Futures	39216.7	39222.2	39166.4	39169.7	5172.0
2021-08-06 15:00:00	YM	Futures	39169.7	39222.2	39150.7	39207.7	10798.0

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

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