PREVIEW / etf_1hour / 2001-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-25.parquet
  size:    11 KB
  rows:    216

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-06-25 09:00:00	SPY	ETF	123.28	123.44	123.02	123.28	1143500.0
2001-06-25 10:00:00	SPY	ETF	123.27	123.41	122.67	122.76	1098200.0
2001-06-25 11:00:00	SPY	ETF	122.75	123.08	122.4	122.46	1038600.0
2001-06-25 12:00:00	SPY	ETF	122.49	122.49	121.9	121.95	1182100.0
2001-06-25 13:00:00	SPY	ETF	121.99	122.38	121.92	122.24	779400.0
2001-06-25 14:00:00	SPY	ETF	122.19	122.23	121.5	121.79	1037200.0
2001-06-25 15:00:00	SPY	ETF	121.78	122.29	121.71	122.13	1385000.0
2001-06-25 16:00:00	SPY	ETF	122.1	122.2	121.72	122.11	527400.0
2001-06-25 17:00:00	SPY	ETF	121.72	121.72	121.72	121.72	25000.0
2001-06-25 09:00:00	QQQ	ETF	43.61	43.8	43.3	43.62	6154700.0
2001-06-25 10:00:00	QQQ	ETF	43.62	43.75	43.15	43.3	6691100.0
2001-06-25 11:00:00	QQQ	ETF	43.3	43.55	43.05	43.16	4488500.0
2001-06-25 12:00:00	QQQ	ETF	43.16	43.18	42.65	42.8	4337000.0
2001-06-25 13:00:00	QQQ	ETF	42.83	43.1	42.73	43.06	3323600.0
2001-06-25 14:00:00	QQQ	ETF	43.04	43.26	42.7	43.19	4213000.0
2001-06-25 15:00:00	QQQ	ETF	43.2	43.57	43.1	43.44	7155000.0
2001-06-25 16:00:00	QQQ	ETF	43.5	43.55	43.18	43.34	1080700.0
2001-06-25 17:00:00	QQQ	ETF	43.33	43.37	43.2	43.25	374400.0
2001-06-25 18:00:00	QQQ	ETF	43.23	43.25	43.12	43.14	20500.0
2001-06-25 09:00:00	IWM	ETF	48.85	48.885	48.7	48.75	247200.0
2001-06-25 10:00:00	IWM	ETF	48.8	48.825	48.5	48.555	392200.0
2001-06-25 11:00:00	IWM	ETF	48.595	48.62	48.415	48.48	253800.0
2001-06-25 12:00:00	IWM	ETF	48.48	48.5	48.325	48.37	237600.0
2001-06-25 13:00:00	IWM	ETF	48.36	48.5	48.305	48.305	155200.0
2001-06-25 14:00:00	IWM	ETF	48.3	48.335	48.125	48.29	342200.0
2001-06-25 15:00:00	IWM	ETF	48.295	48.45	48.295	48.37	153600.0
2001-06-25 16:00:00	IWM	ETF	48.275	48.275	48.26	48.26	28000.0
2001-06-25 09:00:00	DIA	ETF	106.57	106.6	106.11	106.5	206800.0
2001-06-25 10:00:00	DIA	ETF	106.54	106.55	106.03	106.11	204600.0
2001-06-25 11:00:00	DIA	ETF	106.11	106.34	105.9	105.9	118800.0
2001-06-25 12:00:00	DIA	ETF	105.9	105.9	105.15	105.22	372000.0
2001-06-25 13:00:00	DIA	ETF	105.2	105.45	105.11	105.22	178600.0
2001-06-25 14:00:00	DIA	ETF	105.34	105.34	104.77	104.9	418800.0
2001-06-25 15:00:00	DIA	ETF	104.96	105.41	104.96	105.26	550400.0
2001-06-25 16:00:00	DIA	ETF	105.14	105.15	104.95	105.06	77600.0

> showing 35 of 216 rows — these rows as CSV

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