PREVIEW / etf_1hour / 2021-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-06.parquet
  size:    427 KB
  rows:    15,241

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-06 04:00:00	SPY	ETF	428.92	431.91	428.18	428.39	85017.0
2021-10-06 05:00:00	SPY	ETF	428.2	428.2	426.95	427.68	265061.0
2021-10-06 06:00:00	SPY	ETF	427.48	428.14	427.36	427.74	294572.0
2021-10-06 07:00:00	SPY	ETF	427.8	428.7	427.68	428.58	787143.0
2021-10-06 08:00:00	SPY	ETF	427.8301	433.494	427.4496	428.87	1136851.0
2021-10-06 09:00:00	SPY	ETF	428.88	431.32	428.65	428.87	11108321.0
2021-10-06 10:00:00	SPY	ETF	428.87	431.52	427.54	430.95	17731556.0
2021-10-06 11:00:00	SPY	ETF	430.95	431.43	429.08	431.075	9095827.0
2021-10-06 12:00:00	SPY	ETF	431.07	431.19	429.11	430.01	7231856.0
2021-10-06 13:00:00	SPY	ETF	430.0	432.81	429.19	432.56	10686763.0
2021-10-06 14:00:00	SPY	ETF	432.57	434.53	432.02	433.28	13490519.0
2021-10-06 15:00:00	SPY	ETF	433.28	435.1199	433.03	434.91	16306402.0
2021-10-06 16:00:00	SPY	ETF	434.91	435.29	434.57	435.07	2990539.0
2021-10-06 17:00:00	SPY	ETF	435.07	435.2	434.9	435.19	209869.0
2021-10-06 18:00:00	SPY	ETF	435.15	436.24	434.9	436.12	188048.0
2021-10-06 19:00:00	SPY	ETF	436.15	436.67	435.8	436.12	220390.0
2021-10-06 04:00:00	QQQ	ETF	356.28	356.28	352.61	352.72	178283.0
2021-10-06 05:00:00	QQQ	ETF	352.58	352.74	351.68	352.26	280083.0
2021-10-06 06:00:00	QQQ	ETF	352.26	352.7	351.84	352.31	256900.0
2021-10-06 07:00:00	QQQ	ETF	352.32	353.4	352.23	353.3	538076.0
2021-10-06 08:00:00	QQQ	ETF	353.27	357.648	351.8796	353.75	839462.0
2021-10-06 09:00:00	QQQ	ETF	353.75	356.93	353.72	354.47	7964075.0
2021-10-06 10:00:00	QQQ	ETF	354.45	358.12	353.15	357.4001	10437301.0
2021-10-06 11:00:00	QQQ	ETF	357.39	357.74	355.54	357.4101	5050645.0
2021-10-06 12:00:00	QQQ	ETF	357.41	357.46	355.45	356.01	3600210.0
2021-10-06 13:00:00	QQQ	ETF	355.99	358.52	355.1819	358.19	4876131.0
2021-10-06 14:00:00	QQQ	ETF	358.2	359.59	357.7	358.5	5435170.0
2021-10-06 15:00:00	QQQ	ETF	358.43	359.95	357.96	359.67	7129913.0
2021-10-06 16:00:00	QQQ	ETF	359.67	360.06	359.57	359.98	937551.0
2021-10-06 17:00:00	QQQ	ETF	360.03	360.18	359.95	360.18	77778.0
2021-10-06 18:00:00	QQQ	ETF	360.09	361.09	360.04	361.0	130602.0
2021-10-06 19:00:00	QQQ	ETF	361.06	361.5	360.72	361.03	150632.0
2021-10-06 04:00:00	IWM	ETF	220.27	220.27	217.93	218.04	22839.0
2021-10-06 05:00:00	IWM	ETF	217.9	217.9	217.25	217.55	115335.0
2021-10-06 06:00:00	IWM	ETF	217.45	218.1	217.45	218.06	141430.0
2021-10-06 07:00:00	IWM	ETF	218.09	218.5	217.95	218.43	215752.0
2021-10-06 08:00:00	IWM	ETF	218.3499	220.23	218.07	218.75	298021.0
2021-10-06 09:00:00	IWM	ETF	218.72	219.99	218.1	218.23	4447784.0
2021-10-06 10:00:00	IWM	ETF	218.22	218.4	216.835	218.01	6414261.0
2021-10-06 11:00:00	IWM	ETF	218.01	218.72	216.76	218.67	3411357.0
2021-10-06 12:00:00	IWM	ETF	218.67	218.8	217.38	217.94	3211848.0
2021-10-06 13:00:00	IWM	ETF	217.96	219.41	217.29	219.17	2972552.0
2021-10-06 14:00:00	IWM	ETF	219.21	220.2	218.82	219.36	2668440.0
2021-10-06 15:00:00	IWM	ETF	219.35	219.99	219.0516	219.86	3366320.0
2021-10-06 16:00:00	IWM	ETF	219.87	220.25	218.2334	220.06	935518.0
2021-10-06 17:00:00	IWM	ETF	220.3	220.3	219.92	220.01	8213.0
2021-10-06 18:00:00	IWM	ETF	220.07	220.65	220.07	220.54	47551.0
2021-10-06 19:00:00	IWM	ETF	220.64	220.83	220.32	220.48	72569.0
2021-10-06 04:00:00	DIA	ETF	340.26	340.55	340.0	340.1	5625.0
2021-10-06 05:00:00	DIA	ETF	339.84	339.95	339.11	339.57	6340.0

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

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