PREVIEW / etf_1hour / 2004-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-06.parquet
  size:    24 KB
  rows:    698

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-06 08:00:00	SPY	ETF	115.02	115.02	114.61	114.8	50400.0
2004-04-06 09:00:00	SPY	ETF	114.81	114.94	114.7	114.89	3533500.0
2004-04-06 10:00:00	SPY	ETF	114.89	115.06	114.79	114.91	5588700.0
2004-04-06 11:00:00	SPY	ETF	114.9	114.91	114.62	114.74	4196300.0
2004-04-06 12:00:00	SPY	ETF	114.74	114.83	114.64	114.71	1816700.0
2004-04-06 13:00:00	SPY	ETF	114.7	115.01	114.68	114.86	2118000.0
2004-04-06 14:00:00	SPY	ETF	114.85	115.18	114.81	115.02	3116400.0
2004-04-06 15:00:00	SPY	ETF	115.01	115.16	114.85	115.08	3354900.0
2004-04-06 16:00:00	SPY	ETF	115.08	115.14	114.65	114.69	2841100.0
2004-04-06 17:00:00	SPY	ETF	114.71	114.75	114.65	114.75	195500.0
2004-04-06 18:00:00	SPY	ETF	114.68	114.68	114.58	114.61	24100.0
2004-04-06 08:00:00	QQQ	ETF	37.37	37.38	37.08	37.13	486600.0
2004-04-06 09:00:00	QQQ	ETF	37.13	37.23	37.1	37.1375	10994700.0
2004-04-06 10:00:00	QQQ	ETF	37.14	37.25	37.1	37.12	13239200.0
2004-04-06 11:00:00	QQQ	ETF	37.12	37.14	36.98	37.03	12250900.0
2004-04-06 12:00:00	QQQ	ETF	37.028	37.05	36.92	36.96	7976300.0
2004-04-06 13:00:00	QQQ	ETF	36.96	37.09	36.95	36.979	10191400.0
2004-04-06 14:00:00	QQQ	ETF	37.0	37.141	36.95	37.08	12720700.0
2004-04-06 15:00:00	QQQ	ETF	37.09	37.12	36.95	37.06	17537100.0
2004-04-06 16:00:00	QQQ	ETF	37.067	37.12	36.88	36.89	7209300.0
2004-04-06 17:00:00	QQQ	ETF	36.87	36.9	36.87	36.88	128700.0
2004-04-06 18:00:00	QQQ	ETF	36.87	36.87	36.8	36.86	93100.0
2004-04-06 19:00:00	QQQ	ETF	36.83	36.87	36.83	36.85	3000.0
2004-04-06 08:00:00	IWM	ETF	60.065	60.2	60.05	60.05	11000.0
2004-04-06 09:00:00	IWM	ETF	60.025	60.24	59.935	60.165	1621000.0
2004-04-06 10:00:00	IWM	ETF	60.15	60.215	59.94	60.065	1004400.0
2004-04-06 11:00:00	IWM	ETF	60.075	60.09	59.7	59.73	1164000.0
2004-04-06 12:00:00	IWM	ETF	59.75	59.79	59.65	59.7	738000.0
2004-04-06 13:00:00	IWM	ETF	59.72	59.925	59.675	59.8	1054400.0
2004-04-06 14:00:00	IWM	ETF	59.795	59.975	59.76	59.855	918800.0
2004-04-06 15:00:00	IWM	ETF	59.845	59.865	59.625	59.635	2807400.0
2004-04-06 16:00:00	IWM	ETF	59.645	59.695	59.525	59.525	414600.0
2004-04-06 08:00:00	DIA	ETF	105.2	105.38	105.16	105.27	7900.0
2004-04-06 09:00:00	DIA	ETF	105.32	105.42	105.2	105.35	596000.0
2004-04-06 10:00:00	DIA	ETF	105.35	105.57	105.31	105.42	475500.0
2004-04-06 11:00:00	DIA	ETF	105.4	105.43	105.23	105.34	637400.0
2004-04-06 12:00:00	DIA	ETF	105.36	105.47	105.29	105.37	193800.0
2004-04-06 13:00:00	DIA	ETF	105.37	105.6	105.33	105.53	430400.0
2004-04-06 14:00:00	DIA	ETF	105.54	105.81	105.49	105.65	569400.0
2004-04-06 15:00:00	DIA	ETF	105.67	105.91	105.6	105.84	673200.0
2004-04-06 16:00:00	DIA	ETF	105.84	105.89	105.48	105.48	112300.0
2004-04-06 17:00:00	DIA	ETF	105.5	105.5	105.39	105.5	1000.0
2004-04-06 18:00:00	DIA	ETF	105.4	105.47	105.33	105.33	1700.0
2004-04-06 08:00:00	TLT	ETF	86.25	86.31	86.25	86.31	2700.0
2004-04-06 09:00:00	TLT	ETF	86.23	86.41	86.23	86.41	584900.0
2004-04-06 10:00:00	TLT	ETF	86.42	86.44	86.33	86.33	462000.0
2004-04-06 11:00:00	TLT	ETF	86.33	86.37	86.23	86.32	268700.0
2004-04-06 12:00:00	TLT	ETF	86.35	86.35	86.2	86.26	115000.0
2004-04-06 13:00:00	TLT	ETF	86.27	86.35	86.23	86.25	124400.0
2004-04-06 14:00:00	TLT	ETF	86.27	86.39	86.25	86.36	66400.0

> showing 50 of 698 rows — these rows as CSV

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