PREVIEW / futures_1hour / 2021-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-19.parquet
  size:    56 KB
  rows:    1,598

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-19 00:00:00	ES	Futures	5327.61	5329.02	5325.63	5325.63	5743.0
2021-11-19 01:00:00	ES	Futures	5325.63	5329.86	5325.63	5328.17	4826.0
2021-11-19 02:00:00	ES	Futures	5328.17	5332.12	5327.04	5327.32	7315.0
2021-11-19 03:00:00	ES	Futures	5327.32	5327.61	5323.94	5324.5	11996.0
2021-11-19 04:00:00	ES	Futures	5324.5	5326.19	5307.0	5307.85	38758.0
2021-11-19 05:00:00	ES	Futures	5307.85	5308.42	5287.81	5305.31	52831.0
2021-11-19 06:00:00	ES	Futures	5305.31	5306.72	5290.64	5293.46	26640.0
2021-11-19 07:00:00	ES	Futures	5293.46	5299.38	5288.66	5292.05	36743.0
2021-11-19 08:00:00	ES	Futures	5292.05	5301.36	5289.79	5298.82	41194.0
2021-11-19 09:00:00	ES	Futures	5298.54	5313.21	5294.02	5312.65	207963.0
2021-11-19 10:00:00	ES	Futures	5312.65	5313.5	5297.13	5303.34	158062.0
2021-11-19 11:00:00	ES	Futures	5303.34	5313.21	5302.77	5310.67	94575.0
2021-11-19 12:00:00	ES	Futures	5310.67	5321.68	5310.67	5314.62	100849.0
2021-11-19 13:00:00	ES	Futures	5314.34	5316.03	5294.3	5305.59	134466.0
2021-11-19 14:00:00	ES	Futures	5305.59	5309.26	5300.8	5304.18	83109.0
2021-11-19 15:00:00	ES	Futures	5304.18	5305.88	5295.72	5298.54	169706.0
2021-11-19 16:00:00	ES	Futures	5298.54	5303.9	5297.41	5303.05	53382.0
2021-11-19 00:00:00	NQ	Futures	19210.24	19212.27	19193.72	19204.15	2944.0
2021-11-19 01:00:00	NQ	Futures	19204.15	19215.17	19200.97	19202.7	1978.0
2021-11-19 02:00:00	NQ	Futures	19203.57	19211.4	19186.19	19201.26	4222.0
2021-11-19 03:00:00	NQ	Futures	19200.97	19204.44	19180.97	19195.75	5856.0
2021-11-19 04:00:00	NQ	Futures	19195.17	19214.01	19171.69	19174.3	10185.0
2021-11-19 05:00:00	NQ	Futures	19175.46	19188.21	19137.21	19179.52	17180.0
2021-11-19 06:00:00	NQ	Futures	19178.94	19187.63	19145.9	19164.74	9542.0
2021-11-19 07:00:00	NQ	Futures	19164.45	19195.75	19162.42	19185.61	12150.0
2021-11-19 08:00:00	NQ	Futures	19185.9	19206.18	19176.33	19205.02	16949.0
2021-11-19 09:00:00	NQ	Futures	19204.73	19262.41	19146.77	19258.35	91442.0
2021-11-19 10:00:00	NQ	Futures	19258.93	19263.57	19181.84	19203.86	90329.0
2021-11-19 11:00:00	NQ	Futures	19204.15	19274.29	19199.81	19247.92	53576.0
2021-11-19 12:00:00	NQ	Futures	19248.21	19276.9	19227.92	19233.43	41578.0
2021-11-19 13:00:00	NQ	Futures	19233.14	19255.16	19166.77	19221.83	55327.0
2021-11-19 14:00:00	NQ	Futures	19222.12	19234.58	19204.15	19224.15	33430.0
2021-11-19 15:00:00	NQ	Futures	19223.28	19229.66	19195.75	19212.27	55176.0
2021-11-19 16:00:00	NQ	Futures	19212.56	19233.14	19207.34	19230.24	10073.0
2021-11-19 00:00:00	YM	Futures	40273.1	40283.2	40264.1	40265.2	825.0
2021-11-19 01:00:00	YM	Futures	40266.4	40307.8	40264.1	40296.6	1307.0
2021-11-19 02:00:00	YM	Futures	40296.6	40339.2	40286.5	40292.1	2232.0
2021-11-19 03:00:00	YM	Futures	40289.9	40294.4	40259.6	40260.8	2490.0
2021-11-19 04:00:00	YM	Futures	40260.8	40261.9	40059.0	40066.8	8667.0
2021-11-19 05:00:00	YM	Futures	40068.0	40071.3	39864.0	40026.5	13669.0
2021-11-19 06:00:00	YM	Futures	40031.0	40041.1	39894.2	39915.5	6516.0
2021-11-19 07:00:00	YM	Futures	39914.4	39958.1	39839.3	39869.6	7472.0
2021-11-19 08:00:00	YM	Futures	39872.9	39948.0	39851.6	39916.6	7286.0
2021-11-19 09:00:00	YM	Futures	39916.6	40085.9	39881.9	39942.4	33939.0
2021-11-19 10:00:00	YM	Futures	39943.5	39943.5	39823.6	39869.6	20271.0
2021-11-19 11:00:00	YM	Futures	39870.7	39968.2	39869.6	39929.0	12030.0
2021-11-19 12:00:00	YM	Futures	39930.1	39989.5	39922.2	39972.7	9039.0
2021-11-19 13:00:00	YM	Futures	39972.7	39977.2	39776.5	39860.6	14104.0
2021-11-19 14:00:00	YM	Futures	39860.6	39895.3	39821.4	39844.9	8267.0
2021-11-19 15:00:00	YM	Futures	39842.7	39871.8	39810.1	39840.4	12897.0

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

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