PREVIEW / etf_1hour / 2004-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-06.parquet
  size:    26 KB
  rows:    723

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-06 08:00:00	SPY	ETF	108.6	108.76	107.19	107.39	911000.0
2004-08-06 09:00:00	SPY	ETF	107.39	107.965	107.37	107.6	13017800.0
2004-08-06 10:00:00	SPY	ETF	107.6	107.92	107.3	107.51	12280200.0
2004-08-06 11:00:00	SPY	ETF	107.51	107.84	107.38	107.58	8722400.0
2004-08-06 12:00:00	SPY	ETF	107.58	107.8	107.43	107.51	5198300.0
2004-08-06 13:00:00	SPY	ETF	107.52	107.71	107.27	107.41	4179000.0
2004-08-06 14:00:00	SPY	ETF	107.42	107.58	107.02	107.1	8242400.0
2004-08-06 15:00:00	SPY	ETF	107.11	107.15	106.62	106.83	15225900.0
2004-08-06 16:00:00	SPY	ETF	106.83	107.04	106.7	106.72	2514400.0
2004-08-06 17:00:00	SPY	ETF	106.79	106.84	106.7	106.79	23600.0
2004-08-06 18:00:00	SPY	ETF	106.72	106.74	106.6	106.74	7800.0
2004-08-06 19:00:00	SPY	ETF	106.78	106.78	106.7	106.7	500.0
2004-08-06 08:00:00	QQQ	ETF	33.68	33.75	33.18	33.26	2333900.0
2004-08-06 09:00:00	QQQ	ETF	33.26	33.41	33.17	33.21	24989300.0
2004-08-06 10:00:00	QQQ	ETF	33.21	33.36	33.11	33.15	25288300.0
2004-08-06 11:00:00	QQQ	ETF	33.16	33.3	33.11	33.22	14296200.0
2004-08-06 12:00:00	QQQ	ETF	33.212	33.33	33.17	33.21	13393700.0
2004-08-06 13:00:00	QQQ	ETF	33.213	33.24	33.033	33.09	9525600.0
2004-08-06 14:00:00	QQQ	ETF	33.09	33.157	32.96	32.978	13289000.0
2004-08-06 15:00:00	QQQ	ETF	32.98	33.0	32.66	32.73	33578700.0
2004-08-06 16:00:00	QQQ	ETF	32.742	32.83	32.68	32.7	6139800.0
2004-08-06 17:00:00	QQQ	ETF	32.71	32.73	32.7	32.72	122000.0
2004-08-06 18:00:00	QQQ	ETF	32.712	32.75	32.7	32.7	21800.0
2004-08-06 19:00:00	QQQ	ETF	32.71	32.73	32.69	32.71	5800.0
2004-08-06 20:00:00	QQQ	ETF	32.71	32.71	32.71	32.71	500.0
2004-08-06 08:00:00	IWM	ETF	53.065	53.065	52.04	52.11	199600.0
2004-08-06 09:00:00	IWM	ETF	52.1	52.5	52.09	52.15	3020600.0
2004-08-06 10:00:00	IWM	ETF	52.13	52.38	51.945	52.13	3383600.0
2004-08-06 11:00:00	IWM	ETF	52.125	52.29	52.06	52.22	2458600.0
2004-08-06 12:00:00	IWM	ETF	52.215	52.505	52.2	52.395	1519800.0
2004-08-06 13:00:00	IWM	ETF	52.395	52.4	52.13	52.19	1656000.0
2004-08-06 14:00:00	IWM	ETF	52.175	52.27	51.96	51.99	1349600.0
2004-08-06 15:00:00	IWM	ETF	51.99	52.025	51.685	51.735	3208600.0
2004-08-06 16:00:00	IWM	ETF	51.745	52.09	51.73	51.87	378800.0
2004-08-06 17:00:00	IWM	ETF	51.85	51.85	51.85	51.85	2200.0
2004-08-06 08:00:00	DIA	ETF	99.91	100.02	98.79	98.79	129300.0
2004-08-06 09:00:00	DIA	ETF	98.87	99.38	98.82	98.9	1570600.0
2004-08-06 10:00:00	DIA	ETF	98.9	99.32	98.7	98.94	2356400.0
2004-08-06 11:00:00	DIA	ETF	98.94	99.14	98.76	98.97	1062800.0
2004-08-06 12:00:00	DIA	ETF	98.95	99.13	98.84	98.91	455700.0
2004-08-06 13:00:00	DIA	ETF	98.91	99.02	98.7	98.83	525100.0
2004-08-06 14:00:00	DIA	ETF	98.82	98.9	98.41	98.46	971200.0
2004-08-06 15:00:00	DIA	ETF	98.46	98.61	98.15	98.33	1806700.0
2004-08-06 16:00:00	DIA	ETF	98.36	98.51	98.24	98.31	85400.0
2004-08-06 17:00:00	DIA	ETF	98.35	98.35	98.35	98.35	3100.0
2004-08-06 18:00:00	DIA	ETF	98.28	98.3	98.26	98.3	1600.0
2004-08-06 19:00:00	DIA	ETF	98.2	98.2	98.2	98.2	100.0
2004-08-06 08:00:00	TLT	ETF	85.08	86.88	84.97	86.73	175400.0
2004-08-06 09:00:00	TLT	ETF	86.57	86.61	86.3	86.36	444500.0
2004-08-06 10:00:00	TLT	ETF	86.38	86.42	86.2	86.33	217700.0

> showing 50 of 723 rows — these rows as CSV

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