PREVIEW / etf_1hour / 2023-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-23.parquet
  size:    464 KB
  rows:    17,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
2023-05-23 04:00:00	SPY	ETF	418.53	418.98	418.39	418.45	54834.0
2023-05-23 05:00:00	SPY	ETF	418.44	418.5	418.09	418.19	21081.0
2023-05-23 06:00:00	SPY	ETF	418.17	418.79	418.05	418.57	29120.0
2023-05-23 07:00:00	SPY	ETF	418.53	418.59	417.5	417.5	301300.0
2023-05-23 08:00:00	SPY	ETF	418.2183	419.53	417.47	417.6	212022.0
2023-05-23 09:00:00	SPY	ETF	417.59	418.07	416.84	417.66	5892468.0
2023-05-23 10:00:00	SPY	ETF	417.65	418.13	416.96	417.382	6318367.0
2023-05-23 11:00:00	SPY	ETF	417.38	418.03	417.32	417.68	4098629.0
2023-05-23 12:00:00	SPY	ETF	417.68	417.9301	415.89	416.313	8215235.0
2023-05-23 13:00:00	SPY	ETF	416.32	416.94	415.2	415.68	8195549.0
2023-05-23 14:00:00	SPY	ETF	415.69	416.25	413.68	414.71	10447288.0
2023-05-23 15:00:00	SPY	ETF	414.73	415.08	413.885	414.09	16132132.0
2023-05-23 16:00:00	SPY	ETF	414.09	416.282	414.01	414.32	3935109.0
2023-05-23 17:00:00	SPY	ETF	414.319	414.48	414.24	414.34	16381.0
2023-05-23 18:00:00	SPY	ETF	414.24	414.68	414.22	414.62	45191.0
2023-05-23 19:00:00	SPY	ETF	414.64	414.78	414.57	414.73	36400.0
2023-05-23 04:00:00	QQQ	ETF	337.77	337.93	337.57	337.76	40967.0
2023-05-23 05:00:00	QQQ	ETF	337.75	337.82	337.14	337.18	23300.0
2023-05-23 06:00:00	QQQ	ETF	337.17	337.61	337.11	337.46	126780.0
2023-05-23 07:00:00	QQQ	ETF	337.47	337.62	336.37	336.45	190143.0
2023-05-23 08:00:00	QQQ	ETF	336.9991	338.45	336.1	336.16	316118.0
2023-05-23 09:00:00	QQQ	ETF	336.14	337.0338	335.7	336.7	4648985.0
2023-05-23 10:00:00	QQQ	ETF	336.7	337.06	335.95	336.27	4900962.0
2023-05-23 11:00:00	QQQ	ETF	336.27	336.91	336.24	336.61	2809195.0
2023-05-23 12:00:00	QQQ	ETF	336.6	336.82	334.57	335.03	5181249.0
2023-05-23 13:00:00	QQQ	ETF	335.04	335.625	334.335	334.539	4772535.0
2023-05-23 14:00:00	QQQ	ETF	334.55	334.97	333.015	333.75	5647878.0
2023-05-23 15:00:00	QQQ	ETF	333.74	334.13	333.0	333.32	8216607.0
2023-05-23 16:00:00	QQQ	ETF	333.33	333.6	333.19	333.53	1191041.0
2023-05-23 17:00:00	QQQ	ETF	333.54	333.56	333.35	333.35	30820.0
2023-05-23 18:00:00	QQQ	ETF	333.45	333.8	333.45	333.77	47473.0
2023-05-23 19:00:00	QQQ	ETF	333.76	333.93	333.75	333.89	60719.0
2023-05-23 04:00:00	IWM	ETF	178.5	178.5	178.21	178.39	11329.0
2023-05-23 05:00:00	IWM	ETF	178.39	178.41	178.3	178.39	1904.0
2023-05-23 06:00:00	IWM	ETF	178.39	178.69	178.39	178.63	13588.0
2023-05-23 07:00:00	IWM	ETF	178.57	178.58	178.0	178.08	36485.0
2023-05-23 08:00:00	IWM	ETF	178.39	178.67	178.06	178.08	109693.0
2023-05-23 09:00:00	IWM	ETF	178.05	179.29	177.7	179.04	2976908.0
2023-05-23 10:00:00	IWM	ETF	179.05	180.42	179.05	179.97	5476272.0
2023-05-23 11:00:00	IWM	ETF	179.96	180.53	179.89	180.19	2928094.0
2023-05-23 12:00:00	IWM	ETF	180.2	180.2788	178.53	178.73	3407214.0
2023-05-23 13:00:00	IWM	ETF	178.73	179.26	178.25	178.72	2389167.0
2023-05-23 14:00:00	IWM	ETF	178.72	179.0	177.53	178.05	3049638.0
2023-05-23 15:00:00	IWM	ETF	178.04	178.09	177.38	177.45	4176219.0
2023-05-23 16:00:00	IWM	ETF	177.42	177.77	177.42	177.72	730965.0
2023-05-23 17:00:00	IWM	ETF	177.7	177.71	177.58	177.58	3488.0
2023-05-23 18:00:00	IWM	ETF	177.62	177.95	177.59	177.93	16101.0
2023-05-23 19:00:00	IWM	ETF	177.97	177.98	177.84	177.96	12939.0
2023-05-23 05:00:00	DIA	ETF	332.23	332.23	332.23	332.23	250.0
2023-05-23 07:00:00	DIA	ETF	332.4	332.56	332.11	332.11	4510.0

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

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