PREVIEW / etf_1hour / 2021-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-28.parquet
  size:    414 KB
  rows:    14,454

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-28 04:00:00	SPY	ETF	439.0	439.95	438.83	439.91	9606.0
2021-07-28 05:00:00	SPY	ETF	439.9	439.9	439.56	439.79	12416.0
2021-07-28 06:00:00	SPY	ETF	439.41	439.41	438.84	439.25	33668.0
2021-07-28 07:00:00	SPY	ETF	439.18	439.56	438.89	439.13	117448.0
2021-07-28 08:00:00	SPY	ETF	439.2599	439.84	438.42	439.38	354661.0
2021-07-28 09:00:00	SPY	ETF	439.42	439.8301	438.11	438.6	4969774.0
2021-07-28 10:00:00	SPY	ETF	438.6	439.58	438.16	439.31	6211683.0
2021-07-28 11:00:00	SPY	ETF	439.31	439.54	438.885	439.2699	4075188.0
2021-07-28 12:00:00	SPY	ETF	439.265	439.34	438.41	438.62	3909399.0
2021-07-28 13:00:00	SPY	ETF	438.63	438.72	437.91	438.2	3367654.0
2021-07-28 14:00:00	SPY	ETF	438.2	440.3	437.31	439.68	8821814.0
2021-07-28 15:00:00	SPY	ETF	439.7	439.9609	438.73	438.79	8742802.0
2021-07-28 16:00:00	SPY	ETF	438.7999	438.9	438.5	438.71	2045894.0
2021-07-28 17:00:00	SPY	ETF	438.74	438.76	438.65	438.75	36801.0
2021-07-28 18:00:00	SPY	ETF	438.8	438.94	438.7	438.89	46089.0
2021-07-28 19:00:00	SPY	ETF	438.76	438.95	438.6	438.93	26940.0
2021-07-28 04:00:00	QQQ	ETF	364.0	365.58	364.0	365.56	65212.0
2021-07-28 05:00:00	QQQ	ETF	365.61	365.62	365.22	365.3	96280.0
2021-07-28 06:00:00	QQQ	ETF	365.36	365.36	364.57	365.07	58408.0
2021-07-28 07:00:00	QQQ	ETF	364.99	365.64	364.82	365.38	185727.0
2021-07-28 08:00:00	QQQ	ETF	365.2496	366.12	363.41	365.73	311775.0
2021-07-28 09:00:00	QQQ	ETF	365.74	366.2	363.24	365.13	6258621.0
2021-07-28 10:00:00	QQQ	ETF	365.12	367.45	365.01	366.57	6668583.0
2021-07-28 11:00:00	QQQ	ETF	366.56	367.12	365.2932	365.8975	3686808.0
2021-07-28 12:00:00	QQQ	ETF	365.8912	366.36	365.36	365.57	2252738.0
2021-07-28 13:00:00	QQQ	ETF	365.585	365.81	364.4	364.975	2594435.0
2021-07-28 14:00:00	QQQ	ETF	364.98	366.635	363.77	365.83	5833728.0
2021-07-28 15:00:00	QQQ	ETF	365.91	366.58	365.57	365.79	4954934.0
2021-07-28 16:00:00	QQQ	ETF	365.79	366.3	364.96	365.22	1234457.0
2021-07-28 17:00:00	QQQ	ETF	365.15	365.83	365.0	365.14	41681.0
2021-07-28 18:00:00	QQQ	ETF	365.19	365.36	365.18	365.25	52957.0
2021-07-28 19:00:00	QQQ	ETF	365.3	365.83	365.05	365.32	171475.0
2021-07-28 04:00:00	IWM	ETF	218.5	219.46	218.41	219.45	31320.0
2021-07-28 05:00:00	IWM	ETF	219.29	219.43	219.17	219.42	3880.0
2021-07-28 06:00:00	IWM	ETF	219.29	219.29	218.6	218.96	4562.0
2021-07-28 07:00:00	IWM	ETF	218.94	219.33	218.63	219.03	86798.0
2021-07-28 08:00:00	IWM	ETF	218.7404	219.3	218.0	218.69	362171.0
2021-07-28 09:00:00	IWM	ETF	218.77	220.23	218.69	219.68	3952629.0
2021-07-28 10:00:00	IWM	ETF	219.69	219.795	217.4	218.53	4389409.0
2021-07-28 11:00:00	IWM	ETF	218.55	220.11	218.34	220.01	2907579.0
2021-07-28 12:00:00	IWM	ETF	220.0	220.43	219.55	219.79	2981684.0
2021-07-28 13:00:00	IWM	ETF	219.79	220.3	219.675	219.765	1812855.0
2021-07-28 14:00:00	IWM	ETF	219.77	222.59	219.49	221.965	4990312.0
2021-07-28 15:00:00	IWM	ETF	221.965	222.44	220.85	220.89	5197701.0
2021-07-28 16:00:00	IWM	ETF	220.82	221.76	220.82	221.19	1101719.0
2021-07-28 17:00:00	IWM	ETF	221.28	221.29	220.82	221.29	34202.0
2021-07-28 18:00:00	IWM	ETF	221.24	221.39	221.24	221.36	10605.0
2021-07-28 19:00:00	IWM	ETF	220.82	221.41	220.82	221.34	103370.0
2021-07-28 05:00:00	DIA	ETF	350.53	350.53	350.53	350.53	200.0
2021-07-28 06:00:00	DIA	ETF	350.01	350.23	350.01	350.22	2200.0

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

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