PREVIEW / etf_1hour / 2021-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-30.parquet
  size:    410 KB
  rows:    14,201

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-30 04:00:00	SPY	ETF	437.18	438.28	436.85	437.86	22318.0
2021-07-30 05:00:00	SPY	ETF	437.92	437.95	437.3	437.47	32290.0
2021-07-30 06:00:00	SPY	ETF	437.52	438.39	437.32	438.36	81586.0
2021-07-30 07:00:00	SPY	ETF	438.39	438.39	437.64	437.67	194656.0
2021-07-30 08:00:00	SPY	ETF	437.67	440.98	436.91	438.03	444243.0
2021-07-30 09:00:00	SPY	ETF	438.01	439.7	437.56	439.39	8005897.0
2021-07-30 10:00:00	SPY	ETF	439.39	440.06	438.53	438.5942	6270730.0
2021-07-30 11:00:00	SPY	ETF	438.595	439.18	438.07	438.4	4701366.0
2021-07-30 12:00:00	SPY	ETF	438.4	439.0699	438.28	438.955	2245811.0
2021-07-30 13:00:00	SPY	ETF	438.95	439.165	438.54	438.8702	2974025.0
2021-07-30 14:00:00	SPY	ETF	438.88	438.929	437.77	438.53	6600111.0
2021-07-30 15:00:00	SPY	ETF	438.53	438.879	437.97	438.47	14433183.0
2021-07-30 16:00:00	SPY	ETF	438.49	439.05	438.3412	439.0	5170818.0
2021-07-30 17:00:00	SPY	ETF	439.01	439.01	438.7999	438.88	82869.0
2021-07-30 18:00:00	SPY	ETF	438.88	438.99	438.8001	438.99	4971.0
2021-07-30 19:00:00	SPY	ETF	438.99	439.14	438.8201	439.04	45114.0
2021-07-30 04:00:00	QQQ	ETF	361.85	362.79	361.66	362.46	85177.0
2021-07-30 05:00:00	QQQ	ETF	362.43	362.5	362.15	362.24	66708.0
2021-07-30 06:00:00	QQQ	ETF	362.3	363.24	362.21	363.23	110115.0
2021-07-30 07:00:00	QQQ	ETF	363.22	363.28	362.33	362.54	262984.0
2021-07-30 08:00:00	QQQ	ETF	363.17	366.754	361.3	362.56	348036.0
2021-07-30 09:00:00	QQQ	ETF	362.5	364.499	362.1	364.37	5698485.0
2021-07-30 10:00:00	QQQ	ETF	364.39	365.17	363.69	363.98	4795097.0
2021-07-30 11:00:00	QQQ	ETF	363.96	364.39	363.46	364.05	2861965.0
2021-07-30 12:00:00	QQQ	ETF	364.03	365.07	363.98	365.06	1882961.0
2021-07-30 13:00:00	QQQ	ETF	365.07	365.12	364.46	364.8	1964048.0
2021-07-30 14:00:00	QQQ	ETF	364.81	364.8699	363.85	364.52	1971712.0
2021-07-30 15:00:00	QQQ	ETF	364.52	364.81	364.04	364.51	5575996.0
2021-07-30 16:00:00	QQQ	ETF	364.53	365.3333	364.51	364.82	2259523.0
2021-07-30 17:00:00	QQQ	ETF	364.9	364.94	364.57	364.85	94871.0
2021-07-30 18:00:00	QQQ	ETF	364.85	364.87	364.8	364.86	8572.0
2021-07-30 19:00:00	QQQ	ETF	364.88	365.0	364.81	365.0	9985.0
2021-07-30 04:00:00	IWM	ETF	221.09	222.13	220.9	221.88	16101.0
2021-07-30 05:00:00	IWM	ETF	221.82	221.85	221.3	221.4	21589.0
2021-07-30 06:00:00	IWM	ETF	221.48	221.81	221.24	221.81	12891.0
2021-07-30 07:00:00	IWM	ETF	221.78	221.78	221.16	221.29	59073.0
2021-07-30 08:00:00	IWM	ETF	221.2801	222.05	220.82	221.71	153420.0
2021-07-30 09:00:00	IWM	ETF	221.63	224.05	221.31	223.6	3081569.0
2021-07-30 10:00:00	IWM	ETF	223.59	223.995	221.76	221.83	3899433.0
2021-07-30 11:00:00	IWM	ETF	221.83	222.33	221.24	221.92	2482211.0
2021-07-30 12:00:00	IWM	ETF	221.92	221.985	221.31	221.395	1474110.0
2021-07-30 13:00:00	IWM	ETF	221.41	221.47	220.935	221.22	1851039.0
2021-07-30 14:00:00	IWM	ETF	221.25	221.39	220.275	220.49	3340535.0
2021-07-30 15:00:00	IWM	ETF	220.48	221.28	220.465	221.06	5712125.0
2021-07-30 16:00:00	IWM	ETF	221.09	221.7	221.0	221.46	1790922.0
2021-07-30 17:00:00	IWM	ETF	221.45	221.45	221.05	221.05	323321.0
2021-07-30 18:00:00	IWM	ETF	221.51	221.51	221.51	221.51	500.0
2021-07-30 19:00:00	IWM	ETF	221.46	221.66	221.38	221.41	3480.0
2021-07-30 04:00:00	DIA	ETF	349.36	350.32	349.36	350.01	8301.0
2021-07-30 05:00:00	DIA	ETF	349.92	349.92	349.69	349.69	1600.0

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

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