PREVIEW / futures_1hour / 2021-12-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-06.parquet
  size:    66 KB
  rows:    2,017

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-06 00:00:00	ES	Futures	5146.71	5154.89	5145.58	5151.22	6388.0
2021-12-06 01:00:00	ES	Futures	5151.51	5153.2	5145.58	5148.12	6066.0
2021-12-06 02:00:00	ES	Futures	5148.4	5152.07	5138.81	5145.58	12113.0
2021-12-06 03:00:00	ES	Futures	5145.58	5152.07	5138.81	5146.99	26463.0
2021-12-06 04:00:00	ES	Futures	5146.99	5160.82	5131.19	5133.73	38411.0
2021-12-06 05:00:00	ES	Futures	5134.01	5138.24	5115.38	5117.08	33796.0
2021-12-06 06:00:00	ES	Futures	5117.36	5143.6	5116.23	5143.04	23732.0
2021-12-06 07:00:00	ES	Futures	5143.32	5145.86	5132.6	5135.14	23507.0
2021-12-06 08:00:00	ES	Futures	5135.7	5146.71	5134.29	5146.43	34177.0
2021-12-06 09:00:00	ES	Futures	5146.14	5159.41	5124.13	5154.33	288301.0
2021-12-06 10:00:00	ES	Futures	5154.05	5178.6	5138.24	5177.75	338759.0
2021-12-06 11:00:00	ES	Futures	5177.75	5179.44	5157.43	5166.74	201446.0
2021-12-06 12:00:00	ES	Futures	5167.03	5192.71	5165.62	5192.43	159516.0
2021-12-06 13:00:00	ES	Futures	5192.71	5204.56	5188.76	5200.89	155943.0
2021-12-06 14:00:00	ES	Futures	5200.89	5205.97	5182.83	5184.24	136943.0
2021-12-06 15:00:00	ES	Futures	5183.96	5192.43	5177.75	5182.83	283313.0
2021-12-06 16:00:00	ES	Futures	5182.83	5187.35	5178.88	5187.35	63287.0
2021-12-06 18:00:00	ES	Futures	5186.22	5190.17	5181.42	5185.65	6793.0
2021-12-06 19:00:00	ES	Futures	5185.65	5187.06	5178.32	5185.09	7597.0
2021-12-06 20:00:00	ES	Futures	5185.09	5197.51	5184.52	5192.99	12260.0
2021-12-06 21:00:00	ES	Futures	5192.99	5193.84	5185.65	5186.78	6300.0
2021-12-06 22:00:00	ES	Futures	5186.78	5194.68	5184.81	5194.12	4694.0
2021-12-06 23:00:00	ES	Futures	5194.4	5202.3	5193.55	5200.33	5999.0
2021-12-06 00:00:00	NQ	Futures	18242.54	18285.72	18236.45	18275.0	4871.0
2021-12-06 01:00:00	NQ	Futures	18275.29	18279.93	18239.93	18254.13	4090.0
2021-12-06 02:00:00	NQ	Futures	18253.26	18264.57	18190.66	18235.01	8528.0
2021-12-06 03:00:00	NQ	Futures	18234.72	18294.71	18234.43	18265.44	13470.0
2021-12-06 04:00:00	NQ	Futures	18264.86	18326.88	18176.17	18183.71	16043.0
2021-12-06 05:00:00	NQ	Futures	18184.0	18202.55	18075.32	18085.75	16232.0
2021-12-06 06:00:00	NQ	Futures	18085.75	18188.63	18081.98	18185.74	12178.0
2021-12-06 07:00:00	NQ	Futures	18186.61	18193.27	18124.01	18147.77	10068.0
2021-12-06 08:00:00	NQ	Futures	18149.8	18222.83	18143.13	18214.43	17702.0
2021-12-06 09:00:00	NQ	Futures	18214.72	18270.65	18037.35	18161.97	110697.0
2021-12-06 10:00:00	NQ	Futures	18161.39	18302.53	18085.17	18238.19	118044.0
2021-12-06 11:00:00	NQ	Futures	18237.03	18279.06	18150.09	18220.22	73028.0
2021-12-06 12:00:00	NQ	Futures	18220.8	18350.35	18204.86	18349.48	51185.0
2021-12-06 13:00:00	NQ	Futures	18349.48	18411.79	18328.91	18399.33	45629.0
2021-12-06 14:00:00	NQ	Futures	18399.33	18429.18	18350.93	18360.79	45598.0
2021-12-06 15:00:00	NQ	Futures	18360.21	18413.53	18344.56	18366.0	67699.0
2021-12-06 16:00:00	NQ	Futures	18366.0	18374.99	18345.72	18373.54	14155.0
2021-12-06 18:00:00	NQ	Futures	18372.96	18385.42	18348.61	18365.42	4034.0
2021-12-06 19:00:00	NQ	Futures	18366.0	18370.06	18344.85	18366.29	4897.0
2021-12-06 20:00:00	NQ	Futures	18366.58	18414.69	18364.84	18397.59	6448.0
2021-12-06 21:00:00	NQ	Futures	18399.04	18403.97	18369.77	18375.57	3504.0
2021-12-06 22:00:00	NQ	Futures	18376.44	18402.81	18368.61	18401.94	3175.0
2021-12-06 23:00:00	NQ	Futures	18401.94	18432.08	18394.69	18420.49	4397.0
2021-12-06 00:00:00	YM	Futures	38999.7	39049.1	38993.0	39021.0	1811.0
2021-12-06 01:00:00	YM	Futures	39022.1	39032.2	38987.4	39012.1	2405.0
2021-12-06 02:00:00	YM	Futures	39009.8	39040.1	38958.3	38989.6	5171.0
2021-12-06 03:00:00	YM	Futures	38989.6	39023.3	38901.1	38963.9	8082.0

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

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