PREVIEW / etf_1hour / 2022-03-18

all etf 1-hour files

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

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-18 04:00:00	SPY	ETF	438.0	438.05	436.57	437.08	33735.0
2022-03-18 05:00:00	SPY	ETF	437.2	437.23	436.25	437.06	46751.0
2022-03-18 06:00:00	SPY	ETF	436.92	437.29	436.05	436.51	52819.0
2022-03-18 07:00:00	SPY	ETF	436.57	436.83	435.71	436.139	372742.0
2022-03-18 08:00:00	SPY	ETF	436.201	438.3	435.76	436.66	680237.0
2022-03-18 09:00:00	SPY	ETF	436.66	440.8241	436.23	439.0401	7724907.0
2022-03-18 10:00:00	SPY	ETF	439.07	440.89	438.43	439.5	9334620.0
2022-03-18 11:00:00	SPY	ETF	439.51	440.97	439.15	439.9417	7578181.0
2022-03-18 12:00:00	SPY	ETF	439.96	441.72	439.5328	441.4214	5931549.0
2022-03-18 13:00:00	SPY	ETF	441.44	442.52	441.21	442.035	5323069.0
2022-03-18 14:00:00	SPY	ETF	442.04	442.69	441.48	442.5524	6289254.0
2022-03-18 15:00:00	SPY	ETF	442.55	444.86	442.34	444.47	19284789.0
2022-03-18 16:00:00	SPY	ETF	444.47	445.66	444.0	445.6	5992987.0
2022-03-18 17:00:00	SPY	ETF	445.6	445.67	444.52	445.22	969023.0
2022-03-18 18:00:00	SPY	ETF	445.22	445.5	445.2	445.3	59188.0
2022-03-18 19:00:00	SPY	ETF	445.38	445.49	444.6	445.49	33205.0
2022-03-18 04:00:00	QQQ	ETF	342.58	342.72	341.56	342.2	119262.0
2022-03-18 05:00:00	QQQ	ETF	342.18	342.4	341.47	342.2	58256.0
2022-03-18 06:00:00	QQQ	ETF	342.12	342.39	341.4	341.72	74451.0
2022-03-18 07:00:00	QQQ	ETF	341.75	341.76	341.0	341.33	234593.0
2022-03-18 08:00:00	QQQ	ETF	341.52	344.18	341.0	341.65	532316.0
2022-03-18 09:00:00	QQQ	ETF	341.57	345.24	341.34	345.21	6991123.0
2022-03-18 10:00:00	QQQ	ETF	345.28	347.49	344.895	346.56	10089131.0
2022-03-18 11:00:00	QQQ	ETF	346.58	348.24	346.38	347.36	6638888.0
2022-03-18 12:00:00	QQQ	ETF	347.39	349.07	346.98	348.72	4490871.0
2022-03-18 13:00:00	QQQ	ETF	348.745	349.4	348.39	348.9799	4444276.0
2022-03-18 14:00:00	QQQ	ETF	348.99	349.72	348.44	349.66	3999036.0
2022-03-18 15:00:00	QQQ	ETF	349.66	351.79	349.39	351.49	14030549.0
2022-03-18 16:00:00	QQQ	ETF	351.47	352.19	351.16	352.0	4876771.0
2022-03-18 17:00:00	QQQ	ETF	352.08	352.1	351.49	352.05	618988.0
2022-03-18 18:00:00	QQQ	ETF	352.05	352.1	351.9	352.0	27917.0
2022-03-18 19:00:00	QQQ	ETF	352.05	352.5	351.86	352.5	46944.0
2022-03-18 04:00:00	IWM	ETF	204.61	204.62	203.9	204.18	38592.0
2022-03-18 05:00:00	IWM	ETF	204.22	204.22	203.77	204.1	50441.0
2022-03-18 06:00:00	IWM	ETF	204.0	204.17	203.55	203.55	27716.0
2022-03-18 07:00:00	IWM	ETF	203.66	203.85	203.31	203.48	86798.0
2022-03-18 08:00:00	IWM	ETF	203.6601	204.14	203.38	203.76	51616.0
2022-03-18 09:00:00	IWM	ETF	203.69	205.29	203.43	205.25	2476782.0
2022-03-18 10:00:00	IWM	ETF	205.26	206.47	204.83	205.26	3235219.0
2022-03-18 11:00:00	IWM	ETF	205.26	205.41	204.42	204.73	2691640.0
2022-03-18 12:00:00	IWM	ETF	204.73	206.21	204.54	206.13	1840279.0
2022-03-18 13:00:00	IWM	ETF	206.13	206.7996	206.05	206.57	1562266.0
2022-03-18 14:00:00	IWM	ETF	206.58	206.69	206.27	206.425	1577594.0
2022-03-18 15:00:00	IWM	ETF	206.43	207.45	206.42	207.06	5350341.0
2022-03-18 16:00:00	IWM	ETF	207.27	207.76	207.03	207.76	5186658.0
2022-03-18 17:00:00	IWM	ETF	207.74	207.75	207.27	207.5	428252.0
2022-03-18 18:00:00	IWM	ETF	207.45	207.55	207.3	207.31	22551.0
2022-03-18 19:00:00	IWM	ETF	207.32	207.4	207.12	207.39	35650.0
2022-03-18 04:00:00	DIA	ETF	343.31	343.31	342.6	342.66	1552.0
2022-03-18 05:00:00	DIA	ETF	342.88	343.04	342.64	343.01	2000.0

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

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