PREVIEW / etf_1hour / 2023-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-25.parquet
  size:    477 KB
  rows:    17,269

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-05-25 04:00:00	SPY	ETF	412.59	413.65	412.5	413.63	33118.0
2023-05-25 05:00:00	SPY	ETF	413.8	414.27	413.69	414.17	136867.0
2023-05-25 06:00:00	SPY	ETF	414.17	414.27	413.6	413.6	101955.0
2023-05-25 07:00:00	SPY	ETF	413.56	413.96	413.24	413.95	286582.0
2023-05-25 08:00:00	SPY	ETF	413.55	415.21	412.28	415.0	1023872.0
2023-05-25 09:00:00	SPY	ETF	414.98	415.32	412.59	413.15	8513521.0
2023-05-25 10:00:00	SPY	ETF	413.14	413.97	412.4101	413.73	8919811.0
2023-05-25 11:00:00	SPY	ETF	413.74	414.63	412.59	413.1	9056207.0
2023-05-25 12:00:00	SPY	ETF	413.11	414.55	413.1	413.67	6484796.0
2023-05-25 13:00:00	SPY	ETF	413.69	415.1	413.425	414.9799	4990976.0
2023-05-25 14:00:00	SPY	ETF	414.98	416.16	413.82	414.1199	8668616.0
2023-05-25 15:00:00	SPY	ETF	414.12	415.68	414.06	414.63	15504155.0
2023-05-25 16:00:00	SPY	ETF	414.63	414.77	414.39	414.49	3592019.0
2023-05-25 17:00:00	SPY	ETF	414.52	414.65	414.1	414.3	162061.0
2023-05-25 18:00:00	SPY	ETF	414.3	414.54	413.94	414.2	74341.0
2023-05-25 19:00:00	SPY	ETF	414.2204	414.23	413.85	413.92	38936.0
2023-05-25 04:00:00	QQQ	ETF	336.0	337.46	336.0	337.43	126989.0
2023-05-25 05:00:00	QQQ	ETF	337.48	337.99	337.48	337.98	156232.0
2023-05-25 06:00:00	QQQ	ETF	337.94	338.36	337.62	337.72	111602.0
2023-05-25 07:00:00	QQQ	ETF	337.71	338.55	337.57	338.55	432067.0
2023-05-25 08:00:00	QQQ	ETF	337.7407	339.5	336.1	339.35	1353563.0
2023-05-25 09:00:00	QQQ	ETF	339.34	339.62	336.665	337.27	10264004.0
2023-05-25 10:00:00	QQQ	ETF	337.26	338.69	336.705	338.62	8151549.0
2023-05-25 11:00:00	QQQ	ETF	338.64	339.92	338.355	338.885	7878617.0
2023-05-25 12:00:00	QQQ	ETF	338.89	340.32	338.87	339.6277	5854513.0
2023-05-25 13:00:00	QQQ	ETF	339.64	340.33	339.45	340.03	4384210.0
2023-05-25 14:00:00	QQQ	ETF	340.04	341.01	338.8401	339.02	5709734.0
2023-05-25 15:00:00	QQQ	ETF	339.04	340.84	338.985	339.74	8231464.0
2023-05-25 16:00:00	QQQ	ETF	339.73	340.1	339.62	339.82	1436725.0
2023-05-25 17:00:00	QQQ	ETF	339.84	339.84	339.3	339.58	46982.0
2023-05-25 18:00:00	QQQ	ETF	339.65	339.92	339.4	339.55	60435.0
2023-05-25 19:00:00	QQQ	ETF	339.63	339.63	339.33	339.41	65643.0
2023-05-25 04:00:00	IWM	ETF	174.75	175.21	174.72	175.2	12516.0
2023-05-25 05:00:00	IWM	ETF	175.21	175.56	175.21	175.51	9352.0
2023-05-25 06:00:00	IWM	ETF	175.4	175.45	175.0	175.0	23909.0
2023-05-25 07:00:00	IWM	ETF	175.0	175.21	174.61	175.15	77127.0
2023-05-25 08:00:00	IWM	ETF	174.9608	175.91	174.68	175.62	327937.0
2023-05-25 09:00:00	IWM	ETF	175.61	175.93	174.56	174.94	3817374.0
2023-05-25 10:00:00	IWM	ETF	174.94	175.1699	173.56	173.8	3917131.0
2023-05-25 11:00:00	IWM	ETF	173.81	174.03	172.6999	173.41	3554954.0
2023-05-25 12:00:00	IWM	ETF	173.42	173.81	173.26	173.295	3716019.0
2023-05-25 13:00:00	IWM	ETF	173.305	174.41	173.1503	173.99	2724226.0
2023-05-25 14:00:00	IWM	ETF	173.9801	174.61	173.535	173.74	3136950.0
2023-05-25 15:00:00	IWM	ETF	173.745	174.53	173.66	174.2	4886849.0
2023-05-25 16:00:00	IWM	ETF	174.17	174.24	173.94	174.05	1773805.0
2023-05-25 17:00:00	IWM	ETF	174.04	174.12	173.93	173.99	17425.0
2023-05-25 18:00:00	IWM	ETF	174.02	174.05	173.51	173.81	112190.0
2023-05-25 19:00:00	IWM	ETF	173.73	173.75	173.57	173.66	14446.0
2023-05-25 04:00:00	DIA	ETF	326.75	327.23	326.75	327.23	5425.0
2023-05-25 05:00:00	DIA	ETF	327.59	327.59	327.59	327.59	375.0

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

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