PREVIEW / futures_1hour / 2021-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-02.parquet
  size:    65 KB
  rows:    2,018

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-11-02 00:00:00	ES	Futures	5188.76	5190.17	5188.19	5188.47	3182.0
2021-11-02 01:00:00	ES	Futures	5188.19	5195.81	5186.5	5193.55	7042.0
2021-11-02 02:00:00	ES	Futures	5193.55	5196.94	5190.73	5195.81	4415.0
2021-11-02 03:00:00	ES	Futures	5196.09	5199.76	5193.84	5197.51	8755.0
2021-11-02 04:00:00	ES	Futures	5197.51	5199.76	5193.27	5193.27	16055.0
2021-11-02 05:00:00	ES	Futures	5193.27	5198.07	5191.01	5196.38	11110.0
2021-11-02 06:00:00	ES	Futures	5196.38	5199.2	5192.99	5199.2	8666.0
2021-11-02 07:00:00	ES	Futures	5198.92	5202.59	5196.94	5199.76	12401.0
2021-11-02 08:00:00	ES	Futures	5199.76	5204.0	5199.48	5201.74	15096.0
2021-11-02 09:00:00	ES	Futures	5202.02	5212.46	5198.92	5211.05	140283.0
2021-11-02 10:00:00	ES	Futures	5211.33	5217.54	5206.25	5215.85	146312.0
2021-11-02 11:00:00	ES	Futures	5215.85	5223.19	5212.18	5213.87	140634.0
2021-11-02 12:00:00	ES	Futures	5213.87	5221.78	5209.92	5220.08	87365.0
2021-11-02 13:00:00	ES	Futures	5220.08	5221.49	5212.75	5216.41	66032.0
2021-11-02 14:00:00	ES	Futures	5216.41	5220.08	5211.62	5219.52	70069.0
2021-11-02 15:00:00	ES	Futures	5219.8	5221.49	5213.87	5219.52	137251.0
2021-11-02 16:00:00	ES	Futures	5219.8	5220.08	5215.29	5216.98	33019.0
2021-11-02 18:00:00	ES	Futures	5216.7	5217.54	5214.44	5214.72	3709.0
2021-11-02 19:00:00	ES	Futures	5214.72	5216.13	5213.87	5214.44	2804.0
2021-11-02 20:00:00	ES	Futures	5214.44	5216.41	5212.75	5215.85	3628.0
2021-11-02 21:00:00	ES	Futures	5215.85	5220.93	5215.57	5216.98	6038.0
2021-11-02 22:00:00	ES	Futures	5216.98	5217.26	5214.44	5215.0	4093.0
2021-11-02 23:00:00	ES	Futures	5214.72	5215.57	5213.03	5213.31	3245.0
2021-11-02 00:00:00	NQ	Futures	18390.35	18402.52	18389.48	18397.01	1904.0
2021-11-02 01:00:00	NQ	Futures	18397.01	18428.89	18389.19	18423.97	3826.0
2021-11-02 02:00:00	NQ	Futures	18423.68	18428.89	18408.9	18421.65	3255.0
2021-11-02 03:00:00	NQ	Futures	18421.94	18427.15	18406.87	18412.37	3258.0
2021-11-02 04:00:00	NQ	Futures	18411.79	18415.85	18387.16	18389.77	5408.0
2021-11-02 05:00:00	NQ	Futures	18389.77	18398.46	18376.44	18389.77	5635.0
2021-11-02 06:00:00	NQ	Futures	18389.77	18399.04	18383.1	18392.96	3482.0
2021-11-02 07:00:00	NQ	Futures	18392.67	18405.71	18383.39	18393.25	4843.0
2021-11-02 08:00:00	NQ	Futures	18392.67	18414.98	18387.16	18395.85	7214.0
2021-11-02 09:00:00	NQ	Futures	18395.85	18511.49	18390.64	18497.0	72740.0
2021-11-02 10:00:00	NQ	Futures	18497.29	18504.54	18425.99	18491.49	77280.0
2021-11-02 11:00:00	NQ	Futures	18491.2	18525.4	18471.21	18477.87	50117.0
2021-11-02 12:00:00	NQ	Futures	18478.16	18499.32	18446.28	18494.68	39394.0
2021-11-02 13:00:00	NQ	Futures	18494.97	18501.06	18459.32	18475.84	29422.0
2021-11-02 14:00:00	NQ	Futures	18475.84	18492.36	18438.46	18489.75	35432.0
2021-11-02 15:00:00	NQ	Futures	18489.75	18523.66	18480.19	18504.25	49352.0
2021-11-02 16:00:00	NQ	Futures	18504.54	18505.12	18492.94	18501.06	7126.0
2021-11-02 18:00:00	NQ	Futures	18499.32	18499.32	18479.9	18483.09	2347.0
2021-11-02 19:00:00	NQ	Futures	18483.38	18489.18	18481.06	18482.22	1087.0
2021-11-02 20:00:00	NQ	Futures	18481.64	18498.16	18476.13	18495.26	1891.0
2021-11-02 21:00:00	NQ	Futures	18495.55	18521.06	18494.39	18505.98	3149.0
2021-11-02 22:00:00	NQ	Futures	18505.98	18506.56	18494.97	18502.8	2055.0
2021-11-02 23:00:00	NQ	Futures	18502.51	18511.2	18499.32	18500.48	1482.0
2021-11-02 00:00:00	YM	Futures	40037.7	40046.7	40024.2	40026.5	753.0
2021-11-02 01:00:00	YM	Futures	40026.5	40076.9	40016.4	40056.7	1316.0
2021-11-02 02:00:00	YM	Futures	40057.9	40085.9	40034.3	40084.8	1293.0
2021-11-02 03:00:00	YM	Futures	40082.5	40121.8	40064.6	40104.9	2181.0

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

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