PREVIEW / futures_1hour / 2021-06-11

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-11.parquet
  size:    51 KB
  rows:    1,508

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-11 00:00:00	ES	Futures	4766.08	4766.93	4765.52	4766.08	1197.0
2021-06-11 01:00:00	ES	Futures	4766.08	4766.36	4764.68	4766.36	1343.0
2021-06-11 02:00:00	ES	Futures	4766.36	4766.36	4761.03	4764.4	3265.0
2021-06-11 03:00:00	ES	Futures	4764.4	4765.24	4761.59	4762.43	3565.0
2021-06-11 04:00:00	ES	Futures	4762.43	4766.08	4761.59	4765.52	3371.0
2021-06-11 05:00:00	ES	Futures	4765.8	4766.36	4764.4	4765.24	2541.0
2021-06-11 06:00:00	ES	Futures	4764.96	4773.95	4764.4	4773.39	6442.0
2021-06-11 07:00:00	ES	Futures	4773.11	4773.95	4767.77	4769.17	6546.0
2021-06-11 08:00:00	ES	Futures	4769.45	4772.54	4766.93	4771.42	8796.0
2021-06-11 09:00:00	ES	Futures	4771.42	4773.67	4765.8	4768.05	58771.0
2021-06-11 10:00:00	ES	Futures	4767.77	4771.7	4759.34	4761.03	75095.0
2021-06-11 11:00:00	ES	Futures	4761.03	4763.83	4757.09	4761.03	39098.0
2021-06-11 12:00:00	ES	Futures	4760.74	4762.15	4754.84	4759.06	27801.0
2021-06-11 13:00:00	ES	Futures	4759.06	4763.27	4757.37	4762.71	15257.0
2021-06-11 14:00:00	ES	Futures	4762.71	4766.36	4762.71	4765.8	22109.0
2021-06-11 15:00:00	ES	Futures	4765.52	4772.83	4761.59	4771.42	64298.0
2021-06-11 16:00:00	ES	Futures	4771.7	4773.11	4770.02	4770.86	24583.0
2021-06-11 00:00:00	NQ	Futures	16184.81	16188.0	16181.34	16183.08	932.0
2021-06-11 01:00:00	NQ	Futures	16183.08	16183.94	16174.68	16183.08	1581.0
2021-06-11 02:00:00	NQ	Futures	16183.65	16183.65	16162.81	16178.44	3202.0
2021-06-11 03:00:00	NQ	Futures	16177.86	16178.44	16155.57	16157.31	4998.0
2021-06-11 04:00:00	NQ	Futures	16156.73	16173.81	16150.94	16172.07	4096.0
2021-06-11 05:00:00	NQ	Futures	16172.07	16173.52	16156.73	16163.68	2911.0
2021-06-11 06:00:00	NQ	Futures	16163.97	16207.97	16153.84	16205.08	6635.0
2021-06-11 07:00:00	NQ	Futures	16205.08	16209.13	16183.37	16184.81	7053.0
2021-06-11 08:00:00	NQ	Futures	16184.81	16192.92	16169.18	16178.73	7817.0
2021-06-11 09:00:00	NQ	Futures	16178.15	16194.95	16143.7	16175.55	38172.0
2021-06-11 10:00:00	NQ	Futures	16174.39	16194.37	16141.39	16158.47	37889.0
2021-06-11 11:00:00	NQ	Futures	16158.47	16181.92	16133.28	16164.26	21799.0
2021-06-11 12:00:00	NQ	Futures	16163.97	16175.55	16151.52	16166.0	12266.0
2021-06-11 13:00:00	NQ	Futures	16166.0	16176.42	16150.36	16171.79	8202.0
2021-06-11 14:00:00	NQ	Futures	16171.5	16192.63	16171.5	16184.52	10609.0
2021-06-11 15:00:00	NQ	Futures	16184.23	16208.55	16167.44	16205.37	17972.0
2021-06-11 16:00:00	NQ	Futures	16205.66	16207.97	16198.71	16203.34	4748.0
2021-06-11 00:00:00	YM	Futures	38395.5	38404.4	38392.1	38398.8	230.0
2021-06-11 01:00:00	YM	Futures	38398.8	38401.1	38388.8	38395.5	524.0
2021-06-11 02:00:00	YM	Futures	38395.5	38395.5	38359.7	38388.8	816.0
2021-06-11 03:00:00	YM	Futures	38387.7	38410.0	38364.2	38391.0	1555.0
2021-06-11 04:00:00	YM	Futures	38391.0	38430.1	38382.1	38422.3	1199.0
2021-06-11 05:00:00	YM	Futures	38423.4	38440.2	38423.4	38433.5	910.0
2021-06-11 06:00:00	YM	Futures	38434.6	38507.2	38432.4	38499.4	1877.0
2021-06-11 07:00:00	YM	Futures	38499.4	38507.2	38445.8	38467.0	1879.0
2021-06-11 08:00:00	YM	Futures	38467.0	38498.3	38449.1	38492.7	1948.0
2021-06-11 09:00:00	YM	Futures	38491.6	38554.1	38411.1	38417.8	15050.0
2021-06-11 10:00:00	YM	Futures	38417.8	38441.3	38317.3	38335.2	14950.0
2021-06-11 11:00:00	YM	Futures	38332.9	38358.6	38302.8	38316.2	7823.0
2021-06-11 12:00:00	YM	Futures	38315.0	38324.0	38219.0	38275.9	6998.0
2021-06-11 13:00:00	YM	Futures	38275.9	38312.8	38267.0	38309.5	4096.0
2021-06-11 14:00:00	YM	Futures	38308.3	38348.6	38308.3	38346.3	4653.0
2021-06-11 15:00:00	YM	Futures	38345.2	38393.2	38315.0	38386.5	7966.0

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

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