PREVIEW / etf_1hour / 2021-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-26.parquet
  size:    433 KB
  rows:    15,200

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-26 04:00:00	SPY	ETF	456.92	457.55	456.92	457.21	27416.0
2021-10-26 05:00:00	SPY	ETF	457.16	457.18	456.97	457.16	11991.0
2021-10-26 06:00:00	SPY	ETF	457.21	457.27	456.94	457.16	20440.0
2021-10-26 07:00:00	SPY	ETF	457.17	457.38	457.0	457.09	210789.0
2021-10-26 08:00:00	SPY	ETF	457.2	457.35	455.55	457.15	162677.0
2021-10-26 09:00:00	SPY	ETF	457.15	457.8	456.78	457.4	4776680.0
2021-10-26 10:00:00	SPY	ETF	457.41	458.49	457.18	458.125	6109248.0
2021-10-26 11:00:00	SPY	ETF	458.12	458.35	457.115	457.15	4453170.0
2021-10-26 12:00:00	SPY	ETF	457.15	457.26	455.56	456.23	6795235.0
2021-10-26 13:00:00	SPY	ETF	456.22	456.97	455.82	456.61	4566205.0
2021-10-26 14:00:00	SPY	ETF	456.61	457.17	456.5301	457.06	4863294.0
2021-10-26 15:00:00	SPY	ETF	457.07	457.43	455.89	455.9801	10019824.0
2021-10-26 16:00:00	SPY	ETF	455.99	456.43	455.0	455.9	2914880.0
2021-10-26 17:00:00	SPY	ETF	455.72	455.99	455.64	455.9	79294.0
2021-10-26 18:00:00	SPY	ETF	455.89	456.64	455.89	456.53	93475.0
2021-10-26 19:00:00	SPY	ETF	456.49	456.76	456.16	456.46	37373.0
2021-10-26 04:00:00	QQQ	ETF	379.54	380.54	379.54	380.18	404778.0
2021-10-26 05:00:00	QQQ	ETF	380.18	380.28	380.04	380.18	212824.0
2021-10-26 06:00:00	QQQ	ETF	380.21	380.26	379.66	379.82	107870.0
2021-10-26 07:00:00	QQQ	ETF	379.88	380.11	379.84	379.93	127039.0
2021-10-26 08:00:00	QQQ	ETF	379.979	380.18	378.213	379.97	208948.0
2021-10-26 09:00:00	QQQ	ETF	379.97	381.68	379.7905	381.24	6499620.0
2021-10-26 10:00:00	QQQ	ETF	381.24	382.71	381.11	381.95	4472865.0
2021-10-26 11:00:00	QQQ	ETF	381.96	382.17	379.87	380.0599	4214534.0
2021-10-26 12:00:00	QQQ	ETF	380.02	380.31	377.905	378.74	6009371.0
2021-10-26 13:00:00	QQQ	ETF	378.74	379.9	378.31	379.3	3855921.0
2021-10-26 14:00:00	QQQ	ETF	379.3	379.87	379.015	379.7319	2495554.0
2021-10-26 15:00:00	QQQ	ETF	379.7162	380.12	378.77	378.92	4844946.0
2021-10-26 16:00:00	QQQ	ETF	378.91	379.21	378.23	378.43	1391052.0
2021-10-26 17:00:00	QQQ	ETF	378.36	378.69	378.35	378.6	80909.0
2021-10-26 18:00:00	QQQ	ETF	378.6	379.56	378.57	379.39	135456.0
2021-10-26 19:00:00	QQQ	ETF	379.43	379.54	379.09	379.3	95438.0
2021-10-26 04:00:00	IWM	ETF	230.29	230.5	230.23	230.36	10242.0
2021-10-26 05:00:00	IWM	ETF	230.27	230.33	230.14	230.25	10321.0
2021-10-26 06:00:00	IWM	ETF	230.3	230.41	230.22	230.39	8051.0
2021-10-26 07:00:00	IWM	ETF	230.4	230.57	230.28	230.36	89616.0
2021-10-26 08:00:00	IWM	ETF	230.33	230.53	229.95	230.35	45794.0
2021-10-26 09:00:00	IWM	ETF	230.36	230.36	228.58	229.22	2333179.0
2021-10-26 10:00:00	IWM	ETF	229.24	230.72	229.05	230.59	2960110.0
2021-10-26 11:00:00	IWM	ETF	230.61	230.635	229.36	229.39	3239680.0
2021-10-26 12:00:00	IWM	ETF	229.37	229.45	228.05	228.83	3064928.0
2021-10-26 13:00:00	IWM	ETF	228.81	228.81	228.005	228.36	2090346.0
2021-10-26 14:00:00	IWM	ETF	228.37	229.06	228.37	228.98	1729955.0
2021-10-26 15:00:00	IWM	ETF	228.98	229.09	227.84	227.9	3161771.0
2021-10-26 16:00:00	IWM	ETF	227.9	228.1	227.58	227.75	677454.0
2021-10-26 17:00:00	IWM	ETF	227.55	227.92	227.55	227.77	27712.0
2021-10-26 18:00:00	IWM	ETF	227.87	228.11	227.81	228.02	32905.0
2021-10-26 19:00:00	IWM	ETF	228.0	228.17	227.73	227.98	75946.0
2021-10-26 04:00:00	DIA	ETF	358.19	358.3	358.19	358.27	370.0
2021-10-26 05:00:00	DIA	ETF	358.42	358.43	358.42	358.43	333.0

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

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