PREVIEW / etf_1hour / 2006-02-08

all etf 1-hour files

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

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-08 06:00:00	SPY	ETF	125.79	125.89	125.79	125.89	200.0
2006-02-08 07:00:00	SPY	ETF	125.8	125.93	125.8	125.85	81600.0
2006-02-08 08:00:00	SPY	ETF	125.82	125.93	125.56	125.85	1292700.0
2006-02-08 09:00:00	SPY	ETF	125.87	125.96	125.63	125.68	6858100.0
2006-02-08 10:00:00	SPY	ETF	125.69	126.07	125.6	125.77	11689400.0
2006-02-08 11:00:00	SPY	ETF	125.77	125.96	125.68	125.92	6199600.0
2006-02-08 12:00:00	SPY	ETF	125.92	126.37	125.9	126.27	7916100.0
2006-02-08 13:00:00	SPY	ETF	126.27	126.28	126.02	126.14	5699100.0
2006-02-08 14:00:00	SPY	ETF	126.14	128.1	125.96	126.21	3740700.0
2006-02-08 15:00:00	SPY	ETF	126.22	126.78	126.11	126.63	9929700.0
2006-02-08 16:00:00	SPY	ETF	126.62	126.71	126.59	126.67	1680100.0
2006-02-08 17:00:00	SPY	ETF	126.65	126.65	126.59	126.6	123200.0
2006-02-08 18:00:00	SPY	ETF	126.63	126.65	126.63	126.65	1800.0
2006-02-08 19:00:00	SPY	ETF	126.62	126.62	126.6	126.6	1300.0
2006-02-08 09:00:00	QQQ	ETF	40.92	40.93	40.72	40.76	11789500.0
2006-02-08 10:00:00	QQQ	ETF	40.75	40.89	40.69	40.75	15566700.0
2006-02-08 11:00:00	QQQ	ETF	40.76	40.9	40.69	40.88	11835400.0
2006-02-08 12:00:00	QQQ	ETF	40.88	41.11	40.88	41.01	12051700.0
2006-02-08 13:00:00	QQQ	ETF	41.01	41.02	40.89	40.95	6140600.0
2006-02-08 14:00:00	QQQ	ETF	40.94	40.98	40.83	40.95	6611400.0
2006-02-08 15:00:00	QQQ	ETF	40.94	41.15	40.91	41.1	12497400.0
2006-02-08 07:00:00	IWM	ETF	71.42	71.42	71.42	71.42	300.0
2006-02-08 08:00:00	IWM	ETF	71.44	71.46	71.4	71.41	412700.0
2006-02-08 09:00:00	IWM	ETF	71.4	71.47	71.05	71.1	2637300.0
2006-02-08 10:00:00	IWM	ETF	71.09	71.35	70.97	71.09	7062800.0
2006-02-08 11:00:00	IWM	ETF	71.08	71.14	70.88	71.06	5264500.0
2006-02-08 12:00:00	IWM	ETF	71.06	71.56	71.05	71.51	5118700.0
2006-02-08 13:00:00	IWM	ETF	71.51	71.6	71.36	71.4	3040400.0
2006-02-08 14:00:00	IWM	ETF	71.4	71.48	71.29	71.32	2495300.0
2006-02-08 15:00:00	IWM	ETF	71.32	71.84	71.26	71.66	9094100.0
2006-02-08 16:00:00	IWM	ETF	71.64	71.7	71.63	71.65	343700.0
2006-02-08 18:00:00	IWM	ETF	71.65	71.65	71.65	71.65	10000.0
2006-02-08 08:00:00	DIA	ETF	107.68	107.68	107.65	107.66	7000.0
2006-02-08 09:00:00	DIA	ETF	107.67	107.86	107.64	107.77	645100.0
2006-02-08 10:00:00	DIA	ETF	107.78	108.07	107.71	107.89	943100.0
2006-02-08 11:00:00	DIA	ETF	107.89	108.02	107.79	107.96	559000.0
2006-02-08 12:00:00	DIA	ETF	107.98	108.33	107.98	108.26	772300.0
2006-02-08 13:00:00	DIA	ETF	108.24	108.25	108.01	108.17	431300.0
2006-02-08 14:00:00	DIA	ETF	108.1601	108.28	108.04	108.21	362200.0
2006-02-08 15:00:00	DIA	ETF	108.23	108.71	108.15	108.6	1484300.0
2006-02-08 16:00:00	DIA	ETF	108.59	108.67	108.59	108.64	28000.0
2006-02-08 19:00:00	DIA	ETF	108.6	108.6	108.6	108.6	1900.0
2006-02-08 07:00:00	GLD	ETF	54.3	54.3	54.3	54.3	1000.0
2006-02-08 08:00:00	GLD	ETF	54.28	54.62	54.25	54.58	47400.0
2006-02-08 09:00:00	GLD	ETF	54.53	54.87	54.5	54.55	1146600.0
2006-02-08 10:00:00	GLD	ETF	54.56	54.93	54.41	54.86	818400.0
2006-02-08 11:00:00	GLD	ETF	54.87	54.99	54.65	54.94	467800.0
2006-02-08 12:00:00	GLD	ETF	54.95	55.08	54.81	54.82	695800.0
2006-02-08 13:00:00	GLD	ETF	54.82	54.9	54.63	54.63	469600.0
2006-02-08 14:00:00	GLD	ETF	54.61	54.86	54.61	54.82	637600.0

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

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