PREVIEW / etf_1hour / 2004-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-12.parquet
  size:    25 KB
  rows:    715

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-03-12 08:00:00	SPY	ETF	111.59	111.71	111.52	111.66	66900.0
2004-03-12 09:00:00	SPY	ETF	111.68	112.22	111.66	112.04	11662900.0
2004-03-12 10:00:00	SPY	ETF	112.08	112.26	111.58	111.78	13715800.0
2004-03-12 11:00:00	SPY	ETF	111.77	112.51	111.76	112.5	6637000.0
2004-03-12 12:00:00	SPY	ETF	112.51	112.54	112.05	112.2	3666000.0
2004-03-12 13:00:00	SPY	ETF	112.21	112.35	112.04	112.25	1859700.0
2004-03-12 14:00:00	SPY	ETF	112.28	112.53	112.21	112.34	3897400.0
2004-03-12 15:00:00	SPY	ETF	112.35	112.7	112.18	112.69	5825300.0
2004-03-12 16:00:00	SPY	ETF	112.68	112.71	112.51	112.67	1694100.0
2004-03-12 17:00:00	SPY	ETF	112.67	112.73	112.59	112.73	19000.0
2004-03-12 18:00:00	SPY	ETF	112.74	112.74	112.74	112.74	1400.0
2004-03-12 19:00:00	SPY	ETF	112.74	112.74	112.74	112.74	500.0
2004-03-12 08:00:00	QQQ	ETF	35.08	35.18	35.06	35.15	445100.0
2004-03-12 09:00:00	QQQ	ETF	35.15	35.42	35.14	35.35	23530500.0
2004-03-12 10:00:00	QQQ	ETF	35.35	35.43	35.15	35.243	18675300.0
2004-03-12 11:00:00	QQQ	ETF	35.2422	35.524	35.23	35.5	14466500.0
2004-03-12 12:00:00	QQQ	ETF	35.523	35.53	35.27	35.31	10100900.0
2004-03-12 13:00:00	QQQ	ETF	35.31	35.422	35.26	35.36	6211400.0
2004-03-12 14:00:00	QQQ	ETF	35.35	35.49	35.33	35.38	9757100.0
2004-03-12 15:00:00	QQQ	ETF	35.39	35.58	35.32	35.56	23021300.0
2004-03-12 16:00:00	QQQ	ETF	35.556	35.59	35.48	35.51	4112800.0
2004-03-12 17:00:00	QQQ	ETF	35.51	35.54	35.5	35.53	23800.0
2004-03-12 18:00:00	QQQ	ETF	35.53	35.55	35.51	35.52	29700.0
2004-03-12 19:00:00	QQQ	ETF	35.53	35.55	35.53	35.54	11100.0
2004-03-12 08:00:00	IWM	ETF	56.985	57.05	56.955	57.02	19200.0
2004-03-12 09:00:00	IWM	ETF	57.0	57.325	56.95	57.17	2242000.0
2004-03-12 10:00:00	IWM	ETF	57.175	57.25	56.91	57.005	2078800.0
2004-03-12 11:00:00	IWM	ETF	57.01	57.7	57.0	57.685	2378000.0
2004-03-12 12:00:00	IWM	ETF	57.685	57.75	57.455	57.48	1048800.0
2004-03-12 13:00:00	IWM	ETF	57.485	57.6	57.425	57.52	377200.0
2004-03-12 14:00:00	IWM	ETF	57.52	57.795	57.46	57.7	1201000.0
2004-03-12 15:00:00	IWM	ETF	57.695	58.13	57.61	58.12	2879400.0
2004-03-12 16:00:00	IWM	ETF	58.125	58.135	58.025	58.13	631200.0
2004-03-12 19:00:00	IWM	ETF	58.075	58.075	58.075	58.075	600.0
2004-03-12 08:00:00	DIA	ETF	101.7	101.82	101.7	101.79	14400.0
2004-03-12 09:00:00	DIA	ETF	101.78	102.27	101.76	102.12	1488800.0
2004-03-12 10:00:00	DIA	ETF	102.13	102.27	101.77	101.92	1322600.0
2004-03-12 11:00:00	DIA	ETF	101.91	102.5	101.87	102.5	1631700.0
2004-03-12 12:00:00	DIA	ETF	102.53	102.54	102.09	102.18	446500.0
2004-03-12 13:00:00	DIA	ETF	102.17	102.29	102.01	102.25	742900.0
2004-03-12 14:00:00	DIA	ETF	102.25	102.52	102.25	102.38	869600.0
2004-03-12 15:00:00	DIA	ETF	102.39	102.66	102.18	102.66	1365900.0
2004-03-12 16:00:00	DIA	ETF	102.62	102.66	102.5	102.54	181900.0
2004-03-12 17:00:00	DIA	ETF	102.65	102.65	102.65	102.65	100.0
2004-03-12 08:00:00	TLT	ETF	90.67	90.67	90.67	90.67	1000.0
2004-03-12 09:00:00	TLT	ETF	90.67	90.7	90.43	90.43	95200.0
2004-03-12 10:00:00	TLT	ETF	90.48	90.71	90.45	90.71	118200.0
2004-03-12 11:00:00	TLT	ETF	90.71	90.81	90.7	90.7	77100.0
2004-03-12 12:00:00	TLT	ETF	90.68	90.8	90.68	90.75	6200.0
2004-03-12 13:00:00	TLT	ETF	90.74	90.74	90.6	90.6	4500.0

> showing 50 of 715 rows — these rows as CSV

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