PREVIEW / etf_1hour / 2005-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-27.parquet
  size:    31 KB
  rows:    869

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-27 05:00:00	SPY	ETF	115.15	115.15	115.15	115.15	2400.0
2005-04-27 06:00:00	SPY	ETF	115.15	115.15	115.0	115.0	5500.0
2005-04-27 07:00:00	SPY	ETF	115.07	115.08	114.97	115.05	37500.0
2005-04-27 08:00:00	SPY	ETF	115.08	115.2	114.87	114.9	549500.0
2005-04-27 09:00:00	SPY	ETF	114.89	115.0	114.55	114.62	10185100.0
2005-04-27 10:00:00	SPY	ETF	114.61	115.07	114.44	114.91	16212700.0
2005-04-27 11:00:00	SPY	ETF	114.91	115.4	114.71	115.37	12554200.0
2005-04-27 12:00:00	SPY	ETF	115.38	115.79	115.37	115.6	10130100.0
2005-04-27 13:00:00	SPY	ETF	115.58	116.07	115.55	115.86	10977200.0
2005-04-27 14:00:00	SPY	ETF	115.85	115.93	115.58	115.86	7762400.0
2005-04-27 15:00:00	SPY	ETF	115.85	115.96	115.51	115.68	12391000.0
2005-04-27 16:00:00	SPY	ETF	115.67	115.77	115.63	115.68	1404100.0
2005-04-27 17:00:00	SPY	ETF	115.65	115.71	115.63	115.71	831000.0
2005-04-27 18:00:00	SPY	ETF	115.71	115.72	115.67	115.71	4300.0
2005-04-27 09:00:00	QQQ	ETF	34.87	34.95	34.78	34.83	19218000.0
2005-04-27 10:00:00	QQQ	ETF	34.82	35.01	34.73	34.96	24567000.0
2005-04-27 11:00:00	QQQ	ETF	34.96	35.08	34.85	35.05	13957100.0
2005-04-27 12:00:00	QQQ	ETF	35.05	35.18	35.02	35.08	10461500.0
2005-04-27 13:00:00	QQQ	ETF	35.08	35.25	34.8	35.16	10978500.0
2005-04-27 14:00:00	QQQ	ETF	35.16	35.19	35.04	35.18	9767900.0
2005-04-27 15:00:00	QQQ	ETF	35.19	35.21	35.05	35.1	12318500.0
2005-04-27 08:00:00	IWM	ETF	58.245	58.245	58.065	58.105	25200.0
2005-04-27 09:00:00	IWM	ETF	58.105	58.185	57.78	57.82	3883000.0
2005-04-27 10:00:00	IWM	ETF	57.815	58.09	57.615	57.97	6647400.0
2005-04-27 11:00:00	IWM	ETF	57.97	58.24	57.705	58.225	4276800.0
2005-04-27 12:00:00	IWM	ETF	58.24	58.6	58.24	58.475	3726400.0
2005-04-27 13:00:00	IWM	ETF	58.47	58.79	58.375	58.695	3388800.0
2005-04-27 14:00:00	IWM	ETF	58.695	58.695	58.46	58.615	2247000.0
2005-04-27 15:00:00	IWM	ETF	58.625	58.72	58.33	58.335	5470600.0
2005-04-27 16:00:00	IWM	ETF	58.335	58.43	58.32	58.33	381600.0
2005-04-27 17:00:00	IWM	ETF	58.35	58.37	58.3	58.37	2225400.0
2005-04-27 08:00:00	DIA	ETF	101.31	101.31	101.08	101.18	8500.0
2005-04-27 09:00:00	DIA	ETF	101.14	101.22	100.85	100.9	1659300.0
2005-04-27 10:00:00	DIA	ETF	100.89	101.25	100.74	101.14	1674900.0
2005-04-27 11:00:00	DIA	ETF	101.14	101.61	101.01	101.56	1693800.0
2005-04-27 12:00:00	DIA	ETF	101.56	101.95	101.56	101.73	2336100.0
2005-04-27 13:00:00	DIA	ETF	101.75	102.17	101.69	102.02	1009500.0
2005-04-27 14:00:00	DIA	ETF	102.0	102.1	101.75	102.022	546000.0
2005-04-27 15:00:00	DIA	ETF	102.04	102.14	101.72	101.96	1080200.0
2005-04-27 16:00:00	DIA	ETF	101.88	101.97	101.87	101.92	17500.0
2005-04-27 17:00:00	DIA	ETF	101.91	101.91	101.91	101.91	20000.0
2005-04-27 08:00:00	GLD	ETF	43.44	43.55	43.44	43.55	100000.0
2005-04-27 09:00:00	GLD	ETF	43.53	43.54	43.34	43.358	482900.0
2005-04-27 10:00:00	GLD	ETF	43.36	43.46	43.21	43.25	578700.0
2005-04-27 11:00:00	GLD	ETF	43.24	43.25	43.12	43.2	214800.0
2005-04-27 12:00:00	GLD	ETF	43.21	43.21	43.12	43.146	540000.0
2005-04-27 13:00:00	GLD	ETF	43.15	43.26	43.15	43.241	459900.0
2005-04-27 14:00:00	GLD	ETF	43.24	43.25	43.19	43.21	120000.0
2005-04-27 15:00:00	GLD	ETF	43.21	43.24	43.186	43.19	264400.0
2005-04-27 16:00:00	GLD	ETF	43.2	43.2	43.2	43.2	100.0

> showing 50 of 869 rows — these rows as CSV

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