PREVIEW / etf_1hour / 2022-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-03.parquet
  size:    453 KB
  rows:    16,350

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-03-03 04:00:00	SPY	ETF	437.89	438.02	436.98	437.35	85194.0
2022-03-03 05:00:00	SPY	ETF	437.39	437.56	436.64	437.01	57651.0
2022-03-03 06:00:00	SPY	ETF	436.9	437.87	436.52	436.9	65487.0
2022-03-03 07:00:00	SPY	ETF	436.9	438.04	436.85	437.55	214931.0
2022-03-03 08:00:00	SPY	ETF	437.57	440.59	436.5496	440.55	972939.0
2022-03-03 09:00:00	SPY	ETF	440.54	441.54	438.95	439.7	9608344.0
2022-03-03 10:00:00	SPY	ETF	439.69	440.31	434.85	434.91	13138320.0
2022-03-03 11:00:00	SPY	ETF	434.9	436.86	433.84	436.3	12185819.0
2022-03-03 12:00:00	SPY	ETF	436.3	439.25	435.39	437.83	12084185.0
2022-03-03 13:00:00	SPY	ETF	437.79	439.01	437.34	438.0201	6308224.0
2022-03-03 14:00:00	SPY	ETF	437.98	439.27	435.87	436.2701	7344382.0
2022-03-03 15:00:00	SPY	ETF	436.26	436.5	433.8	435.72	18903949.0
2022-03-03 16:00:00	SPY	ETF	435.73	436.29	435.32	436.25	3925021.0
2022-03-03 17:00:00	SPY	ETF	436.25	436.44	435.71	436.44	73589.0
2022-03-03 18:00:00	SPY	ETF	436.41	437.01	436.08	436.9	135650.0
2022-03-03 19:00:00	SPY	ETF	436.93	437.1	428.1	429.21	1233888.0
2022-03-03 04:00:00	QQQ	ETF	346.53	346.71	345.38	346.34	52277.0
2022-03-03 05:00:00	QQQ	ETF	346.35	346.39	345.65	346.02	44101.0
2022-03-03 06:00:00	QQQ	ETF	345.8	346.82	345.65	345.96	84247.0
2022-03-03 07:00:00	QQQ	ETF	345.95	346.94	345.92	346.4	204659.0
2022-03-03 08:00:00	QQQ	ETF	346.39	349.65	345.75	349.46	718175.0
2022-03-03 09:00:00	QQQ	ETF	349.47	350.93	347.14	347.8372	7221444.0
2022-03-03 10:00:00	QQQ	ETF	347.83	348.4401	342.66	342.7	9487752.0
2022-03-03 11:00:00	QQQ	ETF	342.7	344.76	342.2	344.2304	7561075.0
2022-03-03 12:00:00	QQQ	ETF	344.26	346.65	342.58	344.92	8648336.0
2022-03-03 13:00:00	QQQ	ETF	344.88	346.1817	344.05	344.57	4644505.0
2022-03-03 14:00:00	QQQ	ETF	344.54	345.65	342.43	342.8057	4978103.0
2022-03-03 15:00:00	QQQ	ETF	342.77	342.77	340.35	342.26	11476170.0
2022-03-03 16:00:00	QQQ	ETF	342.26	342.96	342.12	342.9	1696415.0
2022-03-03 17:00:00	QQQ	ETF	342.79	343.0	342.26	342.89	294375.0
2022-03-03 18:00:00	QQQ	ETF	342.89	343.45	342.64	343.38	143752.0
2022-03-03 19:00:00	QQQ	ETF	343.45	343.45	335.9	336.73	1120914.0
2022-03-03 04:00:00	IWM	ETF	204.24	204.34	203.62	203.85	17699.0
2022-03-03 05:00:00	IWM	ETF	203.82	203.87	203.28	203.86	7813.0
2022-03-03 06:00:00	IWM	ETF	203.79	204.23	203.4	203.65	32167.0
2022-03-03 07:00:00	IWM	ETF	203.82	204.48	203.79	204.01	59485.0
2022-03-03 08:00:00	IWM	ETF	204.35	205.54	203.3604	205.36	175180.0
2022-03-03 09:00:00	IWM	ETF	205.34	205.81	202.75	203.09	3436161.0
2022-03-03 10:00:00	IWM	ETF	203.105	203.45	200.815	200.83	3638165.0
2022-03-03 11:00:00	IWM	ETF	200.82	202.3	200.63	202.02	3395746.0
2022-03-03 12:00:00	IWM	ETF	201.99	203.27	201.27	202.36	3004511.0
2022-03-03 13:00:00	IWM	ETF	202.35	203.01	202.04	202.27	1528895.0
2022-03-03 14:00:00	IWM	ETF	202.24	202.69	200.96	201.12	1764339.0
2022-03-03 15:00:00	IWM	ETF	201.105	201.89	200.29	201.79	4263746.0
2022-03-03 16:00:00	IWM	ETF	201.82	202.25	201.65	201.93	1690461.0
2022-03-03 17:00:00	IWM	ETF	201.82	202.07	201.82	201.88	64637.0
2022-03-03 18:00:00	IWM	ETF	201.93	202.35	201.9	202.29	16407.0
2022-03-03 19:00:00	IWM	ETF	202.32	202.34	198.25	198.6	299126.0
2022-03-03 04:00:00	DIA	ETF	339.0	339.0	338.99	338.99	2800.0
2022-03-03 05:00:00	DIA	ETF	338.74	338.74	338.74	338.74	300.0

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

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