PREVIEW / futures_1hour / 2022-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-07.parquet
  size:    68 KB
  rows:    2,051

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
2022-04-07 00:00:00	ES	Futures	5053.17	5056.29	5050.05	5053.74	5529.0
2022-04-07 01:00:00	ES	Futures	5053.74	5062.53	5050.34	5058.84	8234.0
2022-04-07 02:00:00	ES	Futures	5058.84	5076.7	5056.57	5074.43	12660.0
2022-04-07 03:00:00	ES	Futures	5074.43	5084.35	5070.46	5071.6	22218.0
2022-04-07 04:00:00	ES	Futures	5071.6	5085.48	5068.76	5084.63	14211.0
2022-04-07 05:00:00	ES	Futures	5084.63	5090.02	5079.82	5088.89	12795.0
2022-04-07 06:00:00	ES	Futures	5088.6	5090.59	5084.92	5085.2	11092.0
2022-04-07 07:00:00	ES	Futures	5085.2	5098.24	5077.83	5082.93	33922.0
2022-04-07 08:00:00	ES	Futures	5082.65	5084.07	5064.79	5066.78	30121.0
2022-04-07 09:00:00	ES	Futures	5066.78	5086.05	5059.41	5078.11	149518.0
2022-04-07 10:00:00	ES	Futures	5078.11	5086.9	5048.92	5058.56	208322.0
2022-04-07 11:00:00	ES	Futures	5058.27	5067.91	5042.68	5047.79	153115.0
2022-04-07 12:00:00	ES	Futures	5047.79	5057.71	5039.0	5047.22	95713.0
2022-04-07 13:00:00	ES	Futures	5047.22	5086.33	5045.8	5083.78	141789.0
2022-04-07 14:00:00	ES	Futures	5083.78	5106.74	5076.98	5103.91	154090.0
2022-04-07 15:00:00	ES	Futures	5103.91	5121.48	5095.4	5099.37	274981.0
2022-04-07 16:00:00	ES	Futures	5099.09	5101.64	5092.57	5096.25	42514.0
2022-04-07 18:00:00	ES	Futures	5095.97	5100.22	5095.97	5098.24	2840.0
2022-04-07 19:00:00	ES	Futures	5098.52	5105.61	5096.82	5103.62	4495.0
2022-04-07 20:00:00	ES	Futures	5103.91	5105.33	5092.57	5096.25	9727.0
2022-04-07 21:00:00	ES	Futures	5096.54	5097.67	5092.57	5092.85	6979.0
2022-04-07 22:00:00	ES	Futures	5092.85	5101.64	5092.57	5100.79	4837.0
2022-04-07 23:00:00	ES	Futures	5100.79	5101.64	5095.4	5097.39	4131.0
2022-04-07 00:00:00	NQ	Futures	16760.56	16772.45	16741.71	16762.59	2794.0
2022-04-07 01:00:00	NQ	Futures	16764.04	16799.7	16748.67	16785.79	3983.0
2022-04-07 02:00:00	NQ	Futures	16785.21	16863.5	16779.41	16853.06	6339.0
2022-04-07 03:00:00	NQ	Futures	16853.93	16895.98	16833.05	16838.85	11692.0
2022-04-07 04:00:00	NQ	Futures	16839.43	16909.02	16832.18	16907.86	9726.0
2022-04-07 05:00:00	NQ	Futures	16907.0	16916.56	16883.22	16912.5	6357.0
2022-04-07 06:00:00	NQ	Futures	16912.5	16920.91	16884.96	16887.28	5742.0
2022-04-07 07:00:00	NQ	Futures	16887.28	16939.18	16858.28	16879.16	14542.0
2022-04-07 08:00:00	NQ	Futures	16878.87	16884.67	16788.98	16795.93	17739.0
2022-04-07 09:00:00	NQ	Futures	16797.09	16909.02	16762.01	16888.15	83861.0
2022-04-07 10:00:00	NQ	Futures	16887.57	16943.82	16732.14	16785.21	101099.0
2022-04-07 11:00:00	NQ	Futures	16784.92	16827.25	16650.95	16675.88	74498.0
2022-04-07 12:00:00	NQ	Futures	16675.88	16722.57	16606.29	16655.01	56039.0
2022-04-07 13:00:00	NQ	Futures	16654.14	16826.67	16649.5	16816.52	65206.0
2022-04-07 14:00:00	NQ	Futures	16815.94	16911.34	16777.96	16895.11	63034.0
2022-04-07 15:00:00	NQ	Futures	16894.24	16973.69	16853.64	16868.14	83041.0
2022-04-07 16:00:00	NQ	Futures	16868.14	16879.45	16844.07	16857.99	11572.0
2022-04-07 18:00:00	NQ	Futures	16860.6	16875.97	16858.57	16866.4	1693.0
2022-04-07 19:00:00	NQ	Futures	16866.69	16905.55	16862.63	16894.82	2548.0
2022-04-07 20:00:00	NQ	Futures	16895.69	16907.0	16846.97	16859.44	4475.0
2022-04-07 21:00:00	NQ	Futures	16860.31	16870.17	16839.14	16843.78	3766.0
2022-04-07 22:00:00	NQ	Futures	16843.78	16882.35	16840.88	16875.68	2650.0
2022-04-07 23:00:00	NQ	Futures	16875.68	16881.77	16856.25	16869.59	1893.0
2022-04-07 00:00:00	YM	Futures	38617.8	38631.4	38594.2	38612.2	1081.0
2022-04-07 01:00:00	YM	Futures	38608.8	38667.4	38586.3	38642.6	1410.0
2022-04-07 02:00:00	YM	Futures	38644.9	38762.1	38626.9	38744.1	2757.0
2022-04-07 03:00:00	YM	Futures	38745.2	38809.5	38713.7	38723.8	3917.0

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

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