PREVIEW / futures_1hour / 2021-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-18.parquet
  size:    66 KB
  rows:    2,019

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-10-18 00:00:00	ES	Futures	5034.1	5034.39	5030.15	5030.44	3875.0
2021-10-18 01:00:00	ES	Futures	5030.15	5032.69	5030.15	5030.72	3351.0
2021-10-18 02:00:00	ES	Futures	5031.0	5031.0	5019.15	5024.23	14920.0
2021-10-18 03:00:00	ES	Futures	5023.95	5025.36	5014.07	5021.97	23023.0
2021-10-18 04:00:00	ES	Futures	5021.69	5029.31	5020.84	5021.69	14631.0
2021-10-18 05:00:00	ES	Futures	5021.97	5024.51	5017.74	5019.43	10864.0
2021-10-18 06:00:00	ES	Futures	5019.43	5023.1	5013.22	5018.58	13913.0
2021-10-18 07:00:00	ES	Futures	5018.58	5029.02	5018.3	5022.25	17937.0
2021-10-18 08:00:00	ES	Futures	5022.25	5022.53	5007.86	5012.09	39896.0
2021-10-18 09:00:00	ES	Futures	5012.09	5033.82	5008.42	5031.56	167904.0
2021-10-18 10:00:00	ES	Futures	5031.85	5040.31	5029.31	5037.77	155756.0
2021-10-18 11:00:00	ES	Futures	5037.77	5051.04	5037.21	5048.5	116755.0
2021-10-18 12:00:00	ES	Futures	5048.78	5051.32	5044.55	5046.24	58833.0
2021-10-18 13:00:00	ES	Futures	5046.24	5050.47	5045.68	5047.65	44767.0
2021-10-18 14:00:00	ES	Futures	5047.65	5052.17	5044.83	5050.47	64398.0
2021-10-18 15:00:00	ES	Futures	5050.19	5056.96	5048.5	5053.58	181660.0
2021-10-18 16:00:00	ES	Futures	5053.86	5054.42	5051.6	5052.73	42321.0
2021-10-18 18:00:00	ES	Futures	5052.45	5053.58	5047.93	5048.5	4847.0
2021-10-18 19:00:00	ES	Futures	5048.78	5055.27	5048.5	5054.42	5665.0
2021-10-18 20:00:00	ES	Futures	5054.42	5062.04	5050.76	5053.86	13121.0
2021-10-18 21:00:00	ES	Futures	5053.86	5058.66	5048.5	5057.25	9578.0
2021-10-18 22:00:00	ES	Futures	5057.53	5058.09	5051.88	5053.58	4767.0
2021-10-18 23:00:00	ES	Futures	5053.3	5056.12	5052.17	5054.99	3063.0
2021-10-18 00:00:00	NQ	Futures	17495.97	17500.03	17485.25	17491.33	2660.0
2021-10-18 01:00:00	NQ	Futures	17491.33	17498.58	17487.28	17491.04	2110.0
2021-10-18 02:00:00	NQ	Futures	17491.04	17493.36	17448.44	17469.31	7831.0
2021-10-18 03:00:00	NQ	Futures	17468.44	17479.45	17433.95	17458.01	10495.0
2021-10-18 04:00:00	NQ	Futures	17458.01	17498.87	17454.24	17477.71	7128.0
2021-10-18 05:00:00	NQ	Futures	17477.42	17490.18	17460.9	17471.05	6599.0
2021-10-18 06:00:00	NQ	Futures	17470.76	17476.55	17441.78	17469.02	6844.0
2021-10-18 07:00:00	NQ	Futures	17469.31	17530.46	17469.02	17504.38	10541.0
2021-10-18 08:00:00	NQ	Futures	17504.67	17509.88	17445.83	17466.41	17800.0
2021-10-18 09:00:00	NQ	Futures	17465.83	17560.31	17449.31	17548.72	77917.0
2021-10-18 10:00:00	NQ	Futures	17549.01	17587.84	17534.52	17583.79	57691.0
2021-10-18 11:00:00	NQ	Futures	17584.08	17641.46	17583.79	17629.87	43761.0
2021-10-18 12:00:00	NQ	Futures	17629.29	17651.02	17624.36	17643.49	23673.0
2021-10-18 13:00:00	NQ	Futures	17644.07	17681.16	17640.59	17675.37	24501.0
2021-10-18 14:00:00	NQ	Futures	17675.66	17704.64	17667.54	17697.39	26358.0
2021-10-18 15:00:00	NQ	Futures	17697.68	17730.14	17692.18	17720.87	50438.0
2021-10-18 16:00:00	NQ	Futures	17720.87	17733.62	17716.81	17723.77	10770.0
2021-10-18 18:00:00	NQ	Futures	17724.93	17729.85	17700.87	17705.51	3489.0
2021-10-18 19:00:00	NQ	Futures	17705.8	17730.72	17704.93	17727.54	3167.0
2021-10-18 20:00:00	NQ	Futures	17728.12	17755.94	17712.75	17728.41	7307.0
2021-10-18 21:00:00	NQ	Futures	17727.54	17746.08	17708.12	17738.84	6070.0
2021-10-18 22:00:00	NQ	Futures	17739.42	17742.32	17716.52	17720.87	2719.0
2021-10-18 23:00:00	NQ	Futures	17721.45	17735.94	17720.0	17727.83	2933.0
2021-10-18 00:00:00	YM	Futures	39439.1	39440.2	39401.0	39404.4	1028.0
2021-10-18 01:00:00	YM	Futures	39403.3	39425.7	39401.0	39406.6	654.0
2021-10-18 02:00:00	YM	Futures	39406.6	39407.7	39305.7	39350.6	3647.0
2021-10-18 03:00:00	YM	Futures	39348.3	39355.1	39271.0	39343.9	4968.0

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

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