PREVIEW / futures_1hour / 2021-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-02.parquet
  size:    66 KB
  rows:    2,002

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-12-02 00:00:00	ES	Futures	5118.77	5123.85	5114.25	5122.16	7059.0
2021-12-02 01:00:00	ES	Futures	5122.16	5135.14	5117.08	5133.73	13214.0
2021-12-02 02:00:00	ES	Futures	5133.44	5138.52	5115.38	5121.03	25558.0
2021-12-02 03:00:00	ES	Futures	5121.03	5125.82	5107.48	5121.03	34538.0
2021-12-02 04:00:00	ES	Futures	5120.74	5135.98	5117.92	5128.08	24192.0
2021-12-02 05:00:00	ES	Futures	5128.36	5130.34	5109.74	5125.54	28036.0
2021-12-02 06:00:00	ES	Futures	5125.54	5126.39	5116.51	5121.59	22044.0
2021-12-02 07:00:00	ES	Futures	5121.87	5125.54	5090.55	5106.63	57058.0
2021-12-02 08:00:00	ES	Futures	5106.63	5117.36	5094.5	5099.01	64947.0
2021-12-02 09:00:00	ES	Futures	5099.01	5150.09	5086.03	5149.81	339869.0
2021-12-02 10:00:00	ES	Futures	5149.53	5155.17	5105.79	5139.09	444726.0
2021-12-02 11:00:00	ES	Futures	5139.09	5163.36	5130.9	5159.41	300658.0
2021-12-02 12:00:00	ES	Futures	5159.12	5178.03	5154.61	5169.57	224197.0
2021-12-02 13:00:00	ES	Futures	5169.85	5178.03	5152.92	5176.9	200400.0
2021-12-02 14:00:00	ES	Futures	5177.19	5181.98	5163.92	5171.26	170983.0
2021-12-02 15:00:00	ES	Futures	5171.26	5185.65	5154.05	5167.31	371907.0
2021-12-02 16:00:00	ES	Futures	5167.31	5177.19	5161.66	5176.06	72098.0
2021-12-02 18:00:00	ES	Futures	5178.32	5180.29	5146.99	5149.53	19686.0
2021-12-02 19:00:00	ES	Futures	5149.53	5159.41	5143.6	5153.48	16033.0
2021-12-02 20:00:00	ES	Futures	5153.48	5161.1	5129.21	5141.06	21350.0
2021-12-02 21:00:00	ES	Futures	5140.78	5145.58	5136.83	5144.17	10971.0
2021-12-02 22:00:00	ES	Futures	5144.17	5158.84	5143.32	5156.3	8639.0
2021-12-02 23:00:00	ES	Futures	5156.58	5167.59	5156.3	5163.92	9053.0
2021-12-02 00:00:00	NQ	Futures	18486.57	18498.74	18472.95	18491.2	6266.0
2021-12-02 01:00:00	NQ	Futures	18491.78	18521.06	18471.79	18516.71	7192.0
2021-12-02 02:00:00	NQ	Futures	18516.42	18536.13	18464.83	18471.21	11553.0
2021-12-02 03:00:00	NQ	Futures	18472.37	18506.85	18437.88	18489.75	16794.0
2021-12-02 04:00:00	NQ	Futures	18489.75	18540.18	18461.64	18487.15	11915.0
2021-12-02 05:00:00	NQ	Futures	18487.15	18493.81	18420.78	18476.71	12587.0
2021-12-02 06:00:00	NQ	Futures	18477.29	18483.67	18430.05	18444.83	9175.0
2021-12-02 07:00:00	NQ	Futures	18444.83	18460.19	18317.89	18386.58	25785.0
2021-12-02 08:00:00	NQ	Futures	18386.58	18419.91	18305.72	18355.57	30345.0
2021-12-02 09:00:00	NQ	Futures	18354.7	18552.93	18303.11	18540.76	113534.0
2021-12-02 10:00:00	NQ	Futures	18540.47	18579.6	18273.26	18423.68	151393.0
2021-12-02 11:00:00	NQ	Futures	18423.68	18532.36	18380.78	18500.19	103264.0
2021-12-02 12:00:00	NQ	Futures	18500.48	18619.3	18481.06	18545.11	78624.0
2021-12-02 13:00:00	NQ	Futures	18545.69	18569.16	18458.45	18557.57	68515.0
2021-12-02 14:00:00	NQ	Futures	18558.44	18582.21	18495.26	18544.53	49418.0
2021-12-02 15:00:00	NQ	Futures	18544.82	18625.1	18487.73	18537.28	81295.0
2021-12-02 16:00:00	NQ	Futures	18539.02	18568.87	18517.0	18567.43	15362.0
2021-12-02 18:00:00	NQ	Futures	18571.48	18580.47	18467.15	18476.13	8893.0
2021-12-02 19:00:00	NQ	Futures	18475.26	18506.27	18442.51	18479.61	8991.0
2021-12-02 20:00:00	NQ	Futures	18481.35	18508.88	18388.32	18433.53	10413.0
2021-12-02 21:00:00	NQ	Futures	18432.95	18453.82	18413.53	18450.63	6174.0
2021-12-02 22:00:00	NQ	Futures	18449.76	18503.38	18441.93	18489.46	5035.0
2021-12-02 23:00:00	NQ	Futures	18489.75	18528.88	18487.73	18515.84	6211.0
2021-12-02 00:00:00	YM	Futures	38348.5	38391.1	38319.3	38381.0	1712.0
2021-12-02 01:00:00	YM	Futures	38379.9	38488.6	38340.6	38475.1	3266.0
2021-12-02 02:00:00	YM	Futures	38477.4	38525.6	38321.6	38384.4	9090.0
2021-12-02 03:00:00	YM	Futures	38383.2	38414.6	38255.4	38357.5	7653.0

> showing 50 of 2,002 rows — these rows as CSV

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