PREVIEW / etf_1hour / 2021-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-03.parquet
  size:    414 KB
  rows:    14,340

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-08-03 04:00:00	SPY	ETF	438.25	439.11	438.25	438.95	43557.0
2021-08-03 05:00:00	SPY	ETF	439.05	439.17	438.69	439.07	10077.0
2021-08-03 06:00:00	SPY	ETF	439.07	439.26	439.06	439.18	17893.0
2021-08-03 07:00:00	SPY	ETF	439.19	439.24	438.94	439.16	71020.0
2021-08-03 08:00:00	SPY	ETF	439.0101	439.2	438.1	438.72	305237.0
2021-08-03 09:00:00	SPY	ETF	438.69	438.72	436.32	436.4	5521960.0
2021-08-03 10:00:00	SPY	ETF	436.4	438.14	436.1	437.4611	8689444.0
2021-08-03 11:00:00	SPY	ETF	437.46	439.84	437.04	439.7481	8189372.0
2021-08-03 12:00:00	SPY	ETF	439.745	439.84	439.063	439.8	4148212.0
2021-08-03 13:00:00	SPY	ETF	439.8	440.29	439.795	440.2	3003499.0
2021-08-03 14:00:00	SPY	ETF	440.2	440.64	439.86	440.4608	4169254.0
2021-08-03 15:00:00	SPY	ETF	440.46	441.28	440.46	441.12	11649195.0
2021-08-03 16:00:00	SPY	ETF	441.11	441.17	440.45	440.48	2559831.0
2021-08-03 17:00:00	SPY	ETF	440.55	441.15	440.4	440.53	83278.0
2021-08-03 18:00:00	SPY	ETF	440.53	440.76	440.53	440.57	74720.0
2021-08-03 19:00:00	SPY	ETF	440.5	440.52	440.35	440.4	29387.0
2021-08-03 04:00:00	QQQ	ETF	365.27	365.33	365.15	365.33	17141.0
2021-08-03 05:00:00	QQQ	ETF	365.29	365.29	364.66	364.92	39078.0
2021-08-03 06:00:00	QQQ	ETF	364.88	365.17	364.83	364.97	21918.0
2021-08-03 07:00:00	QQQ	ETF	364.96	365.15	364.71	365.08	89094.0
2021-08-03 08:00:00	QQQ	ETF	364.7999	365.33	364.6	365.33	118899.0
2021-08-03 09:00:00	QQQ	ETF	365.35	365.86	363.3199	363.35	4102721.0
2021-08-03 10:00:00	QQQ	ETF	363.35	364.18	362.32	363.44	6292534.0
2021-08-03 11:00:00	QQQ	ETF	363.43	366.08	362.0	365.91	5350328.0
2021-08-03 12:00:00	QQQ	ETF	365.92	366.17	365.16	366.16	3180775.0
2021-08-03 13:00:00	QQQ	ETF	366.17	366.549	365.93	366.14	1833678.0
2021-08-03 14:00:00	QQQ	ETF	366.16	366.598	365.53	366.2701	1936575.0
2021-08-03 15:00:00	QQQ	ETF	366.28	366.93	366.125	366.77	4721229.0
2021-08-03 16:00:00	QQQ	ETF	366.77	366.88	366.45	366.53	747005.0
2021-08-03 17:00:00	QQQ	ETF	366.53	366.81	366.4	366.7	39000.0
2021-08-03 18:00:00	QQQ	ETF	366.64	366.78	366.55	366.59	54378.0
2021-08-03 19:00:00	QQQ	ETF	366.58	366.59	366.35	366.42	65415.0
2021-08-03 04:00:00	IWM	ETF	221.24	221.3	221.09	221.09	14453.0
2021-08-03 05:00:00	IWM	ETF	221.36	221.64	221.17	221.46	17799.0
2021-08-03 06:00:00	IWM	ETF	221.54	221.65	221.4	221.58	12702.0
2021-08-03 07:00:00	IWM	ETF	221.7	221.7	221.43	221.65	68853.0
2021-08-03 08:00:00	IWM	ETF	221.67	221.69	220.6	220.93	151988.0
2021-08-03 09:00:00	IWM	ETF	220.93	221.12	217.665	218.24	3271792.0
2021-08-03 10:00:00	IWM	ETF	218.24	219.39	217.1	218.41	5736365.0
2021-08-03 11:00:00	IWM	ETF	218.41	220.31	218.27	219.92	2973640.0
2021-08-03 12:00:00	IWM	ETF	219.92	220.23	219.41	219.9	1484864.0
2021-08-03 13:00:00	IWM	ETF	219.91	220.41	219.6	220.27	2090011.0
2021-08-03 14:00:00	IWM	ETF	220.27	221.06	219.87	220.59	2184677.0
2021-08-03 15:00:00	IWM	ETF	220.61	220.94	220.3	220.9	4507154.0
2021-08-03 16:00:00	IWM	ETF	220.9	220.91	220.25	220.45	1009379.0
2021-08-03 17:00:00	IWM	ETF	220.32	220.57	220.27	220.45	2660.0
2021-08-03 18:00:00	IWM	ETF	220.33	220.5	220.2	220.23	55794.0
2021-08-03 19:00:00	IWM	ETF	220.23	220.23	219.97	219.98	52186.0
2021-08-03 04:00:00	DIA	ETF	349.72	349.72	349.72	349.72	100.0
2021-08-03 06:00:00	DIA	ETF	349.88	349.98	349.85	349.98	1400.0

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

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