PREVIEW / etf_1hour / 2004-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-13.parquet
  size:    26 KB
  rows:    708

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-13 08:00:00	SPY	ETF	115.14	115.42	115.14	115.33	100600.0
2004-04-13 09:00:00	SPY	ETF	115.33	115.35	114.65	114.68	2702300.0
2004-04-13 10:00:00	SPY	ETF	114.67	114.68	114.2	114.43	7060900.0
2004-04-13 11:00:00	SPY	ETF	114.43	114.46	114.16	114.28	2469300.0
2004-04-13 12:00:00	SPY	ETF	114.28	114.29	113.74	113.91	5148600.0
2004-04-13 13:00:00	SPY	ETF	113.94	113.97	113.41	113.5	5607000.0
2004-04-13 14:00:00	SPY	ETF	113.5	113.64	113.18	113.33	7160000.0
2004-04-13 15:00:00	SPY	ETF	113.29	113.54	113.08	113.29	5632400.0
2004-04-13 16:00:00	SPY	ETF	113.29	113.4	113.02	113.06	3505800.0
2004-04-13 17:00:00	SPY	ETF	113.07	113.12	112.95	112.98	233400.0
2004-04-13 18:00:00	SPY	ETF	112.99	113.12	112.99	113.08	5900.0
2004-04-13 19:00:00	SPY	ETF	113.11	113.11	113.1	113.1	500.0
2004-04-13 08:00:00	QQQ	ETF	37.25	37.44	37.25	37.35	257300.0
2004-04-13 09:00:00	QQQ	ETF	37.35	37.37	37.1	37.104	6923200.0
2004-04-13 10:00:00	QQQ	ETF	37.12	37.12	36.88	36.95	10383100.0
2004-04-13 11:00:00	QQQ	ETF	36.95	37.001	36.87	36.951	7623700.0
2004-04-13 12:00:00	QQQ	ETF	36.95	36.96	36.82	36.89	6784900.0
2004-04-13 13:00:00	QQQ	ETF	36.892	36.91	36.67	36.74	7947400.0
2004-04-13 14:00:00	QQQ	ETF	36.74	36.78	36.55	36.603	14920500.0
2004-04-13 15:00:00	QQQ	ETF	36.6	36.73	36.52	36.61	10754800.0
2004-04-13 16:00:00	QQQ	ETF	36.61	36.7	36.428	36.56	5886600.0
2004-04-13 17:00:00	QQQ	ETF	36.56	36.62	36.45	36.5	331100.0
2004-04-13 18:00:00	QQQ	ETF	36.52	36.55	36.48	36.49	165200.0
2004-04-13 19:00:00	QQQ	ETF	36.51	36.55	36.5	36.55	11400.0
2004-04-13 08:00:00	IWM	ETF	60.075	60.075	60.075	60.075	1000.0
2004-04-13 09:00:00	IWM	ETF	60.045	60.075	59.45	59.47	510800.0
2004-04-13 10:00:00	IWM	ETF	59.43	59.445	58.81	58.96	2386800.0
2004-04-13 11:00:00	IWM	ETF	59.005	59.09	58.9	58.935	240600.0
2004-04-13 12:00:00	IWM	ETF	58.93	58.99	58.73	58.775	1105000.0
2004-04-13 13:00:00	IWM	ETF	58.775	58.795	58.48	58.54	1370400.0
2004-04-13 14:00:00	IWM	ETF	58.53	58.53	58.225	58.29	2037800.0
2004-04-13 15:00:00	IWM	ETF	58.315	58.615	58.1	58.335	2022800.0
2004-04-13 16:00:00	IWM	ETF	58.33	58.65	58.15	58.2	1200000.0
2004-04-13 17:00:00	IWM	ETF	58.375	58.375	57.765	57.78	311800.0
2004-04-13 18:00:00	IWM	ETF	58.17	58.17	58.17	58.17	600.0
2004-04-13 08:00:00	DIA	ETF	105.75	105.95	105.75	105.85	11700.0
2004-04-13 09:00:00	DIA	ETF	105.82	105.83	105.24	105.25	496900.0
2004-04-13 10:00:00	DIA	ETF	105.28	105.28	104.87	105.0	600800.0
2004-04-13 11:00:00	DIA	ETF	104.99	105.02	104.76	104.84	325400.0
2004-04-13 12:00:00	DIA	ETF	104.83	104.88	104.39	104.51	504300.0
2004-04-13 13:00:00	DIA	ETF	104.53	104.59	104.11	104.23	683900.0
2004-04-13 14:00:00	DIA	ETF	104.21	104.34	103.89	104.0	762100.0
2004-04-13 15:00:00	DIA	ETF	104.01	104.23	103.83	103.99	1210200.0
2004-04-13 16:00:00	DIA	ETF	103.99	104.08	103.8	103.82	163600.0
2004-04-13 17:00:00	DIA	ETF	103.8	105.31	103.69	103.7	6400.0
2004-04-13 18:00:00	DIA	ETF	103.79	103.8	103.79	103.8	200.0
2004-04-13 19:00:00	DIA	ETF	103.98	103.99	103.98	103.99	1400.0
2004-04-13 08:00:00	TLT	ETF	85.31	85.31	85.02	85.06	6700.0
2004-04-13 09:00:00	TLT	ETF	85.1	85.1	84.8	85.0	78900.0
2004-04-13 10:00:00	TLT	ETF	85.0	85.08	84.89	84.96	138300.0

> showing 50 of 708 rows — these rows as CSV

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