PREVIEW / etf_1hour / 2022-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-18.parquet
  size:    461 KB
  rows:    16,734

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
2022-04-18 04:00:00	SPY	ETF	436.18	436.51	435.83	436.18	25846.0
2022-04-18 05:00:00	SPY	ETF	436.11	436.12	435.32	435.67	14858.0
2022-04-18 06:00:00	SPY	ETF	435.64	436.27	435.64	436.15	26790.0
2022-04-18 07:00:00	SPY	ETF	436.05	437.36	436.05	436.64	144659.0
2022-04-18 08:00:00	SPY	ETF	436.33	437.35	435.57	436.57	340087.0
2022-04-18 09:00:00	SPY	ETF	436.55	439.46	436.43	437.76	6482235.0
2022-04-18 10:00:00	SPY	ETF	437.76	439.5	437.085	438.57	6384837.0
2022-04-18 11:00:00	SPY	ETF	438.58	438.97	436.21	437.16	4910027.0
2022-04-18 12:00:00	SPY	ETF	437.17	437.22	435.61	436.56	3955186.0
2022-04-18 13:00:00	SPY	ETF	436.55	439.74	436.385	439.15	5886996.0
2022-04-18 14:00:00	SPY	ETF	439.14	439.75	438.28	438.37	5485559.0
2022-04-18 15:00:00	SPY	ETF	438.38	438.56	435.63	437.99	12086049.0
2022-04-18 16:00:00	SPY	ETF	437.99	439.53	437.8357	439.03	4758162.0
2022-04-18 17:00:00	SPY	ETF	439.02	439.25	439.0	439.15	128081.0
2022-04-18 18:00:00	SPY	ETF	439.14	439.52	437.97	439.21	154408.0
2022-04-18 19:00:00	SPY	ETF	439.21	440.21	439.01	440.12	82534.0
2022-04-18 04:00:00	QQQ	ETF	336.36	337.01	335.87	336.5	62199.0
2022-04-18 05:00:00	QQQ	ETF	336.49	336.49	335.68	335.98	113572.0
2022-04-18 06:00:00	QQQ	ETF	336.1	336.7	336.07	336.56	67746.0
2022-04-18 07:00:00	QQQ	ETF	336.54	337.79	336.54	337.05	246005.0
2022-04-18 08:00:00	QQQ	ETF	336.71	337.78	335.3	337.24	475439.0
2022-04-18 09:00:00	QQQ	ETF	337.23	339.35	336.8	337.7605	7878633.0
2022-04-18 10:00:00	QQQ	ETF	337.74	341.04	337.01	339.53	6869970.0
2022-04-18 11:00:00	QQQ	ETF	339.53	340.0973	337.04	337.93	4613579.0
2022-04-18 12:00:00	QQQ	ETF	337.9412	338.0	335.791	336.55	4812536.0
2022-04-18 13:00:00	QQQ	ETF	336.54	340.44	336.29	339.89	5323002.0
2022-04-18 14:00:00	QQQ	ETF	339.9	340.87	339.22	339.3283	5934717.0
2022-04-18 15:00:00	QQQ	ETF	339.32	339.58	336.72	338.96	7521905.0
2022-04-18 16:00:00	QQQ	ETF	338.97	340.71	337.7	340.11	2091343.0
2022-04-18 17:00:00	QQQ	ETF	340.09	340.42	338.69	340.34	173530.0
2022-04-18 18:00:00	QQQ	ETF	340.18	340.68	340.08	340.34	97436.0
2022-04-18 19:00:00	QQQ	ETF	340.4	341.45	340.18	341.4	151002.0
2022-04-18 04:00:00	IWM	ETF	198.0	198.13	197.89	198.02	25872.0
2022-04-18 05:00:00	IWM	ETF	197.83	197.91	197.48	197.74	13569.0
2022-04-18 06:00:00	IWM	ETF	197.78	198.1	197.72	198.03	17753.0
2022-04-18 07:00:00	IWM	ETF	198.11	198.57	198.11	198.29	41867.0
2022-04-18 08:00:00	IWM	ETF	198.2301	198.7	198.2301	198.37	148811.0
2022-04-18 09:00:00	IWM	ETF	198.38	199.18	197.54	198.095	2549221.0
2022-04-18 10:00:00	IWM	ETF	198.08	198.59	197.62	198.08	2723738.0
2022-04-18 11:00:00	IWM	ETF	198.08	198.5	196.77	197.24	2066617.0
2022-04-18 12:00:00	IWM	ETF	197.24	197.36	196.64	197.31	1429380.0
2022-04-18 13:00:00	IWM	ETF	197.3	198.84	197.22	198.69	1788888.0
2022-04-18 14:00:00	IWM	ETF	198.7	198.75	197.96	197.98	1738065.0
2022-04-18 15:00:00	IWM	ETF	197.97	198.13	196.53	197.62	4209062.0
2022-04-18 16:00:00	IWM	ETF	197.62	198.4	196.7	198.1801	850084.0
2022-04-18 17:00:00	IWM	ETF	198.0	198.44	197.62	198.17	35663.0
2022-04-18 18:00:00	IWM	ETF	198.3	198.37	198.08	198.24	27191.0
2022-04-18 19:00:00	IWM	ETF	198.23	198.73	198.08	198.6	25567.0
2022-04-18 04:00:00	DIA	ETF	343.63	343.75	343.63	343.75	589.0
2022-04-18 06:00:00	DIA	ETF	343.58	343.58	343.58	343.58	100.0

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

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