PREVIEW / futures_1hour / 2023-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-14.parquet
  size:    70 KB
  rows:    2,118

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
2023-11-14 00:00:00	ES	Futures	4809.3	4809.3	4807.4	4807.94	3015.0
2023-11-14 01:00:00	ES	Futures	4807.94	4810.93	4806.58	4809.57	5355.0
2023-11-14 02:00:00	ES	Futures	4809.3	4813.37	4807.94	4812.83	6615.0
2023-11-14 03:00:00	ES	Futures	4813.1	4815.0	4809.03	4814.46	13799.0
2023-11-14 04:00:00	ES	Futures	4814.19	4819.62	4813.64	4816.9	18104.0
2023-11-14 05:00:00	ES	Futures	4816.9	4818.8	4809.57	4810.66	14540.0
2023-11-14 06:00:00	ES	Futures	4810.93	4812.56	4807.94	4812.01	14543.0
2023-11-14 07:00:00	ES	Futures	4812.01	4812.29	4806.04	4810.93	18543.0
2023-11-14 08:00:00	ES	Futures	4810.93	4877.46	4801.42	4875.02	209637.0
2023-11-14 09:00:00	ES	Futures	4875.02	4892.12	4868.77	4890.49	313912.0
2023-11-14 10:00:00	ES	Futures	4890.77	4906.79	4887.51	4902.44	266345.0
2023-11-14 11:00:00	ES	Futures	4902.44	4910.59	4895.93	4896.47	164090.0
2023-11-14 12:00:00	ES	Futures	4896.74	4900.54	4890.22	4899.73	129722.0
2023-11-14 13:00:00	ES	Futures	4900.0	4904.07	4894.02	4894.3	87591.0
2023-11-14 14:00:00	ES	Futures	4894.3	4908.15	4888.32	4907.33	126907.0
2023-11-14 15:00:00	ES	Futures	4907.06	4914.39	4894.84	4899.73	293363.0
2023-11-14 16:00:00	ES	Futures	4899.46	4906.52	4898.91	4903.8	95216.0
2023-11-14 18:00:00	ES	Futures	4904.89	4909.5	4903.8	4905.97	7994.0
2023-11-14 19:00:00	ES	Futures	4906.24	4906.79	4903.53	4905.43	7706.0
2023-11-14 20:00:00	ES	Futures	4905.7	4907.33	4903.26	4905.7	7264.0
2023-11-14 21:00:00	ES	Futures	4905.97	4912.22	4904.89	4911.95	7600.0
2023-11-14 22:00:00	ES	Futures	4911.68	4913.31	4910.05	4911.95	8389.0
2023-11-14 23:00:00	ES	Futures	4911.95	4912.76	4910.59	4910.59	3695.0
2023-11-14 00:00:00	NQ	Futures	17108.56	17108.56	17100.87	17104.71	2255.0
2023-11-14 01:00:00	NQ	Futures	17104.16	17114.33	17098.12	17110.21	2455.0
2023-11-14 02:00:00	NQ	Futures	17109.66	17120.92	17103.61	17118.72	3639.0
2023-11-14 03:00:00	NQ	Futures	17118.17	17135.2	17111.58	17133.83	8177.0
2023-11-14 04:00:00	NQ	Futures	17133.83	17147.56	17125.04	17131.63	9547.0
2023-11-14 05:00:00	NQ	Futures	17131.9	17139.59	17109.38	17116.25	7123.0
2023-11-14 06:00:00	NQ	Futures	17116.52	17124.21	17103.06	17120.92	6378.0
2023-11-14 07:00:00	NQ	Futures	17121.19	17124.76	17103.06	17119.54	7742.0
2023-11-14 08:00:00	NQ	Futures	17119.54	17402.45	17086.31	17381.02	78798.0
2023-11-14 09:00:00	NQ	Futures	17381.3	17432.94	17348.07	17427.44	130877.0
2023-11-14 10:00:00	NQ	Futures	17426.89	17471.94	17411.51	17433.21	91733.0
2023-11-14 11:00:00	NQ	Futures	17432.94	17461.23	17398.05	17405.47	60310.0
2023-11-14 12:00:00	NQ	Futures	17405.74	17444.75	17395.31	17442.55	43275.0
2023-11-14 13:00:00	NQ	Futures	17442.55	17455.46	17415.36	17415.36	34572.0
2023-11-14 14:00:00	NQ	Futures	17415.91	17462.6	17382.95	17457.11	51090.0
2023-11-14 15:00:00	NQ	Futures	17457.11	17489.24	17427.72	17445.3	76024.0
2023-11-14 16:00:00	NQ	Futures	17445.3	17474.41	17441.73	17460.95	14557.0
2023-11-14 18:00:00	NQ	Futures	17463.15	17482.93	17463.15	17473.86	3816.0
2023-11-14 19:00:00	NQ	Futures	17474.14	17477.43	17463.15	17474.96	4195.0
2023-11-14 20:00:00	NQ	Futures	17475.23	17482.93	17469.47	17480.45	4717.0
2023-11-14 21:00:00	NQ	Futures	17481.28	17497.48	17476.33	17496.66	4350.0
2023-11-14 22:00:00	NQ	Futures	17496.66	17504.9	17492.81	17499.68	4216.0
2023-11-14 23:00:00	NQ	Futures	17499.95	17502.43	17491.44	17492.26	2219.0
2023-11-14 00:00:00	YM	Futures	37298.5	37298.5	37282.2	37286.5	588.0
2023-11-14 01:00:00	YM	Futures	37286.5	37299.5	37276.8	37290.9	850.0
2023-11-14 02:00:00	YM	Futures	37289.8	37320.2	37283.3	37320.2	1254.0
2023-11-14 03:00:00	YM	Futures	37319.1	37329.9	37285.4	37322.3	2504.0

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

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