PREVIEW / etf_1hour / 2021-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-07.parquet
  size:    423 KB
  rows:    14,916

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-07 04:00:00	SPY	ETF	452.0	453.61	452.0	453.36	10027.0
2021-09-07 05:00:00	SPY	ETF	453.16	453.36	452.6	452.67	12845.0
2021-09-07 06:00:00	SPY	ETF	452.85	453.09	452.8	452.98	13024.0
2021-09-07 07:00:00	SPY	ETF	453.03	453.43	452.99	453.32	66050.0
2021-09-07 08:00:00	SPY	ETF	453.2699	453.5	452.8296	453.0	153273.0
2021-09-07 09:00:00	SPY	ETF	452.99	453.07	451.31	451.745	5724027.0
2021-09-07 10:00:00	SPY	ETF	451.74	451.82	450.7423	451.685	6955848.0
2021-09-07 11:00:00	SPY	ETF	451.68	451.72	450.805	451.28	4700720.0
2021-09-07 12:00:00	SPY	ETF	451.29	452.24	451.23	452.19	3371761.0
2021-09-07 13:00:00	SPY	ETF	452.19	452.43	452.031	452.345	3605731.0
2021-09-07 14:00:00	SPY	ETF	452.35	452.36	451.74	452.11	3057936.0
2021-09-07 15:00:00	SPY	ETF	452.11	452.28	451.4	451.52	8422584.0
2021-09-07 16:00:00	SPY	ETF	451.52	451.57	451.16	451.4	1620853.0
2021-09-07 17:00:00	SPY	ETF	451.36	451.46	451.34	451.34	59202.0
2021-09-07 18:00:00	SPY	ETF	451.39	451.6	451.36	451.42	135018.0
2021-09-07 19:00:00	SPY	ETF	451.48	451.48	451.0	451.11	45715.0
2021-09-07 04:00:00	QQQ	ETF	381.5	382.32	381.5	381.88	53388.0
2021-09-07 05:00:00	QQQ	ETF	381.85	381.93	380.85	381.27	72832.0
2021-09-07 06:00:00	QQQ	ETF	381.29	381.4	380.96	381.13	27266.0
2021-09-07 07:00:00	QQQ	ETF	381.18	381.6	381.13	381.54	147386.0
2021-09-07 08:00:00	QQQ	ETF	381.55	381.81	380.9696	381.5	133193.0
2021-09-07 09:00:00	QQQ	ETF	381.5	381.97	380.65	381.36	3481276.0
2021-09-07 10:00:00	QQQ	ETF	381.34	382.19	380.4882	382.12	3763772.0
2021-09-07 11:00:00	QQQ	ETF	382.11	382.1784	381.11	382.0	2289973.0
2021-09-07 12:00:00	QQQ	ETF	381.96	382.778	381.93	382.53	1578136.0
2021-09-07 13:00:00	QQQ	ETF	382.53	382.765	382.31	382.56	1285813.0
2021-09-07 14:00:00	QQQ	ETF	382.56	382.66	382.1501	382.51	1457764.0
2021-09-07 15:00:00	QQQ	ETF	382.51	382.62	382.03	382.12	2839616.0
2021-09-07 16:00:00	QQQ	ETF	382.11	382.12	381.69	382.03	621729.0
2021-09-07 17:00:00	QQQ	ETF	381.97	382.11	381.97	382.0	14423.0
2021-09-07 18:00:00	QQQ	ETF	382.02	382.16	382.02	382.11	21364.0
2021-09-07 19:00:00	QQQ	ETF	382.11	382.11	381.77	381.81	18881.0
2021-09-07 04:00:00	IWM	ETF	227.9	227.9	227.4	227.86	10223.0
2021-09-07 05:00:00	IWM	ETF	227.75	227.77	227.49	227.7	7596.0
2021-09-07 06:00:00	IWM	ETF	227.69	227.88	227.66	227.77	5747.0
2021-09-07 07:00:00	IWM	ETF	227.79	228.25	227.79	228.09	35780.0
2021-09-07 08:00:00	IWM	ETF	227.9	228.22	227.7	228.02	95821.0
2021-09-07 09:00:00	IWM	ETF	228.0	229.0	227.61	228.23	2589226.0
2021-09-07 10:00:00	IWM	ETF	228.23	228.74	227.27	227.475	3683773.0
2021-09-07 11:00:00	IWM	ETF	227.48	227.68	226.73	226.86	2030545.0
2021-09-07 12:00:00	IWM	ETF	226.85	227.2411	226.67	227.17	1608854.0
2021-09-07 13:00:00	IWM	ETF	227.175	227.38	226.95	227.26	1422051.0
2021-09-07 14:00:00	IWM	ETF	227.24	227.42	226.45	226.73	1532104.0
2021-09-07 15:00:00	IWM	ETF	226.74	226.85	226.2549	226.39	2123003.0
2021-09-07 16:00:00	IWM	ETF	226.4	226.46	226.14	226.39	454011.0
2021-09-07 17:00:00	IWM	ETF	226.45	226.45	226.22	226.25	59065.0
2021-09-07 18:00:00	IWM	ETF	226.28	226.48	226.28	226.37	9225.0
2021-09-07 19:00:00	IWM	ETF	226.35	226.43	226.07	226.18	77820.0
2021-09-07 04:00:00	DIA	ETF	354.47	354.47	353.99	354.12	1685.0
2021-09-07 05:00:00	DIA	ETF	354.04	354.04	353.98	353.98	400.0

> showing 50 of 14,916 rows — these rows as CSV

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