PREVIEW / etf_1hour / 2021-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-30.parquet
  size:    433 KB
  rows:    15,242

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-09-30 04:00:00	SPY	ETF	437.02	438.0	437.02	437.48	87335.0
2021-09-30 05:00:00	SPY	ETF	437.41	437.58	436.38	436.5	16124.0
2021-09-30 06:00:00	SPY	ETF	436.47	436.79	435.8	436.05	114185.0
2021-09-30 07:00:00	SPY	ETF	436.0	436.45	435.54	435.92	192946.0
2021-09-30 08:00:00	SPY	ETF	435.8001	437.75	435.58	435.84	481404.0
2021-09-30 09:00:00	SPY	ETF	435.88	436.77	435.16	435.84	7152163.0
2021-09-30 10:00:00	SPY	ETF	435.82	436.11	433.38	433.73	11835957.0
2021-09-30 11:00:00	SPY	ETF	433.73	435.13	431.52	432.2699	10851098.0
2021-09-30 12:00:00	SPY	ETF	432.27	432.47	430.0	430.855	14326801.0
2021-09-30 13:00:00	SPY	ETF	430.85	432.26	430.42	431.89	10155717.0
2021-09-30 14:00:00	SPY	ETF	431.87	433.86	431.8	432.38	10817931.0
2021-09-30 15:00:00	SPY	ETF	432.4	433.6	428.78	429.16	32337119.0
2021-09-30 16:00:00	SPY	ETF	429.16	430.04	429.01	429.38	9842703.0
2021-09-30 17:00:00	SPY	ETF	429.32	429.58	429.31	429.47	149755.0
2021-09-30 18:00:00	SPY	ETF	429.47	429.99	429.14	429.85	257507.0
2021-09-30 19:00:00	SPY	ETF	429.88	430.34	429.14	430.05	141566.0
2021-09-30 04:00:00	QQQ	ETF	361.3	362.51	361.3	361.84	49242.0
2021-09-30 05:00:00	QQQ	ETF	361.9	361.92	360.84	361.03	48755.0
2021-09-30 06:00:00	QQQ	ETF	361.06	361.35	360.4	360.95	51505.0
2021-09-30 07:00:00	QQQ	ETF	360.77	361.3	360.5	360.9	115125.0
2021-09-30 08:00:00	QQQ	ETF	360.5599	362.72	360.54	360.92	281266.0
2021-09-30 09:00:00	QQQ	ETF	360.89	362.68	360.21	361.81	6153145.0
2021-09-30 10:00:00	QQQ	ETF	361.78	362.42	360.11	360.41	7632284.0
2021-09-30 11:00:00	QQQ	ETF	360.41	361.76	358.76	359.57	6634513.0
2021-09-30 12:00:00	QQQ	ETF	359.61	359.7	357.1	358.8055	6817741.0
2021-09-30 13:00:00	QQQ	ETF	358.8	360.09	358.52	359.84	4675084.0
2021-09-30 14:00:00	QQQ	ETF	359.83	361.48	359.77	360.21	6684369.0
2021-09-30 15:00:00	QQQ	ETF	360.23	361.3	357.57	357.73	10722040.0
2021-09-30 16:00:00	QQQ	ETF	357.74	360.5591	357.66	358.12	2410631.0
2021-09-30 17:00:00	QQQ	ETF	358.09	358.3	357.95	358.3	67109.0
2021-09-30 18:00:00	QQQ	ETF	358.35	358.57	357.96	358.48	192791.0
2021-09-30 19:00:00	QQQ	ETF	358.48	358.87	358.4	358.69	80774.0
2021-09-30 04:00:00	IWM	ETF	222.67	223.76	222.67	223.34	24875.0
2021-09-30 05:00:00	IWM	ETF	223.31	223.31	222.53	222.53	7686.0
2021-09-30 06:00:00	IWM	ETF	222.64	222.84	222.15	222.57	16181.0
2021-09-30 07:00:00	IWM	ETF	222.51	222.85	222.18	222.41	60158.0
2021-09-30 08:00:00	IWM	ETF	222.34	223.71	221.99	221.99	156475.0
2021-09-30 09:00:00	IWM	ETF	222.03	222.61	220.95	221.65	2915968.0
2021-09-30 10:00:00	IWM	ETF	221.63	221.79	220.19	220.26	3309149.0
2021-09-30 11:00:00	IWM	ETF	220.25	221.6	219.75	220.08	2773903.0
2021-09-30 12:00:00	IWM	ETF	220.095	220.25	218.69	219.55	3874321.0
2021-09-30 13:00:00	IWM	ETF	219.58	220.49	219.21	220.2	2464266.0
2021-09-30 14:00:00	IWM	ETF	220.2	221.05	219.96	220.32	2517514.0
2021-09-30 15:00:00	IWM	ETF	220.33	221.01	218.6	218.72	5836189.0
2021-09-30 16:00:00	IWM	ETF	218.72	219.33	218.42	218.71	2501981.0
2021-09-30 17:00:00	IWM	ETF	218.65	218.99	218.6	218.82	27670.0
2021-09-30 18:00:00	IWM	ETF	218.9	219.3	218.75	219.19	311209.0
2021-09-30 19:00:00	IWM	ETF	219.22	219.39	219.03	219.14	10559.0
2021-09-30 04:00:00	DIA	ETF	346.44	346.45	346.0	346.2	15000.0
2021-09-30 05:00:00	DIA	ETF	346.0	346.0	345.51	345.56	5299.0

> showing 50 of 15,242 rows — these rows as CSV

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