PREVIEW / etf_1hour / 2004-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-14.parquet
  size:    25 KB
  rows:    700

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-06-14 08:00:00	SPY	ETF	113.77	113.81	113.72	113.81	33900.0
2004-06-14 09:00:00	SPY	ETF	113.81	113.84	113.51	113.6	4480100.0
2004-06-14 10:00:00	SPY	ETF	113.61	113.67	113.38	113.39	4607300.0
2004-06-14 11:00:00	SPY	ETF	113.39	113.46	113.3	113.34	3352800.0
2004-06-14 12:00:00	SPY	ETF	113.31	113.38	113.13	113.36	3415000.0
2004-06-14 13:00:00	SPY	ETF	113.36	113.45	113.1	113.26	2775100.0
2004-06-14 14:00:00	SPY	ETF	113.26	113.35	112.97	113.01	4335300.0
2004-06-14 15:00:00	SPY	ETF	113.01	113.26	112.87	113.19	6189300.0
2004-06-14 16:00:00	SPY	ETF	113.17	113.31	113.1	113.27	1657300.0
2004-06-14 17:00:00	SPY	ETF	113.3	113.3	113.22	113.25	6300.0
2004-06-14 18:00:00	SPY	ETF	113.33	113.37	113.33	113.37	3200.0
2004-06-14 19:00:00	SPY	ETF	113.35	113.35	113.3	113.3	2400.0
2004-06-14 08:00:00	QQQ	ETF	36.55	36.58	36.53	36.53	138800.0
2004-06-14 09:00:00	QQQ	ETF	36.55	36.61	36.44	36.494	8122600.0
2004-06-14 10:00:00	QQQ	ETF	36.49	36.56	36.348	36.35	12513700.0
2004-06-14 11:00:00	QQQ	ETF	36.37	36.384	36.3	36.35	8286100.0
2004-06-14 12:00:00	QQQ	ETF	36.331	36.36	36.21	36.3	9363100.0
2004-06-14 13:00:00	QQQ	ETF	36.3	36.338	36.21	36.271	6052400.0
2004-06-14 14:00:00	QQQ	ETF	36.27	36.33	36.12	36.16	8161600.0
2004-06-14 15:00:00	QQQ	ETF	36.156	36.3	36.1	36.24	16462000.0
2004-06-14 16:00:00	QQQ	ETF	36.25	36.8267	36.23	36.347	8427600.0
2004-06-14 17:00:00	QQQ	ETF	36.35	36.36	36.22	36.35	486600.0
2004-06-14 18:00:00	QQQ	ETF	36.329	36.35	36.313	36.32	48200.0
2004-06-14 19:00:00	QQQ	ETF	36.32	36.35	36.32	36.35	2800.0
2004-06-14 08:00:00	IWM	ETF	56.49	56.49	56.49	56.49	1000.0
2004-06-14 09:00:00	IWM	ETF	56.48	56.55	56.185	56.215	1397400.0
2004-06-14 10:00:00	IWM	ETF	56.205	56.315	55.975	56.0	1920600.0
2004-06-14 11:00:00	IWM	ETF	55.99	56.055	55.885	55.92	729000.0
2004-06-14 12:00:00	IWM	ETF	55.91	56.015	55.79	55.965	1275800.0
2004-06-14 13:00:00	IWM	ETF	55.965	56.01	55.75	55.865	912000.0
2004-06-14 14:00:00	IWM	ETF	55.865	55.965	55.67	55.705	1161800.0
2004-06-14 15:00:00	IWM	ETF	55.74	55.975	55.615	55.655	3032000.0
2004-06-14 16:00:00	IWM	ETF	55.65	55.735	55.36	55.72	549000.0
2004-06-14 18:00:00	IWM	ETF	55.775	55.775	55.775	55.775	800.0
2004-06-14 19:00:00	IWM	ETF	55.79	55.81	55.79	55.81	1200.0
2004-06-14 08:00:00	DIA	ETF	103.9	103.92	103.85	103.85	6000.0
2004-06-14 09:00:00	DIA	ETF	103.95	103.97	103.72	103.76	476800.0
2004-06-14 10:00:00	DIA	ETF	103.75	103.86	103.61	103.68	365100.0
2004-06-14 11:00:00	DIA	ETF	103.65	103.71	103.55	103.59	409600.0
2004-06-14 12:00:00	DIA	ETF	103.58	103.65	103.45	103.62	284300.0
2004-06-14 13:00:00	DIA	ETF	103.65	103.71	103.47	103.55	806100.0
2004-06-14 14:00:00	DIA	ETF	103.55	103.65	103.37	103.43	418300.0
2004-06-14 15:00:00	DIA	ETF	103.39	103.59	103.3	103.54	914900.0
2004-06-14 16:00:00	DIA	ETF	103.59	103.65	103.42	103.65	125400.0
2004-06-14 18:00:00	DIA	ETF	103.69	103.69	103.69	103.69	500.0
2004-06-14 19:00:00	DIA	ETF	103.68	103.68	103.68	103.68	500.0
2004-06-14 08:00:00	TLT	ETF	81.17	81.17	81.17	81.17	200.0
2004-06-14 09:00:00	TLT	ETF	81.2	81.22	81.11	81.21	336400.0
2004-06-14 10:00:00	TLT	ETF	81.21	81.23	81.14	81.2	141900.0
2004-06-14 11:00:00	TLT	ETF	81.19	81.21	81.19	81.2	6400.0

> showing 50 of 700 rows — these rows as CSV

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