PREVIEW / etf_1hour / 2004-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-15.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-04-15 08:00:00	SPY	ETF	113.45	113.62	113.25	113.61	57800.0
2004-04-15 09:00:00	SPY	ETF	113.6	113.78	113.28	113.42	3469500.0
2004-04-15 10:00:00	SPY	ETF	113.43	113.52	112.86	112.88	11420200.0
2004-04-15 11:00:00	SPY	ETF	112.91	113.22	112.85	113.1	4962000.0
2004-04-15 12:00:00	SPY	ETF	113.12	113.32	112.67	113.15	4901000.0
2004-04-15 13:00:00	SPY	ETF	113.16	113.18	112.7	112.75	2468400.0
2004-04-15 14:00:00	SPY	ETF	112.74	113.05	112.36	113.0	5850700.0
2004-04-15 15:00:00	SPY	ETF	113.0	113.39	112.88	113.17	4728900.0
2004-04-15 16:00:00	SPY	ETF	113.2	113.21	112.65	112.76	2000500.0
2004-04-15 17:00:00	SPY	ETF	112.79	113.22	112.7	112.71	60100.0
2004-04-15 18:00:00	SPY	ETF	112.7	112.77	112.7	112.73	17500.0
2004-04-15 19:00:00	SPY	ETF	112.73	112.77	112.7	112.7	11000.0
2004-04-15 08:00:00	QQQ	ETF	36.85	36.91	36.8	36.82	227100.0
2004-04-15 09:00:00	QQQ	ETF	36.83	36.86	36.63	36.67	6338500.0
2004-04-15 10:00:00	QQQ	ETF	36.66	36.75	36.37	36.42	15585300.0
2004-04-15 11:00:00	QQQ	ETF	36.43	36.57	36.35	36.43	9384000.0
2004-04-15 12:00:00	QQQ	ETF	36.44	36.5	36.23	36.35	12509700.0
2004-04-15 13:00:00	QQQ	ETF	36.35	36.37	36.13	36.15	9991600.0
2004-04-15 14:00:00	QQQ	ETF	36.15	36.29	36.02	36.287	17377700.0
2004-04-15 15:00:00	QQQ	ETF	36.28	36.46	36.22	36.312	13140000.0
2004-04-15 16:00:00	QQQ	ETF	36.309	36.32	35.945	35.99	5581600.0
2004-04-15 17:00:00	QQQ	ETF	35.98	36.01	35.91	35.93	1686700.0
2004-04-15 18:00:00	QQQ	ETF	35.93	35.96	35.92	35.96	101900.0
2004-04-15 19:00:00	QQQ	ETF	35.95	35.97	35.93	35.93	22800.0
2004-04-15 08:00:00	IWM	ETF	58.25	58.25	58.25	58.25	4000.0
2004-04-15 09:00:00	IWM	ETF	58.21	58.475	58.075	58.075	1172600.0
2004-04-15 10:00:00	IWM	ETF	58.11	58.25	57.635	57.65	1053400.0
2004-04-15 11:00:00	IWM	ETF	57.615	57.85	57.56	57.665	1119000.0
2004-04-15 12:00:00	IWM	ETF	57.66	57.845	57.55	57.78	679400.0
2004-04-15 13:00:00	IWM	ETF	57.785	57.79	57.4	57.47	488600.0
2004-04-15 14:00:00	IWM	ETF	57.495	57.675	57.2	57.67	1072800.0
2004-04-15 15:00:00	IWM	ETF	57.665	57.99	57.62	57.75	2112200.0
2004-04-15 16:00:00	IWM	ETF	57.71	57.825	57.625	57.655	1438000.0
2004-04-15 17:00:00	IWM	ETF	57.54	57.54	57.54	57.54	8000.0
2004-04-15 08:00:00	DIA	ETF	104.22	104.4	104.2	104.39	24200.0
2004-04-15 09:00:00	DIA	ETF	104.4	104.53	104.09	104.2	571000.0
2004-04-15 10:00:00	DIA	ETF	104.19	104.34	103.76	103.79	713100.0
2004-04-15 11:00:00	DIA	ETF	103.82	104.13	103.74	104.05	425800.0
2004-04-15 12:00:00	DIA	ETF	104.04	104.22	103.72	104.15	591000.0
2004-04-15 13:00:00	DIA	ETF	104.15	104.18	103.75	103.79	509400.0
2004-04-15 14:00:00	DIA	ETF	103.76	104.0	103.4	103.97	927000.0
2004-04-15 15:00:00	DIA	ETF	103.98	104.33	103.82	104.16	785900.0
2004-04-15 16:00:00	DIA	ETF	104.14	104.22	103.64	103.7	255600.0
2004-04-15 17:00:00	DIA	ETF	103.55	103.88	103.55	103.88	100100.0
2004-04-15 19:00:00	DIA	ETF	103.66	103.79	103.66	103.79	500.0
2004-04-15 08:00:00	TLT	ETF	84.88	84.88	84.88	84.88	1000.0
2004-04-15 09:00:00	TLT	ETF	84.65	84.68	84.57	84.63	78300.0
2004-04-15 10:00:00	TLT	ETF	84.64	84.78	84.54	84.6	294000.0
2004-04-15 11:00:00	TLT	ETF	84.56	84.56	84.25	84.25	100100.0
2004-04-15 12:00:00	TLT	ETF	84.43	84.78	84.4	84.78	161400.0

> showing 50 of 680 rows — these rows as CSV

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