PREVIEW / etf_1hour / 2022-08-04

all etf 1-hour files

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

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-04 04:00:00	SPY	ETF	414.45	414.5	413.99	413.99	20953.0
2022-08-04 05:00:00	SPY	ETF	414.08	415.15	414.04	414.95	29730.0
2022-08-04 06:00:00	SPY	ETF	414.96	416.1	414.95	415.55	101547.0
2022-08-04 07:00:00	SPY	ETF	415.46	415.62	414.44	414.44	161470.0
2022-08-04 08:00:00	SPY	ETF	415.2308	416.0204	413.7849	415.28	543751.0
2022-08-04 09:00:00	SPY	ETF	415.24	415.24	413.43	414.48	5073703.0
2022-08-04 10:00:00	SPY	ETF	414.48	415.09	412.44	413.99	6064144.0
2022-08-04 11:00:00	SPY	ETF	414.0	414.44	412.7558	414.3	3761980.0
2022-08-04 12:00:00	SPY	ETF	414.31	414.64	413.054	413.2	2751652.0
2022-08-04 13:00:00	SPY	ETF	413.17	414.665	413.1449	414.18	2772637.0
2022-08-04 14:00:00	SPY	ETF	414.1899	414.51	413.5903	414.21	3155043.0
2022-08-04 15:00:00	SPY	ETF	414.24	415.0	413.59	414.17	6894520.0
2022-08-04 16:00:00	SPY	ETF	414.17	414.59	413.92	414.05	1966975.0
2022-08-04 17:00:00	SPY	ETF	414.08	414.25	414.08	414.11	48297.0
2022-08-04 18:00:00	SPY	ETF	414.1	414.26	413.88	414.18	64781.0
2022-08-04 19:00:00	SPY	ETF	414.2	414.51	414.2	414.23	94834.0
2022-08-04 04:00:00	QQQ	ETF	322.11	322.87	322.11	322.52	62488.0
2022-08-04 05:00:00	QQQ	ETF	322.54	323.49	322.29	323.43	71148.0
2022-08-04 06:00:00	QQQ	ETF	323.58	324.9	323.58	324.54	130578.0
2022-08-04 07:00:00	QQQ	ETF	324.36	324.5	322.86	322.9	470289.0
2022-08-04 08:00:00	QQQ	ETF	323.87	324.68	322.01	323.98	539082.0
2022-08-04 09:00:00	QQQ	ETF	323.94	324.52	322.21	323.7	5723570.0
2022-08-04 10:00:00	QQQ	ETF	323.74	324.37	320.77	322.48	5993440.0
2022-08-04 11:00:00	QQQ	ETF	322.47	323.359	321.11	323.19	4081378.0
2022-08-04 12:00:00	QQQ	ETF	323.21	323.9261	322.21	322.3302	2999848.0
2022-08-04 13:00:00	QQQ	ETF	322.3391	323.98	322.32	323.53	2007989.0
2022-08-04 14:00:00	QQQ	ETF	323.54	324.165	322.885	323.926	2152777.0
2022-08-04 15:00:00	QQQ	ETF	323.92	324.72	323.37	324.325	4822349.0
2022-08-04 16:00:00	QQQ	ETF	324.33	324.65	323.6	324.25	805967.0
2022-08-04 17:00:00	QQQ	ETF	324.29	324.4	324.12	324.4	407057.0
2022-08-04 18:00:00	QQQ	ETF	324.2	324.42	324.03	324.35	36462.0
2022-08-04 19:00:00	QQQ	ETF	324.3	324.64	324.3	324.4196	75101.0
2022-08-04 04:00:00	IWM	ETF	189.81	189.95	189.68	189.7	14159.0
2022-08-04 05:00:00	IWM	ETF	189.73	190.44	189.6	190.33	9594.0
2022-08-04 06:00:00	IWM	ETF	190.35	190.76	190.35	190.51	26218.0
2022-08-04 07:00:00	IWM	ETF	190.43	190.45	190.04	190.04	24761.0
2022-08-04 08:00:00	IWM	ETF	190.4804	190.4804	189.83	190.32	70536.0
2022-08-04 09:00:00	IWM	ETF	190.31	190.31	188.77	189.67	2126938.0
2022-08-04 10:00:00	IWM	ETF	189.69	190.01	188.68	189.22	1940442.0
2022-08-04 11:00:00	IWM	ETF	189.23	189.43	188.44	189.08	1294254.0
2022-08-04 12:00:00	IWM	ETF	189.08	189.4	188.69	189.05	752830.0
2022-08-04 13:00:00	IWM	ETF	189.04	189.88	189.04	189.67	983809.0
2022-08-04 14:00:00	IWM	ETF	189.64	189.74	189.24	189.57	727832.0
2022-08-04 15:00:00	IWM	ETF	189.57	189.89	189.13	189.42	2463638.0
2022-08-04 16:00:00	IWM	ETF	189.35	189.75	189.35	189.51	870313.0
2022-08-04 17:00:00	IWM	ETF	189.45	189.61	189.35	189.35	56269.0
2022-08-04 18:00:00	IWM	ETF	189.54	189.57	189.4	189.47	21732.0
2022-08-04 19:00:00	IWM	ETF	189.52	189.73	189.52	189.59	16487.0
2022-08-04 04:00:00	DIA	ETF	328.24	328.27	327.91	327.92	3300.0
2022-08-04 05:00:00	DIA	ETF	328.07	328.54	328.07	328.39	4200.0

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

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