PREVIEW / etf_1hour / 2023-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-14.parquet
  size:    464 KB
  rows:    16,817

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-04-14 04:00:00	SPY	ETF	413.28	413.28	412.66	412.79	19978.0
2023-04-14 05:00:00	SPY	ETF	412.69	412.96	412.65	412.86	17447.0
2023-04-14 06:00:00	SPY	ETF	412.75	413.24	412.42	413.1	113434.0
2023-04-14 07:00:00	SPY	ETF	413.07	413.68	412.98	413.27	513321.0
2023-04-14 08:00:00	SPY	ETF	413.2508	413.999	412.41	412.91	695463.0
2023-04-14 09:00:00	SPY	ETF	412.84	415.09	412.52	414.8264	7065598.0
2023-04-14 10:00:00	SPY	ETF	414.79	414.97	411.71	412.22	12065140.0
2023-04-14 11:00:00	SPY	ETF	412.24	412.46	411.27	411.7714	6533472.0
2023-04-14 12:00:00	SPY	ETF	411.785	411.85	410.13	410.35	7040809.0
2023-04-14 13:00:00	SPY	ETF	410.35	411.54	410.06	411.02	6129746.0
2023-04-14 14:00:00	SPY	ETF	411.03	412.19	410.69	412.0821	6054974.0
2023-04-14 15:00:00	SPY	ETF	412.09	412.785	410.65	412.49	12593592.0
2023-04-14 16:00:00	SPY	ETF	412.49	413.7	412.46	413.36	3198027.0
2023-04-14 17:00:00	SPY	ETF	413.47	413.47	412.92	413.0	204423.0
2023-04-14 18:00:00	SPY	ETF	413.04	413.1	413.0	413.03	5943.0
2023-04-14 19:00:00	SPY	ETF	413.08	413.15	413.05	413.15	11542.0
2023-04-14 04:00:00	QQQ	ETF	318.86	319.27	318.57	318.63	14265.0
2023-04-14 05:00:00	QQQ	ETF	318.6	318.64	318.14	318.14	14716.0
2023-04-14 06:00:00	QQQ	ETF	318.25	318.35	317.15	317.54	142938.0
2023-04-14 07:00:00	QQQ	ETF	317.53	317.89	317.32	317.67	267473.0
2023-04-14 08:00:00	QQQ	ETF	317.49	319.409	316.62	317.15	1045936.0
2023-04-14 09:00:00	QQQ	ETF	317.11	320.26	317.0	319.88	5734622.0
2023-04-14 10:00:00	QQQ	ETF	319.81	320.36	317.01	317.65	8427690.0
2023-04-14 11:00:00	QQQ	ETF	317.66	318.32	316.88	317.3294	4552013.0
2023-04-14 12:00:00	QQQ	ETF	317.33	317.34	315.61	315.925	3609491.0
2023-04-14 13:00:00	QQQ	ETF	315.92	316.988	315.69	316.83	3586826.0
2023-04-14 14:00:00	QQQ	ETF	316.84	318.37	316.51	318.26	4828443.0
2023-04-14 15:00:00	QQQ	ETF	318.27	318.825	316.97	318.57	8448613.0
2023-04-14 16:00:00	QQQ	ETF	318.57	319.31	318.49	319.0	1283834.0
2023-04-14 17:00:00	QQQ	ETF	318.99	319.03	318.73	318.73	66756.0
2023-04-14 18:00:00	QQQ	ETF	318.88	318.98	318.84	318.85	13590.0
2023-04-14 19:00:00	QQQ	ETF	318.85	318.94	318.85	318.9	7195.0
2023-04-14 04:00:00	IWM	ETF	177.93	177.93	177.67	177.78	4454.0
2023-04-14 05:00:00	IWM	ETF	177.73	177.89	177.72	177.85	5018.0
2023-04-14 06:00:00	IWM	ETF	177.83	178.45	177.65	178.41	90964.0
2023-04-14 07:00:00	IWM	ETF	178.44	179.02	178.29	178.55	145234.0
2023-04-14 08:00:00	IWM	ETF	178.35	179.25	177.89	178.49	335462.0
2023-04-14 09:00:00	IWM	ETF	178.45	179.22	178.01	179.08	1882720.0
2023-04-14 10:00:00	IWM	ETF	179.07	179.19	176.8701	177.25	3662119.0
2023-04-14 11:00:00	IWM	ETF	177.26	177.28	175.9	176.25	2582663.0
2023-04-14 12:00:00	IWM	ETF	176.25	176.31	175.55	175.8	1977145.0
2023-04-14 13:00:00	IWM	ETF	175.8	176.21	175.34	175.76	2028735.0
2023-04-14 14:00:00	IWM	ETF	175.77	176.27	175.57	176.07	1980441.0
2023-04-14 15:00:00	IWM	ETF	176.07	176.61	175.44	176.52	5485204.0
2023-04-14 16:00:00	IWM	ETF	176.51	177.13	176.49	177.07	1754417.0
2023-04-14 17:00:00	IWM	ETF	176.97	177.0	176.73	176.75	18768.0
2023-04-14 18:00:00	IWM	ETF	176.84	176.84	176.75	176.77	3655.0
2023-04-14 19:00:00	IWM	ETF	176.76	176.94	176.74	176.93	3928.0
2023-04-14 04:00:00	DIA	ETF	339.56	339.61	339.56	339.61	1100.0
2023-04-14 06:00:00	DIA	ETF	339.69	340.13	339.62	340.13	3150.0

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

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