PREVIEW / futures_1hour / 2021-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-20.parquet
  size:    63 KB
  rows:    1,944

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-04-20 00:00:00	ES	Futures	4680.11	4680.11	4677.58	4679.54	4340.0
2021-04-20 01:00:00	ES	Futures	4679.26	4682.35	4678.98	4682.07	7139.0
2021-04-20 02:00:00	ES	Futures	4682.07	4683.48	4675.61	4676.45	7883.0
2021-04-20 03:00:00	ES	Futures	4676.17	4681.51	4675.89	4675.89	12073.0
2021-04-20 04:00:00	ES	Futures	4676.17	4677.02	4668.02	4669.71	18227.0
2021-04-20 05:00:00	ES	Futures	4669.71	4670.27	4648.92	4653.13	31035.0
2021-04-20 06:00:00	ES	Futures	4653.13	4654.82	4642.74	4652.29	30109.0
2021-04-20 07:00:00	ES	Futures	4652.57	4654.54	4648.36	4653.13	24639.0
2021-04-20 08:00:00	ES	Futures	4653.13	4654.82	4649.48	4653.13	29191.0
2021-04-20 09:00:00	ES	Futures	4653.13	4665.21	4652.85	4661.56	189233.0
2021-04-20 10:00:00	ES	Futures	4661.28	4664.09	4632.62	4639.08	353365.0
2021-04-20 11:00:00	ES	Futures	4638.8	4641.05	4619.7	4629.25	291991.0
2021-04-20 12:00:00	ES	Futures	4628.97	4639.93	4627.28	4635.43	139678.0
2021-04-20 13:00:00	ES	Futures	4635.43	4635.71	4626.16	4634.31	117507.0
2021-04-20 14:00:00	ES	Futures	4634.03	4636.56	4619.98	4622.23	108168.0
2021-04-20 15:00:00	ES	Futures	4622.23	4642.74	4622.23	4637.96	198853.0
2021-04-20 16:00:00	ES	Futures	4637.96	4639.37	4629.81	4630.66	56033.0
2021-04-20 18:00:00	ES	Futures	4631.78	4635.99	4631.22	4634.87	5286.0
2021-04-20 19:00:00	ES	Futures	4634.87	4635.15	4630.37	4633.18	5786.0
2021-04-20 20:00:00	ES	Futures	4633.18	4636.27	4629.81	4634.03	11575.0
2021-04-20 21:00:00	ES	Futures	4633.75	4634.59	4627.56	4627.85	14739.0
2021-04-20 22:00:00	ES	Futures	4628.13	4628.13	4622.51	4626.72	14152.0
2021-04-20 23:00:00	ES	Futures	4627.0	4630.09	4625.04	4629.53	7468.0
2021-04-20 00:00:00	NQ	Futures	16114.75	16119.39	16108.39	16115.91	1844.0
2021-04-20 01:00:00	NQ	Futures	16115.33	16125.76	16109.25	16123.73	2894.0
2021-04-20 02:00:00	NQ	Futures	16124.31	16129.81	16081.75	16088.7	4696.0
2021-04-20 03:00:00	NQ	Futures	16088.7	16127.49	16088.7	16112.73	8216.0
2021-04-20 04:00:00	NQ	Futures	16113.02	16135.02	16098.54	16103.46	10134.0
2021-04-20 05:00:00	NQ	Futures	16104.33	16113.6	16012.27	16029.06	16380.0
2021-04-20 06:00:00	NQ	Futures	16029.06	16047.88	15996.35	16038.33	13690.0
2021-04-20 07:00:00	NQ	Futures	16039.49	16059.46	16021.25	16049.33	9319.0
2021-04-20 08:00:00	NQ	Futures	16049.33	16065.83	16031.96	16041.51	9556.0
2021-04-20 09:00:00	NQ	Futures	16041.8	16130.39	16039.49	16101.44	85306.0
2021-04-20 10:00:00	NQ	Futures	16101.15	16112.73	15964.51	15985.64	116689.0
2021-04-20 11:00:00	NQ	Futures	15985.93	16007.35	15886.63	15943.08	99058.0
2021-04-20 12:00:00	NQ	Futures	15942.79	15987.67	15932.37	15955.24	54561.0
2021-04-20 13:00:00	NQ	Futures	15955.24	15976.67	15911.24	15974.64	43419.0
2021-04-20 14:00:00	NQ	Futures	15974.35	15982.17	15903.42	15914.71	39188.0
2021-04-20 15:00:00	NQ	Futures	15915.29	15999.83	15913.85	15979.56	45947.0
2021-04-20 16:00:00	NQ	Futures	15979.56	15989.11	15899.08	15904.87	21841.0
2021-04-20 18:00:00	NQ	Futures	15910.66	15927.74	15908.92	15923.4	3309.0
2021-04-20 19:00:00	NQ	Futures	15923.11	15926.29	15906.32	15917.32	2442.0
2021-04-20 20:00:00	NQ	Futures	15917.61	15934.69	15903.42	15925.71	4815.0
2021-04-20 21:00:00	NQ	Futures	15925.43	15929.77	15902.84	15904.87	4364.0
2021-04-20 22:00:00	NQ	Futures	15905.16	15905.16	15875.63	15893.29	5939.0
2021-04-20 23:00:00	NQ	Futures	15893.29	15909.5	15891.84	15906.32	3422.0
2021-04-20 00:00:00	YM	Futures	37922.2	37922.2	37895.4	37906.6	912.0
2021-04-20 01:00:00	YM	Futures	37905.5	37927.7	37898.8	37926.6	1517.0
2021-04-20 02:00:00	YM	Futures	37926.6	37938.9	37884.3	37894.3	2176.0
2021-04-20 03:00:00	YM	Futures	37894.3	37916.6	37858.7	37859.8	2938.0

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

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