PREVIEW / etf_1hour / 2004-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-27.parquet
  size:    25 KB
  rows:    690

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-27 08:00:00	SPY	ETF	114.25	114.31	114.2	114.31	22400.0
2004-04-27 09:00:00	SPY	ETF	114.31	114.4	114.13	114.3	2781800.0
2004-04-27 10:00:00	SPY	ETF	114.29	115.12	114.27	114.64	10531000.0
2004-04-27 11:00:00	SPY	ETF	114.64	114.85	114.51	114.8	3274100.0
2004-04-27 12:00:00	SPY	ETF	114.81	114.9	114.72	114.85	1971700.0
2004-04-27 13:00:00	SPY	ETF	114.84	114.94	114.69	114.89	2114200.0
2004-04-27 14:00:00	SPY	ETF	114.86	114.92	113.96	114.26	8784000.0
2004-04-27 15:00:00	SPY	ETF	114.26	114.39	114.02	114.22	6032800.0
2004-04-27 16:00:00	SPY	ETF	114.25	114.37	114.13	114.22	767800.0
2004-04-27 17:00:00	SPY	ETF	114.23	114.25	114.2	114.25	7000.0
2004-04-27 18:00:00	SPY	ETF	114.25	114.25	114.21	114.22	3500.0
2004-04-27 19:00:00	SPY	ETF	114.19	114.2	114.19	114.2	300.0
2004-04-27 08:00:00	QQQ	ETF	36.93	37.0	36.92	36.99	180500.0
2004-04-27 09:00:00	QQQ	ETF	36.99	37.01	36.85	36.9	7566500.0
2004-04-27 10:00:00	QQQ	ETF	36.9	37.19	36.88	37.0	19311700.0
2004-04-27 11:00:00	QQQ	ETF	37.0	37.07	36.91	37.04	9160300.0
2004-04-27 12:00:00	QQQ	ETF	37.04	37.09	36.98	37.07	4616800.0
2004-04-27 13:00:00	QQQ	ETF	37.059	37.14	36.982	37.12	6509800.0
2004-04-27 14:00:00	QQQ	ETF	37.12	37.14	36.71	36.807	15183000.0
2004-04-27 15:00:00	QQQ	ETF	36.79	36.89	36.69	36.814	13396900.0
2004-04-27 16:00:00	QQQ	ETF	36.81	36.893	36.77	36.81	3449000.0
2004-04-27 17:00:00	QQQ	ETF	36.81	36.86	36.79	36.84	119900.0
2004-04-27 18:00:00	QQQ	ETF	36.84	36.84	36.82	36.84	40700.0
2004-04-27 19:00:00	QQQ	ETF	36.85	36.85	36.81	36.84	29600.0
2004-04-27 08:00:00	IWM	ETF	58.97	58.97	58.97	58.97	2000.0
2004-04-27 09:00:00	IWM	ETF	59.0	59.085	58.75	58.86	863200.0
2004-04-27 10:00:00	IWM	ETF	58.83	59.355	58.825	58.975	1074200.0
2004-04-27 11:00:00	IWM	ETF	58.925	58.975	58.8	58.935	467800.0
2004-04-27 12:00:00	IWM	ETF	58.965	58.99	58.85	58.98	274600.0
2004-04-27 13:00:00	IWM	ETF	58.955	59.105	58.885	59.06	459000.0
2004-04-27 14:00:00	IWM	ETF	59.065	59.07	58.43	58.595	815200.0
2004-04-27 15:00:00	IWM	ETF	58.56	58.81	58.51	58.74	1938200.0
2004-04-27 16:00:00	IWM	ETF	58.72	58.875	58.715	58.85	265000.0
2004-04-27 08:00:00	DIA	ETF	104.88	105.0	104.88	104.98	9100.0
2004-04-27 09:00:00	DIA	ETF	105.0	105.02	104.8	104.9	458200.0
2004-04-27 10:00:00	DIA	ETF	104.93	105.59	104.88	105.18	1085800.0
2004-04-27 11:00:00	DIA	ETF	105.15	105.45	105.1	105.39	607900.0
2004-04-27 12:00:00	DIA	ETF	105.43	105.43	105.28	105.41	175000.0
2004-04-27 13:00:00	DIA	ETF	105.4	105.51	105.31	105.46	488500.0
2004-04-27 14:00:00	DIA	ETF	105.46	105.54	104.75	104.95	1026700.0
2004-04-27 15:00:00	DIA	ETF	104.94	105.06	104.77	104.99	788800.0
2004-04-27 16:00:00	DIA	ETF	104.94	105.13	104.94	105.02	76400.0
2004-04-27 18:00:00	DIA	ETF	104.95	104.95	104.95	104.95	200.0
2004-04-27 19:00:00	DIA	ETF	104.95	104.95	104.95	104.95	100.0
2004-04-27 08:00:00	TLT	ETF	84.24	84.24	84.24	84.24	800.0
2004-04-27 09:00:00	TLT	ETF	84.4	84.43	84.32	84.36	66800.0
2004-04-27 10:00:00	TLT	ETF	84.35	84.35	84.08	84.18	74500.0
2004-04-27 11:00:00	TLT	ETF	84.22	84.24	84.1	84.13	37100.0
2004-04-27 12:00:00	TLT	ETF	84.17	84.23	84.16	84.21	4800.0
2004-04-27 13:00:00	TLT	ETF	84.16	84.35	84.12	84.31	154700.0

> showing 50 of 690 rows — these rows as CSV

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