PREVIEW / etf_1hour / 2004-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-30.parquet
  size:    25 KB
  rows:    695

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-04-30 08:00:00	SPY	ETF	112.2	112.38	112.19	112.3	91200.0
2004-04-30 09:00:00	SPY	ETF	112.3	112.38	111.92	111.94	5479800.0
2004-04-30 10:00:00	SPY	ETF	111.94	112.24	111.49	111.98	9017000.0
2004-04-30 11:00:00	SPY	ETF	111.99	112.3	111.72	111.86	4241000.0
2004-04-30 12:00:00	SPY	ETF	111.85	112.06	111.6	111.73	2898100.0
2004-04-30 13:00:00	SPY	ETF	111.72	112.06	111.62	112.0	2921100.0
2004-04-30 14:00:00	SPY	ETF	112.02	112.13	111.68	111.73	2255200.0
2004-04-30 15:00:00	SPY	ETF	111.74	111.76	111.1	111.13	7593800.0
2004-04-30 16:00:00	SPY	ETF	111.12	111.14	110.84	110.85	3228400.0
2004-04-30 17:00:00	SPY	ETF	110.85	110.96	110.81	110.86	39400.0
2004-04-30 18:00:00	SPY	ETF	110.9	110.9	110.9	110.9	500.0
2004-04-30 19:00:00	SPY	ETF	110.9	110.9	110.9	110.9	1600.0
2004-04-30 08:00:00	QQQ	ETF	35.72	35.83	35.68	35.78	654000.0
2004-04-30 09:00:00	QQQ	ETF	35.77	35.8	35.51	35.569	17635500.0
2004-04-30 10:00:00	QQQ	ETF	35.56	35.63	35.32	35.48	23629900.0
2004-04-30 11:00:00	QQQ	ETF	35.48	35.63	35.3	35.36	12853400.0
2004-04-30 12:00:00	QQQ	ETF	35.36	35.421	35.18	35.23	12302700.0
2004-04-30 13:00:00	QQQ	ETF	35.247	35.42	35.17	35.32	13263000.0
2004-04-30 14:00:00	QQQ	ETF	35.31	35.4	35.2	35.232	8656700.0
2004-04-30 15:00:00	QQQ	ETF	35.23	35.237	34.83	34.837	29729800.0
2004-04-30 16:00:00	QQQ	ETF	34.86	34.95	34.71	34.76	7667500.0
2004-04-30 17:00:00	QQQ	ETF	34.77	34.91	34.73	34.75	740200.0
2004-04-30 18:00:00	QQQ	ETF	34.75	34.77	34.73	34.76	22000.0
2004-04-30 19:00:00	QQQ	ETF	34.77	34.79	34.75	34.75	8800.0
2004-04-30 08:00:00	IWM	ETF	56.75	56.845	56.75	56.845	48800.0
2004-04-30 09:00:00	IWM	ETF	56.815	56.9	56.265	56.305	2927400.0
2004-04-30 10:00:00	IWM	ETF	56.325	56.65	55.94	56.425	3621600.0
2004-04-30 11:00:00	IWM	ETF	56.415	56.735	56.295	56.32	828600.0
2004-04-30 12:00:00	IWM	ETF	56.395	56.42	56.06	56.075	842600.0
2004-04-30 13:00:00	IWM	ETF	56.07	56.37	55.965	56.295	1090400.0
2004-04-30 14:00:00	IWM	ETF	56.295	56.37	56.09	56.11	1164800.0
2004-04-30 15:00:00	IWM	ETF	56.11	56.12	55.58	55.67	3337000.0
2004-04-30 16:00:00	IWM	ETF	55.65	55.805	55.555	55.555	1008600.0
2004-04-30 17:00:00	IWM	ETF	55.555	55.555	55.555	55.555	2000.0
2004-04-30 08:00:00	DIA	ETF	103.3	103.45	103.28	103.41	9200.0
2004-04-30 09:00:00	DIA	ETF	103.38	103.41	103.02	103.13	351200.0
2004-04-30 10:00:00	DIA	ETF	103.14	103.47	102.81	103.26	1761300.0
2004-04-30 11:00:00	DIA	ETF	103.27	103.55	103.05	103.21	354700.0
2004-04-30 12:00:00	DIA	ETF	103.21	103.34	103.01	103.07	294200.0
2004-04-30 13:00:00	DIA	ETF	103.07	103.39	103.03	103.33	346500.0
2004-04-30 14:00:00	DIA	ETF	103.33	103.49	103.1	103.16	327000.0
2004-04-30 15:00:00	DIA	ETF	103.12	103.13	102.51	102.59	1643300.0
2004-04-30 16:00:00	DIA	ETF	102.55	102.6	102.3	102.39	84900.0
2004-04-30 17:00:00	DIA	ETF	102.38	102.44	102.38	102.4	9600.0
2004-04-30 19:00:00	DIA	ETF	102.55	102.55	102.55	102.55	900.0
2004-04-30 08:00:00	TLT	ETF	83.5	83.64	83.44	83.63	105500.0
2004-04-30 09:00:00	TLT	ETF	83.55	83.62	83.4	83.62	281000.0
2004-04-30 10:00:00	TLT	ETF	83.61	83.67	83.27	83.42	73900.0
2004-04-30 11:00:00	TLT	ETF	83.48	83.77	83.48	83.65	58000.0
2004-04-30 12:00:00	TLT	ETF	83.63	83.76	83.58	83.63	33300.0

> showing 50 of 695 rows — these rows as CSV

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