PREVIEW / futures_1hour / 2021-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-01.parquet
  size:    66 KB
  rows:    2,037

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-11-01 00:00:00	ES	Futures	5199.76	5200.61	5198.35	5199.2	4173.0
2021-11-01 01:00:00	ES	Futures	5199.2	5202.3	5196.94	5197.79	7576.0
2021-11-01 02:00:00	ES	Futures	5198.07	5198.35	5194.4	5197.51	7033.0
2021-11-01 03:00:00	ES	Futures	5197.22	5199.76	5196.94	5198.07	6148.0
2021-11-01 04:00:00	ES	Futures	5198.35	5209.64	5198.07	5209.36	20035.0
2021-11-01 05:00:00	ES	Futures	5209.36	5213.31	5208.79	5210.21	12139.0
2021-11-01 06:00:00	ES	Futures	5210.49	5213.87	5210.21	5213.59	11849.0
2021-11-01 07:00:00	ES	Futures	5213.31	5214.72	5209.64	5210.77	12048.0
2021-11-01 08:00:00	ES	Futures	5210.77	5210.77	5202.59	5203.15	23788.0
2021-11-01 09:00:00	ES	Futures	5202.87	5206.25	5188.47	5190.17	175549.0
2021-11-01 10:00:00	ES	Futures	5190.17	5191.58	5177.47	5182.55	170992.0
2021-11-01 11:00:00	ES	Futures	5182.27	5192.99	5181.7	5192.43	87176.0
2021-11-01 12:00:00	ES	Futures	5192.43	5198.35	5191.01	5197.79	67046.0
2021-11-01 13:00:00	ES	Futures	5198.07	5198.35	5183.11	5185.09	81389.0
2021-11-01 14:00:00	ES	Futures	5184.81	5190.73	5177.75	5189.04	88145.0
2021-11-01 15:00:00	ES	Futures	5189.32	5200.61	5186.5	5199.48	148747.0
2021-11-01 16:00:00	ES	Futures	5199.2	5199.48	5195.53	5199.2	41112.0
2021-11-01 18:00:00	ES	Futures	5199.2	5202.02	5195.81	5201.17	4310.0
2021-11-01 19:00:00	ES	Futures	5201.17	5201.17	5196.38	5196.38	4796.0
2021-11-01 20:00:00	ES	Futures	5196.66	5197.79	5194.68	5196.09	5680.0
2021-11-01 21:00:00	ES	Futures	5196.38	5198.92	5190.17	5191.01	10621.0
2021-11-01 22:00:00	ES	Futures	5191.3	5192.71	5187.06	5187.63	6898.0
2021-11-01 23:00:00	ES	Futures	5187.63	5189.32	5185.09	5188.47	5370.0
2021-11-01 00:00:00	NQ	Futures	18399.62	18407.45	18397.59	18404.84	1289.0
2021-11-01 01:00:00	NQ	Futures	18404.84	18422.52	18404.84	18410.06	2538.0
2021-11-01 02:00:00	NQ	Futures	18410.63	18411.21	18383.68	18397.59	2756.0
2021-11-01 03:00:00	NQ	Futures	18396.72	18412.66	18396.43	18399.33	2907.0
2021-11-01 04:00:00	NQ	Futures	18399.91	18436.72	18399.33	18434.98	6509.0
2021-11-01 05:00:00	NQ	Futures	18435.56	18447.73	18425.13	18430.63	3783.0
2021-11-01 06:00:00	NQ	Futures	18430.63	18441.65	18422.52	18440.49	2586.0
2021-11-01 07:00:00	NQ	Futures	18440.49	18449.47	18427.73	18429.47	4518.0
2021-11-01 08:00:00	NQ	Futures	18429.47	18432.08	18383.68	18394.12	10041.0
2021-11-01 09:00:00	NQ	Futures	18394.69	18395.85	18313.84	18321.37	79806.0
2021-11-01 10:00:00	NQ	Futures	18322.24	18350.35	18279.93	18325.72	79079.0
2021-11-01 11:00:00	NQ	Futures	18325.43	18387.74	18323.11	18386.58	40998.0
2021-11-01 12:00:00	NQ	Futures	18387.16	18393.25	18370.93	18386.29	24292.0
2021-11-01 13:00:00	NQ	Futures	18386.29	18399.62	18324.85	18339.34	36388.0
2021-11-01 14:00:00	NQ	Futures	18338.76	18351.22	18303.69	18346.01	33659.0
2021-11-01 15:00:00	NQ	Futures	18346.3	18431.21	18341.37	18425.13	44542.0
2021-11-01 16:00:00	NQ	Futures	18424.84	18426.86	18401.94	18418.17	9517.0
2021-11-01 18:00:00	NQ	Futures	18421.94	18425.71	18403.97	18421.65	2633.0
2021-11-01 19:00:00	NQ	Futures	18421.94	18422.23	18403.68	18405.13	2321.0
2021-11-01 20:00:00	NQ	Futures	18405.42	18411.21	18394.12	18406.29	2674.0
2021-11-01 21:00:00	NQ	Futures	18406.87	18419.91	18387.16	18393.54	3605.0
2021-11-01 22:00:00	NQ	Futures	18393.83	18399.33	18380.49	18385.13	2470.0
2021-11-01 23:00:00	NQ	Futures	18386.0	18390.64	18373.83	18390.06	2753.0
2021-11-01 00:00:00	YM	Futures	40108.3	40117.3	40093.7	40100.5	783.0
2021-11-01 01:00:00	YM	Futures	40100.5	40116.2	40076.9	40083.6	1428.0
2021-11-01 02:00:00	YM	Futures	40082.5	40085.9	40057.9	40074.7	1173.0
2021-11-01 03:00:00	YM	Futures	40073.6	40099.3	40073.6	40096.0	2036.0

> showing 50 of 2,037 rows — these rows as CSV

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