PREVIEW / etf_1hour / 2004-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-24.parquet
  size:    24 KB
  rows:    669

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-24 08:00:00	SPY	ETF	110.54	110.64	110.52	110.56	38400.0
2004-08-24 09:00:00	SPY	ETF	110.6	110.7	110.45	110.6	2473300.0
2004-08-24 10:00:00	SPY	ETF	110.58	110.73	110.06	110.22	6620600.0
2004-08-24 11:00:00	SPY	ETF	110.22	110.25	110.03	110.06	3247700.0
2004-08-24 12:00:00	SPY	ETF	110.06	110.2	109.85	110.17	4111900.0
2004-08-24 13:00:00	SPY	ETF	110.16	110.39	110.09	110.33	2449000.0
2004-08-24 14:00:00	SPY	ETF	110.33	110.34	110.08	110.11	2826800.0
2004-08-24 15:00:00	SPY	ETF	110.1	110.28	109.95	110.19	5013500.0
2004-08-24 16:00:00	SPY	ETF	110.21	110.4	110.14	110.36	810900.0
2004-08-24 17:00:00	SPY	ETF	110.37	110.38	110.31	110.32	41400.0
2004-08-24 18:00:00	SPY	ETF	110.31	110.36	110.28	110.28	81800.0
2004-08-24 19:00:00	SPY	ETF	110.28	110.28	110.18	110.18	9800.0
2004-08-24 08:00:00	QQQ	ETF	34.19	34.23	34.19	34.22	149600.0
2004-08-24 09:00:00	QQQ	ETF	34.22	34.31	34.13	34.21	12632600.0
2004-08-24 10:00:00	QQQ	ETF	34.21	34.292	33.92	33.97	19711800.0
2004-08-24 11:00:00	QQQ	ETF	33.97	33.983	33.82	33.94	11902700.0
2004-08-24 12:00:00	QQQ	ETF	33.937	34.02	33.84	34.0	9944100.0
2004-08-24 13:00:00	QQQ	ETF	34.0	34.1	33.943	34.07	7148600.0
2004-08-24 14:00:00	QQQ	ETF	34.08	34.11	33.94	33.95	7016100.0
2004-08-24 15:00:00	QQQ	ETF	33.95	34.05	33.86	34.036	12126300.0
2004-08-24 16:00:00	QQQ	ETF	34.03	34.14	34.02	34.12	3116500.0
2004-08-24 17:00:00	QQQ	ETF	34.12	34.15	34.09	34.09	494500.0
2004-08-24 18:00:00	QQQ	ETF	34.1	34.12	34.06	34.1	135900.0
2004-08-24 19:00:00	QQQ	ETF	34.12	34.12	34.07	34.11	24200.0
2004-08-24 09:00:00	IWM	ETF	54.625	54.75	54.475	54.6	917600.0
2004-08-24 10:00:00	IWM	ETF	54.58	54.73	54.195	54.325	2281000.0
2004-08-24 11:00:00	IWM	ETF	54.325	54.325	54.065	54.16	1292600.0
2004-08-24 12:00:00	IWM	ETF	54.155	54.305	54.06	54.29	1387400.0
2004-08-24 13:00:00	IWM	ETF	54.27	54.445	54.25	54.4	1996400.0
2004-08-24 14:00:00	IWM	ETF	54.385	54.385	54.17	54.19	596000.0
2004-08-24 15:00:00	IWM	ETF	54.19	54.35	54.08	54.345	1742400.0
2004-08-24 16:00:00	IWM	ETF	54.35	54.47	54.32	54.47	613400.0
2004-08-24 17:00:00	IWM	ETF	54.35	54.35	54.35	54.35	600.0
2004-08-24 08:00:00	DIA	ETF	101.23	101.34	101.21	101.27	16500.0
2004-08-24 09:00:00	DIA	ETF	101.35	101.49	101.3	101.42	755400.0
2004-08-24 10:00:00	DIA	ETF	101.41	101.57	101.02	101.14	610300.0
2004-08-24 11:00:00	DIA	ETF	101.14	101.18	100.94	100.97	450900.0
2004-08-24 12:00:00	DIA	ETF	100.97	101.05	100.73	101.01	546500.0
2004-08-24 13:00:00	DIA	ETF	101.01	101.23	100.98	101.18	218600.0
2004-08-24 14:00:00	DIA	ETF	101.2	101.2	100.96	101.03	344500.0
2004-08-24 15:00:00	DIA	ETF	101.02	101.18	100.88	101.1032	503700.0
2004-08-24 16:00:00	DIA	ETF	101.1	101.27	101.06	101.27	234300.0
2004-08-24 09:00:00	TLT	ETF	85.95	85.95	85.83	85.83	91200.0
2004-08-24 10:00:00	TLT	ETF	85.89	85.93	85.77	85.88	489700.0
2004-08-24 11:00:00	TLT	ETF	85.89	85.92	85.83	85.84	80400.0
2004-08-24 12:00:00	TLT	ETF	85.88	86.0	85.88	85.98	28600.0
2004-08-24 13:00:00	TLT	ETF	85.89	86.05	85.88	86.02	43200.0
2004-08-24 14:00:00	TLT	ETF	86.02	86.09	85.96	86.08	211200.0
2004-08-24 15:00:00	TLT	ETF	86.09	86.14	86.07	86.07	82900.0
2004-08-24 16:00:00	TLT	ETF	86.09	86.09	86.09	86.09	2800.0

> showing 50 of 669 rows — these rows as CSV

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