PREVIEW / futures_1hour / 2020-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-28.parquet
  size:    59 KB
  rows:    1,826

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
2020-12-28 00:00:00	ES	Futures	4172.39	4175.19	4171.54	4173.79	4291.0
2020-12-28 01:00:00	ES	Futures	4173.79	4175.19	4171.26	4174.07	3265.0
2020-12-28 02:00:00	ES	Futures	4174.35	4177.44	4173.51	4174.35	6337.0
2020-12-28 03:00:00	ES	Futures	4174.63	4175.19	4169.86	4173.79	10058.0
2020-12-28 04:00:00	ES	Futures	4173.79	4175.19	4170.7	4174.07	4536.0
2020-12-28 05:00:00	ES	Futures	4174.35	4175.47	4172.67	4174.91	3727.0
2020-12-28 06:00:00	ES	Futures	4174.91	4183.61	4174.91	4177.16	9397.0
2020-12-28 07:00:00	ES	Futures	4177.16	4178.28	4174.35	4176.6	9692.0
2020-12-28 08:00:00	ES	Futures	4176.6	4180.25	4176.6	4178.84	9385.0
2020-12-28 09:00:00	ES	Futures	4178.84	4181.37	4171.83	4175.75	112698.0
2020-12-28 10:00:00	ES	Futures	4175.75	4186.98	4172.95	4184.74	126511.0
2020-12-28 11:00:00	ES	Futures	4184.46	4185.02	4180.81	4181.93	57621.0
2020-12-28 12:00:00	ES	Futures	4181.65	4185.3	4181.65	4183.89	55931.0
2020-12-28 13:00:00	ES	Futures	4183.89	4186.98	4183.33	4186.14	34902.0
2020-12-28 14:00:00	ES	Futures	4186.42	4190.07	4185.3	4188.38	45774.0
2020-12-28 15:00:00	ES	Futures	4188.67	4189.51	4181.65	4185.02	133805.0
2020-12-28 16:00:00	ES	Futures	4185.02	4188.38	4182.49	4186.98	33856.0
2020-12-28 18:00:00	ES	Futures	4188.67	4193.16	4186.7	4193.16	7011.0
2020-12-28 19:00:00	ES	Futures	4192.88	4199.33	4192.88	4196.24	12449.0
2020-12-28 20:00:00	ES	Futures	4195.96	4199.05	4195.4	4196.52	5169.0
2020-12-28 21:00:00	ES	Futures	4196.8	4200.45	4195.96	4199.33	5277.0
2020-12-28 22:00:00	ES	Futures	4199.05	4200.45	4196.8	4198.49	3276.0
2020-12-28 23:00:00	ES	Futures	4198.21	4201.58	4197.37	4200.17	6423.0
2020-12-28 00:00:00	NQ	Futures	14786.3	14797.59	14785.14	14794.41	2244.0
2020-12-28 01:00:00	NQ	Futures	14794.41	14797.59	14781.09	14790.64	3478.0
2020-12-28 02:00:00	NQ	Futures	14790.93	14816.11	14790.64	14804.25	5269.0
2020-12-28 03:00:00	NQ	Futures	14804.54	14805.69	14785.72	14799.04	4958.0
2020-12-28 04:00:00	NQ	Futures	14798.75	14798.75	14778.49	14795.27	3244.0
2020-12-28 05:00:00	NQ	Futures	14795.56	14802.8	14791.8	14801.93	2228.0
2020-12-28 06:00:00	NQ	Futures	14802.22	14817.56	14801.06	14803.67	4154.0
2020-12-28 07:00:00	NQ	Futures	14803.38	14826.24	14801.35	14824.22	5376.0
2020-12-28 08:00:00	NQ	Futures	14824.22	14849.69	14819.88	14845.06	7523.0
2020-12-28 09:00:00	NQ	Futures	14845.35	14850.85	14799.04	14816.98	56842.0
2020-12-28 10:00:00	NQ	Futures	14816.4	14835.22	14750.41	14831.74	70281.0
2020-12-28 11:00:00	NQ	Futures	14831.74	14849.69	14824.8	14842.74	38200.0
2020-12-28 12:00:00	NQ	Futures	14842.45	14864.16	14831.45	14863.29	29411.0
2020-12-28 13:00:00	NQ	Futures	14863.0	14872.84	14856.34	14863.58	18790.0
2020-12-28 14:00:00	NQ	Futures	14863.87	14880.08	14859.53	14876.32	18055.0
2020-12-28 15:00:00	NQ	Futures	14876.32	14883.26	14846.79	14858.08	34485.0
2020-12-28 16:00:00	NQ	Futures	14857.79	14868.79	14849.69	14868.21	6952.0
2020-12-28 18:00:00	NQ	Futures	14871.39	14880.66	14866.76	14880.08	2615.0
2020-12-28 19:00:00	NQ	Futures	14880.08	14892.52	14879.21	14886.73	4901.0
2020-12-28 20:00:00	NQ	Futures	14887.02	14894.84	14885.29	14885.29	2821.0
2020-12-28 21:00:00	NQ	Futures	14885.58	14896.58	14883.84	14892.52	2332.0
2020-12-28 22:00:00	NQ	Futures	14892.81	14895.42	14884.42	14890.5	1868.0
2020-12-28 23:00:00	NQ	Futures	14890.79	14897.73	14884.71	14895.13	2956.0
2020-12-28 00:00:00	YM	Futures	33538.7	33559.8	33528.8	33546.5	895.0
2020-12-28 01:00:00	YM	Futures	33546.5	33562.0	33526.5	33554.3	1162.0
2020-12-28 02:00:00	YM	Futures	33555.4	33590.9	33554.3	33567.6	2450.0
2020-12-28 03:00:00	YM	Futures	33568.7	33572.0	33507.7	33542.1	3638.0

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

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