PREVIEW / futures_1hour / 2021-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-29.parquet
  size:    60 KB
  rows:    1,925

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-06-29 00:00:00	ES	Futures	4813.65	4815.9	4813.08	4815.34	3074.0
2021-06-29 01:00:00	ES	Futures	4815.34	4818.72	4813.37	4818.72	5047.0
2021-06-29 02:00:00	ES	Futures	4818.72	4818.72	4815.06	4815.34	5790.0
2021-06-29 03:00:00	ES	Futures	4815.34	4823.22	4815.06	4820.69	15923.0
2021-06-29 04:00:00	ES	Futures	4820.69	4822.38	4815.06	4817.59	12307.0
2021-06-29 05:00:00	ES	Futures	4817.59	4821.53	4817.31	4820.69	8394.0
2021-06-29 06:00:00	ES	Futures	4820.41	4824.35	4817.87	4824.35	8083.0
2021-06-29 07:00:00	ES	Futures	4824.35	4824.35	4815.9	4818.15	13493.0
2021-06-29 08:00:00	ES	Futures	4818.15	4823.5	4817.03	4822.1	19514.0
2021-06-29 09:00:00	ES	Futures	4822.1	4830.82	4821.25	4828.29	107178.0
2021-06-29 10:00:00	ES	Futures	4828.57	4833.08	4826.04	4828.57	118086.0
2021-06-29 11:00:00	ES	Futures	4828.85	4829.42	4825.19	4826.6	69429.0
2021-06-29 12:00:00	ES	Futures	4826.88	4827.73	4824.07	4826.6	42052.0
2021-06-29 13:00:00	ES	Futures	4826.88	4827.45	4822.66	4825.19	39927.0
2021-06-29 14:00:00	ES	Futures	4825.19	4827.45	4817.31	4821.53	80407.0
2021-06-29 15:00:00	ES	Futures	4821.53	4824.91	4819.0	4823.5	111638.0
2021-06-29 16:00:00	ES	Futures	4823.5	4827.73	4822.94	4825.47	32635.0
2021-06-29 18:00:00	ES	Futures	4826.04	4827.16	4824.63	4826.32	2684.0
2021-06-29 19:00:00	ES	Futures	4826.6	4830.26	4826.32	4829.42	4034.0
2021-06-29 20:00:00	ES	Futures	4829.7	4831.95	4827.16	4827.73	7069.0
2021-06-29 21:00:00	ES	Futures	4827.73	4829.7	4826.32	4826.32	4579.0
2021-06-29 22:00:00	ES	Futures	4826.6	4828.57	4826.04	4827.16	3441.0
2021-06-29 23:00:00	ES	Futures	4826.88	4829.14	4826.04	4829.14	2586.0
2021-06-29 00:00:00	NQ	Futures	16779.5	16785.58	16777.76	16785.29	1531.0
2021-06-29 01:00:00	NQ	Futures	16785.58	16790.79	16775.15	16787.9	2224.0
2021-06-29 02:00:00	NQ	Futures	16787.61	16788.19	16768.78	16775.44	3207.0
2021-06-29 03:00:00	NQ	Futures	16775.73	16802.09	16773.41	16785.58	6763.0
2021-06-29 04:00:00	NQ	Futures	16785.58	16785.58	16765.3	16783.26	5918.0
2021-06-29 05:00:00	NQ	Futures	16783.55	16804.41	16782.39	16802.67	4544.0
2021-06-29 06:00:00	NQ	Futures	16802.38	16817.16	16791.66	16816.87	4170.0
2021-06-29 07:00:00	NQ	Futures	16816.29	16816.58	16780.66	16790.22	6629.0
2021-06-29 08:00:00	NQ	Futures	16789.93	16799.2	16774.28	16785.58	10005.0
2021-06-29 09:00:00	NQ	Futures	16786.45	16835.7	16767.33	16817.45	64467.0
2021-06-29 10:00:00	NQ	Futures	16817.74	16839.17	16775.15	16817.16	60376.0
2021-06-29 11:00:00	NQ	Futures	16816.87	16829.9	16793.11	16829.32	37562.0
2021-06-29 12:00:00	NQ	Futures	16829.32	16864.66	16818.6	16860.03	31466.0
2021-06-29 13:00:00	NQ	Futures	16860.03	16864.66	16844.97	16861.48	20938.0
2021-06-29 14:00:00	NQ	Futures	16860.9	16873.93	16836.56	16856.55	29344.0
2021-06-29 15:00:00	NQ	Futures	16856.55	16878.86	16848.44	16875.67	39449.0
2021-06-29 16:00:00	NQ	Futures	16875.38	16899.71	16875.38	16897.4	11951.0
2021-06-29 18:00:00	NQ	Futures	16899.71	16904.35	16888.42	16893.05	2212.0
2021-06-29 19:00:00	NQ	Futures	16893.05	16906.09	16892.18	16902.9	1780.0
2021-06-29 20:00:00	NQ	Futures	16903.19	16915.65	16898.56	16900.29	3245.0
2021-06-29 21:00:00	NQ	Futures	16900.29	16906.96	16893.05	16893.34	2196.0
2021-06-29 22:00:00	NQ	Futures	16893.34	16900.87	16887.26	16891.6	2271.0
2021-06-29 23:00:00	NQ	Futures	16891.6	16895.95	16885.81	16895.08	1708.0
2021-06-29 00:00:00	YM	Futures	38130.7	38149.7	38127.3	38145.2	563.0
2021-06-29 01:00:00	YM	Futures	38144.1	38191.0	38141.9	38189.9	958.0
2021-06-29 02:00:00	YM	Futures	38189.9	38202.2	38164.2	38166.4	1367.0
2021-06-29 03:00:00	YM	Futures	38167.6	38240.2	38164.2	38227.9	3390.0

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

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