PREVIEW / etf_1hour / 2001-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-24.parquet
  size:    12 KB
  rows:    231

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
2001-07-24 09:00:00	SPY	ETF	119.0	119.2	118.6	119.13	1396500.0
2001-07-24 10:00:00	SPY	ETF	119.11	119.15	118.41	119.05	1293400.0
2001-07-24 11:00:00	SPY	ETF	119.06	119.12	118.08	118.27	1229300.0
2001-07-24 12:00:00	SPY	ETF	118.25	118.25	117.66	117.9	1638700.0
2001-07-24 13:00:00	SPY	ETF	117.88	118.34	117.62	117.62	1088500.0
2001-07-24 14:00:00	SPY	ETF	117.65	117.89	117.36	117.41	1674600.0
2001-07-24 15:00:00	SPY	ETF	117.33	117.49	116.75	117.39	3119200.0
2001-07-24 16:00:00	SPY	ETF	117.58	118.0	117.42	117.9	615100.0
2001-07-24 17:00:00	SPY	ETF	117.9	118.0	117.9	118.0	13200.0
2001-07-24 09:00:00	QQQ	ETF	40.38	40.7	40.12	40.65	9810700.0
2001-07-24 10:00:00	QQQ	ETF	40.54	40.89	40.15	40.79	10356500.0
2001-07-24 11:00:00	QQQ	ETF	40.77	40.9	40.25	40.29	9426800.0
2001-07-24 12:00:00	QQQ	ETF	40.26	40.34	39.97	40.15	5258000.0
2001-07-24 13:00:00	QQQ	ETF	40.14	40.36	39.89	39.95	6362400.0
2001-07-24 14:00:00	QQQ	ETF	39.96	40.09	39.53	39.68	11803900.0
2001-07-24 15:00:00	QQQ	ETF	39.7	40.05	39.31	40.01	11213700.0
2001-07-24 16:00:00	QQQ	ETF	40.01	40.3	40.01	40.29	2632600.0
2001-07-24 17:00:00	QQQ	ETF	40.3	40.5	40.21	40.44	297900.0
2001-07-24 18:00:00	QQQ	ETF	40.45	40.5	40.4	40.4	6800.0
2001-07-24 09:00:00	IWM	ETF	48.0	48.025	47.885	48.025	11000.0
2001-07-24 10:00:00	IWM	ETF	48.175	48.175	47.875	47.955	43400.0
2001-07-24 11:00:00	IWM	ETF	47.875	47.875	47.4	47.6	166600.0
2001-07-24 12:00:00	IWM	ETF	47.5	47.5	47.15	47.275	19400.0
2001-07-24 13:00:00	IWM	ETF	47.26	47.48	47.255	47.3	100800.0
2001-07-24 14:00:00	IWM	ETF	47.3	47.375	47.05	47.1	60600.0
2001-07-24 15:00:00	IWM	ETF	47.1	47.365	46.9	47.255	182200.0
2001-07-24 16:00:00	IWM	ETF	47.25	47.35	47.25	47.35	400.0
2001-07-24 09:00:00	DIA	ETF	103.8	104.17	103.77	104.09	241800.0
2001-07-24 10:00:00	DIA	ETF	104.1	104.15	103.44	104.05	290600.0
2001-07-24 11:00:00	DIA	ETF	103.95	104.0	103.2	103.3	347700.0
2001-07-24 12:00:00	DIA	ETF	103.25	103.3	102.84	103.0	460400.0
2001-07-24 13:00:00	DIA	ETF	103.05	103.38	102.68	102.68	194200.0
2001-07-24 14:00:00	DIA	ETF	102.65	102.95	102.51	102.6	432100.0
2001-07-24 15:00:00	DIA	ETF	102.61	102.64	102.0	102.4	604400.0
2001-07-24 16:00:00	DIA	ETF	102.39	102.65	102.35	102.65	25300.0

> showing 35 of 231 rows — these rows as CSV

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