PREVIEW / etf_1hour / 2021-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-13.parquet
  size:    436 KB
  rows:    15,495

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-12-13 04:00:00	SPY	ETF	471.53	472.53	471.53	472.2	18774.0
2021-12-13 05:00:00	SPY	ETF	472.29	472.4	471.82	472.08	21785.0
2021-12-13 06:00:00	SPY	ETF	472.16	472.54	471.7	472.05	39686.0
2021-12-13 07:00:00	SPY	ETF	472.08	472.1	471.48	471.55	144749.0
2021-12-13 08:00:00	SPY	ETF	471.8101	472.3	471.31	471.44	258450.0
2021-12-13 09:00:00	SPY	ETF	471.4	471.41	468.38	468.71	7522227.0
2021-12-13 10:00:00	SPY	ETF	468.7	469.39	467.25	467.78	9040494.0
2021-12-13 11:00:00	SPY	ETF	467.78	468.0	466.76	467.335	8740876.0
2021-12-13 12:00:00	SPY	ETF	467.32	468.13	466.76	467.52	4629499.0
2021-12-13 13:00:00	SPY	ETF	467.52	467.92	467.0	467.75	3219888.0
2021-12-13 14:00:00	SPY	ETF	467.74	468.3	467.39	468.23	4630008.0
2021-12-13 15:00:00	SPY	ETF	468.23	468.63	466.27	466.61	18735143.0
2021-12-13 16:00:00	SPY	ETF	466.62	467.12	466.1	466.92	4522913.0
2021-12-13 17:00:00	SPY	ETF	466.95	467.11	466.71	466.86	72326.0
2021-12-13 18:00:00	SPY	ETF	466.86	467.24	466.57	467.01	54593.0
2021-12-13 19:00:00	SPY	ETF	467.09	467.48	467.09	467.45	84877.0
2021-12-13 04:00:00	QQQ	ETF	398.71	399.73	398.71	399.62	16657.0
2021-12-13 05:00:00	QQQ	ETF	399.66	399.8	399.35	399.76	17599.0
2021-12-13 06:00:00	QQQ	ETF	399.81	400.06	399.45	399.7	21455.0
2021-12-13 07:00:00	QQQ	ETF	399.71	399.81	399.35	399.6	54125.0
2021-12-13 08:00:00	QQQ	ETF	399.3004	400.0004	398.01	399.47	139154.0
2021-12-13 09:00:00	QQQ	ETF	399.43	399.45	396.3	396.77	4696552.0
2021-12-13 10:00:00	QQQ	ETF	396.78	397.7195	394.53	395.16	6658015.0
2021-12-13 11:00:00	QQQ	ETF	395.15	395.41	392.82	393.446	5463434.0
2021-12-13 12:00:00	QQQ	ETF	393.43	394.73	392.96	394.04	3475930.0
2021-12-13 13:00:00	QQQ	ETF	394.03	394.65	393.02	393.98	3271854.0
2021-12-13 14:00:00	QQQ	ETF	393.94	394.84	393.52	394.815	2116664.0
2021-12-13 15:00:00	QQQ	ETF	394.81	395.18	391.88	392.24	6443246.0
2021-12-13 16:00:00	QQQ	ETF	392.27	392.44	391.68	392.4	952779.0
2021-12-13 17:00:00	QQQ	ETF	392.35	392.49	392.08	392.12	35601.0
2021-12-13 18:00:00	QQQ	ETF	392.14	392.6	392.14	392.36	79460.0
2021-12-13 19:00:00	QQQ	ETF	392.4	392.68	392.4	392.68	74520.0
2021-12-13 04:00:00	IWM	ETF	220.13	220.45	219.89	220.03	22160.0
2021-12-13 05:00:00	IWM	ETF	220.12	220.12	219.6	219.74	8547.0
2021-12-13 06:00:00	IWM	ETF	219.85	220.23	219.65	219.87	15864.0
2021-12-13 07:00:00	IWM	ETF	219.7	219.72	219.05	219.09	65576.0
2021-12-13 08:00:00	IWM	ETF	219.39	220.2196	219.05	219.5	98093.0
2021-12-13 09:00:00	IWM	ETF	219.54	219.54	216.71	217.68	4471745.0
2021-12-13 10:00:00	IWM	ETF	217.69	217.99	216.14	216.39	3585072.0
2021-12-13 11:00:00	IWM	ETF	216.39	216.54	214.745	215.23	3464636.0
2021-12-13 12:00:00	IWM	ETF	215.22	216.12	214.92	215.4	2802351.0
2021-12-13 13:00:00	IWM	ETF	215.4	216.05	215.23	216.0	1446475.0
2021-12-13 14:00:00	IWM	ETF	215.99	216.8783	215.63	216.865	2398346.0
2021-12-13 15:00:00	IWM	ETF	216.87	217.71	215.93	216.12	5971584.0
2021-12-13 16:00:00	IWM	ETF	216.04	216.71	215.88	216.5	2238006.0
2021-12-13 17:00:00	IWM	ETF	216.5	216.59	216.0	216.24	50860.0
2021-12-13 18:00:00	IWM	ETF	216.37	216.84	216.04	216.79	102856.0
2021-12-13 19:00:00	IWM	ETF	216.85	217.13	216.78	217.09	86902.0
2021-12-13 04:00:00	DIA	ETF	361.39	361.39	361.39	361.39	100.0
2021-12-13 06:00:00	DIA	ETF	360.81	360.87	360.8	360.87	900.0

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

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