PREVIEW / etf_1hour / 2022-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-22.parquet
  size:    456 KB
  rows:    16,644

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-22 04:00:00	SPY	ETF	419.97	419.97	417.1	417.58	52510.0
2022-08-22 05:00:00	SPY	ETF	417.42	417.7	416.77	417.35	41662.0
2022-08-22 06:00:00	SPY	ETF	417.31	417.86	417.29	417.66	59982.0
2022-08-22 07:00:00	SPY	ETF	417.68	418.04	417.31	417.65	308771.0
2022-08-22 08:00:00	SPY	ETF	417.8	421.13	416.8396	417.09	501548.0
2022-08-22 09:00:00	SPY	ETF	417.08	417.41	415.63	416.19	6511485.0
2022-08-22 10:00:00	SPY	ETF	416.21	416.46	414.36	414.38	7977058.0
2022-08-22 11:00:00	SPY	ETF	414.385	415.75	414.341	415.45	4820958.0
2022-08-22 12:00:00	SPY	ETF	415.46	415.75	414.69	415.1699	3350205.0
2022-08-22 13:00:00	SPY	ETF	415.15	415.22	413.2782	413.3692	5073960.0
2022-08-22 14:00:00	SPY	ETF	413.37	413.59	412.54	412.87	5383662.0
2022-08-22 15:00:00	SPY	ETF	412.87	413.76	412.4	413.46	15200145.0
2022-08-22 16:00:00	SPY	ETF	413.45	413.88	413.2193	413.86	3740894.0
2022-08-22 17:00:00	SPY	ETF	413.65	413.91	413.65	413.9	35215.0
2022-08-22 18:00:00	SPY	ETF	413.9	414.19	413.59	414.06	57400.0
2022-08-22 19:00:00	SPY	ETF	414.06	414.48	414.01	414.39	62965.0
2022-08-22 04:00:00	QQQ	ETF	320.8	321.6	317.9	318.22	124649.0
2022-08-22 05:00:00	QQQ	ETF	318.09	318.35	317.68	318.2	51439.0
2022-08-22 06:00:00	QQQ	ETF	318.19	318.76	318.14	318.39	55688.0
2022-08-22 07:00:00	QQQ	ETF	318.39	318.67	317.85	318.27	307512.0
2022-08-22 08:00:00	QQQ	ETF	318.2501	323.102	317.79	318.08	513547.0
2022-08-22 09:00:00	QQQ	ETF	318.1	318.74	316.7	317.23	6293914.0
2022-08-22 10:00:00	QQQ	ETF	317.23	317.3	315.35	315.36	5943300.0
2022-08-22 11:00:00	QQQ	ETF	315.37	316.52	315.22	316.3001	4443863.0
2022-08-22 12:00:00	QQQ	ETF	316.33	316.55	315.58	316.0	2210620.0
2022-08-22 13:00:00	QQQ	ETF	315.9899	316.04	314.61	314.68	3237447.0
2022-08-22 14:00:00	QQQ	ETF	314.69	315.01	313.84	314.19	4193324.0
2022-08-22 15:00:00	QQQ	ETF	314.18	314.8079	313.53	314.47	8656180.0
2022-08-22 16:00:00	QQQ	ETF	314.47	315.02	314.29	314.94	1522129.0
2022-08-22 17:00:00	QQQ	ETF	314.97	315.08	314.88	314.92	118218.0
2022-08-22 18:00:00	QQQ	ETF	315.0	315.17	314.7	315.07	73404.0
2022-08-22 19:00:00	QQQ	ETF	315.02	315.47	315.02	315.43	71345.0
2022-08-22 04:00:00	IWM	ETF	193.5	193.5	192.0	192.44	67849.0
2022-08-22 05:00:00	IWM	ETF	192.35	192.55	192.01	192.45	21346.0
2022-08-22 06:00:00	IWM	ETF	192.39	192.74	192.37	192.74	165842.0
2022-08-22 07:00:00	IWM	ETF	192.69	192.89	192.49	192.65	62513.0
2022-08-22 08:00:00	IWM	ETF	192.66	193.9	192.31	192.44	133115.0
2022-08-22 09:00:00	IWM	ETF	192.4	192.5	191.16	191.905	3099117.0
2022-08-22 10:00:00	IWM	ETF	191.91	191.95	190.71	190.88	2713197.0
2022-08-22 11:00:00	IWM	ETF	190.89	191.7901	190.84	191.55	1177505.0
2022-08-22 12:00:00	IWM	ETF	191.55	191.7	191.1	191.315	869789.0
2022-08-22 13:00:00	IWM	ETF	191.315	191.34	190.26	190.29	1207207.0
2022-08-22 14:00:00	IWM	ETF	190.29	190.36	190.03	190.24	1467777.0
2022-08-22 15:00:00	IWM	ETF	190.235	190.68	190.01	190.64	4077435.0
2022-08-22 16:00:00	IWM	ETF	190.64	190.91	190.5002	190.88	2449803.0
2022-08-22 17:00:00	IWM	ETF	190.81	190.95	190.74	190.93	11989.0
2022-08-22 18:00:00	IWM	ETF	190.87	191.08	190.7	191.02	24521.0
2022-08-22 19:00:00	IWM	ETF	191.04	191.23	190.95	191.22	33267.0
2022-08-22 04:00:00	DIA	ETF	334.26	334.26	333.93	334.2	500.0
2022-08-22 05:00:00	DIA	ETF	334.25	334.25	333.85	333.85	300.0

> showing 50 of 16,644 rows — these rows as CSV

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