PREVIEW / etf_1hour / 2004-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-28.parquet
  size:    24 KB
  rows:    646

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-01-28 08:00:00	SPY	ETF	115.01	115.1	114.88	115.09	49900.0
2004-01-28 09:00:00	SPY	ETF	115.09	115.14	114.94	115.1	2836300.0
2004-01-28 10:00:00	SPY	ETF	115.11	115.27	114.95	115.19	3771800.0
2004-01-28 11:00:00	SPY	ETF	115.2	115.28	115.05	115.15	2282500.0
2004-01-28 12:00:00	SPY	ETF	115.15	115.17	115.02	115.08	1353700.0
2004-01-28 13:00:00	SPY	ETF	115.07	115.23	115.02	115.16	1804900.0
2004-01-28 14:00:00	SPY	ETF	115.14	115.2	113.46	113.89	18749100.0
2004-01-28 15:00:00	SPY	ETF	113.9	114.03	112.94	113.23	14243100.0
2004-01-28 16:00:00	SPY	ETF	113.23	114.185	113.15	113.35	3140400.0
2004-01-28 17:00:00	SPY	ETF	113.35	113.38	113.27	113.29	555500.0
2004-01-28 18:00:00	SPY	ETF	113.29	113.32	113.19	113.32	19300.0
2004-01-28 19:00:00	SPY	ETF	113.32	113.37	113.29	113.35	7400.0
2004-01-28 08:00:00	QQQ	ETF	37.95	38.01	37.85	37.98	254300.0
2004-01-28 09:00:00	QQQ	ETF	37.99	38.0	37.86	37.92	9302700.0
2004-01-28 10:00:00	QQQ	ETF	37.939	38.06	37.8	38.0	15688500.0
2004-01-28 11:00:00	QQQ	ETF	37.99	38.05	37.91	37.93	6961100.0
2004-01-28 12:00:00	QQQ	ETF	37.93	37.94	37.82	37.894	7741400.0
2004-01-28 13:00:00	QQQ	ETF	37.888	37.95	37.82	37.895	5900100.0
2004-01-28 14:00:00	QQQ	ETF	37.89	37.96	37.28	37.46	36236100.0
2004-01-28 15:00:00	QQQ	ETF	37.47	37.579	37.01	37.156	31851800.0
2004-01-28 16:00:00	QQQ	ETF	37.16	37.2	37.04	37.1	3479000.0
2004-01-28 17:00:00	QQQ	ETF	37.1	37.1	37.05	37.08	740000.0
2004-01-28 18:00:00	QQQ	ETF	37.08	37.14	37.04	37.12	94100.0
2004-01-28 19:00:00	QQQ	ETF	37.14	37.16	37.13	37.14	26800.0
2004-01-28 09:00:00	IWM	ETF	59.38	59.67	59.345	59.38	596800.0
2004-01-28 10:00:00	IWM	ETF	59.38	59.53	59.288	59.46	1339600.0
2004-01-28 11:00:00	IWM	ETF	59.48	59.49	59.334	59.38	492600.0
2004-01-28 12:00:00	IWM	ETF	59.38	59.4	59.25	59.31	682400.0
2004-01-28 13:00:00	IWM	ETF	59.31	59.359	59.233	59.325	450800.0
2004-01-28 14:00:00	IWM	ETF	59.325	59.4	58.425	58.645	4533800.0
2004-01-28 15:00:00	IWM	ETF	58.645	58.715	57.94	58.14	2937600.0
2004-01-28 16:00:00	IWM	ETF	58.125	58.305	58.125	58.175	337800.0
2004-01-28 17:00:00	IWM	ETF	58.2	58.2	58.2	58.2	400.0
2004-01-28 08:00:00	DIA	ETF	106.49	106.52	106.38	106.52	6800.0
2004-01-28 09:00:00	DIA	ETF	106.5	106.59	106.38	106.57	356400.0
2004-01-28 10:00:00	DIA	ETF	106.59	106.73	106.46	106.68	683600.0
2004-01-28 11:00:00	DIA	ETF	106.7	106.78	106.55	106.56	293900.0
2004-01-28 12:00:00	DIA	ETF	106.52	106.55	106.4	106.47	403900.0
2004-01-28 13:00:00	DIA	ETF	106.44	106.61	106.39	106.55	197800.0
2004-01-28 14:00:00	DIA	ETF	106.57	106.58	105.058	105.51	2801400.0
2004-01-28 15:00:00	DIA	ETF	105.5	105.56	104.54	104.81	2237100.0
2004-01-28 16:00:00	DIA	ETF	104.81	105.08	104.81	105.07	401300.0
2004-01-28 17:00:00	DIA	ETF	105.06	105.12	105.04	105.04	4600.0
2004-01-28 18:00:00	DIA	ETF	105.03	105.07	105.0	105.07	16100.0
2004-01-28 19:00:00	DIA	ETF	105.0	105.05	105.0	105.05	200.0
2004-01-28 09:00:00	TLT	ETF	87.25	87.5	87.25	87.43	77700.0
2004-01-28 10:00:00	TLT	ETF	87.5	87.61	87.41	87.58	142500.0
2004-01-28 11:00:00	TLT	ETF	87.6	87.85	87.6	87.75	116800.0
2004-01-28 12:00:00	TLT	ETF	87.72	87.8	87.67	87.74	46800.0
2004-01-28 13:00:00	TLT	ETF	87.74	87.79	87.65	87.68	39200.0

> showing 50 of 646 rows — these rows as CSV

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