PREVIEW / etf_1hour / 2023-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-14.parquet
  size:    470 KB
  rows:    17,190

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
2023-02-14 04:00:00	SPY	ETF	412.66	413.65	412.61	413.3	25614.0
2023-02-14 05:00:00	SPY	ETF	413.25	413.79	413.2	413.59	30013.0
2023-02-14 06:00:00	SPY	ETF	413.63	413.94	413.58	413.6	43127.0
2023-02-14 07:00:00	SPY	ETF	413.6	414.3	413.5	414.12	181158.0
2023-02-14 08:00:00	SPY	ETF	413.6	416.67	411.3	412.6	3304558.0
2023-02-14 09:00:00	SPY	ETF	412.62	413.72	409.49	413.2803	9312758.0
2023-02-14 10:00:00	SPY	ETF	413.29	415.05	409.33	410.53	13994160.0
2023-02-14 11:00:00	SPY	ETF	410.52	411.92	408.511	409.555	9135492.0
2023-02-14 12:00:00	SPY	ETF	409.56	411.25	409.38	411.03	6282568.0
2023-02-14 13:00:00	SPY	ETF	411.05	413.55	410.95	412.45	7366106.0
2023-02-14 14:00:00	SPY	ETF	412.45	413.65	411.23	413.16	5980957.0
2023-02-14 15:00:00	SPY	ETF	413.18	413.7	412.4	412.67	12865490.0
2023-02-14 16:00:00	SPY	ETF	412.66	412.76	412.0	412.2	2903126.0
2023-02-14 17:00:00	SPY	ETF	412.33	412.64	412.2	412.22	384070.0
2023-02-14 18:00:00	SPY	ETF	412.28	412.29	411.75	411.96	64985.0
2023-02-14 19:00:00	SPY	ETF	411.94	411.97	411.49	411.57	91852.0
2023-02-14 04:00:00	QQQ	ETF	304.89	305.26	304.22	305.07	42031.0
2023-02-14 05:00:00	QQQ	ETF	305.01	305.76	304.93	305.51	16584.0
2023-02-14 06:00:00	QQQ	ETF	305.55	305.88	305.35	305.38	56277.0
2023-02-14 07:00:00	QQQ	ETF	305.38	305.989	305.36	305.79	122575.0
2023-02-14 08:00:00	QQQ	ETF	305.7	308.0	302.58	303.95	4779108.0
2023-02-14 09:00:00	QQQ	ETF	303.93	305.99	300.91	305.6	9296264.0
2023-02-14 10:00:00	QQQ	ETF	305.63	307.72	301.7	303.31	10489862.0
2023-02-14 11:00:00	QQQ	ETF	303.3	304.71	301.57	302.79	7097761.0
2023-02-14 12:00:00	QQQ	ETF	302.77	304.33	302.55	304.085	3713060.0
2023-02-14 13:00:00	QQQ	ETF	304.1	306.5	304.02	305.5601	4482211.0
2023-02-14 14:00:00	QQQ	ETF	305.6	306.91	304.42	306.41	4155674.0
2023-02-14 15:00:00	QQQ	ETF	306.435	307.53	305.7803	306.71	5790613.0
2023-02-14 16:00:00	QQQ	ETF	306.71	306.75	306.09	306.42	1668198.0
2023-02-14 17:00:00	QQQ	ETF	306.42	306.57	306.21	306.56	39202.0
2023-02-14 18:00:00	QQQ	ETF	306.51	306.51	306.12	306.2	59297.0
2023-02-14 19:00:00	QQQ	ETF	306.13	306.14	305.72	305.8	78638.0
2023-02-14 04:00:00	IWM	ETF	192.43	192.83	192.37	192.58	9134.0
2023-02-14 05:00:00	IWM	ETF	192.61	192.73	192.48	192.68	10624.0
2023-02-14 06:00:00	IWM	ETF	192.83	192.86	192.66	192.67	8924.0
2023-02-14 07:00:00	IWM	ETF	192.69	192.99	192.67	192.99	16495.0
2023-02-14 08:00:00	IWM	ETF	192.69	194.25	191.6	192.21	707947.0
2023-02-14 09:00:00	IWM	ETF	192.3	192.82	190.08	192.595	2613969.0
2023-02-14 10:00:00	IWM	ETF	192.63	193.95	190.58	191.21	3764217.0
2023-02-14 11:00:00	IWM	ETF	191.2	192.13	190.19	190.81	1950752.0
2023-02-14 12:00:00	IWM	ETF	190.7982	191.79	190.78	191.7	1282361.0
2023-02-14 13:00:00	IWM	ETF	191.71	192.98	191.63	192.22	1414371.0
2023-02-14 14:00:00	IWM	ETF	192.24	192.94	191.6	192.76	1152661.0
2023-02-14 15:00:00	IWM	ETF	192.77	193.13	192.34	192.52	2470738.0
2023-02-14 16:00:00	IWM	ETF	192.53	192.54	192.0	192.11	810409.0
2023-02-14 17:00:00	IWM	ETF	192.2	192.35	192.16	192.26	7645.0
2023-02-14 18:00:00	IWM	ETF	192.22	192.23	191.93	192.12	20634.0
2023-02-14 19:00:00	IWM	ETF	192.0	192.02	191.81	191.89	7547.0
2023-02-14 05:00:00	DIA	ETF	342.95	342.95	342.88	342.88	350.0
2023-02-14 07:00:00	DIA	ETF	342.86	343.1	342.77	343.1	2677.0

> showing 50 of 17,190 rows — these rows as CSV

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