PREVIEW / etf_1hour / 2022-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-25.parquet
  size:    459 KB
  rows:    16,817

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-02-25 04:00:00	SPY	ETF	423.47	425.77	422.82	425.19	72320.0
2022-02-25 05:00:00	SPY	ETF	424.86	426.35	424.74	425.47	40750.0
2022-02-25 06:00:00	SPY	ETF	425.54	426.61	423.72	425.4	119754.0
2022-02-25 07:00:00	SPY	ETF	425.29	429.61	425.09	429.17	1159300.0
2022-02-25 08:00:00	SPY	ETF	425.3001	431.5	423.09	430.18	1702663.0
2022-02-25 09:00:00	SPY	ETF	430.12	431.26	428.26	428.52	10022984.0
2022-02-25 10:00:00	SPY	ETF	428.49	433.98	427.86	433.27	13989641.0
2022-02-25 11:00:00	SPY	ETF	433.25	436.84	432.45	436.72	13350965.0
2022-02-25 12:00:00	SPY	ETF	436.74	437.3	435.35	435.8081	10330306.0
2022-02-25 13:00:00	SPY	ETF	435.8	437.73	434.83	436.6	10675964.0
2022-02-25 14:00:00	SPY	ETF	436.62	437.54	435.01	436.0605	9758117.0
2022-02-25 15:00:00	SPY	ETF	436.07	437.84	435.11	437.68	20861944.0
2022-02-25 16:00:00	SPY	ETF	437.67	438.05	437.41	437.78	4561645.0
2022-02-25 17:00:00	SPY	ETF	437.86	438.4	437.7	438.06	145215.0
2022-02-25 18:00:00	SPY	ETF	438.15	438.15	437.85	438.0	53425.0
2022-02-25 19:00:00	SPY	ETF	438.03	438.03	437.63	437.7	45417.0
2022-02-25 04:00:00	QQQ	ETF	337.89	338.67	335.84	338.28	90761.0
2022-02-25 05:00:00	QQQ	ETF	338.27	339.54	338.0	339.14	85971.0
2022-02-25 06:00:00	QQQ	ETF	339.22	340.0	337.47	338.88	200104.0
2022-02-25 07:00:00	QQQ	ETF	338.79	342.03	338.73	341.61	505099.0
2022-02-25 08:00:00	QQQ	ETF	339.8399	344.06	336.0296	342.47	1448909.0
2022-02-25 09:00:00	QQQ	ETF	342.41	342.58	338.05	338.28	10235092.0
2022-02-25 10:00:00	QQQ	ETF	338.3	343.63	337.39	342.87	10982057.0
2022-02-25 11:00:00	QQQ	ETF	342.84	345.45	341.97	345.4029	8350543.0
2022-02-25 12:00:00	QQQ	ETF	345.44	345.74	342.785	343.39	5760366.0
2022-02-25 13:00:00	QQQ	ETF	343.4	345.08	342.36	344.15	6109084.0
2022-02-25 14:00:00	QQQ	ETF	344.16	345.22	342.96	344.09	6236055.0
2022-02-25 15:00:00	QQQ	ETF	344.025	345.98	343.23	345.87	9739374.0
2022-02-25 16:00:00	QQQ	ETF	345.88	346.22	345.7	345.97	1644720.0
2022-02-25 17:00:00	QQQ	ETF	345.88	346.33	345.88	346.15	120546.0
2022-02-25 18:00:00	QQQ	ETF	346.22	346.22	345.8	345.8	28297.0
2022-02-25 19:00:00	QQQ	ETF	345.83	345.93	345.6	345.77	25326.0
2022-02-25 04:00:00	IWM	ETF	195.73	196.81	195.44	196.7	25199.0
2022-02-25 05:00:00	IWM	ETF	196.43	197.35	196.43	196.88	13746.0
2022-02-25 06:00:00	IWM	ETF	196.99	197.3	196.15	196.86	81798.0
2022-02-25 07:00:00	IWM	ETF	196.92	199.44	196.84	198.95	147766.0
2022-02-25 08:00:00	IWM	ETF	198.97	199.99	195.7096	199.25	534954.0
2022-02-25 09:00:00	IWM	ETF	199.18	199.71	197.59	197.7	4354299.0
2022-02-25 10:00:00	IWM	ETF	197.71	200.16	197.0	199.7	3840875.0
2022-02-25 11:00:00	IWM	ETF	199.67	201.22	199.22	201.2	2568907.0
2022-02-25 12:00:00	IWM	ETF	201.22	201.74	200.62	201.11	2440834.0
2022-02-25 13:00:00	IWM	ETF	201.12	202.07	200.54	201.62	2068473.0
2022-02-25 14:00:00	IWM	ETF	201.65	201.93	200.87	201.45	2432007.0
2022-02-25 15:00:00	IWM	ETF	201.44	202.62	201.08	202.61	4816604.0
2022-02-25 16:00:00	IWM	ETF	202.62	202.73	202.4	202.61	1339030.0
2022-02-25 17:00:00	IWM	ETF	202.55	202.82	202.51	202.6	10361.0
2022-02-25 18:00:00	IWM	ETF	202.6	202.63	202.37	202.37	6342.0
2022-02-25 19:00:00	IWM	ETF	202.37	202.6	202.32	202.6	6960.0
2022-02-25 04:00:00	DIA	ETF	329.07	330.13	328.84	330.12	1424.0
2022-02-25 05:00:00	DIA	ETF	329.88	330.54	329.88	330.15	2100.0

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

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