PREVIEW / etf_1hour / 2004-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-06.parquet
  size:    25 KB
  rows:    696

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-05-06 08:00:00	SPY	ETF	112.17	112.18	111.99	112.11	73800.0
2004-05-06 09:00:00	SPY	ETF	112.12	112.23	111.93	112.06	6404200.0
2004-05-06 10:00:00	SPY	ETF	112.08	112.4	111.43	111.55	8604800.0
2004-05-06 11:00:00	SPY	ETF	111.55	111.68	111.38	111.52	7582600.0
2004-05-06 12:00:00	SPY	ETF	111.53	111.64	111.0	111.3	6562900.0
2004-05-06 13:00:00	SPY	ETF	111.31	111.49	111.23	111.42	3294800.0
2004-05-06 14:00:00	SPY	ETF	111.41	111.65	111.22	111.6	4790600.0
2004-05-06 15:00:00	SPY	ETF	111.6	112.09	111.45	111.85	8096100.0
2004-05-06 16:00:00	SPY	ETF	111.84	111.95	111.72	111.84	2249400.0
2004-05-06 17:00:00	SPY	ETF	111.77	111.83	111.72	111.78	46400.0
2004-05-06 18:00:00	SPY	ETF	111.81	111.81	111.81	111.81	500.0
2004-05-06 19:00:00	SPY	ETF	111.87	111.87	111.86	111.86	4200.0
2004-05-06 08:00:00	QQQ	ETF	35.5	35.5	35.24	35.27	353900.0
2004-05-06 09:00:00	QQQ	ETF	35.27	35.35	35.17	35.326	11048000.0
2004-05-06 10:00:00	QQQ	ETF	35.33	35.44	34.93	35.04	24821700.0
2004-05-06 11:00:00	QQQ	ETF	35.04	35.11	34.92	35.036	13780400.0
2004-05-06 12:00:00	QQQ	ETF	35.04	35.1	34.85	34.95	11827100.0
2004-05-06 13:00:00	QQQ	ETF	34.95	35.05	34.94	35.023	6703600.0
2004-05-06 14:00:00	QQQ	ETF	35.024	35.16	34.93	35.123	9942800.0
2004-05-06 15:00:00	QQQ	ETF	35.123	35.36	35.08	35.233	17234400.0
2004-05-06 16:00:00	QQQ	ETF	35.24	35.29	35.17	35.26	2891500.0
2004-05-06 17:00:00	QQQ	ETF	35.25	35.26	35.22	35.22	112300.0
2004-05-06 18:00:00	QQQ	ETF	35.22	35.24	35.21	35.23	25500.0
2004-05-06 19:00:00	QQQ	ETF	35.23	35.26	35.21	35.25	30600.0
2004-05-06 08:00:00	IWM	ETF	56.5	56.54	56.45	56.54	15000.0
2004-05-06 09:00:00	IWM	ETF	56.53	56.53	56.075	56.19	3569200.0
2004-05-06 10:00:00	IWM	ETF	56.18	56.3	55.515	55.535	4228400.0
2004-05-06 11:00:00	IWM	ETF	55.515	55.79	55.35	55.66	4032600.0
2004-05-06 12:00:00	IWM	ETF	55.66	55.745	55.44	55.66	1405600.0
2004-05-06 13:00:00	IWM	ETF	55.655	55.85	55.63	55.77	1696800.0
2004-05-06 14:00:00	IWM	ETF	55.8	56.04	55.66	55.995	1530800.0
2004-05-06 15:00:00	IWM	ETF	56.015	56.415	55.89	56.055	2558400.0
2004-05-06 16:00:00	IWM	ETF	56.075	56.13	56.02	56.06	798400.0
2004-05-06 18:00:00	IWM	ETF	56.0	56.05	55.98	56.05	11000.0
2004-05-06 08:00:00	DIA	ETF	103.0	103.0	102.88	102.88	12800.0
2004-05-06 09:00:00	DIA	ETF	102.93	103.05	102.71	102.91	904800.0
2004-05-06 10:00:00	DIA	ETF	102.9	103.18	102.4	102.5	1987400.0
2004-05-06 11:00:00	DIA	ETF	102.48	102.59	102.32	102.36	1161000.0
2004-05-06 12:00:00	DIA	ETF	102.31	102.45	101.91	102.15	1058700.0
2004-05-06 13:00:00	DIA	ETF	102.18	102.32	102.13	102.27	678300.0
2004-05-06 14:00:00	DIA	ETF	102.29	102.47	102.13	102.43	924200.0
2004-05-06 15:00:00	DIA	ETF	102.42	102.88	102.29	102.6	1484200.0
2004-05-06 16:00:00	DIA	ETF	102.6	102.73	102.58	102.59	219600.0
2004-05-06 17:00:00	DIA	ETF	102.59	102.64	102.59	102.62	3400.0
2004-05-06 19:00:00	DIA	ETF	102.75	102.75	102.75	102.75	1000.0
2004-05-06 09:00:00	TLT	ETF	82.39	82.65	82.39	82.6	243300.0
2004-05-06 10:00:00	TLT	ETF	82.61	82.63	82.48	82.56	365300.0
2004-05-06 11:00:00	TLT	ETF	82.59	82.59	82.4	82.45	133900.0
2004-05-06 12:00:00	TLT	ETF	82.46	82.54	82.41	82.44	129300.0
2004-05-06 13:00:00	TLT	ETF	82.47	82.56	82.45	82.53	52700.0

> showing 50 of 696 rows — these rows as CSV

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