PREVIEW / etf_1hour / 2023-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-13.parquet
  size:    524 KB
  rows:    19,494

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-12-13 04:00:00	SPY	ETF	464.88	464.92	464.68	464.73	14044.0
2023-12-13 05:00:00	SPY	ETF	464.7	464.78	464.58	464.77	2873.0
2023-12-13 06:00:00	SPY	ETF	464.65	464.9	464.59	464.76	8504.0
2023-12-13 07:00:00	SPY	ETF	464.75	464.82	464.58	464.6	90688.0
2023-12-13 08:00:00	SPY	ETF	464.72	465.36	464.1	465.27	380283.0
2023-12-13 09:00:00	SPY	ETF	465.26	465.3	464.3	464.475	4001869.0
2023-12-13 10:00:00	SPY	ETF	464.475	465.31	464.24	465.15	5044457.0
2023-12-13 11:00:00	SPY	ETF	465.145	465.335	464.61	464.64	3653666.0
2023-12-13 12:00:00	SPY	ETF	464.65	464.705	464.34	464.48	3262433.0
2023-12-13 13:00:00	SPY	ETF	464.495	464.69	464.12	464.42	3992103.0
2023-12-13 14:00:00	SPY	ETF	464.37	470.1	464.37	469.78	22906697.0
2023-12-13 15:00:00	SPY	ETF	469.785	470.7599	468.13	470.44	23443486.0
2023-12-13 16:00:00	SPY	ETF	470.44	473.38	465.0062	470.23	5284862.0
2023-12-13 17:00:00	SPY	ETF	470.2202	470.63	470.13	470.54	259049.0
2023-12-13 18:00:00	SPY	ETF	470.56	471.33	470.46	471.3	270040.0
2023-12-13 19:00:00	SPY	ETF	471.32	472.08	471.32	472.03	250331.0
2023-12-13 04:00:00	QQQ	ETF	399.52	399.61	399.32	399.41	33390.0
2023-12-13 05:00:00	QQQ	ETF	399.37	399.46	399.23	399.36	19533.0
2023-12-13 06:00:00	QQQ	ETF	399.35	399.71	399.34	399.65	14996.0
2023-12-13 07:00:00	QQQ	ETF	399.65	399.73	399.5	399.55	108301.0
2023-12-13 08:00:00	QQQ	ETF	399.71	400.37	398.969	400.14	414066.0
2023-12-13 09:00:00	QQQ	ETF	400.15	400.79	399.36	399.68	4570531.0
2023-12-13 10:00:00	QQQ	ETF	399.68	400.56	399.49	400.1	3290982.0
2023-12-13 11:00:00	QQQ	ETF	400.105	400.38	399.34	399.43	2418880.0
2023-12-13 12:00:00	QQQ	ETF	399.45	399.69	399.1303	399.24	1847868.0
2023-12-13 13:00:00	QQQ	ETF	399.25	399.54	398.8399	399.13	2288382.0
2023-12-13 14:00:00	QQQ	ETF	399.2	404.0	399.2	403.53	13699778.0
2023-12-13 15:00:00	QQQ	ETF	403.54	404.36	401.39	403.76	11655634.0
2023-12-13 16:00:00	QQQ	ETF	403.76	403.89	403.12	403.37	1794977.0
2023-12-13 17:00:00	QQQ	ETF	403.36	404.14	403.36	404.1	305198.0
2023-12-13 18:00:00	QQQ	ETF	404.03	404.73	403.74	404.72	723088.0
2023-12-13 19:00:00	QQQ	ETF	404.68	405.77	403.74	405.77	293261.0
2023-12-13 04:00:00	IWM	ETF	187.15	187.17	186.96	187.14	11374.0
2023-12-13 05:00:00	IWM	ETF	187.03	187.04	186.92	186.94	7434.0
2023-12-13 06:00:00	IWM	ETF	186.94	187.0	186.84	186.9	6878.0
2023-12-13 07:00:00	IWM	ETF	186.92	186.98	186.84	186.95	35745.0
2023-12-13 08:00:00	IWM	ETF	186.9498	187.28	186.86	187.24	126082.0
2023-12-13 09:00:00	IWM	ETF	187.22	187.6	186.59	186.68	2617322.0
2023-12-13 10:00:00	IWM	ETF	186.68	187.43	186.68	187.405	3334799.0
2023-12-13 11:00:00	IWM	ETF	187.41	187.47	186.696	186.81	2100873.0
2023-12-13 12:00:00	IWM	ETF	186.81	186.82	186.215	186.31	2557321.0
2023-12-13 13:00:00	IWM	ETF	186.31	186.33	185.67	186.09	2441867.0
2023-12-13 14:00:00	IWM	ETF	186.07	192.48	186.05	192.27	16899087.0
2023-12-13 15:00:00	IWM	ETF	192.28	193.64	191.37	193.6	20896367.0
2023-12-13 16:00:00	IWM	ETF	193.33	194.02	193.33	193.47	2799109.0
2023-12-13 17:00:00	IWM	ETF	193.47	193.68	193.23	193.59	166746.0
2023-12-13 18:00:00	IWM	ETF	193.59	194.1	193.46	194.09	59125.0
2023-12-13 19:00:00	IWM	ETF	194.09	194.8	194.09	194.49	127632.0
2023-12-13 05:00:00	DIA	ETF	366.84	366.84	366.84	366.84	100.0
2023-12-13 06:00:00	DIA	ETF	367.1	367.1	366.87	366.87	550.0

> showing 50 of 19,494 rows — these rows as CSV

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