PREVIEW / futures_1hour / 2021-11-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	5281.61	5283.3	5277.37	5279.35	6135.0
2021-11-16 01:00:00	ES	Futures	5279.35	5281.04	5277.37	5279.91	4188.0
2021-11-16 02:00:00	ES	Futures	5279.91	5282.73	5279.35	5281.04	5887.0
2021-11-16 03:00:00	ES	Futures	5281.32	5284.43	5273.14	5275.11	15023.0
2021-11-16 04:00:00	ES	Futures	5275.11	5279.91	5274.83	5279.07	7651.0
2021-11-16 05:00:00	ES	Futures	5278.78	5279.63	5272.57	5275.96	10848.0
2021-11-16 06:00:00	ES	Futures	5275.96	5286.97	5275.4	5285.84	16936.0
2021-11-16 07:00:00	ES	Futures	5286.12	5286.97	5280.76	5282.45	12039.0
2021-11-16 08:00:00	ES	Futures	5282.45	5289.22	5278.78	5281.89	31031.0
2021-11-16 09:00:00	ES	Futures	5281.61	5299.67	5275.68	5294.3	172697.0
2021-11-16 10:00:00	ES	Futures	5294.3	5300.51	5288.94	5292.89	131731.0
2021-11-16 11:00:00	ES	Futures	5292.61	5310.39	5292.61	5307.57	134355.0
2021-11-16 12:00:00	ES	Futures	5307.57	5313.21	5305.59	5310.67	65479.0
2021-11-16 13:00:00	ES	Futures	5310.67	5315.75	5309.54	5315.19	65335.0
2021-11-16 14:00:00	ES	Futures	5314.91	5316.6	5308.98	5310.11	62971.0
2021-11-16 15:00:00	ES	Futures	5309.83	5311.24	5299.38	5302.49	169555.0
2021-11-16 16:00:00	ES	Futures	5302.49	5305.31	5300.23	5301.64	46660.0
2021-11-16 18:00:00	ES	Futures	5301.64	5305.88	5299.67	5304.75	5347.0
2021-11-16 19:00:00	ES	Futures	5304.46	5305.59	5302.21	5303.9	5213.0
2021-11-16 20:00:00	ES	Futures	5303.62	5304.46	5301.36	5302.77	5584.0
2021-11-16 21:00:00	ES	Futures	5302.49	5303.62	5299.95	5300.8	3455.0
2021-11-16 22:00:00	ES	Futures	5300.51	5301.92	5294.87	5296.28	6866.0
2021-11-16 23:00:00	ES	Futures	5296.56	5299.67	5296.28	5299.1	3655.0
2021-11-16 00:00:00	NQ	Futures	18769.14	18776.67	18746.82	18761.6	3005.0
2021-11-16 01:00:00	NQ	Futures	18761.89	18773.49	18754.36	18767.69	2943.0
2021-11-16 02:00:00	NQ	Futures	18767.11	18783.63	18761.6	18776.67	3143.0
2021-11-16 03:00:00	NQ	Futures	18777.25	18786.24	18741.03	18744.5	6066.0
2021-11-16 04:00:00	NQ	Futures	18745.66	18761.31	18744.5	18754.65	4120.0
2021-11-16 05:00:00	NQ	Futures	18754.07	18755.81	18723.64	18740.74	5178.0
2021-11-16 06:00:00	NQ	Futures	18740.45	18784.5	18731.17	18780.73	6239.0
2021-11-16 07:00:00	NQ	Futures	18780.73	18785.08	18752.62	18763.34	6172.0
2021-11-16 08:00:00	NQ	Futures	18763.63	18797.25	18738.13	18745.37	17165.0
2021-11-16 09:00:00	NQ	Futures	18745.08	18840.14	18712.91	18808.55	90685.0
2021-11-16 10:00:00	NQ	Futures	18808.55	18849.71	18774.07	18815.51	70515.0
2021-11-16 11:00:00	NQ	Futures	18814.93	18906.8	18813.77	18882.75	51992.0
2021-11-16 12:00:00	NQ	Futures	18882.46	18901.01	18870.28	18888.54	25564.0
2021-11-16 13:00:00	NQ	Futures	18888.54	18913.18	18882.46	18910.28	25658.0
2021-11-16 14:00:00	NQ	Futures	18909.99	18923.61	18897.24	18906.51	24504.0
2021-11-16 15:00:00	NQ	Futures	18906.8	18923.32	18878.4	18901.87	50272.0
2021-11-16 16:00:00	NQ	Futures	18901.3	18902.74	18885.65	18889.41	10066.0
2021-11-16 18:00:00	NQ	Futures	18893.47	18908.54	18887.09	18901.58	3058.0
2021-11-16 19:00:00	NQ	Futures	18902.16	18907.67	18897.82	18903.03	2374.0
2021-11-16 20:00:00	NQ	Futures	18902.16	18910.28	18892.02	18897.82	2635.0
2021-11-16 21:00:00	NQ	Futures	18897.53	18900.43	18886.8	18889.7	1402.0
2021-11-16 22:00:00	NQ	Futures	18889.7	18894.63	18865.07	18875.5	3234.0
2021-11-16 23:00:00	NQ	Futures	18874.92	18890.57	18873.76	18888.83	1648.0
2021-11-16 00:00:00	YM	Futures	40362.8	40372.8	40338.1	40345.9	1184.0
2021-11-16 01:00:00	YM	Futures	40347.1	40356.0	40330.2	40352.7	1081.0
2021-11-16 02:00:00	YM	Futures	40351.5	40371.7	40349.3	40362.8	1537.0
2021-11-16 03:00:00	YM	Futures	40362.8	40381.8	40292.1	40324.6	3604.0

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

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