PREVIEW / etf_1hour / 2023-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-06.parquet
  size:    477 KB
  rows:    17,481

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-02-06 04:00:00	SPY	ETF	410.25	410.95	409.04	409.08	99675.0
2023-02-06 05:00:00	SPY	ETF	409.04	409.09	408.39	408.93	67887.0
2023-02-06 06:00:00	SPY	ETF	408.84	409.31	408.44	409.29	61466.0
2023-02-06 07:00:00	SPY	ETF	409.24	410.13	409.21	410.01	262318.0
2023-02-06 08:00:00	SPY	ETF	409.98	411.15	408.86	409.36	384246.0
2023-02-06 09:00:00	SPY	ETF	409.36	410.89	409.18	410.29	5739100.0
2023-02-06 10:00:00	SPY	ETF	410.32	410.689	408.1	410.27	8756654.0
2023-02-06 11:00:00	SPY	ETF	410.27	411.29	409.5999	409.7207	6298595.0
2023-02-06 12:00:00	SPY	ETF	409.72	410.48	409.33	409.9499	3624475.0
2023-02-06 13:00:00	SPY	ETF	409.94	410.34	409.18	409.97	3366398.0
2023-02-06 14:00:00	SPY	ETF	409.96	411.05	409.7	410.26	4655064.0
2023-02-06 15:00:00	SPY	ETF	410.24	410.33	408.72	409.9	9731231.0
2023-02-06 16:00:00	SPY	ETF	409.91	410.15	409.81	410.02	2397987.0
2023-02-06 17:00:00	SPY	ETF	410.02	410.17	409.9	410.08	152586.0
2023-02-06 18:00:00	SPY	ETF	410.08	410.65	410.05	410.65	184495.0
2023-02-06 19:00:00	SPY	ETF	410.67	410.99	410.54	410.97	98547.0
2023-02-06 04:00:00	QQQ	ETF	304.12	304.44	302.99	303.0	113301.0
2023-02-06 05:00:00	QQQ	ETF	302.97	303.15	302.48	303.03	77774.0
2023-02-06 06:00:00	QQQ	ETF	303.09	303.16	302.3	303.16	204706.0
2023-02-06 07:00:00	QQQ	ETF	303.14	304.21	303.1	303.98	369220.0
2023-02-06 08:00:00	QQQ	ETF	303.3	306.409	302.3185	303.32	661201.0
2023-02-06 09:00:00	QQQ	ETF	303.27	304.96	303.01	304.5	5056544.0
2023-02-06 10:00:00	QQQ	ETF	304.54	305.51	302.22	304.66	6705764.0
2023-02-06 11:00:00	QQQ	ETF	304.67	305.91	304.01	304.214	4119207.0
2023-02-06 12:00:00	QQQ	ETF	304.2	304.92	303.73	304.33	2526755.0
2023-02-06 13:00:00	QQQ	ETF	304.36	304.42	303.36	303.995	2388258.0
2023-02-06 14:00:00	QQQ	ETF	303.99	305.04	303.56	304.02	2521602.0
2023-02-06 15:00:00	QQQ	ETF	304.04	304.12	302.49	303.6	5260682.0
2023-02-06 16:00:00	QQQ	ETF	303.59	303.74	303.4	303.6	1374735.0
2023-02-06 17:00:00	QQQ	ETF	303.64	303.66	303.53	303.6	48759.0
2023-02-06 18:00:00	QQQ	ETF	303.66	304.16	303.55	304.08	61133.0
2023-02-06 19:00:00	QQQ	ETF	304.15	304.59	304.07	304.55	77790.0
2023-02-06 04:00:00	IWM	ETF	195.8	195.84	195.15	195.15	15949.0
2023-02-06 05:00:00	IWM	ETF	195.2	195.3	194.94	195.18	9223.0
2023-02-06 06:00:00	IWM	ETF	195.08	195.39	194.96	195.33	12397.0
2023-02-06 07:00:00	IWM	ETF	195.35	195.63	195.25	195.56	38165.0
2023-02-06 08:00:00	IWM	ETF	195.38	196.99	195.09	195.31	58252.0
2023-02-06 09:00:00	IWM	ETF	195.36	196.38	194.94	195.33	1860314.0
2023-02-06 10:00:00	IWM	ETF	195.33	195.69	193.48	194.74	3049090.0
2023-02-06 11:00:00	IWM	ETF	194.72	195.19	194.19	194.46	1158616.0
2023-02-06 12:00:00	IWM	ETF	194.42	194.81	194.12	194.235	710892.0
2023-02-06 13:00:00	IWM	ETF	194.24	194.43	193.82	194.21	746063.0
2023-02-06 14:00:00	IWM	ETF	194.18	194.63	193.795	194.17	1093615.0
2023-02-06 15:00:00	IWM	ETF	194.15	194.32	193.37	194.15	2538183.0
2023-02-06 16:00:00	IWM	ETF	194.14	194.33	194.02	194.14	1226507.0
2023-02-06 17:00:00	IWM	ETF	194.18	194.26	194.08	194.26	4876.0
2023-02-06 18:00:00	IWM	ETF	194.17	194.55	194.14	194.53	71838.0
2023-02-06 19:00:00	IWM	ETF	194.53	194.73	194.48	194.71	46684.0
2023-02-06 04:00:00	DIA	ETF	337.33	337.33	337.0	337.0	900.0
2023-02-06 05:00:00	DIA	ETF	336.52	336.52	336.4	336.49	1600.0

> showing 50 of 17,481 rows — these rows as CSV

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