PREVIEW / etf_1hour / 2021-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-17.parquet
  size:    423 KB
  rows:    14,786

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-08-17 04:00:00	SPY	ETF	445.51	445.51	444.89	445.07	82566.0
2021-08-17 05:00:00	SPY	ETF	445.15	445.5	445.0	445.17	21058.0
2021-08-17 06:00:00	SPY	ETF	444.95	445.18	444.83	444.99	85676.0
2021-08-17 07:00:00	SPY	ETF	445.12	445.15	444.6	445.08	288616.0
2021-08-17 08:00:00	SPY	ETF	445.08	447.305	444.43	445.04	322305.0
2021-08-17 09:00:00	SPY	ETF	445.07	445.07	443.27	443.66	9733068.0
2021-08-17 10:00:00	SPY	ETF	443.67	444.96	443.38	444.37	10936754.0
2021-08-17 11:00:00	SPY	ETF	444.369	444.52	443.0099	443.0599	7357148.0
2021-08-17 12:00:00	SPY	ETF	443.06	443.28	440.89	441.02	10709936.0
2021-08-17 13:00:00	SPY	ETF	440.99	442.19	440.85	442.09	9538304.0
2021-08-17 14:00:00	SPY	ETF	442.08	443.16	441.7614	443.065	7356349.0
2021-08-17 15:00:00	SPY	ETF	443.065	444.07	442.7401	444.06	14191437.0
2021-08-17 16:00:00	SPY	ETF	444.05	444.14	442.81	443.38	3143314.0
2021-08-17 17:00:00	SPY	ETF	443.38	443.5	443.26	443.34	82322.0
2021-08-17 18:00:00	SPY	ETF	443.33	443.51	443.14	443.33	147258.0
2021-08-17 19:00:00	SPY	ETF	443.34	443.47	443.0	443.0	99594.0
2021-08-17 04:00:00	QQQ	ETF	367.68	368.0	367.46	367.67	28600.0
2021-08-17 05:00:00	QQQ	ETF	367.69	367.92	367.35	367.53	21984.0
2021-08-17 06:00:00	QQQ	ETF	367.49	367.82	367.44	367.78	36030.0
2021-08-17 07:00:00	QQQ	ETF	367.71	367.78	367.37	367.648	170494.0
2021-08-17 08:00:00	QQQ	ETF	367.61	369.256	366.501	366.9	359106.0
2021-08-17 09:00:00	QQQ	ETF	366.77	366.8	364.66	365.18	6389789.0
2021-08-17 10:00:00	QQQ	ETF	365.17	367.15	364.51	366.38	5996604.0
2021-08-17 11:00:00	QQQ	ETF	366.4	366.4598	364.225	364.29	4383775.0
2021-08-17 12:00:00	QQQ	ETF	364.285	365.13	363.26	363.4	4870803.0
2021-08-17 13:00:00	QQQ	ETF	363.39	364.6	363.23	364.28	3238252.0
2021-08-17 14:00:00	QQQ	ETF	364.27	365.31	364.12	365.22	3161997.0
2021-08-17 15:00:00	QQQ	ETF	365.21	365.75	364.62	365.705	5824481.0
2021-08-17 16:00:00	QQQ	ETF	365.72	365.77	364.8	364.94	882769.0
2021-08-17 17:00:00	QQQ	ETF	364.75	365.73	364.75	364.98	24759.0
2021-08-17 18:00:00	QQQ	ETF	364.95	365.13	364.75	364.89	12571.0
2021-08-17 19:00:00	QQQ	ETF	364.92	364.96	364.62	364.66	21427.0
2021-08-17 04:00:00	IWM	ETF	217.82	217.82	216.32	216.59	10420.0
2021-08-17 05:00:00	IWM	ETF	216.61	217.07	216.45	216.48	5646.0
2021-08-17 06:00:00	IWM	ETF	216.43	216.61	216.21	216.35	23495.0
2021-08-17 07:00:00	IWM	ETF	216.4	216.83	215.9	216.72	111810.0
2021-08-17 08:00:00	IWM	ETF	216.0201	218.45	216.02	217.19	218907.0
2021-08-17 09:00:00	IWM	ETF	217.17	217.44	215.64	215.84	4392323.0
2021-08-17 10:00:00	IWM	ETF	215.83	217.41	215.65	216.27	3732865.0
2021-08-17 11:00:00	IWM	ETF	216.26	217.1	214.99	215.45	3886641.0
2021-08-17 12:00:00	IWM	ETF	215.455	215.58	213.75	213.8	4972273.0
2021-08-17 13:00:00	IWM	ETF	213.79	215.48	213.75	215.32	3731937.0
2021-08-17 14:00:00	IWM	ETF	215.32	216.29	214.8	216.22	3097576.0
2021-08-17 15:00:00	IWM	ETF	216.22	216.61	215.74	216.39	5059606.0
2021-08-17 16:00:00	IWM	ETF	216.4	216.47	215.85	216.27	743104.0
2021-08-17 17:00:00	IWM	ETF	216.25	216.4	216.15	216.15	224761.0
2021-08-17 18:00:00	IWM	ETF	216.15	216.4	215.84	215.99	77032.0
2021-08-17 19:00:00	IWM	ETF	216.11	216.18	215.78	215.78	17665.0
2021-08-17 04:00:00	DIA	ETF	355.68	355.68	354.87	354.87	3917.0
2021-08-17 05:00:00	DIA	ETF	355.14	355.3	355.14	355.3	900.0

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

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