PREVIEW / etf_1hour / 2005-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-07.parquet
  size:    30 KB
  rows:    880

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
2005-03-07 08:00:00	SPY	ETF	122.73	122.79	122.64	122.66	91700.0
2005-03-07 09:00:00	SPY	ETF	122.69	122.96	122.59	122.87	7086300.0
2005-03-07 10:00:00	SPY	ETF	122.87	123.09	122.4	122.82	10216700.0
2005-03-07 11:00:00	SPY	ETF	122.82	123.25	122.79	123.06	5429600.0
2005-03-07 12:00:00	SPY	ETF	123.06	123.24	122.88	123.05	3038600.0
2005-03-07 13:00:00	SPY	ETF	123.06	123.18	122.93	123.03	4637200.0
2005-03-07 14:00:00	SPY	ETF	123.03	123.1	122.75	123.0	3502700.0
2005-03-07 15:00:00	SPY	ETF	123.0	123.13	122.74	122.78	5938500.0
2005-03-07 16:00:00	SPY	ETF	122.84	122.85	122.63	122.7	998100.0
2005-03-07 17:00:00	SPY	ETF	122.71	122.72	122.66	122.7	117300.0
2005-03-07 18:00:00	SPY	ETF	122.69	122.69	122.65	122.65	1000.0
2005-03-07 19:00:00	SPY	ETF	122.65	122.65	122.65	122.65	400.0
2005-03-07 09:00:00	QQQ	ETF	37.6	37.97	37.56	37.93	14280900.0
2005-03-07 10:00:00	QQQ	ETF	37.94	38.2	37.08	38.09	24600700.0
2005-03-07 11:00:00	QQQ	ETF	38.08	38.24	37.11	38.13	11204500.0
2005-03-07 12:00:00	QQQ	ETF	38.13	38.29	38.12	38.19	8511600.0
2005-03-07 13:00:00	QQQ	ETF	38.19	38.24	38.1	38.17	5624200.0
2005-03-07 14:00:00	QQQ	ETF	38.17	38.21	38.05	38.12	8324100.0
2005-03-07 15:00:00	QQQ	ETF	38.12	38.22	38.0	38.04	11982400.0
2005-03-07 08:00:00	IWM	ETF	64.425	64.425	64.39	64.39	3600.0
2005-03-07 09:00:00	IWM	ETF	64.35	64.475	64.265	64.38	1730800.0
2005-03-07 10:00:00	IWM	ETF	64.39	64.59	64.325	64.375	2035800.0
2005-03-07 11:00:00	IWM	ETF	64.37	64.635	64.355	64.535	1582600.0
2005-03-07 12:00:00	IWM	ETF	64.525	64.64	64.385	64.41	1136800.0
2005-03-07 13:00:00	IWM	ETF	64.415	64.56	64.34	64.55	1580200.0
2005-03-07 14:00:00	IWM	ETF	64.55	64.61	64.17	64.265	2190400.0
2005-03-07 15:00:00	IWM	ETF	64.265	64.365	64.13	64.2	2147200.0
2005-03-07 16:00:00	IWM	ETF	64.225	64.24	64.07	64.11	349000.0
2005-03-07 18:00:00	IWM	ETF	64.185	64.185	64.185	64.185	1600.0
2005-03-07 08:00:00	DIA	ETF	109.48	109.48	109.43	109.43	1800.0
2005-03-07 09:00:00	DIA	ETF	109.45	109.63	109.35	109.58	764100.0
2005-03-07 10:00:00	DIA	ETF	109.57	109.69	109.37	109.44	536800.0
2005-03-07 11:00:00	DIA	ETF	109.46	109.83	109.41	109.71	731400.0
2005-03-07 12:00:00	DIA	ETF	109.69	109.82	109.65	109.67	254200.0
2005-03-07 13:00:00	DIA	ETF	109.69	109.75	109.58	109.69	216900.0
2005-03-07 14:00:00	DIA	ETF	109.7	109.72	109.42	109.6	495100.0
2005-03-07 15:00:00	DIA	ETF	109.6	109.68	109.3	109.36	1045700.0
2005-03-07 16:00:00	DIA	ETF	109.35	109.35	109.27	109.3	14300.0
2005-03-07 17:00:00	DIA	ETF	109.31	109.31	109.31	109.31	100.0
2005-03-07 18:00:00	DIA	ETF	109.33	109.33	109.24	109.31	1700.0
2005-03-07 19:00:00	DIA	ETF	109.33	109.33	109.33	109.33	300.0
2005-03-07 09:00:00	GLD	ETF	43.24	43.33	43.24	43.3	125800.0
2005-03-07 10:00:00	GLD	ETF	43.28	43.35	43.27	43.35	168000.0
2005-03-07 11:00:00	GLD	ETF	43.36	43.5	43.35	43.48	102500.0
2005-03-07 12:00:00	GLD	ETF	43.48	43.51	43.44	43.5	159800.0
2005-03-07 13:00:00	GLD	ETF	43.51	43.51	43.433	43.47	570500.0
2005-03-07 14:00:00	GLD	ETF	43.45	43.47	43.4	43.42	51600.0
2005-03-07 15:00:00	GLD	ETF	43.42	43.46	43.4	43.44	100400.0
2005-03-07 08:00:00	TLT	ETF	90.78	90.78	90.75	90.75	2100.0
2005-03-07 09:00:00	TLT	ETF	90.85	90.97	90.75	90.97	163600.0

> showing 50 of 880 rows — these rows as CSV

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