PREVIEW / etf_1hour / 2022-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-05.parquet
  size:    443 KB
  rows:    15,982

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
2022-08-05 04:00:00	SPY	ETF	414.54	414.69	414.0	414.04	7386.0
2022-08-05 05:00:00	SPY	ETF	413.99	414.31	413.92	414.28	11747.0
2022-08-05 06:00:00	SPY	ETF	414.12	414.13	413.65	413.72	23646.0
2022-08-05 07:00:00	SPY	ETF	413.94	414.63	413.51	414.6	204518.0
2022-08-05 08:00:00	SPY	ETF	414.6	415.08	409.24	409.78	2234032.0
2022-08-05 09:00:00	SPY	ETF	409.74	412.23	409.42	412.05	6469076.0
2022-08-05 10:00:00	SPY	ETF	412.05	414.15	411.81	413.0305	6558548.0
2022-08-05 11:00:00	SPY	ETF	413.05	413.08	410.08	410.655	6453872.0
2022-08-05 12:00:00	SPY	ETF	410.66	412.58	410.64	412.49	4670515.0
2022-08-05 13:00:00	SPY	ETF	412.47	413.47	412.23	412.53	3714679.0
2022-08-05 14:00:00	SPY	ETF	412.529	412.67	411.43	412.015	4561145.0
2022-08-05 15:00:00	SPY	ETF	412.0	413.71	411.81	413.43	8110898.0
2022-08-05 16:00:00	SPY	ETF	413.45	413.47	412.85	413.02	2322044.0
2022-08-05 17:00:00	SPY	ETF	412.99	413.16	412.99	412.99	82785.0
2022-08-05 18:00:00	SPY	ETF	412.96	413.1	412.95	413.07	18438.0
2022-08-05 19:00:00	SPY	ETF	413.04	413.1	412.11	412.95	31789.0
2022-08-05 04:00:00	QQQ	ETF	324.91	325.03	323.96	324.18	41389.0
2022-08-05 05:00:00	QQQ	ETF	324.19	324.45	323.88	324.14	8934.0
2022-08-05 06:00:00	QQQ	ETF	323.98	323.98	323.5	323.59	28677.0
2022-08-05 07:00:00	QQQ	ETF	323.85	324.49	323.4	324.47	165136.0
2022-08-05 08:00:00	QQQ	ETF	323.88	325.47	319.22	319.67	2829268.0
2022-08-05 09:00:00	QQQ	ETF	319.6	321.43	318.95	320.76	6607076.0
2022-08-05 10:00:00	QQQ	ETF	320.75	323.83	320.37	321.86	6862685.0
2022-08-05 11:00:00	QQQ	ETF	321.85	321.87	318.39	319.3	7411199.0
2022-08-05 12:00:00	QQQ	ETF	319.31	321.2218	319.26	321.1401	4407797.0
2022-08-05 13:00:00	QQQ	ETF	321.16	322.179	320.63	320.97	3498401.0
2022-08-05 14:00:00	QQQ	ETF	320.97	321.11	319.84	320.33	3667854.0
2022-08-05 15:00:00	QQQ	ETF	320.345	322.05	320.13	321.8	4887249.0
2022-08-05 16:00:00	QQQ	ETF	321.79	323.4194	320.512	321.54	2091709.0
2022-08-05 17:00:00	QQQ	ETF	321.59	321.7	321.5	321.5	39123.0
2022-08-05 18:00:00	QQQ	ETF	321.45	321.64	321.42	321.5	8713.0
2022-08-05 19:00:00	QQQ	ETF	321.45	321.45	321.25	321.32	9574.0
2022-08-05 04:00:00	IWM	ETF	189.73	189.73	189.34	189.34	4808.0
2022-08-05 05:00:00	IWM	ETF	189.4	189.56	189.33	189.53	19695.0
2022-08-05 06:00:00	IWM	ETF	189.49	189.59	189.35	189.38	14762.0
2022-08-05 07:00:00	IWM	ETF	189.48	189.76	189.27	189.73	39806.0
2022-08-05 08:00:00	IWM	ETF	189.37	189.95	187.32	187.53	368736.0
2022-08-05 09:00:00	IWM	ETF	187.52	189.35	187.1703	189.19	2675075.0
2022-08-05 10:00:00	IWM	ETF	189.19	190.69	189.03	190.2102	2928228.0
2022-08-05 11:00:00	IWM	ETF	190.24	190.27	188.29	189.17	1898965.0
2022-08-05 12:00:00	IWM	ETF	189.16	190.64	189.16	190.58	1154340.0
2022-08-05 13:00:00	IWM	ETF	190.58	190.84	190.23	190.44	1015742.0
2022-08-05 14:00:00	IWM	ETF	190.44	190.54	189.91	190.24	983723.0
2022-08-05 15:00:00	IWM	ETF	190.25	191.02	190.15	190.79	2374135.0
2022-08-05 16:00:00	IWM	ETF	190.8	190.85	190.52	190.57	1118419.0
2022-08-05 17:00:00	IWM	ETF	190.6	190.63	190.46	190.46	37172.0
2022-08-05 18:00:00	IWM	ETF	190.55	190.69	190.48	190.64	7299.0
2022-08-05 19:00:00	IWM	ETF	190.65	190.65	190.43	190.57	9727.0
2022-08-05 04:00:00	DIA	ETF	327.54	327.54	327.54	327.54	100.0
2022-08-05 05:00:00	DIA	ETF	327.56	327.57	327.5	327.57	1229.0

> showing 50 of 15,982 rows — these rows as CSV

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