PREVIEW / etf_1hour / 2004-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-09.parquet
  size:    24 KB
  rows:    679

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-03-09 08:00:00	SPY	ETF	114.99	115.1	114.88	115.05	157400.0
2004-03-09 09:00:00	SPY	ETF	115.05	115.15	114.85	115.11	3380700.0
2004-03-09 10:00:00	SPY	ETF	115.14	115.2	114.65	114.93	2122200.0
2004-03-09 11:00:00	SPY	ETF	114.93	115.09	114.81	114.83	2277000.0
2004-03-09 12:00:00	SPY	ETF	114.83	115.05	114.55	114.63	3672400.0
2004-03-09 13:00:00	SPY	ETF	114.62	114.79	114.47	114.56	4120900.0
2004-03-09 14:00:00	SPY	ETF	114.57	114.85	114.27	114.37	2966100.0
2004-03-09 15:00:00	SPY	ETF	114.37	114.79	114.24	114.66	5521000.0
2004-03-09 16:00:00	SPY	ETF	114.67	114.68	114.49	114.53	1154800.0
2004-03-09 17:00:00	SPY	ETF	114.55	114.55	114.45	114.5	7400.0
2004-03-09 18:00:00	SPY	ETF	114.5	114.55	114.5	114.5	1800.0
2004-03-09 19:00:00	SPY	ETF	114.5	114.54	114.48	114.53	1000.0
2004-03-09 08:00:00	QQQ	ETF	35.75	35.82	35.69	35.81	322500.0
2004-03-09 09:00:00	QQQ	ETF	35.8	35.92	35.68	35.91	8587400.0
2004-03-09 10:00:00	QQQ	ETF	35.91	35.92	35.57	35.803	9310300.0
2004-03-09 11:00:00	QQQ	ETF	35.8	35.98	35.77	35.801	10292600.0
2004-03-09 12:00:00	QQQ	ETF	35.81	35.855	35.63	35.69	12266300.0
2004-03-09 13:00:00	QQQ	ETF	35.72	35.784	35.61	35.66	8702300.0
2004-03-09 14:00:00	QQQ	ETF	35.674	35.8	35.52	35.55	14516400.0
2004-03-09 15:00:00	QQQ	ETF	35.55	35.89	35.52	35.8	17917600.0
2004-03-09 16:00:00	QQQ	ETF	35.786	35.82	35.65	35.68	2557000.0
2004-03-09 17:00:00	QQQ	ETF	35.68	35.69	35.65	35.65	95400.0
2004-03-09 18:00:00	QQQ	ETF	35.65	35.7	35.65	35.68	23300.0
2004-03-09 19:00:00	QQQ	ETF	35.69	35.69	35.66	35.66	17500.0
2004-03-09 09:00:00	IWM	ETF	58.945	59.15	58.785	59.125	328000.0
2004-03-09 10:00:00	IWM	ETF	59.125	59.14	58.565	58.72	801200.0
2004-03-09 11:00:00	IWM	ETF	58.785	58.975	58.76	58.765	910600.0
2004-03-09 12:00:00	IWM	ETF	58.725	58.875	58.605	58.7	638800.0
2004-03-09 13:00:00	IWM	ETF	58.705	58.755	58.565	58.6	718400.0
2004-03-09 14:00:00	IWM	ETF	58.605	58.705	58.275	58.35	1128600.0
2004-03-09 15:00:00	IWM	ETF	58.35	58.55	58.19	58.48	1867400.0
2004-03-09 16:00:00	IWM	ETF	58.465	59.315	58.365	58.39	241000.0
2004-03-09 17:00:00	IWM	ETF	58.39	58.39	58.385	58.385	4000.0
2004-03-09 08:00:00	DIA	ETF	105.24	105.29	105.09	105.29	9200.0
2004-03-09 09:00:00	DIA	ETF	105.26	105.34	105.02	105.32	242800.0
2004-03-09 10:00:00	DIA	ETF	105.31	105.36	104.98	105.18	524300.0
2004-03-09 11:00:00	DIA	ETF	105.19	105.29	104.94	104.95	339300.0
2004-03-09 12:00:00	DIA	ETF	104.94	105.11	104.73	104.78	458600.0
2004-03-09 13:00:00	DIA	ETF	104.78	104.88	104.6	104.62	1040400.0
2004-03-09 14:00:00	DIA	ETF	104.67	104.91	104.45	104.5	1224400.0
2004-03-09 15:00:00	DIA	ETF	104.48	104.85	104.37	104.76	1391900.0
2004-03-09 16:00:00	DIA	ETF	104.76	104.78	104.57	104.74	210500.0
2004-03-09 17:00:00	DIA	ETF	104.75	104.75	104.65	104.65	200.0
2004-03-09 18:00:00	DIA	ETF	104.74	104.74	104.74	104.74	1200.0
2004-03-09 08:00:00	TLT	ETF	90.29	90.32	90.29	90.32	6000.0
2004-03-09 09:00:00	TLT	ETF	90.25	90.3	90.23	90.26	69700.0
2004-03-09 10:00:00	TLT	ETF	90.3	90.48	90.19	90.48	55100.0
2004-03-09 11:00:00	TLT	ETF	90.42	90.72	90.39	90.66	51300.0
2004-03-09 12:00:00	TLT	ETF	90.67	90.85	90.65	90.69	103800.0
2004-03-09 13:00:00	TLT	ETF	90.68	90.8	90.68	90.77	82100.0

> showing 50 of 679 rows — these rows as CSV

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