PREVIEW / etf_1hour / 2021-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-04.parquet
  size:    417 KB
  rows:    14,586

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-04 04:00:00	SPY	ETF	440.56	440.7	440.38	440.7	3014.0
2021-08-04 05:00:00	SPY	ETF	440.74	440.9	440.66	440.8	5080.0
2021-08-04 06:00:00	SPY	ETF	440.79	441.0	440.72	440.82	6266.0
2021-08-04 07:00:00	SPY	ETF	440.83	440.84	440.27	440.28	110256.0
2021-08-04 08:00:00	SPY	ETF	440.7499	440.84	439.39	439.75	540696.0
2021-08-04 09:00:00	SPY	ETF	439.7	440.196	439.41	439.91	5642077.0
2021-08-04 10:00:00	SPY	ETF	439.93	440.405	439.04	439.42	6603602.0
2021-08-04 11:00:00	SPY	ETF	439.42	439.91	438.73	439.4199	4857543.0
2021-08-04 12:00:00	SPY	ETF	439.41	439.719	439.2	439.57	3109711.0
2021-08-04 13:00:00	SPY	ETF	439.57	440.12	439.56	439.83	2687615.0
2021-08-04 14:00:00	SPY	ETF	439.84	440.28	439.6	439.6943	3946184.0
2021-08-04 15:00:00	SPY	ETF	439.7	439.91	438.97	439.01	7546639.0
2021-08-04 16:00:00	SPY	ETF	439.02	439.27	438.97	439.22	2090244.0
2021-08-04 17:00:00	SPY	ETF	439.44	439.44	439.03	439.18	122149.0
2021-08-04 18:00:00	SPY	ETF	439.18	439.49	438.98	439.45	112390.0
2021-08-04 19:00:00	SPY	ETF	439.41	439.41	439.25	439.33	26500.0
2021-08-04 04:00:00	QQQ	ETF	367.0	367.07	366.69	367.07	24288.0
2021-08-04 05:00:00	QQQ	ETF	366.97	367.11	366.84	366.96	18728.0
2021-08-04 06:00:00	QQQ	ETF	366.97	367.2	366.97	367.01	33713.0
2021-08-04 07:00:00	QQQ	ETF	366.99	367.05	366.48	366.57	63326.0
2021-08-04 08:00:00	QQQ	ETF	366.58	367.25	366.1	366.39	436920.0
2021-08-04 09:00:00	QQQ	ETF	366.38	367.38	366.14	367.06	4174015.0
2021-08-04 10:00:00	QQQ	ETF	367.07	367.26	365.63	366.45	5782652.0
2021-08-04 11:00:00	QQQ	ETF	366.46	367.07	366.01	367.0699	2830597.0
2021-08-04 12:00:00	QQQ	ETF	367.0698	367.38	366.7982	367.27	1665790.0
2021-08-04 13:00:00	QQQ	ETF	367.3	368.2	367.28	367.52	2486324.0
2021-08-04 14:00:00	QQQ	ETF	367.54	368.32	367.401	367.57	2160237.0
2021-08-04 15:00:00	QQQ	ETF	367.57	368.04	367.2201	367.34	3372690.0
2021-08-04 16:00:00	QQQ	ETF	367.35	367.64	367.32	367.6104	513992.0
2021-08-04 17:00:00	QQQ	ETF	367.52	367.52	367.31	367.41	12302.0
2021-08-04 18:00:00	QQQ	ETF	367.48	367.79	367.47	367.79	57262.0
2021-08-04 19:00:00	QQQ	ETF	367.69	367.8	367.6	367.65	58776.0
2021-08-04 04:00:00	IWM	ETF	220.3	220.5	220.2	220.36	4040.0
2021-08-04 05:00:00	IWM	ETF	220.4	220.57	220.34	220.57	7577.0
2021-08-04 06:00:00	IWM	ETF	220.41	220.64	220.41	220.53	7687.0
2021-08-04 07:00:00	IWM	ETF	220.49	220.49	219.63	219.63	43769.0
2021-08-04 08:00:00	IWM	ETF	220.2	220.87	218.45	218.86	351593.0
2021-08-04 09:00:00	IWM	ETF	218.82	220.13	218.54	219.18	4304852.0
2021-08-04 10:00:00	IWM	ETF	219.18	221.2	219.14	220.01	4591295.0
2021-08-04 11:00:00	IWM	ETF	220.03	220.8017	218.46	218.59	2548154.0
2021-08-04 12:00:00	IWM	ETF	218.57	220.0	218.06	218.45	2718899.0
2021-08-04 13:00:00	IWM	ETF	218.45	218.85	218.24	218.78	1471738.0
2021-08-04 14:00:00	IWM	ETF	218.78	218.97	217.89	218.41	1594034.0
2021-08-04 15:00:00	IWM	ETF	218.42	218.57	218.0	218.08	2958632.0
2021-08-04 16:00:00	IWM	ETF	218.11	218.23	217.81	218.04	1429600.0
2021-08-04 17:00:00	IWM	ETF	218.2	218.2	217.9	217.96	19859.0
2021-08-04 18:00:00	IWM	ETF	218.05	218.3	218.05	218.27	43865.0
2021-08-04 19:00:00	IWM	ETF	218.26	218.28	218.1	218.25	53902.0
2021-08-04 04:00:00	DIA	ETF	350.46	350.46	350.4	350.4	1100.0
2021-08-04 05:00:00	DIA	ETF	350.7	350.7	350.7	350.7	100.0

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

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