PREVIEW / etf_1hour / 2021-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-13.parquet
  size:    412 KB
  rows:    14,474

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-07-13 04:00:00	SPY	ETF	436.66	437.15	436.52	437.12	13377.0
2021-07-13 05:00:00	SPY	ETF	437.0	437.25	436.99	437.15	4369.0
2021-07-13 06:00:00	SPY	ETF	437.22	437.29	437.08	437.11	9175.0
2021-07-13 07:00:00	SPY	ETF	437.13	437.25	437.0	437.17	44793.0
2021-07-13 08:00:00	SPY	ETF	437.1	437.2496	435.16	435.2	739444.0
2021-07-13 09:00:00	SPY	ETF	435.22	437.12	435.2	436.8	5746612.0
2021-07-13 10:00:00	SPY	ETF	436.82	437.485	436.55	436.9119	5043550.0
2021-07-13 11:00:00	SPY	ETF	436.91	437.8	436.91	437.725	3508801.0
2021-07-13 12:00:00	SPY	ETF	437.73	437.84	437.4	437.52	1983212.0
2021-07-13 13:00:00	SPY	ETF	437.515	437.5389	435.74	436.47	6373280.0
2021-07-13 14:00:00	SPY	ETF	436.46	436.535	435.57	436.2799	6172759.0
2021-07-13 15:00:00	SPY	ETF	436.28	436.29	435.31	435.61	11279347.0
2021-07-13 16:00:00	SPY	ETF	435.61	435.74	435.3	435.41	1987712.0
2021-07-13 17:00:00	SPY	ETF	435.48	435.58	435.25	435.42	486189.0
2021-07-13 18:00:00	SPY	ETF	435.42	435.73	435.37	435.55	84070.0
2021-07-13 19:00:00	SPY	ETF	435.63	435.63	434.94	435.01	67721.0
2021-07-13 04:00:00	QQQ	ETF	362.38	363.2	362.29	363.09	35090.0
2021-07-13 05:00:00	QQQ	ETF	363.13	363.73	363.13	363.72	46413.0
2021-07-13 06:00:00	QQQ	ETF	363.8	363.8	363.58	363.66	23231.0
2021-07-13 07:00:00	QQQ	ETF	363.7	363.78	363.45	363.5	53221.0
2021-07-13 08:00:00	QQQ	ETF	363.62	363.7896	360.77	360.82	1189825.0
2021-07-13 09:00:00	QQQ	ETF	360.91	363.64	360.62	363.51	3850917.0
2021-07-13 10:00:00	QQQ	ETF	363.51	364.9392	363.51	364.4	4695825.0
2021-07-13 11:00:00	QQQ	ETF	364.4298	365.465	364.38	365.325	2854091.0
2021-07-13 12:00:00	QQQ	ETF	365.32	365.35	364.91	365.06	1486859.0
2021-07-13 13:00:00	QQQ	ETF	365.07	365.09	362.1	362.82	6844454.0
2021-07-13 14:00:00	QQQ	ETF	362.81	363.375	361.54	363.25	5649985.0
2021-07-13 15:00:00	QQQ	ETF	363.25	363.25	361.91	362.34	5376436.0
2021-07-13 16:00:00	QQQ	ETF	362.34	362.54	362.04	362.29	961969.0
2021-07-13 17:00:00	QQQ	ETF	362.16	362.29	362.15	362.22	23500.0
2021-07-13 18:00:00	QQQ	ETF	362.26	362.58	362.21	362.44	64430.0
2021-07-13 19:00:00	QQQ	ETF	362.5	362.52	361.75	361.81	92256.0
2021-07-13 04:00:00	IWM	ETF	226.12	226.29	226.1	226.29	4668.0
2021-07-13 05:00:00	IWM	ETF	226.16	226.16	226.16	226.16	1000.0
2021-07-13 06:00:00	IWM	ETF	226.16	226.16	225.92	225.99	6814.0
2021-07-13 07:00:00	IWM	ETF	226.0	226.08	225.9	226.02	13134.0
2021-07-13 08:00:00	IWM	ETF	226.0125	226.02	224.39	224.39	293547.0
2021-07-13 09:00:00	IWM	ETF	224.43	225.74	224.05	224.15	2687061.0
2021-07-13 10:00:00	IWM	ETF	224.17	224.28	223.125	223.41	4475024.0
2021-07-13 11:00:00	IWM	ETF	223.39	223.91	223.015	223.87	2555614.0
2021-07-13 12:00:00	IWM	ETF	223.865	224.16	223.39	223.44	1123531.0
2021-07-13 13:00:00	IWM	ETF	223.43	223.63	222.83	223.46	2115193.0
2021-07-13 14:00:00	IWM	ETF	223.45	223.79	222.92	223.15	1812777.0
2021-07-13 15:00:00	IWM	ETF	223.16	223.37	222.22	222.3402	5702723.0
2021-07-13 16:00:00	IWM	ETF	222.34	222.46	222.24	222.37	924588.0
2021-07-13 17:00:00	IWM	ETF	222.32	222.4	222.3	222.3	14332.0
2021-07-13 18:00:00	IWM	ETF	222.31	222.63	222.23	222.56	30565.0
2021-07-13 19:00:00	IWM	ETF	222.53	222.54	221.98	222.03	57054.0
2021-07-13 04:00:00	DIA	ETF	349.61	350.05	349.61	350.05	1000.0
2021-07-13 05:00:00	DIA	ETF	349.87	349.88	349.8	349.8	1800.0

> showing 50 of 14,474 rows — these rows as CSV

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