PREVIEW / futures_1hour / 2021-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-06.parquet
  size:    63 KB
  rows:    1,964

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-05-06 00:00:00	ES	Futures	4671.68	4673.36	4669.43	4671.96	4847.0
2021-05-06 01:00:00	ES	Futures	4671.68	4680.11	4671.68	4679.26	7725.0
2021-05-06 02:00:00	ES	Futures	4679.26	4682.63	4676.45	4681.23	8941.0
2021-05-06 03:00:00	ES	Futures	4681.23	4691.63	4680.39	4684.32	24236.0
2021-05-06 04:00:00	ES	Futures	4684.32	4688.25	4677.58	4680.67	15000.0
2021-05-06 05:00:00	ES	Futures	4680.95	4685.16	4671.68	4678.7	21731.0
2021-05-06 06:00:00	ES	Futures	4678.42	4685.44	4677.86	4677.86	16901.0
2021-05-06 07:00:00	ES	Futures	4677.58	4683.2	4675.89	4678.7	19241.0
2021-05-06 08:00:00	ES	Futures	4678.7	4681.51	4669.99	4674.77	35489.0
2021-05-06 09:00:00	ES	Futures	4675.05	4683.2	4665.5	4665.78	219450.0
2021-05-06 10:00:00	ES	Futures	4666.06	4672.52	4653.41	4669.43	267460.0
2021-05-06 11:00:00	ES	Futures	4669.43	4697.25	4659.31	4689.66	261920.0
2021-05-06 12:00:00	ES	Futures	4689.66	4696.96	4685.73	4689.94	123236.0
2021-05-06 13:00:00	ES	Futures	4689.66	4693.31	4681.51	4681.79	105247.0
2021-05-06 14:00:00	ES	Futures	4681.79	4687.97	4675.33	4681.23	189159.0
2021-05-06 15:00:00	ES	Futures	4681.23	4715.51	4679.54	4714.1	268328.0
2021-05-06 16:00:00	ES	Futures	4714.1	4717.19	4712.14	4716.07	73491.0
2021-05-06 18:00:00	ES	Futures	4717.47	4718.32	4713.82	4714.1	5524.0
2021-05-06 19:00:00	ES	Futures	4714.1	4715.79	4712.42	4714.1	4395.0
2021-05-06 20:00:00	ES	Futures	4713.82	4719.72	4711.29	4718.04	10295.0
2021-05-06 21:00:00	ES	Futures	4718.04	4724.5	4717.76	4723.09	13047.0
2021-05-06 22:00:00	ES	Futures	4722.81	4724.22	4716.63	4718.88	8635.0
2021-05-06 23:00:00	ES	Futures	4718.88	4719.72	4717.19	4718.6	3808.0
2021-05-06 00:00:00	NQ	Futures	15601.77	15613.93	15586.14	15602.35	3256.0
2021-05-06 01:00:00	NQ	Futures	15602.06	15646.06	15602.06	15643.46	3719.0
2021-05-06 02:00:00	NQ	Futures	15642.59	15657.93	15631.01	15656.48	3743.0
2021-05-06 03:00:00	NQ	Futures	15656.48	15714.38	15650.98	15676.17	9287.0
2021-05-06 04:00:00	NQ	Futures	15675.59	15699.62	15649.25	15666.33	7902.0
2021-05-06 05:00:00	NQ	Futures	15667.77	15688.91	15622.03	15646.06	8360.0
2021-05-06 06:00:00	NQ	Futures	15647.51	15686.01	15642.88	15644.61	8466.0
2021-05-06 07:00:00	NQ	Futures	15644.04	15666.91	15629.85	15639.69	8505.0
2021-05-06 08:00:00	NQ	Futures	15639.11	15651.85	15587.58	15605.24	14257.0
2021-05-06 09:00:00	NQ	Futures	15605.24	15643.17	15545.32	15549.08	82180.0
2021-05-06 10:00:00	NQ	Futures	15548.79	15618.85	15503.92	15592.22	96909.0
2021-05-06 11:00:00	NQ	Futures	15592.79	15706.86	15525.63	15686.3	75974.0
2021-05-06 12:00:00	NQ	Futures	15686.3	15738.41	15666.62	15705.12	39917.0
2021-05-06 13:00:00	NQ	Futures	15704.83	15718.15	15619.43	15624.06	39611.0
2021-05-06 14:00:00	NQ	Futures	15624.06	15662.27	15593.66	15617.11	51869.0
2021-05-06 15:00:00	NQ	Futures	15616.82	15752.89	15604.95	15744.49	67867.0
2021-05-06 16:00:00	NQ	Futures	15744.78	15761.86	15739.28	15755.2	11808.0
2021-05-06 18:00:00	NQ	Futures	15765.33	15773.15	15756.65	15758.1	2374.0
2021-05-06 19:00:00	NQ	Futures	15758.1	15770.26	15755.2	15762.73	2005.0
2021-05-06 20:00:00	NQ	Futures	15762.73	15797.47	15752.02	15795.44	4912.0
2021-05-06 21:00:00	NQ	Futures	15795.73	15813.39	15794.86	15810.78	4962.0
2021-05-06 22:00:00	NQ	Futures	15811.36	15819.18	15778.65	15790.23	4199.0
2021-05-06 23:00:00	NQ	Futures	15789.65	15794.28	15779.23	15784.44	2114.0
2021-05-06 00:00:00	YM	Futures	37999.0	38013.5	37982.3	38000.1	1054.0
2021-05-06 01:00:00	YM	Futures	37999.0	38053.6	37999.0	38045.8	1371.0
2021-05-06 02:00:00	YM	Futures	38044.7	38069.2	38023.5	38052.5	1654.0
2021-05-06 03:00:00	YM	Futures	38053.6	38112.6	38045.8	38068.1	5743.0

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

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