PREVIEW / etf_1hour / 2003-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-19.parquet
  size:    19 KB
  rows:    513

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
2003-12-19 08:00:00	SPY	ETF	109.18	109.34	109.05	109.34	32600.0
2003-12-19 09:00:00	SPY	ETF	109.34	109.37	108.86	108.93	6647200.0
2003-12-19 10:00:00	SPY	ETF	108.95	109.28	108.9	109.22	3912000.0
2003-12-19 11:00:00	SPY	ETF	109.21	109.37	108.71	109.1	8923800.0
2003-12-19 12:00:00	SPY	ETF	109.11	109.16	108.59	108.77	6144200.0
2003-12-19 13:00:00	SPY	ETF	108.77	108.89	108.63	108.83	3619800.0
2003-12-19 14:00:00	SPY	ETF	108.82	108.9	108.58	108.83	2366200.0
2003-12-19 15:00:00	SPY	ETF	108.84	109.11	108.8	109.03	4116800.0
2003-12-19 16:00:00	SPY	ETF	109.04	109.12	108.85	108.97	2072400.0
2003-12-19 17:00:00	SPY	ETF	108.98	109.03	108.94	109.0	17300.0
2003-12-19 18:00:00	SPY	ETF	108.97	108.97	108.97	108.97	500.0
2003-12-19 19:00:00	SPY	ETF	108.94	108.94	108.94	108.94	100.0
2003-12-19 08:00:00	QQQ	ETF	35.52	35.62	35.47	35.62	127200.0
2003-12-19 09:00:00	QQQ	ETF	35.63	35.64	35.35	35.38	13275200.0
2003-12-19 10:00:00	QQQ	ETF	35.38	35.61	35.37	35.59	10104800.0
2003-12-19 11:00:00	QQQ	ETF	35.58	35.65	35.25	35.45	16746600.0
2003-12-19 12:00:00	QQQ	ETF	35.45	35.47	35.2	35.278	17742600.0
2003-12-19 13:00:00	QQQ	ETF	35.274	35.35	35.22	35.35	6549300.0
2003-12-19 14:00:00	QQQ	ETF	35.35	35.38	35.26	35.35	5213600.0
2003-12-19 15:00:00	QQQ	ETF	35.341	35.49	35.338	35.45	10160000.0
2003-12-19 16:00:00	QQQ	ETF	35.45	35.48	35.4	35.42	4217200.0
2003-12-19 17:00:00	QQQ	ETF	35.43	35.47	35.42	35.46	54800.0
2003-12-19 18:00:00	QQQ	ETF	35.45	35.45	35.41	35.45	7500.0
2003-12-19 08:00:00	IWM	ETF	54.375	54.375	54.375	54.375	2000.0
2003-12-19 09:00:00	IWM	ETF	54.44	54.44	53.835	53.87	718800.0
2003-12-19 10:00:00	IWM	ETF	53.86	54.35	53.835	54.3	738400.0
2003-12-19 11:00:00	IWM	ETF	54.3	54.4	54.02	54.19	542200.0
2003-12-19 12:00:00	IWM	ETF	54.19	54.19	53.88	53.97	1580400.0
2003-12-19 13:00:00	IWM	ETF	53.955	54.045	53.9445	54.025	232000.0
2003-12-19 14:00:00	IWM	ETF	54.045	54.195	53.895	54.135	641800.0
2003-12-19 15:00:00	IWM	ETF	54.16	54.4625	54.1345	54.38	2178200.0
2003-12-19 16:00:00	IWM	ETF	54.39	54.435	54.175	54.3	449200.0
2003-12-19 08:00:00	DIA	ETF	102.6	102.69	102.5	102.69	7900.0
2003-12-19 09:00:00	DIA	ETF	102.7	103.07	102.57	102.61	1878700.0
2003-12-19 10:00:00	DIA	ETF	102.6	102.94	102.59	102.88	1218100.0
2003-12-19 11:00:00	DIA	ETF	102.89	103.03	102.5	102.82	2130800.0
2003-12-19 12:00:00	DIA	ETF	102.8	102.82	102.38	102.54	1097900.0
2003-12-19 13:00:00	DIA	ETF	102.535	102.66	102.43	102.52	729800.0
2003-12-19 14:00:00	DIA	ETF	102.52	102.65	102.38	102.583	819500.0
2003-12-19 15:00:00	DIA	ETF	102.58	102.9	102.58	102.8	1492800.0
2003-12-19 16:00:00	DIA	ETF	102.8	102.864	102.65	102.69	1058400.0
2003-12-19 17:00:00	DIA	ETF	102.71	102.76	102.67	102.72	3200.0
2003-12-19 18:00:00	DIA	ETF	102.72	102.72	102.66	102.66	700.0
2003-12-19 09:00:00	TLT	ETF	86.92	86.98	86.79	86.94	238400.0
2003-12-19 10:00:00	TLT	ETF	86.93	87.05	86.87	86.87	29500.0
2003-12-19 11:00:00	TLT	ETF	86.95	86.95	86.61	86.75	86200.0
2003-12-19 12:00:00	TLT	ETF	86.7	86.84	86.69	86.72	40200.0
2003-12-19 13:00:00	TLT	ETF	86.69	86.85	86.67	86.75	29700.0
2003-12-19 14:00:00	TLT	ETF	86.76	87.07	86.76	87.07	20700.0
2003-12-19 15:00:00	TLT	ETF	86.99	87.07	86.99	87.07	32900.0

> showing 50 of 513 rows — these rows as CSV

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