PREVIEW / etf_1hour / 2005-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-08.parquet
  size:    29 KB
  rows:    853

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-08 08:00:00	SPY	ETF	122.65	122.72	122.65	122.71	19900.0
2005-03-08 09:00:00	SPY	ETF	122.72	123.0	122.58	122.59	5531000.0
2005-03-08 10:00:00	SPY	ETF	122.59	122.63	122.31	122.51	8655300.0
2005-03-08 11:00:00	SPY	ETF	122.51	122.63	122.39	122.5	4728000.0
2005-03-08 12:00:00	SPY	ETF	122.5	122.58	122.39	122.48	3630400.0
2005-03-08 13:00:00	SPY	ETF	122.48	122.74	122.35	122.39	5524500.0
2005-03-08 14:00:00	SPY	ETF	122.4	122.66	122.36	122.55	3668700.0
2005-03-08 15:00:00	SPY	ETF	122.55	122.55	122.11	122.2	11047700.0
2005-03-08 16:00:00	SPY	ETF	122.22	122.42	122.2	122.31	452000.0
2005-03-08 17:00:00	SPY	ETF	122.34	122.34	122.27	122.32	47400.0
2005-03-08 18:00:00	SPY	ETF	122.31	122.33	122.26	122.27	6900.0
2005-03-08 19:00:00	SPY	ETF	122.27	122.31	122.26	122.31	2600.0
2005-03-08 09:00:00	QQQ	ETF	37.98	38.21	37.95	38.05	12952500.0
2005-03-08 10:00:00	QQQ	ETF	38.06	38.08	37.86	37.92	18337800.0
2005-03-08 11:00:00	QQQ	ETF	37.92	37.93	37.8	37.86	9055900.0
2005-03-08 12:00:00	QQQ	ETF	37.86	37.91	37.82	37.86	5713100.0
2005-03-08 13:00:00	QQQ	ETF	37.86	37.97	37.75	37.76	9616100.0
2005-03-08 14:00:00	QQQ	ETF	37.76	37.92	37.74	37.84	8468000.0
2005-03-08 15:00:00	QQQ	ETF	37.85	37.85	37.65	37.69	13781800.0
2005-03-08 08:00:00	IWM	ETF	64.15	64.17	64.13	64.17	14200.0
2005-03-08 09:00:00	IWM	ETF	64.12	64.335	64.06	64.06	953600.0
2005-03-08 10:00:00	IWM	ETF	64.06	64.075	63.825	63.895	2808000.0
2005-03-08 11:00:00	IWM	ETF	63.895	63.9	63.65	63.78	2073800.0
2005-03-08 12:00:00	IWM	ETF	63.78	63.91	63.72	63.8	1217600.0
2005-03-08 13:00:00	IWM	ETF	63.795	63.96	63.745	63.79	1846800.0
2005-03-08 14:00:00	IWM	ETF	63.8	64.02	63.74	63.86	1036600.0
2005-03-08 15:00:00	IWM	ETF	63.855	63.875	63.525	63.55	3748200.0
2005-03-08 16:00:00	IWM	ETF	63.55	63.625	63.53	63.59	672400.0
2005-03-08 17:00:00	IWM	ETF	63.59	63.59	63.585	63.585	2800.0
2005-03-08 19:00:00	IWM	ETF	63.585	63.585	63.585	63.585	200.0
2005-03-08 08:00:00	DIA	ETF	109.2	109.36	109.2	109.36	2600.0
2005-03-08 09:00:00	DIA	ETF	109.28	109.46	109.22	109.27	519800.0
2005-03-08 10:00:00	DIA	ETF	109.25	109.36	109.03	109.29	1625700.0
2005-03-08 11:00:00	DIA	ETF	109.27	109.38	109.15	109.28	911500.0
2005-03-08 12:00:00	DIA	ETF	109.28	109.36	109.2	109.29	490800.0
2005-03-08 13:00:00	DIA	ETF	109.28	109.52	109.19	109.26	646600.0
2005-03-08 14:00:00	DIA	ETF	109.26	109.45	109.18	109.34	1031800.0
2005-03-08 15:00:00	DIA	ETF	109.33	109.34	108.96	109.06	2170900.0
2005-03-08 16:00:00	DIA	ETF	109.14	109.16	109.11	109.15	48200.0
2005-03-08 08:00:00	GLD	ETF	43.52	43.65	43.52	43.65	22000.0
2005-03-08 09:00:00	GLD	ETF	43.65	43.74	43.59	43.72	1319600.0
2005-03-08 10:00:00	GLD	ETF	43.71	43.85	43.66	43.804	549600.0
2005-03-08 11:00:00	GLD	ETF	43.8	43.9	43.8	43.82	138700.0
2005-03-08 12:00:00	GLD	ETF	43.82	43.85	43.79	43.82	67800.0
2005-03-08 13:00:00	GLD	ETF	43.84	44.02	43.79	44.02	111400.0
2005-03-08 14:00:00	GLD	ETF	44.02	44.04	43.99	44.0	207900.0
2005-03-08 15:00:00	GLD	ETF	44.03	44.08	44.0	44.01	251500.0
2005-03-08 08:00:00	TLT	ETF	90.61	90.61	90.3	90.3	10500.0
2005-03-08 09:00:00	TLT	ETF	90.38	90.38	90.11	90.12	127500.0
2005-03-08 10:00:00	TLT	ETF	90.14	90.21	90.03	90.15	138100.0

> showing 50 of 853 rows — these rows as CSV

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