PREVIEW / futures_1hour / 2020-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-21.parquet
  size:    65 KB
  rows:    1,941

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-21 00:00:00	ES	Futures	4155.55	4164.53	4154.42	4163.41	7481.0
2020-12-21 01:00:00	ES	Futures	4163.41	4163.41	4154.99	4156.67	5873.0
2020-12-21 02:00:00	ES	Futures	4156.67	4156.67	4134.22	4140.95	25787.0
2020-12-21 03:00:00	ES	Futures	4140.95	4146.85	4135.9	4137.86	28958.0
2020-12-21 04:00:00	ES	Futures	4137.86	4141.23	4110.08	4114.01	37338.0
2020-12-21 05:00:00	ES	Futures	4114.29	4114.29	4037.11	4050.02	105708.0
2020-12-21 06:00:00	ES	Futures	4050.02	4096.05	4048.33	4086.5	53784.0
2020-12-21 07:00:00	ES	Futures	4086.5	4100.82	4077.24	4090.71	42343.0
2020-12-21 08:00:00	ES	Futures	4090.99	4098.85	4075.28	4096.05	55510.0
2020-12-21 09:00:00	ES	Futures	4096.33	4121.02	4092.4	4102.5	230182.0
2020-12-21 10:00:00	ES	Futures	4102.5	4104.18	4069.66	4085.1	322105.0
2020-12-21 11:00:00	ES	Futures	4085.1	4111.48	4083.7	4107.55	150241.0
2020-12-21 12:00:00	ES	Futures	4107.27	4132.25	4107.27	4129.73	112416.0
2020-12-21 13:00:00	ES	Futures	4129.73	4143.2	4127.76	4138.43	121833.0
2020-12-21 14:00:00	ES	Futures	4138.43	4147.41	4133.94	4138.71	100782.0
2020-12-21 15:00:00	ES	Futures	4138.71	4141.51	4122.15	4137.58	248750.0
2020-12-21 16:00:00	ES	Futures	4137.58	4138.99	4130.01	4136.18	54854.0
2020-12-21 18:00:00	ES	Futures	4137.02	4142.36	4133.09	4135.34	7212.0
2020-12-21 19:00:00	ES	Futures	4135.34	4139.83	4126.36	4127.76	10046.0
2020-12-21 20:00:00	ES	Futures	4127.76	4139.83	4127.48	4134.78	9571.0
2020-12-21 21:00:00	ES	Futures	4134.5	4141.51	4133.09	4140.67	5063.0
2020-12-21 22:00:00	ES	Futures	4140.67	4140.67	4129.44	4133.65	5677.0
2020-12-21 23:00:00	ES	Futures	4133.65	4134.5	4122.43	4124.67	9883.0
2020-12-21 00:00:00	NQ	Futures	14760.25	14790.64	14757.36	14776.17	4974.0
2020-12-21 01:00:00	NQ	Futures	14776.17	14779.93	14752.15	14761.41	3977.0
2020-12-21 02:00:00	NQ	Futures	14760.83	14760.83	14697.73	14738.54	14378.0
2020-12-21 03:00:00	NQ	Futures	14738.26	14755.91	14713.07	14733.91	12656.0
2020-12-21 04:00:00	NQ	Futures	14733.91	14734.2	14636.37	14646.22	13712.0
2020-12-21 05:00:00	NQ	Futures	14646.22	14647.37	14429.43	14474.87	42144.0
2020-12-21 06:00:00	NQ	Futures	14475.45	14566.33	14471.98	14548.1	17996.0
2020-12-21 07:00:00	NQ	Futures	14548.68	14585.14	14532.76	14563.15	14344.0
2020-12-21 08:00:00	NQ	Futures	14563.44	14574.15	14521.76	14562.86	17731.0
2020-12-21 09:00:00	NQ	Futures	14563.73	14643.9	14546.94	14567.2	81514.0
2020-12-21 10:00:00	NQ	Futures	14566.91	14581.38	14426.54	14465.9	112961.0
2020-12-21 11:00:00	NQ	Futures	14465.61	14586.3	14460.4	14566.91	53187.0
2020-12-21 12:00:00	NQ	Futures	14566.33	14653.74	14565.75	14643.9	36124.0
2020-12-21 13:00:00	NQ	Futures	14643.9	14702.65	14634.06	14688.76	37080.0
2020-12-21 14:00:00	NQ	Futures	14689.34	14706.71	14666.19	14682.11	35375.0
2020-12-21 15:00:00	NQ	Futures	14682.39	14691.08	14629.72	14685.58	57088.0
2020-12-21 16:00:00	NQ	Futures	14685.87	14693.68	14664.16	14690.5	11425.0
2020-12-21 18:00:00	NQ	Futures	14701.21	14724.65	14696.29	14705.55	4415.0
2020-12-21 19:00:00	NQ	Futures	14705.84	14716.55	14683.55	14687.31	3468.0
2020-12-21 20:00:00	NQ	Futures	14686.74	14735.65	14685.87	14711.92	5018.0
2020-12-21 21:00:00	NQ	Futures	14712.21	14735.36	14709.89	14728.41	2806.0
2020-12-21 22:00:00	NQ	Futures	14728.41	14729.28	14699.76	14719.44	3242.0
2020-12-21 23:00:00	NQ	Futures	14719.73	14723.78	14685.0	14689.92	4416.0
2020-12-21 00:00:00	YM	Futures	33413.4	33491.0	33406.7	33481.1	2309.0
2020-12-21 01:00:00	YM	Futures	33481.1	33483.3	33420.0	33433.4	2003.0
2020-12-21 02:00:00	YM	Futures	33432.3	33432.3	33237.0	33284.7	5485.0
2020-12-21 03:00:00	YM	Futures	33283.6	33342.4	33229.3	33270.3	6505.0

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

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