PREVIEW / futures_1hour / 2021-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-21.parquet
  size:    66 KB
  rows:    2,015

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-12-21 00:00:00	ES	Futures	5189.42	5198.75	5189.42	5198.19	8203.0
2021-12-21 01:00:00	ES	Futures	5197.9	5205.82	5196.49	5204.41	8587.0
2021-12-21 02:00:00	ES	Futures	5204.41	5205.26	5190.55	5193.09	11558.0
2021-12-21 03:00:00	ES	Futures	5193.09	5193.38	5178.39	5189.42	22321.0
2021-12-21 04:00:00	ES	Futures	5189.42	5196.21	5182.07	5182.91	12921.0
2021-12-21 05:00:00	ES	Futures	5182.91	5196.21	5180.37	5195.36	9487.0
2021-12-21 06:00:00	ES	Futures	5195.36	5209.78	5194.79	5207.52	21291.0
2021-12-21 07:00:00	ES	Futures	5207.8	5210.91	5204.97	5209.78	18599.0
2021-12-21 08:00:00	ES	Futures	5209.78	5210.06	5197.34	5204.41	34995.0
2021-12-21 09:00:00	ES	Futures	5204.41	5208.08	5180.93	5184.33	195131.0
2021-12-21 10:00:00	ES	Futures	5184.33	5200.16	5172.17	5185.74	251824.0
2021-12-21 11:00:00	ES	Futures	5185.18	5218.26	5182.35	5211.76	160606.0
2021-12-21 12:00:00	ES	Futures	5211.48	5236.65	5210.91	5235.52	142043.0
2021-12-21 13:00:00	ES	Futures	5235.52	5243.15	5228.73	5238.91	99135.0
2021-12-21 14:00:00	ES	Futures	5238.91	5245.98	5233.82	5245.98	106622.0
2021-12-21 15:00:00	ES	Futures	5245.98	5251.35	5228.45	5249.09	232466.0
2021-12-21 16:00:00	ES	Futures	5249.37	5252.2	5243.43	5251.07	60796.0
2021-12-21 18:00:00	ES	Futures	5250.79	5251.92	5244.56	5246.26	7139.0
2021-12-21 19:00:00	ES	Futures	5246.54	5249.37	5242.59	5244.56	8268.0
2021-12-21 20:00:00	ES	Futures	5244.56	5251.92	5244.0	5245.13	5964.0
2021-12-21 21:00:00	ES	Futures	5245.13	5247.11	5238.91	5241.17	4511.0
2021-12-21 22:00:00	ES	Futures	5240.89	5244.56	5238.63	5242.3	3142.0
2021-12-21 23:00:00	ES	Futures	5242.59	5244.56	5241.74	5242.59	1675.0
2021-12-21 00:00:00	NQ	Futures	18277.61	18301.95	18277.61	18298.77	3714.0
2021-12-21 01:00:00	NQ	Futures	18297.9	18348.03	18294.71	18341.08	5465.0
2021-12-21 02:00:00	NQ	Futures	18341.95	18343.4	18291.52	18301.95	6177.0
2021-12-21 03:00:00	NQ	Futures	18300.79	18300.79	18239.35	18275.87	10376.0
2021-12-21 04:00:00	NQ	Futures	18275.0	18293.84	18228.34	18235.01	7291.0
2021-12-21 05:00:00	NQ	Futures	18234.72	18273.55	18219.65	18265.44	6120.0
2021-12-21 06:00:00	NQ	Futures	18265.73	18326.3	18261.38	18315.86	6658.0
2021-12-21 07:00:00	NQ	Futures	18315.28	18339.92	18300.79	18331.8	6395.0
2021-12-21 08:00:00	NQ	Futures	18332.38	18333.83	18289.78	18318.76	9860.0
2021-12-21 09:00:00	NQ	Futures	18318.47	18321.37	18158.78	18159.65	82881.0
2021-12-21 10:00:00	NQ	Futures	18159.94	18209.79	18090.39	18166.61	91704.0
2021-12-21 11:00:00	NQ	Futures	18166.9	18318.76	18152.7	18293.84	61178.0
2021-12-21 12:00:00	NQ	Futures	18293.55	18394.69	18283.12	18390.93	43394.0
2021-12-21 13:00:00	NQ	Futures	18392.09	18462.22	18370.06	18450.63	33307.0
2021-12-21 14:00:00	NQ	Futures	18450.92	18518.74	18443.96	18517.29	38065.0
2021-12-21 15:00:00	NQ	Futures	18518.16	18533.52	18443.67	18517.0	67869.0
2021-12-21 16:00:00	NQ	Futures	18516.71	18525.11	18499.03	18518.16	12008.0
2021-12-21 18:00:00	NQ	Futures	18523.95	18527.43	18495.26	18502.8	3792.0
2021-12-21 19:00:00	NQ	Futures	18502.51	18513.52	18478.16	18483.09	4810.0
2021-12-21 20:00:00	NQ	Futures	18482.51	18510.33	18478.74	18482.51	3543.0
2021-12-21 21:00:00	NQ	Futures	18482.8	18491.78	18458.45	18467.44	2866.0
2021-12-21 22:00:00	NQ	Futures	18466.28	18479.61	18457.3	18470.92	2663.0
2021-12-21 23:00:00	NQ	Futures	18470.92	18478.16	18463.09	18472.08	1392.0
2021-12-21 00:00:00	YM	Futures	39340.9	39429.7	39340.9	39427.4	2176.0
2021-12-21 01:00:00	YM	Futures	39425.2	39462.2	39390.3	39444.3	2119.0
2021-12-21 02:00:00	YM	Futures	39444.3	39455.5	39342.0	39365.6	4074.0
2021-12-21 03:00:00	YM	Futures	39366.7	39366.7	39248.7	39338.6	7279.0

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

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