PREVIEW / futures_1hour / 2021-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-17.parquet
  size:    56 KB
  rows:    1,606

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-12-17 00:00:00	ES	Futures	5264.93	5268.04	5256.73	5262.95	7976.0
2021-12-17 01:00:00	ES	Futures	5262.95	5267.19	5256.44	5262.1	7852.0
2021-12-17 02:00:00	ES	Futures	5262.38	5274.82	5261.25	5273.69	11255.0
2021-12-17 03:00:00	ES	Futures	5273.98	5278.22	5262.1	5265.78	23275.0
2021-12-17 04:00:00	ES	Futures	5265.78	5266.62	5242.59	5262.66	42145.0
2021-12-17 05:00:00	ES	Futures	5262.95	5264.64	5246.83	5253.05	24953.0
2021-12-17 06:00:00	ES	Futures	5252.77	5259.55	5248.81	5257.86	20020.0
2021-12-17 07:00:00	ES	Futures	5257.86	5259.55	5230.99	5237.49	42932.0
2021-12-17 08:00:00	ES	Futures	5237.49	5242.02	5233.25	5240.61	63386.0
2021-12-17 09:00:00	ES	Futures	5240.61	5242.59	5206.39	5219.11	382489.0
2021-12-17 10:00:00	ES	Futures	5219.11	5259.27	5192.25	5251.35	413746.0
2021-12-17 11:00:00	ES	Futures	5251.35	5268.04	5218.26	5229.86	286023.0
2021-12-17 12:00:00	ES	Futures	5229.58	5244.85	5212.04	5234.38	209170.0
2021-12-17 13:00:00	ES	Futures	5234.1	5256.73	5226.18	5255.31	144195.0
2021-12-17 14:00:00	ES	Futures	5255.59	5256.44	5234.67	5240.61	134674.0
2021-12-17 15:00:00	ES	Futures	5240.61	5251.63	5209.21	5213.17	394130.0
2021-12-17 16:00:00	ES	Futures	5213.17	5227.03	5210.91	5225.33	98231.0
2021-12-17 00:00:00	NQ	Futures	18354.99	18372.67	18317.6	18353.54	6699.0
2021-12-17 01:00:00	NQ	Futures	18352.38	18371.22	18309.2	18336.73	5954.0
2021-12-17 02:00:00	NQ	Futures	18336.44	18397.3	18330.07	18384.55	7315.0
2021-12-17 03:00:00	NQ	Futures	18385.13	18401.07	18286.88	18316.44	12143.0
2021-12-17 04:00:00	NQ	Futures	18317.6	18324.27	18173.56	18276.74	23261.0
2021-12-17 05:00:00	NQ	Futures	18277.61	18285.43	18204.28	18229.21	11641.0
2021-12-17 06:00:00	NQ	Futures	18228.05	18279.06	18220.22	18272.68	9361.0
2021-12-17 07:00:00	NQ	Futures	18272.1	18281.09	18155.89	18193.56	16188.0
2021-12-17 08:00:00	NQ	Futures	18193.56	18237.32	18165.45	18234.43	21558.0
2021-12-17 09:00:00	NQ	Futures	18235.01	18366.29	18150.67	18295.58	127146.0
2021-12-17 10:00:00	NQ	Futures	18295.87	18450.34	18144.58	18429.18	129049.0
2021-12-17 11:00:00	NQ	Futures	18429.18	18497.87	18270.36	18334.99	99757.0
2021-12-17 12:00:00	NQ	Futures	18334.41	18389.19	18248.92	18334.99	74084.0
2021-12-17 13:00:00	NQ	Futures	18334.41	18439.62	18298.77	18432.95	49204.0
2021-12-17 14:00:00	NQ	Futures	18434.11	18453.24	18358.18	18391.22	50046.0
2021-12-17 15:00:00	NQ	Futures	18391.8	18446.28	18275.0	18292.68	86576.0
2021-12-17 16:00:00	NQ	Futures	18294.13	18354.12	18289.2	18349.48	17712.0
2021-12-17 00:00:00	YM	Futures	40196.1	40214.1	40139.9	40181.5	1453.0
2021-12-17 01:00:00	YM	Futures	40181.5	40212.9	40151.1	40189.3	1702.0
2021-12-17 02:00:00	YM	Futures	40190.5	40268.0	40183.7	40262.4	3309.0
2021-12-17 03:00:00	YM	Futures	40263.5	40317.5	40237.7	40245.5	6701.0
2021-12-17 04:00:00	YM	Futures	40244.4	40263.5	40134.3	40239.9	8113.0
2021-12-17 05:00:00	YM	Futures	40242.2	40255.6	40142.1	40192.7	4365.0
2021-12-17 06:00:00	YM	Futures	40193.8	40204.0	40146.6	40189.3	3233.0
2021-12-17 07:00:00	YM	Futures	40189.3	40206.2	40026.4	40055.6	6431.0
2021-12-17 08:00:00	YM	Futures	40055.6	40075.8	40020.8	40057.9	7870.0
2021-12-17 09:00:00	YM	Futures	40056.7	40065.7	39616.2	39672.4	46470.0
2021-12-17 10:00:00	YM	Futures	39673.5	39935.4	39517.3	39864.6	47076.0
2021-12-17 11:00:00	YM	Futures	39864.6	39950.0	39642.1	39693.7	30975.0
2021-12-17 12:00:00	YM	Futures	39692.6	39800.5	39579.1	39751.1	21799.0
2021-12-17 13:00:00	YM	Futures	39748.8	39873.6	39675.8	39865.7	15097.0
2021-12-17 14:00:00	YM	Futures	39866.8	39872.4	39723.0	39775.8	14181.0
2021-12-17 15:00:00	YM	Futures	39775.8	39843.2	39567.9	39615.1	33042.0

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

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