PREVIEW / etf_1hour / 2004-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-08.parquet
  size:    25 KB
  rows:    689

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-08 08:00:00	SPY	ETF	114.53	114.53	114.46	114.48	38900.0
2004-06-08 09:00:00	SPY	ETF	114.49	114.5	114.24	114.26	5839200.0
2004-06-08 10:00:00	SPY	ETF	114.27	114.56	114.17	114.44	4650500.0
2004-06-08 11:00:00	SPY	ETF	114.44	114.5	114.3	114.42	2654200.0
2004-06-08 12:00:00	SPY	ETF	114.4	114.64	114.4	114.59	2311500.0
2004-06-08 13:00:00	SPY	ETF	114.58	114.73	114.48	114.7	3392700.0
2004-06-08 14:00:00	SPY	ETF	114.66	114.92	114.57	114.77	4117600.0
2004-06-08 15:00:00	SPY	ETF	114.77	114.86	114.38	114.85	5780800.0
2004-06-08 16:00:00	SPY	ETF	114.87	114.9	114.7186	114.81	1739000.0
2004-06-08 17:00:00	SPY	ETF	114.84	114.93	114.81	114.92	325100.0
2004-06-08 18:00:00	SPY	ETF	114.92	114.93	114.89	114.9	5400.0
2004-06-08 19:00:00	SPY	ETF	114.88	114.88	114.87	114.87	2400.0
2004-06-08 08:00:00	QQQ	ETF	36.99	37.0	36.95	36.97	120300.0
2004-06-08 09:00:00	QQQ	ETF	36.98	37.03	36.85	36.92	9044600.0
2004-06-08 10:00:00	QQQ	ETF	36.91	37.041	36.85	36.994	13702100.0
2004-06-08 11:00:00	QQQ	ETF	36.99	37.021	36.88	36.94	7519600.0
2004-06-08 12:00:00	QQQ	ETF	36.933	37.07	36.93	37.03	7570800.0
2004-06-08 13:00:00	QQQ	ETF	37.04	37.1	36.97	37.055	5315700.0
2004-06-08 14:00:00	QQQ	ETF	37.05	37.17	37.005	37.11	8920800.0
2004-06-08 15:00:00	QQQ	ETF	37.126	37.19	36.93	37.16	15523600.0
2004-06-08 16:00:00	QQQ	ETF	37.16	37.19	37.09	37.16	3052500.0
2004-06-08 17:00:00	QQQ	ETF	37.113	37.189	37.11	37.15	438500.0
2004-06-08 18:00:00	QQQ	ETF	37.129	37.15	37.12	37.12	33100.0
2004-06-08 19:00:00	QQQ	ETF	37.12	37.12	37.1	37.1	3700.0
2004-06-08 08:00:00	IWM	ETF	57.525	57.6	57.525	57.6	1600.0
2004-06-08 09:00:00	IWM	ETF	57.57	57.625	57.415	57.5	1282800.0
2004-06-08 10:00:00	IWM	ETF	57.495	57.65	57.455	57.575	932800.0
2004-06-08 11:00:00	IWM	ETF	57.58	57.61	57.435	57.455	432600.0
2004-06-08 12:00:00	IWM	ETF	57.455	57.63	57.455	57.595	330600.0
2004-06-08 13:00:00	IWM	ETF	57.6	57.73	57.5	57.7	659200.0
2004-06-08 14:00:00	IWM	ETF	57.69	57.795	57.605	57.74	612400.0
2004-06-08 15:00:00	IWM	ETF	57.75	57.75	57.48	57.64	1269600.0
2004-06-08 16:00:00	IWM	ETF	57.635	57.71	57.635	57.68	327800.0
2004-06-08 17:00:00	IWM	ETF	57.6	57.6	57.6	57.6	1200.0
2004-06-08 08:00:00	DIA	ETF	103.92	103.93	103.84	103.84	5100.0
2004-06-08 09:00:00	DIA	ETF	103.8	103.95	103.67	103.76	637800.0
2004-06-08 10:00:00	DIA	ETF	103.7516	104.08	103.67	103.98	902800.0
2004-06-08 11:00:00	DIA	ETF	103.99	104.07	103.9	103.98	491500.0
2004-06-08 12:00:00	DIA	ETF	103.99	104.2	103.98	104.1484	536000.0
2004-06-08 13:00:00	DIA	ETF	104.14	104.27	104.07	104.21	312100.0
2004-06-08 14:00:00	DIA	ETF	104.24	104.49	104.15	104.36	526200.0
2004-06-08 15:00:00	DIA	ETF	104.35	104.44	103.97	104.41	1363400.0
2004-06-08 16:00:00	DIA	ETF	104.41	104.49	104.4	104.49	113000.0
2004-06-08 17:00:00	DIA	ETF	104.49	104.55	104.45	104.55	75800.0
2004-06-08 18:00:00	DIA	ETF	104.45	104.45	104.45	104.45	100.0
2004-06-08 19:00:00	DIA	ETF	104.54	104.55	104.54	104.55	500.0
2004-06-08 09:00:00	TLT	ETF	81.2	81.25	81.08	81.13	238200.0
2004-06-08 10:00:00	TLT	ETF	81.21	81.36	81.09	81.3	297100.0
2004-06-08 11:00:00	TLT	ETF	81.3	81.32	81.24	81.26	369800.0
2004-06-08 12:00:00	TLT	ETF	81.23	81.34	81.22	81.34	24400.0

> showing 50 of 689 rows — these rows as CSV

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