PREVIEW / futures_1hour / 2021-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-18.parquet
  size:    49 KB
  rows:    1,446

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-01-18 00:00:00	ES	Futures	4214.21	4218.98	4211.96	4218.14	3988.0
2021-01-18 01:00:00	ES	Futures	4217.85	4218.42	4214.21	4214.77	2673.0
2021-01-18 02:00:00	ES	Futures	4214.77	4215.33	4210.0	4212.52	5630.0
2021-01-18 03:00:00	ES	Futures	4212.24	4218.14	4210.56	4213.64	8823.0
2021-01-18 04:00:00	ES	Futures	4213.64	4216.17	4211.96	4214.77	5946.0
2021-01-18 05:00:00	ES	Futures	4214.77	4220.66	4213.93	4218.42	6810.0
2021-01-18 06:00:00	ES	Futures	4218.42	4229.08	4217.85	4223.47	15523.0
2021-01-18 07:00:00	ES	Futures	4223.75	4225.71	4220.1	4220.66	5669.0
2021-01-18 08:00:00	ES	Futures	4220.66	4226.56	4220.1	4225.71	6405.0
2021-01-18 09:00:00	ES	Futures	4225.71	4225.99	4221.5	4225.99	8588.0
2021-01-18 10:00:00	ES	Futures	4225.99	4229.08	4221.5	4228.8	14517.0
2021-01-18 11:00:00	ES	Futures	4228.52	4230.48	4227.12	4229.08	7295.0
2021-01-18 12:00:00	ES	Futures	4229.08	4231.33	4226.84	4230.77	6165.0
2021-01-18 18:00:00	ES	Futures	4231.61	4236.38	4229.92	4235.82	7193.0
2021-01-18 19:00:00	ES	Futures	4235.82	4247.04	4235.54	4244.24	12996.0
2021-01-18 20:00:00	ES	Futures	4244.24	4248.45	4243.68	4246.2	8611.0
2021-01-18 21:00:00	ES	Futures	4246.48	4248.17	4245.08	4247.32	7407.0
2021-01-18 22:00:00	ES	Futures	4247.32	4261.92	4246.48	4254.62	20270.0
2021-01-18 23:00:00	ES	Futures	4254.9	4259.39	4251.25	4259.39	5801.0
2021-01-18 00:00:00	NQ	Futures	14780.51	14809.46	14769.22	14802.8	2270.0
2021-01-18 01:00:00	NQ	Futures	14801.64	14803.09	14783.41	14788.04	1329.0
2021-01-18 02:00:00	NQ	Futures	14786.88	14796.14	14775.88	14789.49	2280.0
2021-01-18 03:00:00	NQ	Futures	14789.2	14808.01	14784.28	14801.06	3919.0
2021-01-18 04:00:00	NQ	Futures	14801.64	14804.54	14790.64	14803.38	1920.0
2021-01-18 05:00:00	NQ	Futures	14803.38	14809.75	14798.75	14803.38	1911.0
2021-01-18 06:00:00	NQ	Futures	14803.38	14838.4	14796.72	14818.43	4434.0
2021-01-18 07:00:00	NQ	Futures	14818.72	14829.43	14813.22	14816.4	2572.0
2021-01-18 08:00:00	NQ	Futures	14816.4	14828.85	14816.11	14823.93	2175.0
2021-01-18 09:00:00	NQ	Futures	14823.35	14835.22	14800.77	14831.45	7920.0
2021-01-18 10:00:00	NQ	Futures	14831.45	14836.66	14811.48	14831.16	7296.0
2021-01-18 11:00:00	NQ	Futures	14831.74	14834.06	14823.64	14829.14	3111.0
2021-01-18 12:00:00	NQ	Futures	14828.85	14836.37	14818.14	14835.22	3284.0
2021-01-18 18:00:00	NQ	Futures	14832.9	14860.11	14831.45	14856.34	3230.0
2021-01-18 19:00:00	NQ	Futures	14855.77	14905.84	14855.77	14896.86	5531.0
2021-01-18 20:00:00	NQ	Futures	14897.15	14922.05	14894.26	14917.13	4086.0
2021-01-18 21:00:00	NQ	Futures	14917.13	14928.41	14911.34	14924.07	4258.0
2021-01-18 22:00:00	NQ	Futures	14924.36	14991.51	14922.34	14971.83	7897.0
2021-01-18 23:00:00	NQ	Futures	14972.41	14974.43	14958.8	14973.28	2589.0
2021-01-18 00:00:00	YM	Futures	34029.0	34054.5	34009.0	34049.0	999.0
2021-01-18 01:00:00	YM	Futures	34045.6	34051.2	34020.1	34026.8	733.0
2021-01-18 02:00:00	YM	Futures	34027.9	34031.2	33980.2	33999.0	1979.0
2021-01-18 03:00:00	YM	Futures	33999.0	34044.5	33984.6	34000.2	2576.0
2021-01-18 04:00:00	YM	Futures	33999.0	34015.7	33973.5	33992.4	2058.0
2021-01-18 05:00:00	YM	Futures	33993.5	34041.2	33988.0	34034.5	1411.0
2021-01-18 06:00:00	YM	Futures	34034.5	34111.1	34030.1	34063.4	2890.0
2021-01-18 07:00:00	YM	Futures	34064.5	34081.1	34025.7	34032.3	1429.0
2021-01-18 08:00:00	YM	Futures	34033.4	34070.0	34027.9	34065.6	1474.0
2021-01-18 09:00:00	YM	Futures	34066.7	34068.9	34020.1	34041.2	2792.0
2021-01-18 10:00:00	YM	Futures	34041.2	34074.5	34007.9	34064.5	3213.0
2021-01-18 11:00:00	YM	Futures	34063.4	34101.1	34053.4	34098.9	1713.0

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

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