PREVIEW / etf_1hour / 2004-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-07.parquet
  size:    24 KB
  rows:    670

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
2004-04-07 08:00:00	SPY	ETF	114.96	114.99	114.89	114.89	7500.0
2004-04-07 09:00:00	SPY	ETF	114.86	114.98	114.6	114.7	3650400.0
2004-04-07 10:00:00	SPY	ETF	114.72	114.74	114.11	114.19	8767500.0
2004-04-07 11:00:00	SPY	ETF	114.19	114.41	114.16	114.29	5426700.0
2004-04-07 12:00:00	SPY	ETF	114.27	114.42	114.18	114.22	2850800.0
2004-04-07 13:00:00	SPY	ETF	114.22	114.45	114.22	114.3	1865500.0
2004-04-07 14:00:00	SPY	ETF	114.3	114.63	114.13	114.57	4879900.0
2004-04-07 15:00:00	SPY	ETF	114.57	114.93	114.31	114.5	11388000.0
2004-04-07 16:00:00	SPY	ETF	114.48	115.0	114.38	114.91	2638300.0
2004-04-07 17:00:00	SPY	ETF	114.94	115.39	114.92	115.18	369400.0
2004-04-07 18:00:00	SPY	ETF	115.2	115.2	115.15	115.19	2400.0
2004-04-07 19:00:00	SPY	ETF	115.12	115.14	115.1	115.12	1500.0
2004-04-07 08:00:00	QQQ	ETF	37.02	37.05	36.99	37.0	277400.0
2004-04-07 09:00:00	QQQ	ETF	37.0	37.02	36.87	36.925	9964400.0
2004-04-07 10:00:00	QQQ	ETF	36.926	36.93	36.68	36.729	16223200.0
2004-04-07 11:00:00	QQQ	ETF	36.729	36.8	36.68	36.75	8438900.0
2004-04-07 12:00:00	QQQ	ETF	36.744	36.79	36.66	36.71	7095600.0
2004-04-07 13:00:00	QQQ	ETF	36.71	36.82	36.7	36.759	7206100.0
2004-04-07 14:00:00	QQQ	ETF	36.76	36.98	36.7	36.944	12278200.0
2004-04-07 15:00:00	QQQ	ETF	36.94	37.11	36.76	36.877	21401000.0
2004-04-07 16:00:00	QQQ	ETF	36.87	37.18	36.83	37.14	4548900.0
2004-04-07 17:00:00	QQQ	ETF	37.14	37.31	37.14	37.27	1904700.0
2004-04-07 18:00:00	QQQ	ETF	37.27	37.3	37.26	37.3	40800.0
2004-04-07 19:00:00	QQQ	ETF	37.27	37.27	37.25	37.25	28300.0
2004-04-07 08:00:00	IWM	ETF	59.625	59.625	59.625	59.625	16200.0
2004-04-07 09:00:00	IWM	ETF	59.6	59.695	59.42	59.505	1488000.0
2004-04-07 10:00:00	IWM	ETF	59.515	59.515	59.175	59.225	2276600.0
2004-04-07 11:00:00	IWM	ETF	59.23	59.415	59.225	59.35	931600.0
2004-04-07 12:00:00	IWM	ETF	59.35	59.445	59.3	59.395	315800.0
2004-04-07 13:00:00	IWM	ETF	59.385	59.6	59.385	59.53	555000.0
2004-04-07 14:00:00	IWM	ETF	59.53	60.08	59.455	60.03	1191400.0
2004-04-07 15:00:00	IWM	ETF	60.035	60.245	59.795	59.91	3156200.0
2004-04-07 16:00:00	IWM	ETF	59.94	60.28	59.935	60.27	372600.0
2004-04-07 17:00:00	IWM	ETF	60.325	60.495	60.325	60.495	53400.0
2004-04-07 18:00:00	IWM	ETF	60.39	60.39	60.39	60.39	200.0
2004-04-07 08:00:00	DIA	ETF	105.58	105.64	105.53	105.54	1700.0
2004-04-07 09:00:00	DIA	ETF	105.51	105.67	105.31	105.46	460900.0
2004-04-07 10:00:00	DIA	ETF	105.45	105.46	104.92	104.96	1207100.0
2004-04-07 11:00:00	DIA	ETF	104.96	105.13	104.91	105.05	538100.0
2004-04-07 12:00:00	DIA	ETF	105.05	105.11	104.92	104.95	295800.0
2004-04-07 13:00:00	DIA	ETF	104.96	105.12	104.95	105.0	460800.0
2004-04-07 14:00:00	DIA	ETF	104.99	105.27	104.84	105.2	627100.0
2004-04-07 15:00:00	DIA	ETF	105.2	105.52	104.92	105.08	1399900.0
2004-04-07 16:00:00	DIA	ETF	105.09	105.59	104.99	105.56	177700.0
2004-04-07 17:00:00	DIA	ETF	105.59	105.75	105.59	105.72	4700.0
2004-04-07 09:00:00	TLT	ETF	86.3	86.51	86.3	86.5	35800.0
2004-04-07 10:00:00	TLT	ETF	86.5	86.74	86.47	86.69	269200.0
2004-04-07 11:00:00	TLT	ETF	86.69	86.8	86.65	86.74	117500.0
2004-04-07 12:00:00	TLT	ETF	86.74	86.75	86.6	86.64	74500.0
2004-04-07 13:00:00	TLT	ETF	86.64	86.64	86.45	86.45	32500.0

> showing 50 of 670 rows — these rows as CSV

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