PREVIEW / etf_1hour / 2023-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-16.parquet
  size:    474 KB
  rows:    17,211

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-16 04:00:00	SPY	ETF	414.25	414.81	414.04	414.12	25859.0
2023-02-16 05:00:00	SPY	ETF	414.0	414.27	413.87	413.91	26924.0
2023-02-16 06:00:00	SPY	ETF	413.85	414.03	413.67	413.97	29571.0
2023-02-16 07:00:00	SPY	ETF	413.92	414.05	413.0	413.05	151158.0
2023-02-16 08:00:00	SPY	ETF	413.3487	414.79	409.17	409.77	1517520.0
2023-02-16 09:00:00	SPY	ETF	409.76	409.79	408.26	408.86	8136443.0
2023-02-16 10:00:00	SPY	ETF	408.83	411.67	408.4	411.34	10762615.0
2023-02-16 11:00:00	SPY	ETF	411.36	412.05	410.77	411.42	6285429.0
2023-02-16 12:00:00	SPY	ETF	411.415	412.89	410.85	412.14	6157840.0
2023-02-16 13:00:00	SPY	ETF	412.17	412.6625	411.305	412.15	4204385.0
2023-02-16 14:00:00	SPY	ETF	412.14	412.91	411.84	412.18	4077440.0
2023-02-16 15:00:00	SPY	ETF	412.19	412.32	408.14	408.33	20129838.0
2023-02-16 16:00:00	SPY	ETF	408.33	409.0	407.85	407.96	3800555.0
2023-02-16 17:00:00	SPY	ETF	407.95	408.04	407.93	407.95	66972.0
2023-02-16 18:00:00	SPY	ETF	407.94	407.94	407.0	407.22	171264.0
2023-02-16 19:00:00	SPY	ETF	407.16	407.46	407.07	407.3	78965.0
2023-02-16 04:00:00	QQQ	ETF	309.69	309.97	309.3	309.3	70369.0
2023-02-16 05:00:00	QQQ	ETF	309.32	309.51	309.11	309.26	16070.0
2023-02-16 06:00:00	QQQ	ETF	309.22	309.42	309.0	309.16	28965.0
2023-02-16 07:00:00	QQQ	ETF	309.21	309.289	308.1	308.3	231851.0
2023-02-16 08:00:00	QQQ	ETF	309.24	310.41	304.58	305.2	1552657.0
2023-02-16 09:00:00	QQQ	ETF	305.15	306.0	303.71	305.33	8011283.0
2023-02-16 10:00:00	QQQ	ETF	305.32	307.88	304.6402	307.35	6603666.0
2023-02-16 11:00:00	QQQ	ETF	307.39	307.94	306.645	307.18	4340797.0
2023-02-16 12:00:00	QQQ	ETF	307.15	308.43	306.3	307.4309	4151690.0
2023-02-16 13:00:00	QQQ	ETF	307.435	307.93	306.7	307.67	3441887.0
2023-02-16 14:00:00	QQQ	ETF	307.685	308.03	306.92	307.39	3374605.0
2023-02-16 15:00:00	QQQ	ETF	307.4	307.52	303.15	303.28	11713059.0
2023-02-16 16:00:00	QQQ	ETF	303.28	309.2121	302.64	302.9	2005925.0
2023-02-16 17:00:00	QQQ	ETF	302.89	303.0	302.71	302.77	167180.0
2023-02-16 18:00:00	QQQ	ETF	302.82	302.82	301.86	301.95	293499.0
2023-02-16 19:00:00	QQQ	ETF	301.93	302.18	301.83	302.03	146578.0
2023-02-16 04:00:00	IWM	ETF	194.74	194.86	194.55	194.59	9510.0
2023-02-16 05:00:00	IWM	ETF	194.55	194.67	194.4	194.4	8258.0
2023-02-16 06:00:00	IWM	ETF	194.39	194.43	194.27	194.33	10956.0
2023-02-16 07:00:00	IWM	ETF	194.46	194.5	193.9	193.9	52999.0
2023-02-16 08:00:00	IWM	ETF	193.9	193.9	192.06	192.41	320952.0
2023-02-16 09:00:00	IWM	ETF	192.34	192.82	191.25	192.04	2722016.0
2023-02-16 10:00:00	IWM	ETF	192.04	193.85	191.8	193.43	2046029.0
2023-02-16 11:00:00	IWM	ETF	193.45	194.18	193.4	193.86	2046121.0
2023-02-16 12:00:00	IWM	ETF	193.85	194.87	193.75	194.34	1602859.0
2023-02-16 13:00:00	IWM	ETF	194.34	194.63	193.925	194.42	1503268.0
2023-02-16 14:00:00	IWM	ETF	194.42	194.79	194.2	194.48	1370865.0
2023-02-16 15:00:00	IWM	ETF	194.48	194.545	192.53	192.6	4795158.0
2023-02-16 16:00:00	IWM	ETF	192.6	192.65	192.3	192.4	845082.0
2023-02-16 17:00:00	IWM	ETF	192.49	192.49	192.27	192.32	8008.0
2023-02-16 18:00:00	IWM	ETF	192.37	192.43	191.91	192.04	44963.0
2023-02-16 19:00:00	IWM	ETF	192.08	192.22	191.94	192.05	74340.0
2023-02-16 04:00:00	DIA	ETF	341.97	341.97	341.72	341.72	200.0
2023-02-16 05:00:00	DIA	ETF	341.66	341.7	341.66	341.69	1500.0

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

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