PREVIEW / etf_1hour / 2022-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-24.parquet
  size:    439 KB
  rows:    15,801

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-24 04:00:00	SPY	ETF	411.15	412.79	411.13	412.48	66915.0
2022-08-24 05:00:00	SPY	ETF	412.67	412.79	411.98	412.05	81565.0
2022-08-24 06:00:00	SPY	ETF	412.02	412.38	411.79	411.85	93441.0
2022-08-24 07:00:00	SPY	ETF	411.85	413.23	411.85	413.0	193021.0
2022-08-24 08:00:00	SPY	ETF	412.01	413.45	410.86	412.62	489893.0
2022-08-24 09:00:00	SPY	ETF	412.63	412.68	411.39	412.2777	3802081.0
2022-08-24 10:00:00	SPY	ETF	412.28	413.63	411.8786	413.08	5590334.0
2022-08-24 11:00:00	SPY	ETF	413.1	415.1101	412.98	414.7	5064383.0
2022-08-24 12:00:00	SPY	ETF	414.7093	415.0	412.78	413.08	4008588.0
2022-08-24 13:00:00	SPY	ETF	413.08	413.53	412.47	413.08	3163300.0
2022-08-24 14:00:00	SPY	ETF	413.08	413.45	412.7	413.35	3158255.0
2022-08-24 15:00:00	SPY	ETF	413.345	414.46	413.2299	413.63	8822823.0
2022-08-24 16:00:00	SPY	ETF	413.63	414.25	413.46	414.23	2643640.0
2022-08-24 17:00:00	SPY	ETF	414.23	414.25	414.01	414.15	58646.0
2022-08-24 18:00:00	SPY	ETF	414.06	414.3	414.01	414.01	42497.0
2022-08-24 19:00:00	SPY	ETF	414.09	414.24	413.67	413.82	39518.0
2022-08-24 04:00:00	QQQ	ETF	313.09	314.54	313.09	314.27	48228.0
2022-08-24 05:00:00	QQQ	ETF	314.38	314.52	313.84	313.86	41919.0
2022-08-24 06:00:00	QQQ	ETF	313.84	314.09	313.5	313.63	39996.0
2022-08-24 07:00:00	QQQ	ETF	313.64	314.88	313.52	314.71	166171.0
2022-08-24 08:00:00	QQQ	ETF	313.54	315.05	312.5	314.28	511813.0
2022-08-24 09:00:00	QQQ	ETF	314.27	314.52	312.99	314.26	4781237.0
2022-08-24 10:00:00	QQQ	ETF	314.28	315.51	313.61	314.96	5578568.0
2022-08-24 11:00:00	QQQ	ETF	314.96	316.705	314.785	316.37	3639339.0
2022-08-24 12:00:00	QQQ	ETF	316.395	316.87	314.96	315.2536	3332377.0
2022-08-24 13:00:00	QQQ	ETF	315.28	315.69	314.42	315.12	2442423.0
2022-08-24 14:00:00	QQQ	ETF	315.12	315.47	314.53	315.15	2290012.0
2022-08-24 15:00:00	QQQ	ETF	315.13	315.9	314.8	315.02	4389378.0
2022-08-24 16:00:00	QQQ	ETF	315.02	315.73	314.8	315.51	1637160.0
2022-08-24 17:00:00	QQQ	ETF	315.47	315.5	315.12	315.16	86648.0
2022-08-24 18:00:00	QQQ	ETF	315.2	315.53	315.17	315.22	97284.0
2022-08-24 19:00:00	QQQ	ETF	315.22	315.34	314.93	315.0	50272.0
2022-08-24 04:00:00	IWM	ETF	190.24	191.14	190.24	191.06	39601.0
2022-08-24 05:00:00	IWM	ETF	191.06	191.18	190.67	190.69	26350.0
2022-08-24 06:00:00	IWM	ETF	190.75	190.85	190.55	190.55	4328.0
2022-08-24 07:00:00	IWM	ETF	190.63	191.39	190.63	191.31	88158.0
2022-08-24 08:00:00	IWM	ETF	191.26	191.56	190.63	191.07	44270.0
2022-08-24 09:00:00	IWM	ETF	191.08	191.8	190.16	191.58	1815180.0
2022-08-24 10:00:00	IWM	ETF	191.58	192.57	191.32	192.33	1496625.0
2022-08-24 11:00:00	IWM	ETF	192.36	193.3	192.34	192.8309	1627509.0
2022-08-24 12:00:00	IWM	ETF	192.86	193.04	191.81	192.03	1174567.0
2022-08-24 13:00:00	IWM	ETF	192.02	192.49	191.91	192.2038	895647.0
2022-08-24 14:00:00	IWM	ETF	192.205	192.47	192.065	192.43	975347.0
2022-08-24 15:00:00	IWM	ETF	192.425	192.85	192.32	192.43	2243316.0
2022-08-24 16:00:00	IWM	ETF	192.43	192.88	192.41	192.84	798138.0
2022-08-24 17:00:00	IWM	ETF	192.68	192.89	192.68	192.82	21889.0
2022-08-24 18:00:00	IWM	ETF	192.89	192.99	192.75	192.82	22754.0
2022-08-24 19:00:00	IWM	ETF	192.81	192.9	192.63	192.72	18971.0
2022-08-24 06:00:00	DIA	ETF	329.1	329.1	329.1	329.1	300.0
2022-08-24 07:00:00	DIA	ETF	328.78	329.18	328.77	329.11	1600.0

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

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