PREVIEW / etf_1hour / 2021-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-28.parquet
  size:    443 KB
  rows:    15,774

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-28 04:00:00	SPY	ETF	442.0	442.0	439.03	439.84	77068.0
2021-09-28 05:00:00	SPY	ETF	439.84	440.2	438.55	438.58	34908.0
2021-09-28 06:00:00	SPY	ETF	438.66	439.3	438.35	438.77	126198.0
2021-09-28 07:00:00	SPY	ETF	438.73	439.9	438.36	439.61	335195.0
2021-09-28 08:00:00	SPY	ETF	439.64	442.03	438.3096	439.05	677750.0
2021-09-28 09:00:00	SPY	ETF	438.92	440.37	437.2	438.02	10796925.0
2021-09-28 10:00:00	SPY	ETF	438.01	438.01	434.87	435.65	18545848.0
2021-09-28 11:00:00	SPY	ETF	435.64	436.07	433.76	434.57	12019225.0
2021-09-28 12:00:00	SPY	ETF	434.57	435.13	433.07	433.32	7881727.0
2021-09-28 13:00:00	SPY	ETF	433.31	435.0284	432.94	433.705	8305742.0
2021-09-28 14:00:00	SPY	ETF	433.7	436.19	433.02	435.855	12738030.0
2021-09-28 15:00:00	SPY	ETF	435.84	436.67	433.17	433.75	26830785.0
2021-09-28 16:00:00	SPY	ETF	433.75	443.72	433.61	434.03	5467415.0
2021-09-28 17:00:00	SPY	ETF	434.03	434.22	433.96	434.05	105432.0
2021-09-28 18:00:00	SPY	ETF	434.05	443.72	433.72	434.51	1981273.0
2021-09-28 19:00:00	SPY	ETF	434.49	434.9	433.95	434.89	89950.0
2021-09-28 04:00:00	QQQ	ETF	370.0	370.0	364.75	365.95	226547.0
2021-09-28 05:00:00	QQQ	ETF	365.95	366.34	364.36	364.48	139649.0
2021-09-28 06:00:00	QQQ	ETF	364.51	365.0	363.85	364.21	261443.0
2021-09-28 07:00:00	QQQ	ETF	364.26	365.51	363.89	365.29	580392.0
2021-09-28 08:00:00	QQQ	ETF	364.5899	370.1	363.89	364.83	528896.0
2021-09-28 09:00:00	QQQ	ETF	364.78	366.36	363.405	364.49	8502567.0
2021-09-28 10:00:00	QQQ	ETF	364.46	364.46	361.25	361.49	15395527.0
2021-09-28 11:00:00	QQQ	ETF	361.47	361.82	359.86	360.91	12022736.0
2021-09-28 12:00:00	QQQ	ETF	360.91	361.82	359.52	359.78	7588405.0
2021-09-28 13:00:00	QQQ	ETF	359.77	361.3499	359.43	360.07	6150422.0
2021-09-28 14:00:00	QQQ	ETF	360.07	362.31	359.35	361.92	8642797.0
2021-09-28 15:00:00	QQQ	ETF	361.9	362.61	359.52	359.85	13791296.0
2021-09-28 16:00:00	QQQ	ETF	359.91	360.42	359.35	359.99	3106664.0
2021-09-28 17:00:00	QQQ	ETF	359.93	360.04	359.845	359.97	67708.0
2021-09-28 18:00:00	QQQ	ETF	359.97	360.31	359.86	360.18	120639.0
2021-09-28 19:00:00	QQQ	ETF	360.14	360.8	359.8	360.77	91644.0
2021-09-28 04:00:00	IWM	ETF	225.63	225.68	224.98	225.68	50779.0
2021-09-28 05:00:00	IWM	ETF	225.72	226.07	225.28	225.43	25487.0
2021-09-28 06:00:00	IWM	ETF	225.35	225.88	225.2	225.63	131023.0
2021-09-28 07:00:00	IWM	ETF	225.62	226.1	225.14	225.87	91214.0
2021-09-28 08:00:00	IWM	ETF	225.23	227.46	225.07	225.25	196957.0
2021-09-28 09:00:00	IWM	ETF	225.09	225.95	223.65	224.06	4627062.0
2021-09-28 10:00:00	IWM	ETF	224.05	224.05	222.09	223.18	6603483.0
2021-09-28 11:00:00	IWM	ETF	223.17	223.46	221.935	222.45	5030596.0
2021-09-28 12:00:00	IWM	ETF	222.45	222.86	221.63	221.76	2493200.0
2021-09-28 13:00:00	IWM	ETF	221.7685	223.04	221.64	222.06	2432117.0
2021-09-28 14:00:00	IWM	ETF	222.06	223.14	221.43	222.91	3389473.0
2021-09-28 15:00:00	IWM	ETF	222.88	223.26	220.85	221.27	5385242.0
2021-09-28 16:00:00	IWM	ETF	221.27	221.87	221.27	221.55	1769670.0
2021-09-28 17:00:00	IWM	ETF	221.9	221.9	221.26	221.27	142932.0
2021-09-28 18:00:00	IWM	ETF	221.4	221.92	221.29	221.82	234592.0
2021-09-28 19:00:00	IWM	ETF	221.9	222.0	221.48	222.0	47388.0
2021-09-28 04:00:00	DIA	ETF	347.54	347.54	347.21	347.44	2258.0
2021-09-28 05:00:00	DIA	ETF	347.54	347.7	346.73	346.77	13157.0

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

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