PREVIEW / futures_1hour / 2021-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-27.parquet
  size:    64 KB
  rows:    1,974

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-09-27 00:00:00	ES	Futures	5036.64	5037.77	5035.23	5036.64	2450.0
2021-09-27 01:00:00	ES	Futures	5036.64	5045.39	5034.67	5045.11	7617.0
2021-09-27 02:00:00	ES	Futures	5045.39	5048.22	5039.18	5040.31	11474.0
2021-09-27 03:00:00	ES	Futures	5040.31	5041.72	5031.28	5031.28	15986.0
2021-09-27 04:00:00	ES	Futures	5031.28	5033.26	5029.59	5032.41	9721.0
2021-09-27 05:00:00	ES	Futures	5032.13	5036.36	5021.69	5021.97	20710.0
2021-09-27 06:00:00	ES	Futures	5021.97	5024.51	5013.22	5013.79	20583.0
2021-09-27 07:00:00	ES	Futures	5013.79	5016.61	5009.55	5013.22	27068.0
2021-09-27 08:00:00	ES	Futures	5013.22	5013.22	4997.42	5006.73	59650.0
2021-09-27 09:00:00	ES	Futures	5006.73	5010.68	4995.16	5006.45	198603.0
2021-09-27 10:00:00	ES	Futures	5006.45	5019.43	5001.09	5009.55	181635.0
2021-09-27 11:00:00	ES	Futures	5009.83	5017.17	4999.67	5004.75	162909.0
2021-09-27 12:00:00	ES	Futures	5004.47	5011.25	4997.13	4999.96	103356.0
2021-09-27 13:00:00	ES	Futures	4999.67	5012.37	4997.7	5011.81	81439.0
2021-09-27 14:00:00	ES	Futures	5012.09	5015.76	5008.99	5010.4	70059.0
2021-09-27 15:00:00	ES	Futures	5010.12	5015.76	5000.24	5004.47	176237.0
2021-09-27 16:00:00	ES	Futures	5004.19	5005.04	4999.11	4999.96	47966.0
2021-09-27 18:00:00	ES	Futures	5000.52	5003.63	4995.72	4995.72	6126.0
2021-09-27 19:00:00	ES	Futures	4995.72	5004.47	4995.72	5000.52	6200.0
2021-09-27 20:00:00	ES	Futures	5000.8	5002.78	4990.93	4994.88	12317.0
2021-09-27 21:00:00	ES	Futures	4994.6	5001.65	4991.21	5001.37	9710.0
2021-09-27 22:00:00	ES	Futures	5001.37	5007.86	5001.09	5006.73	8478.0
2021-09-27 23:00:00	ES	Futures	5006.73	5009.27	5000.8	5001.09	6614.0
2021-09-27 00:00:00	NQ	Futures	17816.51	17822.31	17808.39	17816.22	1566.0
2021-09-27 01:00:00	NQ	Futures	17816.8	17846.94	17809.55	17845.49	3588.0
2021-09-27 02:00:00	NQ	Futures	17846.36	17851.87	17812.16	17815.93	4457.0
2021-09-27 03:00:00	NQ	Futures	17816.51	17824.04	17776.51	17777.09	7130.0
2021-09-27 04:00:00	NQ	Futures	17777.09	17784.05	17763.47	17768.11	4881.0
2021-09-27 05:00:00	NQ	Futures	17767.82	17781.73	17704.06	17706.96	10442.0
2021-09-27 06:00:00	NQ	Futures	17706.38	17723.19	17647.55	17664.94	12441.0
2021-09-27 07:00:00	NQ	Futures	17665.51	17679.43	17639.43	17657.4	11117.0
2021-09-27 08:00:00	NQ	Futures	17657.98	17657.98	17568.72	17620.01	33657.0
2021-09-27 09:00:00	NQ	Futures	17619.43	17637.69	17486.41	17531.04	112803.0
2021-09-27 10:00:00	NQ	Futures	17531.91	17629.58	17505.83	17594.8	75367.0
2021-09-27 11:00:00	NQ	Futures	17595.09	17647.26	17537.13	17563.21	69336.0
2021-09-27 12:00:00	NQ	Futures	17562.92	17589.0	17528.43	17552.2	40196.0
2021-09-27 13:00:00	NQ	Futures	17551.62	17622.91	17543.79	17621.17	34221.0
2021-09-27 14:00:00	NQ	Futures	17620.88	17644.07	17612.19	17619.14	29346.0
2021-09-27 15:00:00	NQ	Futures	17618.85	17656.53	17595.38	17614.22	48049.0
2021-09-27 16:00:00	NQ	Futures	17613.93	17615.38	17587.26	17587.84	8489.0
2021-09-27 18:00:00	NQ	Futures	17588.71	17605.23	17568.72	17569.88	3308.0
2021-09-27 19:00:00	NQ	Futures	17569.59	17599.44	17568.14	17584.66	3041.0
2021-09-27 20:00:00	NQ	Futures	17584.66	17597.41	17542.34	17556.25	6617.0
2021-09-27 21:00:00	NQ	Futures	17555.96	17587.26	17545.82	17585.53	4789.0
2021-09-27 22:00:00	NQ	Futures	17586.68	17611.61	17586.1	17601.47	4994.0
2021-09-27 23:00:00	NQ	Futures	17602.91	17610.45	17561.18	17561.76	4558.0
2021-09-27 00:00:00	YM	Futures	39017.7	39030.0	39010.9	39021.0	500.0
2021-09-27 01:00:00	YM	Futures	39022.1	39086.0	39009.8	39080.4	1548.0
2021-09-27 02:00:00	YM	Futures	39082.7	39126.4	39064.7	39079.3	4091.0
2021-09-27 03:00:00	YM	Futures	39078.2	39089.4	39018.8	39027.8	2941.0

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

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