PREVIEW / etf_1hour / 2024-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-07.parquet
  size:    544 KB
  rows:    20,241

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
2024-03-07 04:00:00	SPY	ETF	508.7	510.09	508.7	510.07	19116.0
2024-03-07 05:00:00	SPY	ETF	510.23	511.23	510.23	511.15	29034.0
2024-03-07 06:00:00	SPY	ETF	511.18	511.24	510.87	510.98	24303.0
2024-03-07 07:00:00	SPY	ETF	510.99	511.62	510.98	511.25	108201.0
2024-03-07 08:00:00	SPY	ETF	510.9903	512.45	508.0	512.11	452053.0
2024-03-07 09:00:00	SPY	ETF	512.13	513.635	512.0	513.406	5883389.0
2024-03-07 10:00:00	SPY	ETF	513.42	514.87	513.0	514.37	6930983.0
2024-03-07 11:00:00	SPY	ETF	514.36	514.73	513.77	514.62	4946853.0
2024-03-07 12:00:00	SPY	ETF	514.61	514.96	514.02	514.55	4652383.0
2024-03-07 13:00:00	SPY	ETF	514.545	515.89	514.24	515.705	4980902.0
2024-03-07 14:00:00	SPY	ETF	515.71	515.86	514.76	514.905	4660677.0
2024-03-07 15:00:00	SPY	ETF	514.9	515.65	514.07	514.87	10457445.0
2024-03-07 16:00:00	SPY	ETF	514.87	514.87	513.31	514.59	3034229.0
2024-03-07 17:00:00	SPY	ETF	514.65	515.0442	514.5	514.75	221413.0
2024-03-07 18:00:00	SPY	ETF	514.81	515.05	514.62	514.79	83294.0
2024-03-07 19:00:00	SPY	ETF	514.95	515.1	514.46	514.91	21404.0
2024-03-07 04:00:00	QQQ	ETF	437.4	439.82	437.39	439.69	110917.0
2024-03-07 05:00:00	QQQ	ETF	439.79	440.91	439.79	440.89	88506.0
2024-03-07 06:00:00	QQQ	ETF	440.78	441.0	440.29	440.62	72838.0
2024-03-07 07:00:00	QQQ	ETF	440.65	441.27	440.52	440.9	180480.0
2024-03-07 08:00:00	QQQ	ETF	440.6022	441.9084	436.03	441.64	444590.0
2024-03-07 09:00:00	QQQ	ETF	441.6995	443.43	440.86	442.65	4596344.0
2024-03-07 10:00:00	QQQ	ETF	442.66	444.82	442.24	444.05	5302668.0
2024-03-07 11:00:00	QQQ	ETF	444.055	445.4	443.84	445.3	3405601.0
2024-03-07 12:00:00	QQQ	ETF	445.29	445.95	444.915	445.485	3420354.0
2024-03-07 13:00:00	QQQ	ETF	445.48	446.72	445.05	446.55	3118114.0
2024-03-07 14:00:00	QQQ	ETF	446.56	446.66	445.8	445.91	2923805.0
2024-03-07 15:00:00	QQQ	ETF	445.91	446.245	444.98	445.51	7920802.0
2024-03-07 16:00:00	QQQ	ETF	445.5	445.54	441.87	444.19	3291073.0
2024-03-07 17:00:00	QQQ	ETF	444.13	445.45	443.9	444.83	135224.0
2024-03-07 18:00:00	QQQ	ETF	444.95	445.33	444.22	444.4575	123104.0
2024-03-07 19:00:00	QQQ	ETF	444.5	444.75	444.04	444.5	74525.0
2024-03-07 04:00:00	IWM	ETF	204.6	205.14	204.53	205.04	19103.0
2024-03-07 05:00:00	IWM	ETF	205.04	205.55	205.04	205.41	4600.0
2024-03-07 06:00:00	IWM	ETF	205.39	205.39	205.22	205.22	7967.0
2024-03-07 07:00:00	IWM	ETF	205.28	205.55	205.15	205.22	22745.0
2024-03-07 08:00:00	IWM	ETF	205.29	206.76	204.19	206.31	313008.0
2024-03-07 09:00:00	IWM	ETF	206.28	208.099	206.26	207.12	3541950.0
2024-03-07 10:00:00	IWM	ETF	207.14	207.5	206.4	207.113	3522076.0
2024-03-07 11:00:00	IWM	ETF	207.1	207.17	206.44	206.925	1938956.0
2024-03-07 12:00:00	IWM	ETF	206.925	207.115	206.67	207.07	1324842.0
2024-03-07 13:00:00	IWM	ETF	207.07	207.41	207.0	207.33	1312959.0
2024-03-07 14:00:00	IWM	ETF	207.33	207.355	206.78	206.89	1376853.0
2024-03-07 15:00:00	IWM	ETF	206.89	207.08	206.55	206.88	4424935.0
2024-03-07 16:00:00	IWM	ETF	206.96	207.03	206.52	206.96	1527073.0
2024-03-07 17:00:00	IWM	ETF	206.95	207.04	206.86	206.96	9140.0
2024-03-07 18:00:00	IWM	ETF	206.96	207.21	206.87	206.95	50485.0
2024-03-07 19:00:00	IWM	ETF	206.86	207.19	206.86	207.1	39503.0
2024-03-07 04:00:00	DIA	ETF	386.48	386.59	386.44	386.59	340.0
2024-03-07 05:00:00	DIA	ETF	387.29	387.73	387.29	387.7	2329.0

> showing 50 of 20,241 rows — these rows as CSV

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