PREVIEW / etf_1hour / 2023-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-10.parquet
  size:    466 KB
  rows:    17,011

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-10 04:00:00	SPY	ETF	407.37	407.6	405.85	405.91	47949.0
2023-02-10 05:00:00	SPY	ETF	405.9	406.06	405.12	405.59	51345.0
2023-02-10 06:00:00	SPY	ETF	405.6	405.6	404.39	404.49	150465.0
2023-02-10 07:00:00	SPY	ETF	404.57	405.06	404.15	404.3	249239.0
2023-02-10 08:00:00	SPY	ETF	404.69	407.18	404.15	405.27	705440.0
2023-02-10 09:00:00	SPY	ETF	405.27	406.99	405.1	406.42	6892199.0
2023-02-10 10:00:00	SPY	ETF	406.48	408.11	405.01	406.62	10805405.0
2023-02-10 11:00:00	SPY	ETF	406.63	407.49	406.1001	406.2401	5633594.0
2023-02-10 12:00:00	SPY	ETF	406.22	406.91	405.26	406.9	5474206.0
2023-02-10 13:00:00	SPY	ETF	406.895	408.14	406.69	406.73	5655886.0
2023-02-10 14:00:00	SPY	ETF	406.74	407.47	406.2	407.41	5575595.0
2023-02-10 15:00:00	SPY	ETF	407.41	408.44	406.73	408.03	11045013.0
2023-02-10 16:00:00	SPY	ETF	408.01	408.07	407.55	407.96	3607544.0
2023-02-10 17:00:00	SPY	ETF	407.94	408.15	407.66	407.8	104449.0
2023-02-10 18:00:00	SPY	ETF	407.8	407.99	407.7	407.94	24407.0
2023-02-10 19:00:00	SPY	ETF	407.98	408.25	407.94	408.2	9417.0
2023-02-10 04:00:00	QQQ	ETF	301.49	301.73	299.36	299.36	113609.0
2023-02-10 05:00:00	QQQ	ETF	299.5	299.7	298.63	299.21	115596.0
2023-02-10 06:00:00	QQQ	ETF	299.2	299.2	297.96	298.34	165266.0
2023-02-10 07:00:00	QQQ	ETF	298.37	298.82	297.96	298.3	333943.0
2023-02-10 08:00:00	QQQ	ETF	298.53	302.2	297.93	299.41	735020.0
2023-02-10 09:00:00	QQQ	ETF	299.41	300.92	298.93	299.71	5875086.0
2023-02-10 10:00:00	QQQ	ETF	299.78	301.57	298.23	299.435	8053579.0
2023-02-10 11:00:00	QQQ	ETF	299.41	300.0801	298.09	298.18	4029683.0
2023-02-10 12:00:00	QQQ	ETF	298.2	298.78	297.25	298.7	3905811.0
2023-02-10 13:00:00	QQQ	ETF	298.71	300.27	298.56	298.74	3920854.0
2023-02-10 14:00:00	QQQ	ETF	298.75	299.31	298.15	299.2	3038899.0
2023-02-10 15:00:00	QQQ	ETF	299.21	300.23	298.555	299.74	7049573.0
2023-02-10 16:00:00	QQQ	ETF	299.72	299.81	299.44	299.65	1549184.0
2023-02-10 17:00:00	QQQ	ETF	299.57	299.7	299.49	299.61	93386.0
2023-02-10 18:00:00	QQQ	ETF	299.67	299.8	299.56	299.79	7979.0
2023-02-10 19:00:00	QQQ	ETF	299.72	300.0	299.71	299.99	12700.0
2023-02-10 04:00:00	IWM	ETF	190.38	190.45	189.88	190.0	11360.0
2023-02-10 05:00:00	IWM	ETF	189.85	189.85	189.57	189.8	20679.0
2023-02-10 06:00:00	IWM	ETF	189.78	189.78	189.05	189.1	51834.0
2023-02-10 07:00:00	IWM	ETF	189.13	189.3	188.73	188.73	46448.0
2023-02-10 08:00:00	IWM	ETF	189.02	189.42	188.69	189.17	58223.0
2023-02-10 09:00:00	IWM	ETF	189.14	189.79	188.91	189.2	1791831.0
2023-02-10 10:00:00	IWM	ETF	189.2	190.31	188.5328	189.58	2773591.0
2023-02-10 11:00:00	IWM	ETF	189.54	190.0888	189.25	189.33	1421216.0
2023-02-10 12:00:00	IWM	ETF	189.32	189.96	189.025	189.95	953017.0
2023-02-10 13:00:00	IWM	ETF	189.93	190.63	189.8801	189.9	1227833.0
2023-02-10 14:00:00	IWM	ETF	189.9	190.33	189.735	190.26	680185.0
2023-02-10 15:00:00	IWM	ETF	190.26	190.59	190.095	190.3	1924897.0
2023-02-10 16:00:00	IWM	ETF	190.31	190.4	190.12	190.39	587683.0
2023-02-10 17:00:00	IWM	ETF	190.22	190.4	190.22	190.31	168254.0
2023-02-10 18:00:00	IWM	ETF	190.25	190.32	190.16	190.26	22475.0
2023-02-10 19:00:00	IWM	ETF	190.31	190.49	190.28	190.49	7533.0
2023-02-10 04:00:00	DIA	ETF	336.77	336.77	336.77	336.77	100.0
2023-02-10 05:00:00	DIA	ETF	336.81	336.81	336.33	336.37	1500.0

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

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