PREVIEW / etf_1hour / 2021-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-25.parquet
  size:    431 KB
  rows:    15,043

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-10-25 04:00:00	SPY	ETF	453.04	454.1	453.04	453.68	9329.0
2021-10-25 05:00:00	SPY	ETF	453.61	453.8	453.43	453.49	25012.0
2021-10-25 06:00:00	SPY	ETF	453.49	453.84	453.49	453.75	15923.0
2021-10-25 07:00:00	SPY	ETF	453.7	453.9	453.35	453.86	100898.0
2021-10-25 08:00:00	SPY	ETF	453.5496	454.01	453.4	453.76	161958.0
2021-10-25 09:00:00	SPY	ETF	453.79	454.34	452.39	453.67	4757860.0
2021-10-25 10:00:00	SPY	ETF	453.68	454.28	453.29	454.18	4704019.0
2021-10-25 11:00:00	SPY	ETF	454.17	454.91	454.01	454.89	3737579.0
2021-10-25 12:00:00	SPY	ETF	454.895	455.57	454.745	455.38	2847401.0
2021-10-25 13:00:00	SPY	ETF	455.38	455.9	455.255	455.43	2626272.0
2021-10-25 14:00:00	SPY	ETF	455.4	455.89	455.2	455.51	3097155.0
2021-10-25 15:00:00	SPY	ETF	455.52	455.59	454.88	455.49	9188725.0
2021-10-25 16:00:00	SPY	ETF	455.49	456.09	454.77	456.0	3000473.0
2021-10-25 17:00:00	SPY	ETF	456.01	456.05	455.55	455.96	66425.0
2021-10-25 18:00:00	SPY	ETF	455.97	456.01	455.69	455.7	39189.0
2021-10-25 19:00:00	SPY	ETF	455.73	456.2	455.69	456.16	44512.0
2021-10-25 04:00:00	QQQ	ETF	374.66	375.2	374.66	374.84	41386.0
2021-10-25 05:00:00	QQQ	ETF	374.75	374.96	374.7	374.83	15227.0
2021-10-25 06:00:00	QQQ	ETF	374.84	375.05	374.78	374.95	27756.0
2021-10-25 07:00:00	QQQ	ETF	374.96	375.27	374.4	375.21	166540.0
2021-10-25 08:00:00	QQQ	ETF	374.74	375.35	374.35	375.02	269829.0
2021-10-25 09:00:00	QQQ	ETF	375.0	376.24	373.56	375.2	4555793.0
2021-10-25 10:00:00	QQQ	ETF	375.22	375.91	374.89	375.66	3072949.0
2021-10-25 11:00:00	QQQ	ETF	375.65	376.42	375.28	376.31	2285280.0
2021-10-25 12:00:00	QQQ	ETF	376.33	377.99	376.28	377.7793	3181955.0
2021-10-25 13:00:00	QQQ	ETF	377.789	378.035	377.61	377.63	1862067.0
2021-10-25 14:00:00	QQQ	ETF	377.64	378.87	377.54	378.28	3922748.0
2021-10-25 15:00:00	QQQ	ETF	378.3	378.395	377.385	377.93	4846340.0
2021-10-25 16:00:00	QQQ	ETF	377.92	378.95	376.72	378.86	3176371.0
2021-10-25 17:00:00	QQQ	ETF	378.91	378.93	377.93	378.6	106636.0
2021-10-25 18:00:00	QQQ	ETF	378.65	378.77	378.45	378.47	54630.0
2021-10-25 19:00:00	QQQ	ETF	378.51	378.85	378.47	378.81	50090.0
2021-10-25 04:00:00	IWM	ETF	227.62	227.92	227.43	227.43	16055.0
2021-10-25 05:00:00	IWM	ETF	227.37	227.46	227.15	227.15	9058.0
2021-10-25 06:00:00	IWM	ETF	227.19	227.39	227.13	227.39	14954.0
2021-10-25 07:00:00	IWM	ETF	227.25	227.53	227.15	227.45	46944.0
2021-10-25 08:00:00	IWM	ETF	227.2996	227.77	227.2	227.65	86108.0
2021-10-25 09:00:00	IWM	ETF	227.63	228.67	227.28	228.565	2109253.0
2021-10-25 10:00:00	IWM	ETF	228.59	229.64	228.59	229.43	2312568.0
2021-10-25 11:00:00	IWM	ETF	229.41	229.98	229.23	229.4599	1391567.0
2021-10-25 12:00:00	IWM	ETF	229.46	229.905	228.94	228.985	1688042.0
2021-10-25 13:00:00	IWM	ETF	228.99	229.695	228.98	229.63	923698.0
2021-10-25 14:00:00	IWM	ETF	229.625	229.9085	229.4	229.74	1238991.0
2021-10-25 15:00:00	IWM	ETF	229.75	229.85	229.32	229.62	2209003.0
2021-10-25 16:00:00	IWM	ETF	229.6201	229.88	229.27	229.66	665471.0
2021-10-25 17:00:00	IWM	ETF	229.57	229.78	229.51	229.73	111890.0
2021-10-25 18:00:00	IWM	ETF	229.73	229.76	229.57	229.64	19515.0
2021-10-25 19:00:00	IWM	ETF	229.65	230.06	229.6	230.05	31524.0
2021-10-25 04:00:00	DIA	ETF	357.0	357.01	356.95	357.01	600.0
2021-10-25 05:00:00	DIA	ETF	356.88	356.88	356.88	356.88	100.0

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

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