PREVIEW / etf_1hour / 2023-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-09.parquet
  size:    450 KB
  rows:    16,448

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-09 04:00:00	SPY	ETF	412.01	412.11	411.15	411.34	27214.0
2023-05-09 05:00:00	SPY	ETF	411.44	411.48	411.14	411.48	137174.0
2023-05-09 06:00:00	SPY	ETF	411.46	411.5	411.15	411.34	17896.0
2023-05-09 07:00:00	SPY	ETF	411.39	411.41	411.0	411.26	154095.0
2023-05-09 08:00:00	SPY	ETF	411.2994	412.44	411.0	411.2	263819.0
2023-05-09 09:00:00	SPY	ETF	411.2	411.675	410.6894	411.63	4969845.0
2023-05-09 10:00:00	SPY	ETF	411.635	411.84	410.84	411.37	5942251.0
2023-05-09 11:00:00	SPY	ETF	411.365	411.72	410.97	411.03	3736707.0
2023-05-09 12:00:00	SPY	ETF	411.0	411.39	410.81	411.355	3158691.0
2023-05-09 13:00:00	SPY	ETF	411.3501	411.92	411.2	411.84	3023955.0
2023-05-09 14:00:00	SPY	ETF	411.85	412.09	411.11	411.4699	4424880.0
2023-05-09 15:00:00	SPY	ETF	411.4699	411.8	410.81	410.96	9183788.0
2023-05-09 16:00:00	SPY	ETF	410.97	411.39	410.88	411.06	2534932.0
2023-05-09 17:00:00	SPY	ETF	411.02	411.08	410.8	411.07	292237.0
2023-05-09 18:00:00	SPY	ETF	410.95	411.27	410.85	411.23	69176.0
2023-05-09 19:00:00	SPY	ETF	411.2	411.41	411.14	411.35	35314.0
2023-05-09 04:00:00	QQQ	ETF	322.64	323.07	322.15	322.43	22614.0
2023-05-09 05:00:00	QQQ	ETF	322.48	322.53	322.1	322.49	27856.0
2023-05-09 06:00:00	QQQ	ETF	322.43	322.52	322.22	322.44	14720.0
2023-05-09 07:00:00	QQQ	ETF	322.47	322.51	321.88	322.13	101053.0
2023-05-09 08:00:00	QQQ	ETF	322.271	323.51	321.84	321.88	237364.0
2023-05-09 09:00:00	QQQ	ETF	321.87	322.74	321.73	322.695	4084221.0
2023-05-09 10:00:00	QQQ	ETF	322.695	322.88	321.87	322.3	3551699.0
2023-05-09 11:00:00	QQQ	ETF	322.29	322.4478	321.5	321.595	3134168.0
2023-05-09 12:00:00	QQQ	ETF	321.58	322.1541	321.405	322.1	2638887.0
2023-05-09 13:00:00	QQQ	ETF	322.1099	322.23	321.732	322.09	1924880.0
2023-05-09 14:00:00	QQQ	ETF	322.1	322.33	321.53	321.8309	2140428.0
2023-05-09 15:00:00	QQQ	ETF	321.84	321.97	321.32	321.59	6594698.0
2023-05-09 16:00:00	QQQ	ETF	321.62	321.76	321.48	321.5	959516.0
2023-05-09 17:00:00	QQQ	ETF	321.49	321.64	321.35	321.46	191804.0
2023-05-09 18:00:00	QQQ	ETF	321.45	321.77	321.33	321.77	48397.0
2023-05-09 19:00:00	QQQ	ETF	321.79	321.89	321.7	321.82	46267.0
2023-05-09 04:00:00	IWM	ETF	173.62	173.72	173.19	173.27	4990.0
2023-05-09 05:00:00	IWM	ETF	173.33	173.34	173.26	173.34	3800.0
2023-05-09 06:00:00	IWM	ETF	173.42	173.42	173.08	173.16	16448.0
2023-05-09 07:00:00	IWM	ETF	173.16	173.34	173.12	173.34	127110.0
2023-05-09 08:00:00	IWM	ETF	173.19	174.05	173.1199	173.24	131443.0
2023-05-09 09:00:00	IWM	ETF	173.19	173.33	172.255	172.94	2869830.0
2023-05-09 10:00:00	IWM	ETF	172.95	173.44	172.16	173.255	2698181.0
2023-05-09 11:00:00	IWM	ETF	173.26	173.55	173.03	173.145	1763120.0
2023-05-09 12:00:00	IWM	ETF	173.14	173.57	173.08	173.56	1263737.0
2023-05-09 13:00:00	IWM	ETF	173.55	174.125	173.28	174.07	1672376.0
2023-05-09 14:00:00	IWM	ETF	174.08	174.27	173.7	173.89	2007828.0
2023-05-09 15:00:00	IWM	ETF	173.89	174.145	173.5	173.51	3575970.0
2023-05-09 16:00:00	IWM	ETF	173.53	173.89	173.49	173.68	738885.0
2023-05-09 17:00:00	IWM	ETF	173.66	173.66	173.53	173.58	134126.0
2023-05-09 18:00:00	IWM	ETF	173.54	173.8	173.51	173.73	16164.0
2023-05-09 19:00:00	IWM	ETF	173.68	173.75	173.62	173.68	6650.0
2023-05-09 04:00:00	DIA	ETF	335.01	335.25	335.01	335.25	600.0
2023-05-09 05:00:00	DIA	ETF	335.13	335.15	335.13	335.15	406.0

> showing 50 of 16,448 rows — these rows as CSV

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