PREVIEW / futures_1hour / 2021-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-20.parquet
  size:    65 KB
  rows:    2,019

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-20 00:00:00	ES	Futures	5092.8	5093.09	5089.7	5089.98	2894.0
2021-10-20 01:00:00	ES	Futures	5090.27	5091.11	5086.31	5088.57	5916.0
2021-10-20 02:00:00	ES	Futures	5088.57	5088.85	5084.62	5086.03	8298.0
2021-10-20 03:00:00	ES	Futures	5086.31	5097.6	5084.34	5089.14	20011.0
2021-10-20 04:00:00	ES	Futures	5089.14	5093.37	5088.01	5092.52	11004.0
2021-10-20 05:00:00	ES	Futures	5092.24	5095.06	5089.42	5092.8	7026.0
2021-10-20 06:00:00	ES	Futures	5092.8	5094.5	5090.55	5092.8	11591.0
2021-10-20 07:00:00	ES	Futures	5092.52	5094.5	5087.44	5088.01	16129.0
2021-10-20 08:00:00	ES	Futures	5088.29	5093.93	5088.01	5092.52	21212.0
2021-10-20 09:00:00	ES	Futures	5092.52	5107.76	5090.27	5103.25	136398.0
2021-10-20 10:00:00	ES	Futures	5103.25	5116.23	5100.14	5108.61	161590.0
2021-10-20 11:00:00	ES	Futures	5108.61	5113.97	5105.5	5113.41	95324.0
2021-10-20 12:00:00	ES	Futures	5113.41	5114.25	5110.02	5113.41	54106.0
2021-10-20 13:00:00	ES	Futures	5113.41	5113.97	5096.76	5105.5	121296.0
2021-10-20 14:00:00	ES	Futures	5105.5	5111.71	5104.38	5110.3	68542.0
2021-10-20 15:00:00	ES	Futures	5110.58	5113.41	5103.81	5112.84	140722.0
2021-10-20 16:00:00	ES	Futures	5112.56	5115.1	5106.07	5108.04	44614.0
2021-10-20 18:00:00	ES	Futures	5108.04	5109.74	5105.22	5107.2	4430.0
2021-10-20 19:00:00	ES	Futures	5107.2	5108.89	5102.96	5103.25	4222.0
2021-10-20 20:00:00	ES	Futures	5103.25	5105.5	5100.42	5103.81	7171.0
2021-10-20 21:00:00	ES	Futures	5103.53	5110.3	5101.55	5109.17	7177.0
2021-10-20 22:00:00	ES	Futures	5109.17	5111.15	5108.33	5109.17	3317.0
2021-10-20 23:00:00	ES	Futures	5109.17	5109.46	5104.09	5104.09	3402.0
2021-10-20 00:00:00	NQ	Futures	17837.96	17838.83	17827.23	17830.71	1779.0
2021-10-20 01:00:00	NQ	Futures	17831.0	17836.8	17817.67	17829.26	3134.0
2021-10-20 02:00:00	NQ	Futures	17829.84	17831.29	17815.64	17823.47	4438.0
2021-10-20 03:00:00	NQ	Futures	17823.75	17866.36	17817.96	17827.52	11395.0
2021-10-20 04:00:00	NQ	Futures	17828.1	17848.68	17823.75	17842.59	5706.0
2021-10-20 05:00:00	NQ	Futures	17842.3	17860.56	17835.35	17854.77	4087.0
2021-10-20 06:00:00	NQ	Futures	17855.35	17868.1	17847.81	17862.3	4258.0
2021-10-20 07:00:00	NQ	Futures	17862.59	17867.52	17837.09	17840.56	5599.0
2021-10-20 08:00:00	NQ	Futures	17840.56	17877.37	17839.98	17867.52	11496.0
2021-10-20 09:00:00	NQ	Futures	17867.52	17897.95	17849.55	17859.98	76119.0
2021-10-20 10:00:00	NQ	Futures	17859.69	17906.64	17829.55	17856.79	75370.0
2021-10-20 11:00:00	NQ	Futures	17857.08	17878.24	17833.32	17875.63	49002.0
2021-10-20 12:00:00	NQ	Futures	17875.92	17877.08	17828.39	17843.46	30515.0
2021-10-20 13:00:00	NQ	Futures	17843.17	17848.1	17758.84	17800.28	51475.0
2021-10-20 14:00:00	NQ	Futures	17800.86	17828.1	17796.51	17820.86	29799.0
2021-10-20 15:00:00	NQ	Futures	17821.15	17836.51	17801.73	17833.03	45317.0
2021-10-20 16:00:00	NQ	Futures	17832.74	17839.41	17797.38	17803.76	12689.0
2021-10-20 18:00:00	NQ	Futures	17803.47	17811.0	17788.69	17793.03	2330.0
2021-10-20 19:00:00	NQ	Futures	17793.61	17801.15	17777.09	17778.25	2570.0
2021-10-20 20:00:00	NQ	Futures	17777.67	17790.14	17772.17	17783.18	3825.0
2021-10-20 21:00:00	NQ	Futures	17782.89	17809.55	17767.24	17804.05	5367.0
2021-10-20 22:00:00	NQ	Futures	17804.34	17814.48	17798.83	17801.73	2802.0
2021-10-20 23:00:00	NQ	Futures	17802.02	17803.47	17779.41	17779.41	2407.0
2021-10-20 00:00:00	YM	Futures	39608.4	39610.6	39592.7	39593.8	836.0
2021-10-20 01:00:00	YM	Futures	39592.7	39597.2	39560.2	39580.4	1218.0
2021-10-20 02:00:00	YM	Futures	39581.5	39582.6	39541.1	39555.7	2015.0
2021-10-20 03:00:00	YM	Futures	39555.7	39642.0	39536.6	39582.6	3661.0

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

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