PREVIEW / etf_1hour / 2004-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-27.parquet
  size:    24 KB
  rows:    659

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-27 08:00:00	SPY	ETF	115.73	115.75	115.7	115.73	5900.0
2004-01-27 09:00:00	SPY	ETF	115.73	115.85	115.59	115.74	2267600.0
2004-01-27 10:00:00	SPY	ETF	115.73	115.85	115.55	115.61	5080800.0
2004-01-27 11:00:00	SPY	ETF	115.58	115.67	115.31	115.36	3650100.0
2004-01-27 12:00:00	SPY	ETF	115.25	115.27	115.06	115.13	3596400.0
2004-01-27 13:00:00	SPY	ETF	115.15	115.19	114.75	115.06	4133500.0
2004-01-27 14:00:00	SPY	ETF	115.04	115.16	114.79	114.97	3062000.0
2004-01-27 15:00:00	SPY	ETF	114.97	115.1	114.7	114.7	5244700.0
2004-01-27 16:00:00	SPY	ETF	114.73	114.77	114.61	114.62	2480000.0
2004-01-27 17:00:00	SPY	ETF	114.61	114.83	114.61	114.68	50600.0
2004-01-27 18:00:00	SPY	ETF	114.7	114.7	114.6	114.67	26200.0
2004-01-27 19:00:00	SPY	ETF	114.69	114.7	114.69	114.7	7800.0
2004-01-27 08:00:00	QQQ	ETF	38.57	38.57	38.52	38.53	36100.0
2004-01-27 09:00:00	QQQ	ETF	38.53	38.59	38.44	38.519	7714700.0
2004-01-27 10:00:00	QQQ	ETF	38.531	38.63	38.35	38.35	16663300.0
2004-01-27 11:00:00	QQQ	ETF	38.352	38.39	38.12	38.15	12308100.0
2004-01-27 12:00:00	QQQ	ETF	38.1	38.11	37.87	37.99	13910200.0
2004-01-27 13:00:00	QQQ	ETF	37.99	38.01	37.83	38.0	8739400.0
2004-01-27 14:00:00	QQQ	ETF	38.005	38.04	37.85	37.9	9452000.0
2004-01-27 15:00:00	QQQ	ETF	37.906	37.97	37.76	37.79	13806600.0
2004-01-27 16:00:00	QQQ	ETF	37.79	37.86	37.69	37.73	6324400.0
2004-01-27 17:00:00	QQQ	ETF	37.729	37.83	37.72	37.74	2221200.0
2004-01-27 18:00:00	QQQ	ETF	37.75	37.78	37.73	37.77	52400.0
2004-01-27 19:00:00	QQQ	ETF	37.77	37.81	37.77	37.79	22600.0
2004-01-27 09:00:00	IWM	ETF	59.91	59.95	59.625	59.805	466200.0
2004-01-27 10:00:00	IWM	ETF	59.775	59.875	59.645	59.695	650600.0
2004-01-27 11:00:00	IWM	ETF	59.69	59.69	59.43	59.575	802000.0
2004-01-27 12:00:00	IWM	ETF	59.5	59.52	59.385	59.43	998800.0
2004-01-27 13:00:00	IWM	ETF	59.43	59.5	59.25	59.435	1029600.0
2004-01-27 14:00:00	IWM	ETF	59.44	59.565	59.35	59.515	669200.0
2004-01-27 15:00:00	IWM	ETF	59.475	59.545	59.175	59.175	1314600.0
2004-01-27 16:00:00	IWM	ETF	59.195	59.655	59.11	59.195	204400.0
2004-01-27 17:00:00	IWM	ETF	59.2	59.2	59.175	59.175	3200.0
2004-01-27 18:00:00	IWM	ETF	59.175	59.175	59.175	59.175	600.0
2004-01-27 08:00:00	DIA	ETF	107.05	107.12	107.05	107.1	13200.0
2004-01-27 09:00:00	DIA	ETF	107.13	107.21	106.91	106.97	379500.0
2004-01-27 10:00:00	DIA	ETF	106.97	107.14	106.82	106.91	1115900.0
2004-01-27 11:00:00	DIA	ETF	106.88	106.99	106.71	106.8	692200.0
2004-01-27 12:00:00	DIA	ETF	106.72	106.75	106.52	106.65	419600.0
2004-01-27 13:00:00	DIA	ETF	106.64	106.67	106.3	106.54	841000.0
2004-01-27 14:00:00	DIA	ETF	106.53	106.7	106.38	106.548	989300.0
2004-01-27 15:00:00	DIA	ETF	106.54	106.62	106.25	106.26	662000.0
2004-01-27 16:00:00	DIA	ETF	106.27	106.38	106.22	106.23	254000.0
2004-01-27 17:00:00	DIA	ETF	106.26	106.26	106.25	106.25	500.0
2004-01-27 18:00:00	DIA	ETF	106.25	106.25	106.24	106.24	1100.0
2004-01-27 09:00:00	TLT	ETF	86.73	86.89	86.73	86.79	9500.0
2004-01-27 10:00:00	TLT	ETF	86.8	87.27	86.8	87.25	72800.0
2004-01-27 11:00:00	TLT	ETF	87.25	87.36	87.14	87.15	38700.0
2004-01-27 12:00:00	TLT	ETF	87.2	87.4	87.17	87.2	220500.0
2004-01-27 13:00:00	TLT	ETF	87.2	87.29	87.18	87.19	112800.0

> showing 50 of 659 rows — these rows as CSV

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