PREVIEW / etf_1hour / 2021-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-26.parquet
  size:    402 KB
  rows:    14,111

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
2021-05-26 04:00:00	SPY	ETF	419.33	419.65	419.25	419.25	14458.0
2021-05-26 05:00:00	SPY	ETF	419.33	420.02	419.33	419.4	7520.0
2021-05-26 06:00:00	SPY	ETF	419.4	419.5	419.33	419.45	6295.0
2021-05-26 07:00:00	SPY	ETF	419.43	420.0	419.33	419.39	109412.0
2021-05-26 08:00:00	SPY	ETF	419.4296	419.97	419.0	419.19	203776.0
2021-05-26 09:00:00	SPY	ETF	419.28	419.32	417.81	417.9	4026842.0
2021-05-26 10:00:00	SPY	ETF	417.91	418.96	417.76	418.9099	4808031.0
2021-05-26 11:00:00	SPY	ETF	418.91	419.35	418.69	419.26	3990901.0
2021-05-26 12:00:00	SPY	ETF	419.26	419.49	419.1701	419.3819	2447520.0
2021-05-26 13:00:00	SPY	ETF	419.38	419.61	418.44	418.69	4176310.0
2021-05-26 14:00:00	SPY	ETF	418.7	419.18	418.64	418.84	3231155.0
2021-05-26 15:00:00	SPY	ETF	418.84	419.18	418.56	419.0499	10573965.0
2021-05-26 16:00:00	SPY	ETF	419.04	419.12	418.6533	419.08	1948172.0
2021-05-26 17:00:00	SPY	ETF	419.04	419.1	418.98	419.05	98728.0
2021-05-26 18:00:00	SPY	ETF	419.04	419.32	418.98	418.98	67205.0
2021-05-26 19:00:00	SPY	ETF	418.97	419.0	418.76	419.0	49268.0
2021-05-26 04:00:00	QQQ	ETF	333.91	334.13	333.67	333.75	23177.0
2021-05-26 05:00:00	QQQ	ETF	333.66	334.35	333.66	333.79	23244.0
2021-05-26 06:00:00	QQQ	ETF	333.79	334.07	333.76	334.06	12925.0
2021-05-26 07:00:00	QQQ	ETF	334.05	334.69	333.97	334.33	100357.0
2021-05-26 08:00:00	QQQ	ETF	334.0596	334.61	333.5	334.01	202283.0
2021-05-26 09:00:00	QQQ	ETF	334.06	334.221	333.12	333.3299	2897936.0
2021-05-26 10:00:00	QQQ	ETF	333.36	334.325	332.95	334.19	2915829.0
2021-05-26 11:00:00	QQQ	ETF	334.2	334.45	333.5206	334.34	2428832.0
2021-05-26 12:00:00	QQQ	ETF	334.34	334.61	334.2	334.2982	1670114.0
2021-05-26 13:00:00	QQQ	ETF	334.28	334.605	333.43	333.685	2533702.0
2021-05-26 14:00:00	QQQ	ETF	333.69	334.285	333.61	334.07	1949903.0
2021-05-26 15:00:00	QQQ	ETF	334.08	334.24	333.48	334.05	4985889.0
2021-05-26 16:00:00	QQQ	ETF	334.05	334.22	333.7	334.14	899335.0
2021-05-26 17:00:00	QQQ	ETF	334.06	334.22	334.02	334.1	16812.0
2021-05-26 18:00:00	QQQ	ETF	334.05	334.4	334.03	334.18	57295.0
2021-05-26 19:00:00	QQQ	ETF	334.08	334.22	333.89	334.22	66778.0
2021-05-26 04:00:00	IWM	ETF	220.36	220.37	220.21	220.21	7100.0
2021-05-26 05:00:00	IWM	ETF	220.36	220.52	220.33	220.33	2200.0
2021-05-26 06:00:00	IWM	ETF	220.2	220.44	220.2	220.44	49019.0
2021-05-26 07:00:00	IWM	ETF	220.34	220.54	220.13	220.24	46311.0
2021-05-26 08:00:00	IWM	ETF	220.28	220.44	220.141	220.28	63581.0
2021-05-26 09:00:00	IWM	ETF	220.29	221.55	220.04	220.79	2452438.0
2021-05-26 10:00:00	IWM	ETF	220.78	222.3	220.48	222.1501	3173236.0
2021-05-26 11:00:00	IWM	ETF	222.16	222.78	221.83	222.6465	1555393.0
2021-05-26 12:00:00	IWM	ETF	222.65	222.95	222.435	222.55	1193926.0
2021-05-26 13:00:00	IWM	ETF	222.54	223.156	222.37	222.7997	1683642.0
2021-05-26 14:00:00	IWM	ETF	222.81	223.58	222.7589	223.56	2246983.0
2021-05-26 15:00:00	IWM	ETF	223.56	223.69	223.175	223.45	3280354.0
2021-05-26 16:00:00	IWM	ETF	223.35	223.6	223.34	223.51	930848.0
2021-05-26 17:00:00	IWM	ETF	223.52	223.58	223.49	223.57	5283.0
2021-05-26 18:00:00	IWM	ETF	223.58	223.92	223.49	223.5	31758.0
2021-05-26 19:00:00	IWM	ETF	223.49	223.67	223.47	223.67	39024.0
2021-05-26 04:00:00	DIA	ETF	343.91	344.11	343.91	344.11	600.0
2021-05-26 05:00:00	DIA	ETF	344.15	344.52	344.15	344.52	300.0

> showing 50 of 14,111 rows — these rows as CSV

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