PREVIEW / futures_1hour / 2021-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-25.parquet
  size:    63 KB
  rows:    1,996

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-10-25 00:00:00	ES	Futures	5123.57	5125.26	5122.16	5124.98	3634.0
2021-10-25 01:00:00	ES	Futures	5124.98	5128.36	5123.0	5128.08	7111.0
2021-10-25 02:00:00	ES	Futures	5128.08	5128.93	5124.13	5128.36	6886.0
2021-10-25 03:00:00	ES	Futures	5128.36	5128.65	5122.72	5125.54	13808.0
2021-10-25 04:00:00	ES	Futures	5125.54	5132.03	5124.98	5126.39	11378.0
2021-10-25 05:00:00	ES	Futures	5126.67	5128.08	5123.85	5125.26	7369.0
2021-10-25 06:00:00	ES	Futures	5124.98	5128.65	5124.41	5127.23	7474.0
2021-10-25 07:00:00	ES	Futures	5126.95	5129.21	5122.72	5128.93	12341.0
2021-10-25 08:00:00	ES	Futures	5129.21	5130.62	5126.95	5128.36	16887.0
2021-10-25 09:00:00	ES	Futures	5128.36	5134.29	5112.28	5126.39	164317.0
2021-10-25 10:00:00	ES	Futures	5126.67	5133.44	5122.44	5132.6	129976.0
2021-10-25 11:00:00	ES	Futures	5132.31	5141.06	5130.62	5140.78	97983.0
2021-10-25 12:00:00	ES	Futures	5140.78	5148.4	5138.81	5146.14	85864.0
2021-10-25 13:00:00	ES	Futures	5146.43	5152.07	5144.73	5146.14	69588.0
2021-10-25 14:00:00	ES	Futures	5146.43	5152.07	5144.17	5147.27	81693.0
2021-10-25 15:00:00	ES	Futures	5147.55	5148.4	5140.22	5147.84	159581.0
2021-10-25 16:00:00	ES	Futures	5147.84	5154.61	5139.09	5153.48	64866.0
2021-10-25 18:00:00	ES	Futures	5152.92	5154.33	5149.25	5149.81	4245.0
2021-10-25 19:00:00	ES	Futures	5150.09	5156.02	5149.53	5154.89	4058.0
2021-10-25 20:00:00	ES	Futures	5155.17	5161.1	5153.48	5159.69	10837.0
2021-10-25 21:00:00	ES	Futures	5159.69	5164.49	5158.28	5158.84	8633.0
2021-10-25 22:00:00	ES	Futures	5158.56	5161.38	5157.15	5161.1	4093.0
2021-10-25 23:00:00	ES	Futures	5160.82	5161.1	5156.3	5158.0	2807.0
2021-10-25 00:00:00	NQ	Futures	17798.25	17803.18	17794.19	17798.83	1748.0
2021-10-25 01:00:00	NQ	Futures	17799.12	17813.61	17788.98	17810.42	3086.0
2021-10-25 02:00:00	NQ	Futures	17810.71	17834.77	17800.28	17832.74	4916.0
2021-10-25 03:00:00	NQ	Futures	17832.45	17835.35	17808.39	17817.96	5327.0
2021-10-25 04:00:00	NQ	Futures	17818.25	17843.17	17813.61	17820.86	5716.0
2021-10-25 05:00:00	NQ	Futures	17821.15	17831.87	17816.22	17822.02	2811.0
2021-10-25 06:00:00	NQ	Futures	17821.73	17834.48	17820.57	17828.39	3169.0
2021-10-25 07:00:00	NQ	Futures	17828.1	17844.62	17799.99	17841.14	8665.0
2021-10-25 08:00:00	NQ	Futures	17841.14	17848.39	17823.47	17833.03	9724.0
2021-10-25 09:00:00	NQ	Futures	17833.03	17892.15	17762.6	17841.72	84584.0
2021-10-25 10:00:00	NQ	Futures	17842.01	17875.92	17826.65	17862.88	64149.0
2021-10-25 11:00:00	NQ	Futures	17862.59	17899.69	17844.33	17895.05	44863.0
2021-10-25 12:00:00	NQ	Futures	17895.34	17975.04	17891.86	17964.32	41911.0
2021-10-25 13:00:00	NQ	Futures	17964.32	17976.78	17955.91	17957.36	25999.0
2021-10-25 14:00:00	NQ	Futures	17957.65	18016.48	17953.3	17988.95	46531.0
2021-10-25 15:00:00	NQ	Futures	17988.95	17993.88	17944.32	17970.11	49525.0
2021-10-25 16:00:00	NQ	Futures	17970.11	18021.99	17911.86	18019.38	23253.0
2021-10-25 18:00:00	NQ	Futures	18018.51	18018.51	17996.78	17999.96	2949.0
2021-10-25 19:00:00	NQ	Futures	17999.67	18017.64	17996.78	18013.88	2915.0
2021-10-25 20:00:00	NQ	Futures	18014.74	18054.16	18013.3	18046.62	6874.0
2021-10-25 21:00:00	NQ	Futures	18047.2	18065.46	18043.15	18045.75	5131.0
2021-10-25 22:00:00	NQ	Futures	18045.47	18057.06	18039.96	18054.45	2743.0
2021-10-25 23:00:00	NQ	Futures	18054.16	18055.9	18041.41	18046.91	1534.0
2021-10-25 00:00:00	YM	Futures	39865.1	39869.6	39849.4	39867.3	1392.0
2021-10-25 01:00:00	YM	Futures	39867.3	39890.9	39857.2	39887.5	1476.0
2021-10-25 02:00:00	YM	Futures	39888.6	39889.7	39853.9	39872.9	2265.0
2021-10-25 03:00:00	YM	Futures	39874.0	39879.6	39829.2	39865.1	3654.0

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

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