PREVIEW / etf_1hour / 2004-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-12.parquet
  size:    26 KB
  rows:    708

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-12 08:00:00	SPY	ETF	109.75	109.77	109.52	109.66	70500.0
2004-05-12 09:00:00	SPY	ETF	109.69	109.72	109.36	109.52	3537700.0
2004-05-12 10:00:00	SPY	ETF	109.52	109.54	108.66	108.92	13149400.0
2004-05-12 11:00:00	SPY	ETF	108.94	108.94	108.41	108.45	9080000.0
2004-05-12 12:00:00	SPY	ETF	108.44	108.62	108.2	108.46	13364400.0
2004-05-12 13:00:00	SPY	ETF	108.45	108.64	108.06	108.28	7747200.0
2004-05-12 14:00:00	SPY	ETF	108.26	109.04	108.22	108.84	10533100.0
2004-05-12 15:00:00	SPY	ETF	108.84	110.3	108.77	110.3	19542600.0
2004-05-12 16:00:00	SPY	ETF	110.3	110.53	108.12	110.48	4267600.0
2004-05-12 17:00:00	SPY	ETF	110.45	110.5	108.77	110.5	90900.0
2004-05-12 18:00:00	SPY	ETF	110.45	110.48	110.43	110.48	12100.0
2004-05-12 19:00:00	SPY	ETF	110.45	110.46	110.4	110.46	2000.0
2004-05-12 08:00:00	QQQ	ETF	35.25	35.29	35.13	35.16	291700.0
2004-05-12 09:00:00	QQQ	ETF	35.16	35.17	35.02	35.058	13500600.0
2004-05-12 10:00:00	QQQ	ETF	35.06	35.08	34.49	34.63	34593000.0
2004-05-12 11:00:00	QQQ	ETF	34.62	34.63	34.42	34.43	24766100.0
2004-05-12 12:00:00	QQQ	ETF	34.42	34.572	34.321	34.46	23304000.0
2004-05-12 13:00:00	QQQ	ETF	34.46	34.56	34.27	34.34	15504000.0
2004-05-12 14:00:00	QQQ	ETF	34.34	34.72	34.31	34.596	26222300.0
2004-05-12 15:00:00	QQQ	ETF	34.6	35.25	34.588	35.217	44821800.0
2004-05-12 16:00:00	QQQ	ETF	35.217	35.3	35.2	35.26	6143400.0
2004-05-12 17:00:00	QQQ	ETF	35.3	35.31	35.25	35.3	230500.0
2004-05-12 18:00:00	QQQ	ETF	35.3	35.311	35.29	35.3	37300.0
2004-05-12 19:00:00	QQQ	ETF	35.3	35.3	35.25	35.25	23000.0
2004-05-12 08:00:00	IWM	ETF	54.525	54.525	54.465	54.465	21600.0
2004-05-12 09:00:00	IWM	ETF	54.56	54.7	53.75	54.065	3342600.0
2004-05-12 10:00:00	IWM	ETF	54.07	54.08	53.48	53.68	3243600.0
2004-05-12 11:00:00	IWM	ETF	53.66	53.66	53.24	53.35	3173800.0
2004-05-12 12:00:00	IWM	ETF	53.355	53.57	53.15	53.5	3949800.0
2004-05-12 13:00:00	IWM	ETF	53.47	53.645	53.285	53.355	1916200.0
2004-05-12 14:00:00	IWM	ETF	53.37	54.13	53.325	53.95	4024400.0
2004-05-12 15:00:00	IWM	ETF	53.95	54.92	53.91	54.88	6792600.0
2004-05-12 16:00:00	IWM	ETF	54.875	55.18	54.1	55.04	872000.0
2004-05-12 17:00:00	IWM	ETF	55.075	55.11	55.075	55.11	4000.0
2004-05-12 18:00:00	IWM	ETF	55.125	55.125	55.125	55.125	400.0
2004-05-12 08:00:00	DIA	ETF	100.23	100.28	100.07	100.15	18700.0
2004-05-12 09:00:00	DIA	ETF	100.21	100.21	99.88	100.04	1030900.0
2004-05-12 10:00:00	DIA	ETF	100.01	100.01	99.35	99.65	2883300.0
2004-05-12 11:00:00	DIA	ETF	99.62	99.64	99.19	99.21	1986500.0
2004-05-12 12:00:00	DIA	ETF	99.21	99.3	98.94	99.17	2264000.0
2004-05-12 13:00:00	DIA	ETF	99.17	99.32	98.81	99.02	1084000.0
2004-05-12 14:00:00	DIA	ETF	98.95	99.65	98.93	99.55	1381100.0
2004-05-12 15:00:00	DIA	ETF	99.56	100.82	99.53	100.81	4189700.0
2004-05-12 16:00:00	DIA	ETF	100.81	101.03	100.78	100.96	153500.0
2004-05-12 17:00:00	DIA	ETF	101.01	101.04	100.9	100.9	14000.0
2004-05-12 18:00:00	DIA	ETF	101.01	101.01	101.01	101.01	500.0
2004-05-12 09:00:00	TLT	ETF	81.4	81.44	81.32	81.38	120200.0
2004-05-12 10:00:00	TLT	ETF	81.38	81.38	81.07	81.15	354600.0
2004-05-12 11:00:00	TLT	ETF	81.2	81.34	81.15	81.22	135300.0
2004-05-12 12:00:00	TLT	ETF	81.22	81.26	81.12	81.18	395100.0

> showing 50 of 708 rows — these rows as CSV

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