PREVIEW / etf_1hour / 2006-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-14.parquet
  size:    40 KB
  rows:    1,211

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
2006-02-14 07:00:00	SPY	ETF	126.68	126.75	126.68	126.7	46000.0
2006-02-14 08:00:00	SPY	ETF	126.73	126.85	126.61	126.66	2004500.0
2006-02-14 09:00:00	SPY	ETF	126.65	126.72	126.19	126.72	9846900.0
2006-02-14 10:00:00	SPY	ETF	126.66	126.84	126.26	126.7	8814100.0
2006-02-14 11:00:00	SPY	ETF	126.7	127.54	126.63	127.49	17657600.0
2006-02-14 12:00:00	SPY	ETF	127.49	127.55	127.2379	127.32	12029800.0
2006-02-14 13:00:00	SPY	ETF	127.32	127.55	127.27	127.45	6382400.0
2006-02-14 14:00:00	SPY	ETF	127.45	128.03	127.43	127.83	20424900.0
2006-02-14 15:00:00	SPY	ETF	127.84	128.0	127.53	127.71	10935700.0
2006-02-14 16:00:00	SPY	ETF	127.71	127.75	127.63	127.63	830500.0
2006-02-14 17:00:00	SPY	ETF	127.68	127.7	127.61	127.66	251500.0
2006-02-14 18:00:00	SPY	ETF	127.69	127.69	127.65	127.65	29000.0
2006-02-14 19:00:00	SPY	ETF	127.67	127.67	127.62	127.62	800.0
2006-02-14 09:00:00	QQQ	ETF	40.56	40.7	40.41	40.7	11074700.0
2006-02-14 10:00:00	QQQ	ETF	40.7	40.73	40.45	40.62	13448600.0
2006-02-14 11:00:00	QQQ	ETF	40.63	40.8	40.61	40.77	13975600.0
2006-02-14 12:00:00	QQQ	ETF	40.78	40.8	40.7	40.73	8988100.0
2006-02-14 13:00:00	QQQ	ETF	40.73	40.8	40.67	40.77	5909200.0
2006-02-14 14:00:00	QQQ	ETF	40.78	41.0	40.77	40.99	14163200.0
2006-02-14 15:00:00	QQQ	ETF	40.99	41.02	40.84	40.89	15965900.0
2006-02-14 07:00:00	IWM	ETF	70.92	70.92	70.92	70.92	300.0
2006-02-14 08:00:00	IWM	ETF	70.92	71.0	70.91	70.92	55200.0
2006-02-14 09:00:00	IWM	ETF	70.9	70.91	70.31	70.63	6767800.0
2006-02-14 10:00:00	IWM	ETF	70.63	70.85	70.44	70.82	8063400.0
2006-02-14 11:00:00	IWM	ETF	70.82	71.5	70.77	71.44	9080600.0
2006-02-14 12:00:00	IWM	ETF	71.44	71.49	71.37	71.37	4873300.0
2006-02-14 13:00:00	IWM	ETF	71.37	71.53	71.32	71.35	3134400.0
2006-02-14 14:00:00	IWM	ETF	71.35	71.78	71.34	71.67	7487500.0
2006-02-14 15:00:00	IWM	ETF	71.66	71.74	71.44	71.47	5543400.0
2006-02-14 16:00:00	IWM	ETF	71.46	71.55	71.43	71.51	507200.0
2006-02-14 18:00:00	IWM	ETF	71.51	71.51	71.51	71.51	1300.0
2006-02-14 19:00:00	IWM	ETF	71.42	71.42	71.42	71.42	300.0
2006-02-14 08:00:00	DIA	ETF	109.38	109.44	109.3	109.32	44400.0
2006-02-14 09:00:00	DIA	ETF	109.27	109.47	109.12	109.47	2052300.0
2006-02-14 10:00:00	DIA	ETF	109.45	109.64	109.18	109.57	2343300.0
2006-02-14 11:00:00	DIA	ETF	109.57	110.28	109.49	110.2419	3464900.0
2006-02-14 12:00:00	DIA	ETF	110.22	110.33	110.09	110.13	912800.0
2006-02-14 13:00:00	DIA	ETF	110.11	110.24	110.07	110.11	428600.0
2006-02-14 14:00:00	DIA	ETF	110.11	110.55	110.1	110.42	1823000.0
2006-02-14 15:00:00	DIA	ETF	110.44	110.51	110.22	110.34	1938700.0
2006-02-14 16:00:00	DIA	ETF	110.33	110.43	110.31	110.34	93900.0
2006-02-14 17:00:00	DIA	ETF	110.34	110.34	110.34	110.34	3600.0
2006-02-14 08:00:00	GLD	ETF	53.95	54.21	53.93	54.14	48600.0
2006-02-14 09:00:00	GLD	ETF	54.15	54.16	53.7	53.79	559600.0
2006-02-14 10:00:00	GLD	ETF	53.79	54.05	53.68	54.0	746200.0
2006-02-14 11:00:00	GLD	ETF	54.0	54.25	54.0	54.2199	572800.0
2006-02-14 12:00:00	GLD	ETF	54.22	54.489	54.02	54.41	570600.0
2006-02-14 13:00:00	GLD	ETF	54.43	54.43	54.18	54.36	331200.0
2006-02-14 14:00:00	GLD	ETF	54.36	54.51	54.33	54.51	265300.0
2006-02-14 15:00:00	GLD	ETF	54.51	54.53	54.47	54.47	494500.0

> showing 50 of 1,211 rows — these rows as CSV

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