PREVIEW / etf_1hour / 2004-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-14.parquet
  size:    25 KB
  rows:    669

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-07-14 08:00:00	SPY	ETF	111.35	111.35	111.11	111.15	85200.0
2004-07-14 09:00:00	SPY	ETF	111.18	111.62	111.15	111.54	5640700.0
2004-07-14 10:00:00	SPY	ETF	111.53	112.22	111.46	112.17	10872800.0
2004-07-14 11:00:00	SPY	ETF	112.17	112.39	112.07	112.19	6082000.0
2004-07-14 12:00:00	SPY	ETF	112.18	112.34	112.01	112.07	3919800.0
2004-07-14 13:00:00	SPY	ETF	112.07	112.12	111.67	111.84	6077200.0
2004-07-14 14:00:00	SPY	ETF	111.83	111.91	111.34	111.51	6600800.0
2004-07-14 15:00:00	SPY	ETF	111.52	111.62	111.12	111.5	8937300.0
2004-07-14 16:00:00	SPY	ETF	111.5	111.79	111.43	111.71	2880700.0
2004-07-14 17:00:00	SPY	ETF	111.71	111.75	111.68	111.7	211600.0
2004-07-14 18:00:00	SPY	ETF	111.7	111.71	111.61	111.65	55300.0
2004-07-14 19:00:00	SPY	ETF	111.7	111.7	111.7	111.7	100.0
2004-07-14 08:00:00	QQQ	ETF	35.26	35.31	35.13	35.13	630700.0
2004-07-14 09:00:00	QQQ	ETF	35.14	35.27	35.1	35.24	18634400.0
2004-07-14 10:00:00	QQQ	ETF	35.24	35.59	35.2	35.53	23610100.0
2004-07-14 11:00:00	QQQ	ETF	35.535	35.65	35.44	35.5077	11121300.0
2004-07-14 12:00:00	QQQ	ETF	35.506	35.58	35.36	35.423	11155500.0
2004-07-14 13:00:00	QQQ	ETF	35.425	35.47	35.29	35.38	13321700.0
2004-07-14 14:00:00	QQQ	ETF	35.37	35.44	35.13	35.21	13928300.0
2004-07-14 15:00:00	QQQ	ETF	35.219	35.29	35.05	35.21	21128500.0
2004-07-14 16:00:00	QQQ	ETF	35.22	35.36	35.16	35.34	2702600.0
2004-07-14 17:00:00	QQQ	ETF	35.34	35.38	35.31	35.34	842000.0
2004-07-14 18:00:00	QQQ	ETF	35.33	35.34	35.32	35.34	249700.0
2004-07-14 19:00:00	QQQ	ETF	35.33	35.35	35.33	35.35	13100.0
2004-07-14 08:00:00	IWM	ETF	55.66	55.66	55.66	55.66	4000.0
2004-07-14 09:00:00	IWM	ETF	55.63	55.785	55.54	55.755	920600.0
2004-07-14 10:00:00	IWM	ETF	55.74	56.43	55.735	56.36	2284800.0
2004-07-14 11:00:00	IWM	ETF	56.36	56.46	56.225	56.27	1680400.0
2004-07-14 12:00:00	IWM	ETF	56.27	56.42	56.18	56.245	562400.0
2004-07-14 13:00:00	IWM	ETF	56.25	56.275	55.9	56.075	1739400.0
2004-07-14 14:00:00	IWM	ETF	56.075	56.12	55.71	55.82	861600.0
2004-07-14 15:00:00	IWM	ETF	55.835	55.865	55.645	55.745	3126000.0
2004-07-14 16:00:00	IWM	ETF	55.745	55.825	55.69	55.825	428000.0
2004-07-14 17:00:00	IWM	ETF	55.82	55.82	55.735	55.81	1000.0
2004-07-14 08:00:00	DIA	ETF	102.17	102.17	101.95	102.09	25900.0
2004-07-14 09:00:00	DIA	ETF	102.05	102.35	102.05	102.3	801900.0
2004-07-14 10:00:00	DIA	ETF	102.3	102.96	102.25	102.87	1378400.0
2004-07-14 11:00:00	DIA	ETF	102.82	103.09	102.8	102.92	915900.0
2004-07-14 12:00:00	DIA	ETF	102.91	103.04	102.77	102.83	450000.0
2004-07-14 13:00:00	DIA	ETF	102.82	102.85	102.47	102.59	1066900.0
2004-07-14 14:00:00	DIA	ETF	102.6	102.63	102.12	102.25	571200.0
2004-07-14 15:00:00	DIA	ETF	102.27	102.42	101.92	102.27	1481000.0
2004-07-14 16:00:00	DIA	ETF	102.21	102.46	102.21	102.45	113400.0
2004-07-14 17:00:00	DIA	ETF	102.46	102.46	102.31	102.31	700.0
2004-07-14 18:00:00	DIA	ETF	102.31	102.31	102.31	102.31	200.0
2004-07-14 09:00:00	TLT	ETF	84.32	84.32	84.19	84.19	18700.0
2004-07-14 10:00:00	TLT	ETF	84.24	84.29	84.18	84.18	7300.0
2004-07-14 11:00:00	TLT	ETF	84.17	84.25	84.15	84.18	5700.0
2004-07-14 12:00:00	TLT	ETF	84.18	84.29	84.16	84.29	10700.0
2004-07-14 13:00:00	TLT	ETF	84.33	84.34	84.29	84.33	29800.0

> showing 50 of 669 rows — these rows as CSV

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