PREVIEW / etf_1hour / 2023-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-17.parquet
  size:    471 KB
  rows:    17,106

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-17 04:00:00	SPY	ETF	413.32	413.51	413.0	413.04	47138.0
2023-04-17 05:00:00	SPY	ETF	413.08	413.21	412.63	412.81	33500.0
2023-04-17 06:00:00	SPY	ETF	412.81	413.07	412.73	413.04	9470.0
2023-04-17 07:00:00	SPY	ETF	412.99	413.21	412.71	413.06	118535.0
2023-04-17 08:00:00	SPY	ETF	413.0219	413.74	412.47	412.6	452467.0
2023-04-17 09:00:00	SPY	ETF	412.61	413.19	412.21	412.6786	5225800.0
2023-04-17 10:00:00	SPY	ETF	412.685	413.175	411.9301	412.3401	7428459.0
2023-04-17 11:00:00	SPY	ETF	412.35	412.69	411.21	411.67	6549261.0
2023-04-17 12:00:00	SPY	ETF	411.68	412.0	411.26	411.7699	4167831.0
2023-04-17 13:00:00	SPY	ETF	411.76	412.12	411.23	411.3234	4219881.0
2023-04-17 14:00:00	SPY	ETF	411.3201	412.81	411.085	412.7	6027793.0
2023-04-17 15:00:00	SPY	ETF	412.7	413.96	412.7	413.94	13793850.0
2023-04-17 16:00:00	SPY	ETF	413.94	414.29	413.88	413.95	3109335.0
2023-04-17 17:00:00	SPY	ETF	413.9	414.0	413.83	413.87	67797.0
2023-04-17 18:00:00	SPY	ETF	413.87	413.92	413.75	413.8657	41288.0
2023-04-17 19:00:00	SPY	ETF	413.88	413.96	413.8	413.88	57743.0
2023-04-17 04:00:00	QQQ	ETF	319.24	319.36	318.67	318.8	44290.0
2023-04-17 05:00:00	QQQ	ETF	318.82	318.86	318.03	318.24	25709.0
2023-04-17 06:00:00	QQQ	ETF	318.17	318.88	318.17	318.76	28984.0
2023-04-17 07:00:00	QQQ	ETF	318.78	319.09	318.32	318.57	84684.0
2023-04-17 08:00:00	QQQ	ETF	318.83	319.2404	318.1	318.48	327062.0
2023-04-17 09:00:00	QQQ	ETF	318.53	319.1999	317.66	318.1499	4914324.0
2023-04-17 10:00:00	QQQ	ETF	318.14	318.88	316.93	317.58	5614939.0
2023-04-17 11:00:00	QQQ	ETF	317.59	317.915	316.35	316.7305	4377324.0
2023-04-17 12:00:00	QQQ	ETF	316.73	316.96	316.04	316.91	3516843.0
2023-04-17 13:00:00	QQQ	ETF	316.9	317.36	316.51	316.59	2501083.0
2023-04-17 14:00:00	QQQ	ETF	316.59	317.79	316.43	317.7	2736627.0
2023-04-17 15:00:00	QQQ	ETF	317.71	318.835	317.71	318.785	6777866.0
2023-04-17 16:00:00	QQQ	ETF	318.78	318.95	318.55	318.6	2043485.0
2023-04-17 17:00:00	QQQ	ETF	318.66	318.79	318.6148	318.7	43723.0
2023-04-17 18:00:00	QQQ	ETF	318.64	318.65	318.47	318.59	41139.0
2023-04-17 19:00:00	QQQ	ETF	318.63	318.66	318.43	318.5	40073.0
2023-04-17 04:00:00	IWM	ETF	177.35	177.44	177.24	177.36	7912.0
2023-04-17 05:00:00	IWM	ETF	177.49	177.49	177.25	177.41	6253.0
2023-04-17 06:00:00	IWM	ETF	177.37	177.37	177.29	177.3	3819.0
2023-04-17 07:00:00	IWM	ETF	177.34	177.44	177.22	177.4	15960.0
2023-04-17 08:00:00	IWM	ETF	177.38	177.59	176.97	177.12	70334.0
2023-04-17 09:00:00	IWM	ETF	177.16	177.94	176.75	177.595	2302208.0
2023-04-17 10:00:00	IWM	ETF	177.59	178.11	177.31	177.895	2490434.0
2023-04-17 11:00:00	IWM	ETF	177.895	178.2	177.32	177.575	2045613.0
2023-04-17 12:00:00	IWM	ETF	177.575	177.77	177.3417	177.56	1303964.0
2023-04-17 13:00:00	IWM	ETF	177.565	177.86	177.13	177.23	1020931.0
2023-04-17 14:00:00	IWM	ETF	177.23	178.16	177.13	178.13	2031236.0
2023-04-17 15:00:00	IWM	ETF	178.14	178.86	178.14	178.77	4867038.0
2023-04-17 16:00:00	IWM	ETF	178.78	179.03	178.77	178.79	717553.0
2023-04-17 17:00:00	IWM	ETF	178.83	178.98	178.79	178.85	35648.0
2023-04-17 18:00:00	IWM	ETF	178.79	178.85	178.72	178.77	9569.0
2023-04-17 19:00:00	IWM	ETF	178.84	178.84	178.72	178.76	21614.0
2023-04-17 06:00:00	DIA	ETF	339.15	339.15	339.15	339.15	295.0
2023-04-17 07:00:00	DIA	ETF	339.25	339.29	339.06	339.17	5034.0

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

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