PREVIEW / futures_1hour / 2021-05-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	4722.81	4722.81	4721.41	4722.25	2092.0
2021-05-25 01:00:00	ES	Futures	4721.97	4727.03	4721.97	4726.47	5327.0
2021-05-25 02:00:00	ES	Futures	4726.47	4734.61	4725.9	4731.52	17607.0
2021-05-25 03:00:00	ES	Futures	4731.52	4732.09	4725.34	4726.75	15314.0
2021-05-25 04:00:00	ES	Futures	4726.75	4728.99	4724.5	4728.71	8814.0
2021-05-25 05:00:00	ES	Futures	4728.99	4729.28	4727.03	4728.99	9389.0
2021-05-25 06:00:00	ES	Futures	4728.99	4731.52	4723.94	4724.78	10004.0
2021-05-25 07:00:00	ES	Futures	4724.78	4730.4	4723.94	4729.28	13412.0
2021-05-25 08:00:00	ES	Futures	4729.28	4729.84	4725.06	4726.47	15011.0
2021-05-25 09:00:00	ES	Futures	4726.75	4731.52	4715.23	4716.07	164172.0
2021-05-25 10:00:00	ES	Futures	4715.79	4720.0	4711.86	4716.91	164639.0
2021-05-25 11:00:00	ES	Futures	4717.19	4718.04	4700.62	4711.01	189064.0
2021-05-25 12:00:00	ES	Futures	4711.01	4717.47	4709.33	4713.82	89904.0
2021-05-25 13:00:00	ES	Futures	4713.82	4714.95	4705.39	4709.61	97740.0
2021-05-25 14:00:00	ES	Futures	4709.61	4710.45	4703.43	4705.39	93455.0
2021-05-25 15:00:00	ES	Futures	4705.11	4709.61	4696.96	4704.27	215027.0
2021-05-25 16:00:00	ES	Futures	4704.55	4708.2	4702.86	4707.36	35597.0
2021-05-25 18:00:00	ES	Futures	4706.8	4714.67	4706.52	4713.54	7445.0
2021-05-25 19:00:00	ES	Futures	4713.82	4714.1	4711.57	4713.26	3664.0
2021-05-25 20:00:00	ES	Futures	4713.54	4720.0	4711.57	4718.04	11418.0
2021-05-25 21:00:00	ES	Futures	4718.04	4720.28	4715.51	4716.63	9436.0
2021-05-25 22:00:00	ES	Futures	4716.63	4719.16	4716.07	4718.32	5282.0
2021-05-25 23:00:00	ES	Futures	4718.32	4719.72	4717.47	4718.04	2902.0
2021-05-25 00:00:00	NQ	Futures	15828.44	15832.5	15824.1	15829.6	1321.0
2021-05-25 01:00:00	NQ	Futures	15829.31	15862.03	15826.42	15855.66	4610.0
2021-05-25 02:00:00	NQ	Futures	15855.66	15909.21	15851.31	15899.08	10363.0
2021-05-25 03:00:00	NQ	Futures	15899.08	15906.03	15877.66	15885.76	6533.0
2021-05-25 04:00:00	NQ	Futures	15885.76	15888.66	15857.68	15876.21	5211.0
2021-05-25 05:00:00	NQ	Futures	15876.21	15887.21	15867.53	15885.19	3339.0
2021-05-25 06:00:00	NQ	Futures	15885.19	15894.45	15846.39	15849.0	5866.0
2021-05-25 07:00:00	NQ	Futures	15849.0	15886.92	15836.26	15878.82	7154.0
2021-05-25 08:00:00	NQ	Futures	15878.24	15884.61	15858.84	15866.95	7348.0
2021-05-25 09:00:00	NQ	Futures	15867.82	15901.98	15807.6	15808.76	63506.0
2021-05-25 10:00:00	NQ	Futures	15808.18	15848.71	15790.81	15841.18	67657.0
2021-05-25 11:00:00	NQ	Futures	15841.18	15845.52	15756.36	15798.63	67324.0
2021-05-25 12:00:00	NQ	Futures	15798.63	15815.13	15782.7	15793.99	34411.0
2021-05-25 13:00:00	NQ	Futures	15794.28	15820.92	15767.36	15806.15	32323.0
2021-05-25 14:00:00	NQ	Futures	15806.44	15811.65	15777.49	15799.49	33376.0
2021-05-25 15:00:00	NQ	Futures	15799.49	15817.15	15771.7	15813.68	52781.0
2021-05-25 16:00:00	NQ	Futures	15814.26	15831.05	15807.02	15827.58	6682.0
2021-05-25 18:00:00	NQ	Futures	15829.89	15866.37	15822.08	15859.71	4474.0
2021-05-25 19:00:00	NQ	Futures	15859.71	15861.74	15847.84	15858.55	2248.0
2021-05-25 20:00:00	NQ	Futures	15857.68	15887.21	15852.18	15879.11	5068.0
2021-05-25 21:00:00	NQ	Futures	15879.11	15887.5	15861.74	15869.26	4112.0
2021-05-25 22:00:00	NQ	Futures	15868.1	15882.29	15866.08	15875.63	2102.0
2021-05-25 23:00:00	NQ	Futures	15875.34	15879.68	15870.42	15870.71	1222.0
2021-05-25 00:00:00	YM	Futures	38330.9	38330.9	38318.7	38324.3	590.0
2021-05-25 01:00:00	YM	Futures	38322.0	38349.9	38320.9	38346.5	1035.0
2021-05-25 02:00:00	YM	Futures	38347.7	38407.8	38345.4	38375.5	3562.0
2021-05-25 03:00:00	YM	Futures	38374.4	38381.1	38324.3	38337.6	3228.0

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

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