PREVIEW / etf_1hour / 2004-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-12.parquet
  size:    25 KB
  rows:    680

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-08-12 08:00:00	SPY	ETF	107.69	107.9	107.57	107.83	339900.0
2004-08-12 09:00:00	SPY	ETF	107.83	107.95	107.62	107.84	3965700.0
2004-08-12 10:00:00	SPY	ETF	107.84	107.85	107.2	107.36	8255800.0
2004-08-12 11:00:00	SPY	ETF	107.38	107.72	107.31	107.4	6282100.0
2004-08-12 12:00:00	SPY	ETF	107.4	107.53	107.26	107.42	3121200.0
2004-08-12 13:00:00	SPY	ETF	107.42	107.42	106.77	107.1	7884000.0
2004-08-12 14:00:00	SPY	ETF	107.09	107.36	106.89	107.24	6712500.0
2004-08-12 15:00:00	SPY	ETF	107.24	107.26	106.82	106.85	7769000.0
2004-08-12 16:00:00	SPY	ETF	106.85	108.1205	106.7	107.0	4258200.0
2004-08-12 17:00:00	SPY	ETF	107.03	107.03	106.96	107.03	784100.0
2004-08-12 18:00:00	SPY	ETF	107.04	107.19	107.04	107.12	19900.0
2004-08-12 19:00:00	SPY	ETF	107.13	107.13	107.07	107.07	5000.0
2004-08-12 08:00:00	QQQ	ETF	32.77	32.83	32.71	32.79	653200.0
2004-08-12 09:00:00	QQQ	ETF	32.79	32.857	32.66	32.784	13322800.0
2004-08-12 10:00:00	QQQ	ETF	32.78	32.8	32.539	32.6	17901300.0
2004-08-12 11:00:00	QQQ	ETF	32.61	32.79	32.57	32.62	11841300.0
2004-08-12 12:00:00	QQQ	ETF	32.62	32.69	32.544	32.63	8769200.0
2004-08-12 13:00:00	QQQ	ETF	32.62	32.63	32.37	32.51	14001500.0
2004-08-12 14:00:00	QQQ	ETF	32.504	32.678	32.39	32.6	19525400.0
2004-08-12 15:00:00	QQQ	ETF	32.61	32.611	32.45	32.456	16250000.0
2004-08-12 16:00:00	QQQ	ETF	32.46	32.6	32.4	32.578	5520400.0
2004-08-12 17:00:00	QQQ	ETF	32.57	32.62	32.55	32.62	340700.0
2004-08-12 18:00:00	QQQ	ETF	32.6	32.655	32.6	32.62	236100.0
2004-08-12 19:00:00	QQQ	ETF	32.62	32.66	32.6	32.62	122100.0
2004-08-12 08:00:00	IWM	ETF	52.095	52.305	52.095	52.265	6800.0
2004-08-12 09:00:00	IWM	ETF	52.275	52.275	51.885	52.1	1355400.0
2004-08-12 10:00:00	IWM	ETF	52.1	52.1	51.63	51.895	1806000.0
2004-08-12 11:00:00	IWM	ETF	51.885	52.035	51.805	51.85	554400.0
2004-08-12 12:00:00	IWM	ETF	51.85	51.965	51.815	51.965	1126200.0
2004-08-12 13:00:00	IWM	ETF	51.935	51.935	51.58	51.775	1179600.0
2004-08-12 14:00:00	IWM	ETF	51.75	51.915	51.61	51.89	1187000.0
2004-08-12 15:00:00	IWM	ETF	51.86	51.875	51.525	51.565	1578600.0
2004-08-12 16:00:00	IWM	ETF	51.57	51.745	51.5	51.745	679000.0
2004-08-12 17:00:00	IWM	ETF	51.725	51.745	51.725	51.745	1000.0
2004-08-12 18:00:00	IWM	ETF	51.745	51.765	51.745	51.765	1000.0
2004-08-12 08:00:00	DIA	ETF	99.36	99.5	99.26	99.43	50400.0
2004-08-12 09:00:00	DIA	ETF	99.45	99.48	99.2	99.34	462300.0
2004-08-12 10:00:00	DIA	ETF	99.34	99.34	98.82	98.94	1117900.0
2004-08-12 11:00:00	DIA	ETF	98.92	99.27	98.91	99.01	761200.0
2004-08-12 12:00:00	DIA	ETF	99.0	99.11	98.84	98.94	360600.0
2004-08-12 13:00:00	DIA	ETF	98.93	98.93	98.41	98.68	1172300.0
2004-08-12 14:00:00	DIA	ETF	98.69	98.9	98.49	98.82	931100.0
2004-08-12 15:00:00	DIA	ETF	98.8	98.86	98.49	98.5	1219300.0
2004-08-12 16:00:00	DIA	ETF	98.5	98.7	98.32	98.64	466800.0
2004-08-12 17:00:00	DIA	ETF	98.64	98.64	98.6	98.6	1300.0
2004-08-12 18:00:00	DIA	ETF	98.64	98.7	98.64	98.7	4900.0
2004-08-12 19:00:00	DIA	ETF	98.7	98.7	98.64	98.64	700.0
2004-08-12 08:00:00	TLT	ETF	85.95	85.95	85.95	85.95	10000.0
2004-08-12 09:00:00	TLT	ETF	86.0	86.0	85.89	85.89	258700.0
2004-08-12 10:00:00	TLT	ETF	85.89	86.05	85.89	85.95	20600.0

> showing 50 of 680 rows — these rows as CSV

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