PREVIEW / etf_1hour / 2023-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-03.parquet
  size:    466 KB
  rows:    17,227

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-03 04:00:00	SPY	ETF	411.34	411.62	411.26	411.46	18999.0
2023-05-03 05:00:00	SPY	ETF	411.44	411.62	411.21	411.34	11040.0
2023-05-03 06:00:00	SPY	ETF	411.49	411.92	411.39	411.4	131722.0
2023-05-03 07:00:00	SPY	ETF	411.41	412.02	411.4	411.72	202623.0
2023-05-03 08:00:00	SPY	ETF	411.76	412.19	411.25	411.26	358153.0
2023-05-03 09:00:00	SPY	ETF	411.26	412.65	411.07	412.19	4866839.0
2023-05-03 10:00:00	SPY	ETF	412.21	412.48	410.51	410.895	6808592.0
2023-05-03 11:00:00	SPY	ETF	410.87	411.55	410.3	411.49	5014618.0
2023-05-03 12:00:00	SPY	ETF	411.5	412.15	411.06	412.15	3587171.0
2023-05-03 13:00:00	SPY	ETF	412.16	412.58	411.91	412.12	4717773.0
2023-05-03 14:00:00	SPY	ETF	412.1137	413.87	410.3	412.1825	19881069.0
2023-05-03 15:00:00	SPY	ETF	412.2024	413.07	407.77	407.99	24574283.0
2023-05-03 16:00:00	SPY	ETF	407.98	408.9399	406.75	406.93	4427583.0
2023-05-03 17:00:00	SPY	ETF	406.96	408.02	406.1	406.13	821123.0
2023-05-03 18:00:00	SPY	ETF	406.1	410.16	405.03	406.17	456261.0
2023-05-03 19:00:00	SPY	ETF	406.15	406.6	405.88	406.59	183762.0
2023-05-03 04:00:00	QQQ	ETF	319.58	320.05	319.46	319.94	34576.0
2023-05-03 05:00:00	QQQ	ETF	319.92	320.07	319.8	319.99	38810.0
2023-05-03 06:00:00	QQQ	ETF	320.0	320.25	319.77	319.82	56695.0
2023-05-03 07:00:00	QQQ	ETF	319.79	320.36	319.76	320.2	122369.0
2023-05-03 08:00:00	QQQ	ETF	319.7899	320.5	319.32	319.82	386857.0
2023-05-03 09:00:00	QQQ	ETF	319.79	320.79	319.475	320.55	4070559.0
2023-05-03 10:00:00	QQQ	ETF	320.56	320.78	319.62	319.755	4664606.0
2023-05-03 11:00:00	QQQ	ETF	319.74	320.16	319.2	320.11	2936802.0
2023-05-03 12:00:00	QQQ	ETF	320.11	320.41	319.48	320.4055	1775306.0
2023-05-03 13:00:00	QQQ	ETF	320.42	320.57	319.8685	320.31	2474728.0
2023-05-03 14:00:00	QQQ	ETF	320.35	322.47	319.04	320.9	14872706.0
2023-05-03 15:00:00	QQQ	ETF	320.9	321.61	317.18	317.35	14002721.0
2023-05-03 16:00:00	QQQ	ETF	317.35	318.12	316.88	317.1	1777902.0
2023-05-03 17:00:00	QQQ	ETF	317.08	317.29	316.0	316.15	586140.0
2023-05-03 18:00:00	QQQ	ETF	316.22	317.01	316.01	317.01	422606.0
2023-05-03 19:00:00	QQQ	ETF	316.95	317.31	316.77	317.31	257045.0
2023-05-03 04:00:00	IWM	ETF	172.0	172.05	171.81	171.83	38753.0
2023-05-03 05:00:00	IWM	ETF	171.81	171.96	171.67	171.84	40643.0
2023-05-03 06:00:00	IWM	ETF	171.92	172.05	171.63	171.78	34639.0
2023-05-03 07:00:00	IWM	ETF	171.86	172.22	171.86	172.04	68655.0
2023-05-03 08:00:00	IWM	ETF	172.01	172.57	171.786	172.25	150148.0
2023-05-03 09:00:00	IWM	ETF	172.21	174.15	172.17	173.6	4104195.0
2023-05-03 10:00:00	IWM	ETF	173.61	173.97	173.09	173.315	3286085.0
2023-05-03 11:00:00	IWM	ETF	173.31	173.56	172.9	173.47	1842658.0
2023-05-03 12:00:00	IWM	ETF	173.47	174.0297	173.37	174.01	1724631.0
2023-05-03 13:00:00	IWM	ETF	174.02	174.61	173.99	174.45	2660938.0
2023-05-03 14:00:00	IWM	ETF	174.54	175.7	173.72	175.02	6241644.0
2023-05-03 15:00:00	IWM	ETF	175.01	175.4	172.19	172.385	9305655.0
2023-05-03 16:00:00	IWM	ETF	172.33	173.0	171.0	171.11	4714052.0
2023-05-03 17:00:00	IWM	ETF	171.15	172.33	170.32	170.56	650329.0
2023-05-03 18:00:00	IWM	ETF	170.6	170.6	169.54	170.22	307547.0
2023-05-03 19:00:00	IWM	ETF	170.22	170.81	170.09	170.81	70898.0
2023-05-03 04:00:00	DIA	ETF	337.32	337.32	337.23	337.26	1060.0
2023-05-03 05:00:00	DIA	ETF	337.14	337.22	337.06	337.22	1300.0

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

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