PREVIEW / etf_1hour / 2021-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-20.parquet
  size:    423 KB
  rows:    14,640

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-07-20 04:00:00	SPY	ETF	426.74	427.37	426.54	426.86	80002.0
2021-07-20 05:00:00	SPY	ETF	426.92	427.06	425.91	426.14	16947.0
2021-07-20 06:00:00	SPY	ETF	425.96	427.03	425.96	426.77	46840.0
2021-07-20 07:00:00	SPY	ETF	426.7	427.15	426.25	426.95	339475.0
2021-07-20 08:00:00	SPY	ETF	426.3801	427.2	425.4	426.15	1141115.0
2021-07-20 09:00:00	SPY	ETF	426.14	428.39	424.83	428.24	10682879.0
2021-07-20 10:00:00	SPY	ETF	428.25	430.27	427.95	430.23	12449807.0
2021-07-20 11:00:00	SPY	ETF	430.22	431.16	429.84	431.11	7847621.0
2021-07-20 12:00:00	SPY	ETF	431.12	432.02	430.85	431.99	7112571.0
2021-07-20 13:00:00	SPY	ETF	432.0	432.08	430.74	431.075	6498741.0
2021-07-20 14:00:00	SPY	ETF	431.0719	431.92	431.0719	431.5389	7468588.0
2021-07-20 15:00:00	SPY	ETF	431.54	432.42	431.03	431.03	20425842.0
2021-07-20 16:00:00	SPY	ETF	431.03	431.7105	430.95	431.5	3832034.0
2021-07-20 17:00:00	SPY	ETF	431.31	431.5	431.06	431.45	107772.0
2021-07-20 18:00:00	SPY	ETF	431.39	431.81	431.06	431.77	64686.0
2021-07-20 19:00:00	SPY	ETF	431.74	432.15	431.7	432.0	66789.0
2021-07-20 04:00:00	QQQ	ETF	355.92	356.4	355.76	356.18	134847.0
2021-07-20 05:00:00	QQQ	ETF	356.28	356.28	355.47	355.71	43077.0
2021-07-20 06:00:00	QQQ	ETF	355.72	356.36	355.6	356.33	76981.0
2021-07-20 07:00:00	QQQ	ETF	356.33	356.49	355.63	356.05	255462.0
2021-07-20 08:00:00	QQQ	ETF	356.05	356.93	355.6	355.92	273443.0
2021-07-20 09:00:00	QQQ	ETF	355.84	356.01	353.8	355.5009	5451805.0
2021-07-20 10:00:00	QQQ	ETF	355.51	357.32	354.54	357.13	5414687.0
2021-07-20 11:00:00	QQQ	ETF	357.1	358.4	356.81	358.35	3147418.0
2021-07-20 12:00:00	QQQ	ETF	358.362	359.37	358.3	359.33	2670201.0
2021-07-20 13:00:00	QQQ	ETF	359.34	359.355	358.36	358.85	3182377.0
2021-07-20 14:00:00	QQQ	ETF	358.86	359.9	358.802	359.54	2677331.0
2021-07-20 15:00:00	QQQ	ETF	359.56	360.28	358.73	358.74	5302151.0
2021-07-20 16:00:00	QQQ	ETF	358.72	359.02	358.0	358.89	1653950.0
2021-07-20 17:00:00	QQQ	ETF	359.05	359.05	358.71	358.82	59973.0
2021-07-20 18:00:00	QQQ	ETF	358.88	359.32	358.84	359.09	61448.0
2021-07-20 19:00:00	QQQ	ETF	359.13	359.5	359.08	359.34	42810.0
2021-07-20 04:00:00	IWM	ETF	214.31	214.67	213.68	213.9	74809.0
2021-07-20 05:00:00	IWM	ETF	213.84	213.84	212.85	212.92	31429.0
2021-07-20 06:00:00	IWM	ETF	212.9	213.82	212.76	213.17	20727.0
2021-07-20 07:00:00	IWM	ETF	213.25	213.81	212.94	213.69	126129.0
2021-07-20 08:00:00	IWM	ETF	212.9499	214.83	212.35	212.56	170438.0
2021-07-20 09:00:00	IWM	ETF	212.54	214.95	211.26	214.9101	5470381.0
2021-07-20 10:00:00	IWM	ETF	214.92	217.18	214.1018	217.1655	5889860.0
2021-07-20 11:00:00	IWM	ETF	217.17	217.97	216.755	217.88	2993466.0
2021-07-20 12:00:00	IWM	ETF	217.88	218.53	217.27	217.93	2844383.0
2021-07-20 13:00:00	IWM	ETF	217.93	218.005	216.99	217.745	2768872.0
2021-07-20 14:00:00	IWM	ETF	217.75	218.79	217.745	218.04	2496528.0
2021-07-20 15:00:00	IWM	ETF	218.05	219.27	217.86	218.22	5974293.0
2021-07-20 16:00:00	IWM	ETF	218.22	218.45	217.98	218.17	3761193.0
2021-07-20 17:00:00	IWM	ETF	218.02	218.3	218.02	218.09	98837.0
2021-07-20 18:00:00	IWM	ETF	218.15	218.65	218.0	218.6	76486.0
2021-07-20 19:00:00	IWM	ETF	218.64	219.05	218.6	218.97	112455.0
2021-07-20 04:00:00	DIA	ETF	341.83	342.28	341.7	341.7	15984.0
2021-07-20 05:00:00	DIA	ETF	341.65	341.65	340.9	340.9	900.0

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

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