PREVIEW / etf_1hour / 2021-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-16.parquet
  size:    436 KB
  rows:    15,339

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-11-16 04:00:00	SPY	ETF	467.0	467.23	466.81	467.23	13049.0
2021-11-16 05:00:00	SPY	ETF	467.14	467.16	466.63	466.89	20305.0
2021-11-16 06:00:00	SPY	ETF	466.87	467.86	466.87	467.85	69435.0
2021-11-16 07:00:00	SPY	ETF	467.84	467.91	467.35	467.48	91141.0
2021-11-16 08:00:00	SPY	ETF	467.6201	468.05	466.8996	467.43	188383.0
2021-11-16 09:00:00	SPY	ETF	467.37	469.01	466.9	468.5	4045080.0
2021-11-16 10:00:00	SPY	ETF	468.52	469.08	468.05	468.39	3768472.0
2021-11-16 11:00:00	SPY	ETF	468.39	469.94	468.39	469.69	4283156.0
2021-11-16 12:00:00	SPY	ETF	469.69	470.19	469.52	469.967	2933229.0
2021-11-16 13:00:00	SPY	ETF	469.9628	470.4	469.88	470.35	2436223.0
2021-11-16 14:00:00	SPY	ETF	470.345	470.485	469.81	469.88	3213066.0
2021-11-16 15:00:00	SPY	ETF	469.88	469.98	468.98	469.24	10154377.0
2021-11-16 16:00:00	SPY	ETF	469.25	469.49	469.01	469.1699	4698517.0
2021-11-16 17:00:00	SPY	ETF	469.18	469.28	469.1	469.2	73404.0
2021-11-16 18:00:00	SPY	ETF	469.19	469.46	469.03	469.43	63980.0
2021-11-16 19:00:00	SPY	ETF	469.43	469.48	469.2	469.35	29330.0
2021-11-16 04:00:00	QQQ	ETF	394.2	394.51	394.2	394.42	56088.0
2021-11-16 05:00:00	QQQ	ETF	394.38	394.39	393.72	394.03	83690.0
2021-11-16 06:00:00	QQQ	ETF	394.05	394.98	393.91	394.91	110415.0
2021-11-16 07:00:00	QQQ	ETF	394.9	395.0	394.35	394.6	186250.0
2021-11-16 08:00:00	QQQ	ETF	394.7701	395.23	393.7204	394.19	371396.0
2021-11-16 09:00:00	QQQ	ETF	394.16	396.19	393.55	395.52	3967189.0
2021-11-16 10:00:00	QQQ	ETF	395.51	396.38	394.81	395.69	3153477.0
2021-11-16 11:00:00	QQQ	ETF	395.66	397.58	395.65	397.07	2884758.0
2021-11-16 12:00:00	QQQ	ETF	397.08	397.46	396.83	397.2	1480947.0
2021-11-16 13:00:00	QQQ	ETF	397.2	397.7	397.0731	397.67	1494741.0
2021-11-16 14:00:00	QQQ	ETF	397.655	397.93	397.39	397.55	1869870.0
2021-11-16 15:00:00	QQQ	ETF	397.565	397.92	396.97	397.5	4591114.0
2021-11-16 16:00:00	QQQ	ETF	397.49	397.5	397.17	397.22	830770.0
2021-11-16 17:00:00	QQQ	ETF	397.22	397.42	397.05	397.4	239997.0
2021-11-16 18:00:00	QQQ	ETF	397.35	397.59	397.21	397.52	35316.0
2021-11-16 19:00:00	QQQ	ETF	397.42	397.58	397.42	397.52	40370.0
2021-11-16 04:00:00	IWM	ETF	238.03	238.27	238.03	238.27	10986.0
2021-11-16 05:00:00	IWM	ETF	238.28	238.28	237.77	237.87	10214.0
2021-11-16 06:00:00	IWM	ETF	237.84	238.43	237.79	238.39	10978.0
2021-11-16 07:00:00	IWM	ETF	238.42	238.5	237.94	238.09	29029.0
2021-11-16 08:00:00	IWM	ETF	238.3101	238.49	237.8096	238.15	98635.0
2021-11-16 09:00:00	IWM	ETF	238.03	238.41	236.95	237.505	3391420.0
2021-11-16 10:00:00	IWM	ETF	237.5	238.21	237.07	237.98	2333964.0
2021-11-16 11:00:00	IWM	ETF	237.99	238.61	237.73	238.59	1531490.0
2021-11-16 12:00:00	IWM	ETF	238.59	239.315	238.57	239.12	1700565.0
2021-11-16 13:00:00	IWM	ETF	239.14	239.28	238.65	238.77	1200419.0
2021-11-16 14:00:00	IWM	ETF	238.76	239.37	238.61	239.02	1133747.0
2021-11-16 15:00:00	IWM	ETF	239.02	239.16	238.57	238.9399	3179567.0
2021-11-16 16:00:00	IWM	ETF	238.93	239.03	238.73	238.78	1845358.0
2021-11-16 17:00:00	IWM	ETF	238.78	239.0	238.78	238.99	73347.0
2021-11-16 18:00:00	IWM	ETF	238.9	239.0	238.64	238.98	43277.0
2021-11-16 19:00:00	IWM	ETF	238.95	239.0	238.66	238.75	33306.0
2021-11-16 04:00:00	DIA	ETF	360.84	360.91	360.84	360.91	676.0
2021-11-16 05:00:00	DIA	ETF	361.03	361.03	361.03	361.03	100.0

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

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