PREVIEW / etf_1hour / 2004-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-05.parquet
  size:    24 KB
  rows:    671

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-05-05 08:00:00	SPY	ETF	112.18	112.4	112.18	112.4	30900.0
2004-05-05 09:00:00	SPY	ETF	112.38	112.6	112.16	112.49	4859500.0
2004-05-05 10:00:00	SPY	ETF	112.47	112.89	112.21	112.64	7449300.0
2004-05-05 11:00:00	SPY	ETF	112.65	112.81	112.4	112.7	4626200.0
2004-05-05 12:00:00	SPY	ETF	112.67	112.72	112.25	112.34	3092700.0
2004-05-05 13:00:00	SPY	ETF	112.37	112.71	112.27	112.69	2623300.0
2004-05-05 14:00:00	SPY	ETF	112.71	112.96	112.59	112.81	4116700.0
2004-05-05 15:00:00	SPY	ETF	112.8	112.9	112.57	112.58	4167500.0
2004-05-05 16:00:00	SPY	ETF	112.61	112.8	112.52	112.66	1637000.0
2004-05-05 17:00:00	SPY	ETF	112.67	112.69	112.15	112.15	48600.0
2004-05-05 18:00:00	SPY	ETF	112.64	112.67	112.64	112.67	500.0
2004-05-05 19:00:00	SPY	ETF	112.65	112.65	112.65	112.65	500.0
2004-05-05 08:00:00	QQQ	ETF	35.31	35.42	35.31	35.4	95200.0
2004-05-05 09:00:00	QQQ	ETF	35.41	35.49	35.2	35.4	12775400.0
2004-05-05 10:00:00	QQQ	ETF	35.413	35.62	35.29	35.54	15814600.0
2004-05-05 11:00:00	QQQ	ETF	35.535	35.64	35.441	35.54	10090800.0
2004-05-05 12:00:00	QQQ	ETF	35.54	35.56	35.3	35.38	16171100.0
2004-05-05 13:00:00	QQQ	ETF	35.37	35.56	35.34	35.53	10101500.0
2004-05-05 14:00:00	QQQ	ETF	35.52	35.7	35.49	35.62	11978100.0
2004-05-05 15:00:00	QQQ	ETF	35.619	35.69	35.51	35.526	10768200.0
2004-05-05 16:00:00	QQQ	ETF	35.54	35.59	35.352	35.56	4828500.0
2004-05-05 17:00:00	QQQ	ETF	35.56	35.602	35.55	35.57	177200.0
2004-05-05 18:00:00	QQQ	ETF	35.58	35.58	35.56	35.56	23700.0
2004-05-05 19:00:00	QQQ	ETF	35.58	35.58	35.56	35.57	14700.0
2004-05-05 08:00:00	IWM	ETF	56.8	56.8	56.8	56.8	600.0
2004-05-05 09:00:00	IWM	ETF	56.865	57.1	56.645	56.955	1486000.0
2004-05-05 10:00:00	IWM	ETF	56.965	57.2	56.68	57.02	1943200.0
2004-05-05 11:00:00	IWM	ETF	57.025	57.085	56.795	57.01	1229400.0
2004-05-05 12:00:00	IWM	ETF	57.055	57.105	56.76	56.85	678000.0
2004-05-05 13:00:00	IWM	ETF	56.85	57.045	56.84	57.02	1218200.0
2004-05-05 14:00:00	IWM	ETF	57.015	57.15	56.925	57.05	278800.0
2004-05-05 15:00:00	IWM	ETF	57.015	57.105	56.76	56.76	1071000.0
2004-05-05 16:00:00	IWM	ETF	56.77	56.85	56.73	56.825	557400.0
2004-05-05 08:00:00	DIA	ETF	103.31	103.37	103.31	103.37	300.0
2004-05-05 09:00:00	DIA	ETF	103.43	103.54	103.19	103.47	578200.0
2004-05-05 10:00:00	DIA	ETF	103.46	103.72	103.2	103.45	517600.0
2004-05-05 11:00:00	DIA	ETF	103.46	103.62	103.28	103.53	430400.0
2004-05-05 12:00:00	DIA	ETF	103.56	103.56	103.11	103.24	480000.0
2004-05-05 13:00:00	DIA	ETF	103.23	103.5	103.15	103.47	424500.0
2004-05-05 14:00:00	DIA	ETF	103.45	103.68	103.31	103.5	505900.0
2004-05-05 15:00:00	DIA	ETF	103.5	103.59	103.28	103.35	444800.0
2004-05-05 16:00:00	DIA	ETF	103.35	103.48	103.32	103.48	87900.0
2004-05-05 09:00:00	TLT	ETF	83.26	83.26	83.09	83.12	146800.0
2004-05-05 10:00:00	TLT	ETF	83.1	83.18	83.0	83.02	738400.0
2004-05-05 11:00:00	TLT	ETF	83.02	83.04	82.94	82.97	179200.0
2004-05-05 12:00:00	TLT	ETF	82.97	82.97	82.71	82.8	164200.0
2004-05-05 13:00:00	TLT	ETF	82.8	82.9	82.73	82.74	13100.0
2004-05-05 14:00:00	TLT	ETF	82.7	82.77	82.58	82.7	198700.0
2004-05-05 15:00:00	TLT	ETF	82.71	82.74	82.5	82.55	386900.0
2004-05-05 16:00:00	TLT	ETF	82.54	82.63	82.53	82.62	14300.0

> showing 50 of 671 rows — these rows as CSV

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