PREVIEW / futures_1hour / 2022-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-06.parquet
  size:    69 KB
  rows:    2,063

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-06 00:00:00	ES	Futures	5118.65	5123.47	5118.65	5120.91	3951.0
2022-04-06 01:00:00	ES	Futures	5120.91	5129.7	5120.63	5124.6	8454.0
2022-04-06 02:00:00	ES	Futures	5124.6	5134.52	5123.75	5130.27	11489.0
2022-04-06 03:00:00	ES	Futures	5130.27	5133.39	5102.21	5103.62	26875.0
2022-04-06 04:00:00	ES	Futures	5103.62	5109.01	5097.96	5106.74	21683.0
2022-04-06 05:00:00	ES	Futures	5106.74	5109.01	5089.17	5097.67	23455.0
2022-04-06 06:00:00	ES	Futures	5097.67	5098.52	5086.05	5087.75	17699.0
2022-04-06 07:00:00	ES	Futures	5087.47	5089.74	5073.01	5074.71	31998.0
2022-04-06 08:00:00	ES	Futures	5075.0	5080.38	5071.31	5078.97	39097.0
2022-04-06 09:00:00	ES	Futures	5078.97	5085.2	5061.39	5062.53	214060.0
2022-04-06 10:00:00	ES	Futures	5062.53	5065.93	5050.34	5055.72	222378.0
2022-04-06 11:00:00	ES	Futures	5055.72	5072.45	5052.04	5066.49	148557.0
2022-04-06 12:00:00	ES	Futures	5066.21	5068.76	5051.75	5059.12	91783.0
2022-04-06 13:00:00	ES	Futures	5059.12	5077.55	5055.16	5068.19	99395.0
2022-04-06 14:00:00	ES	Futures	5068.48	5096.54	5039.0	5090.3	342949.0
2022-04-06 15:00:00	ES	Futures	5090.59	5101.36	5059.97	5074.15	333281.0
2022-04-06 16:00:00	ES	Futures	5074.43	5076.41	5069.04	5069.04	51470.0
2022-04-06 18:00:00	ES	Futures	5069.33	5076.41	5068.48	5073.86	5142.0
2022-04-06 19:00:00	ES	Futures	5073.86	5075.28	5057.42	5058.56	6956.0
2022-04-06 20:00:00	ES	Futures	5058.27	5061.11	5055.16	5059.12	9806.0
2022-04-06 21:00:00	ES	Futures	5059.41	5069.61	5056.57	5065.08	10848.0
2022-04-06 22:00:00	ES	Futures	5064.79	5065.64	5059.97	5061.39	5776.0
2022-04-06 23:00:00	ES	Futures	5061.68	5062.53	5052.61	5053.17	6329.0
2022-04-06 00:00:00	NQ	Futures	17158.98	17180.15	17158.98	17162.75	2642.0
2022-04-06 01:00:00	NQ	Futures	17163.62	17194.94	17160.43	17181.6	3184.0
2022-04-06 02:00:00	NQ	Futures	17182.76	17216.4	17179.57	17206.54	4152.0
2022-04-06 03:00:00	NQ	Futures	17206.54	17214.66	17087.07	17094.32	12174.0
2022-04-06 04:00:00	NQ	Futures	17093.16	17107.66	17060.1	17096.93	12126.0
2022-04-06 05:00:00	NQ	Futures	17097.22	17105.92	17029.36	17061.84	10174.0
2022-04-06 06:00:00	NQ	Futures	17061.84	17065.03	16998.63	17002.98	11025.0
2022-04-06 07:00:00	NQ	Futures	17003.27	17013.13	16912.79	16923.52	19815.0
2022-04-06 08:00:00	NQ	Futures	16923.52	16945.27	16912.79	16938.02	18674.0
2022-04-06 09:00:00	NQ	Futures	16938.02	16985.0	16819.71	16825.22	96637.0
2022-04-06 10:00:00	NQ	Futures	16826.09	16848.13	16767.81	16789.56	110814.0
2022-04-06 11:00:00	NQ	Futures	16789.27	16846.97	16756.21	16814.78	73536.0
2022-04-06 12:00:00	NQ	Futures	16814.49	16823.77	16726.34	16757.37	54640.0
2022-04-06 13:00:00	NQ	Futures	16757.08	16890.18	16738.81	16840.01	54633.0
2022-04-06 14:00:00	NQ	Futures	16843.49	16974.27	16696.47	16935.7	149337.0
2022-04-06 15:00:00	NQ	Futures	16935.99	16995.73	16779.7	16824.93	107831.0
2022-04-06 16:00:00	NQ	Futures	16825.8	16839.43	16809.27	16813.91	14144.0
2022-04-06 18:00:00	NQ	Futures	16814.2	16842.33	16811.88	16831.6	3228.0
2022-04-06 19:00:00	NQ	Futures	16831.89	16835.95	16753.6	16759.4	4303.0
2022-04-06 20:00:00	NQ	Futures	16758.24	16783.76	16746.35	16774.77	4667.0
2022-04-06 21:00:00	NQ	Futures	16775.64	16816.23	16764.62	16804.34	5245.0
2022-04-06 22:00:00	NQ	Futures	16803.47	16809.27	16780.86	16789.85	2863.0
2022-04-06 23:00:00	NQ	Futures	16791.29	16794.77	16757.37	16760.56	2863.0
2022-04-06 00:00:00	YM	Futures	38900.8	38933.5	38900.8	38923.3	752.0
2022-04-06 01:00:00	YM	Futures	38922.2	38985.4	38921.1	38941.4	1568.0
2022-04-06 02:00:00	YM	Futures	38942.5	39011.3	38935.7	38974.1	2095.0
2022-04-06 03:00:00	YM	Futures	38976.3	39014.7	38791.5	38801.6	5194.0

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

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