PREVIEW / etf_1hour / 2005-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-20.parquet
  size:    31 KB
  rows:    879

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
2005-04-20 07:00:00	SPY	ETF	115.7	115.8	115.7	115.7	199200.0
2005-04-20 08:00:00	SPY	ETF	115.74	115.77	115.08	115.59	1684400.0
2005-04-20 09:00:00	SPY	ETF	115.57	115.58	114.75	114.88	15890200.0
2005-04-20 10:00:00	SPY	ETF	114.82	115.35	114.76	115.3	13708900.0
2005-04-20 11:00:00	SPY	ETF	115.3	115.63	115.07	115.27	11527500.0
2005-04-20 12:00:00	SPY	ETF	115.27	115.27	114.54	114.6	7564900.0
2005-04-20 13:00:00	SPY	ETF	114.6	114.71	114.37	114.62	10178200.0
2005-04-20 14:00:00	SPY	ETF	114.61	114.65	114.07	114.42	14500100.0
2005-04-20 15:00:00	SPY	ETF	114.45	115.58	113.6	113.79	24713600.0
2005-04-20 16:00:00	SPY	ETF	113.77	115.22	113.53	113.88	2797700.0
2005-04-20 17:00:00	SPY	ETF	113.88	113.92	113.78	113.82	1216300.0
2005-04-20 18:00:00	SPY	ETF	113.87	113.89	113.8	113.8	95100.0
2005-04-20 19:00:00	SPY	ETF	113.89	113.89	113.88	113.88	1400.0
2005-04-20 09:00:00	QQQ	ETF	35.21	35.25	34.98	35.01	19323200.0
2005-04-20 10:00:00	QQQ	ETF	35.01	35.27	34.99	35.24	21921300.0
2005-04-20 11:00:00	QQQ	ETF	35.24	35.29	35.07	35.21	12213000.0
2005-04-20 12:00:00	QQQ	ETF	35.21	35.22	34.9	34.92	9963200.0
2005-04-20 13:00:00	QQQ	ETF	34.93	35.05	34.8	34.91	12118200.0
2005-04-20 14:00:00	QQQ	ETF	34.9	34.94	34.74	34.91	16155900.0
2005-04-20 15:00:00	QQQ	ETF	34.91	35.26	33.7	34.73	25540800.0
2005-04-20 08:00:00	IWM	ETF	59.305	59.35	58.88	59.34	109200.0
2005-04-20 09:00:00	IWM	ETF	59.265	59.3	58.585	58.595	4082800.0
2005-04-20 10:00:00	IWM	ETF	58.605	59.14	58.57	59.1	6322800.0
2005-04-20 11:00:00	IWM	ETF	59.075	59.225	58.88	59.08	3268400.0
2005-04-20 12:00:00	IWM	ETF	59.085	59.085	58.505	58.505	3329400.0
2005-04-20 13:00:00	IWM	ETF	58.535	58.64	58.265	58.52	4018200.0
2005-04-20 14:00:00	IWM	ETF	58.515	58.57	58.23	58.555	4771400.0
2005-04-20 15:00:00	IWM	ETF	58.545	58.545	58.09	58.23	4210600.0
2005-04-20 16:00:00	IWM	ETF	58.24	58.3	58.115	58.25	580200.0
2005-04-20 07:00:00	DIA	ETF	101.5	101.5	101.5	101.5	1900.0
2005-04-20 08:00:00	DIA	ETF	101.57	101.67	101.07	101.65	60500.0
2005-04-20 09:00:00	DIA	ETF	101.69	101.69	101.0	101.04	1860400.0
2005-04-20 10:00:00	DIA	ETF	101.03	101.56	101.0	101.56	2230000.0
2005-04-20 11:00:00	DIA	ETF	101.55	101.78	101.36	101.52	1413000.0
2005-04-20 12:00:00	DIA	ETF	101.54	101.54	100.91	100.97	1034300.0
2005-04-20 13:00:00	DIA	ETF	100.96	101.05	100.65	100.94	1948500.0
2005-04-20 14:00:00	DIA	ETF	100.91	100.97	100.38	100.7	1690500.0
2005-04-20 15:00:00	DIA	ETF	100.68	100.73	99.93	100.06	1409900.0
2005-04-20 16:00:00	DIA	ETF	100.04	100.2	99.89	100.19	70000.0
2005-04-20 17:00:00	DIA	ETF	100.16	100.16	100.12	100.12	5400.0
2005-04-20 18:00:00	DIA	ETF	100.17	100.17	100.17	100.17	1000.0
2005-04-20 19:00:00	DIA	ETF	100.2	100.2	100.2	100.2	100.0
2005-04-20 08:00:00	GLD	ETF	43.32	43.32	43.13	43.13	400.0
2005-04-20 09:00:00	GLD	ETF	43.21	43.35	43.19	43.35	140600.0
2005-04-20 10:00:00	GLD	ETF	43.33	43.52	43.29	43.47	173800.0
2005-04-20 11:00:00	GLD	ETF	43.47	43.52	43.39	43.46	511100.0
2005-04-20 12:00:00	GLD	ETF	43.46	43.52	43.42	43.48	55600.0
2005-04-20 13:00:00	GLD	ETF	43.48	43.52	43.44	43.47	101100.0
2005-04-20 14:00:00	GLD	ETF	43.47	43.47	43.38	43.43	95900.0
2005-04-20 15:00:00	GLD	ETF	43.44	43.48	43.4	43.41	167600.0

> showing 50 of 879 rows — these rows as CSV

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