PREVIEW / etf_1hour / 2008-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-26.parquet
  size:    107 KB
  rows:    3,442

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
2008-08-26 04:00:00	SPY	ETF	126.79	126.85	126.79	126.85	800.0
2008-08-26 06:00:00	SPY	ETF	127.05	127.32	127.05	127.32	23500.0
2008-08-26 07:00:00	SPY	ETF	127.3	127.39	126.94	127.0	658522.0
2008-08-26 08:00:00	SPY	ETF	126.96	127.15	126.59	127.08	2494182.0
2008-08-26 09:00:00	SPY	ETF	127.11	127.35	126.65	127.15	23023100.0
2008-08-26 10:00:00	SPY	ETF	127.15	127.87	127.13	127.7	35452363.0
2008-08-26 11:00:00	SPY	ETF	127.69	127.76	127.05	127.29	18891504.0
2008-08-26 12:00:00	SPY	ETF	127.2957	127.5	127.17	127.22	11054018.0
2008-08-26 13:00:00	SPY	ETF	127.22	127.27	126.84	127.07	11345690.0
2008-08-26 14:00:00	SPY	ETF	127.07	127.18	126.58	126.71	26918107.0
2008-08-26 15:00:00	SPY	ETF	126.7	127.47	126.62	127.44	25922178.0
2008-08-26 16:00:00	SPY	ETF	127.44	127.52	127.34	127.48	1337977.0
2008-08-26 17:00:00	SPY	ETF	127.48	127.5	127.42	127.48	19154.0
2008-08-26 18:00:00	SPY	ETF	127.42	127.52	127.41	127.45	169880.0
2008-08-26 19:00:00	SPY	ETF	127.45	127.49	127.43	127.43	7700.0
2008-08-26 04:00:00	QQQ	ETF	46.52	46.52	46.52	46.52	200.0
2008-08-26 06:00:00	QQQ	ETF	46.68	46.68	46.68	46.68	300.0
2008-08-26 07:00:00	QQQ	ETF	46.7	46.7	46.55	46.57	65023.0
2008-08-26 08:00:00	QQQ	ETF	46.58	46.58	46.44	46.58	625089.0
2008-08-26 09:00:00	QQQ	ETF	46.59	46.67	46.41	46.5501	18187693.0
2008-08-26 10:00:00	QQQ	ETF	46.56	46.77	46.46	46.71	20153111.0
2008-08-26 11:00:00	QQQ	ETF	46.7099	46.74	46.46	46.54	8999092.0
2008-08-26 12:00:00	QQQ	ETF	46.54	46.65	46.45	46.47	7255567.0
2008-08-26 13:00:00	QQQ	ETF	46.47	46.49	46.21	46.29	8475215.0
2008-08-26 14:00:00	QQQ	ETF	46.28	46.4	46.12	46.15	15156159.0
2008-08-26 15:00:00	QQQ	ETF	46.15	46.45	46.15	46.43	19204522.0
2008-08-26 16:00:00	QQQ	ETF	46.43	46.48	46.3178	46.47	2518932.0
2008-08-26 17:00:00	QQQ	ETF	46.48	46.48	46.44	46.44	7443.0
2008-08-26 18:00:00	QQQ	ETF	46.47	46.48	46.47	46.48	3093.0
2008-08-26 19:00:00	QQQ	ETF	46.45	46.49	46.45	46.49	5300.0
2008-08-26 06:00:00	IWM	ETF	72.18	72.29	72.18	72.29	8000.0
2008-08-26 07:00:00	IWM	ETF	72.3	72.34	72.14	72.16	21900.0
2008-08-26 08:00:00	IWM	ETF	72.15	72.23	71.9	72.23	550920.0
2008-08-26 09:00:00	IWM	ETF	72.21	72.34	71.81	72.16	6180073.0
2008-08-26 10:00:00	IWM	ETF	72.17	72.58	72.14	72.47	7960438.0
2008-08-26 11:00:00	IWM	ETF	72.48	72.53	72.06	72.26	5921804.0
2008-08-26 12:00:00	IWM	ETF	72.26	72.39	72.16	72.18	3538733.0
2008-08-26 13:00:00	IWM	ETF	72.19	72.22	71.94	72.0	4076679.0
2008-08-26 14:00:00	IWM	ETF	71.99	72.3	71.46	71.58	11782038.0
2008-08-26 15:00:00	IWM	ETF	71.57	72.2	71.57	72.16	10051615.0
2008-08-26 16:00:00	IWM	ETF	72.16	72.33	71.78	72.3	2084395.0
2008-08-26 17:00:00	IWM	ETF	72.31	72.31	72.28	72.28	5420.0
2008-08-26 07:00:00	DIA	ETF	114.08	114.14	113.97	113.97	8000.0
2008-08-26 08:00:00	DIA	ETF	114.0	114.1	113.69	114.09	62436.0
2008-08-26 09:00:00	DIA	ETF	114.09	114.09	113.46	113.69	2118586.0
2008-08-26 10:00:00	DIA	ETF	113.69	114.42	113.62	114.3	3363811.0
2008-08-26 11:00:00	DIA	ETF	114.31	114.37	113.69	113.98	1852768.0
2008-08-26 12:00:00	DIA	ETF	113.98	114.24	113.88	114.01	1251829.0
2008-08-26 13:00:00	DIA	ETF	113.98	114.03	113.6	113.82	1070183.0
2008-08-26 14:00:00	DIA	ETF	113.83	113.97	113.46	113.59	2109930.0

> showing 50 of 3,442 rows — these rows as CSV

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