PREVIEW / etf_1hour / 2008-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-27.parquet
  size:    110 KB
  rows:    3,695

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-10-27 04:00:00	SPY	ETF	83.17	83.66	82.81	83.07	4625.0
2008-10-27 05:00:00	SPY	ETF	83.4	84.11	83.32	83.57	6300.0
2008-10-27 06:00:00	SPY	ETF	83.7	84.46	83.6	83.7	43100.0
2008-10-27 07:00:00	SPY	ETF	83.88	85.03	83.85	84.62	1122461.0
2008-10-27 08:00:00	SPY	ETF	83.99	87.5	82.96	86.18	6724046.0
2008-10-27 09:00:00	SPY	ETF	86.17	87.48	85.35	87.23	54862565.0
2008-10-27 10:00:00	SPY	ETF	87.23	88.47	86.06	87.37	66615961.0
2008-10-27 11:00:00	SPY	ETF	87.36	88.3	86.5	87.06	40864131.0
2008-10-27 12:00:00	SPY	ETF	87.06	88.82	87.05	88.72	44680593.0
2008-10-27 13:00:00	SPY	ETF	88.73	89.51	87.96	88.67	38928686.0
2008-10-27 14:00:00	SPY	ETF	88.68	88.82	86.73	86.7975	43750593.0
2008-10-27 15:00:00	SPY	ETF	86.82	87.88	84.68	84.86	76361417.0
2008-10-27 16:00:00	SPY	ETF	84.85	88.6	83.69	84.0	15018880.0
2008-10-27 17:00:00	SPY	ETF	84.05	88.21	83.73	83.73	3463489.0
2008-10-27 18:00:00	SPY	ETF	83.77	83.77	83.07	83.29	3063279.0
2008-10-27 19:00:00	SPY	ETF	83.26	83.82	83.26	83.79	228382.0
2008-10-27 04:00:00	QQQ	ETF	28.12	28.43	28.11	28.19	7200.0
2008-10-27 05:00:00	QQQ	ETF	28.28	28.53	28.17	28.25	25000.0
2008-10-27 06:00:00	QQQ	ETF	28.32	28.57	28.24	28.25	86895.0
2008-10-27 07:00:00	QQQ	ETF	28.34	28.79	28.33	28.71	396709.0
2008-10-27 08:00:00	QQQ	ETF	28.76	29.95	28.68	29.32	1838465.0
2008-10-27 09:00:00	QQQ	ETF	29.31	29.51	28.55	29.4	37986561.0
2008-10-27 10:00:00	QQQ	ETF	29.4	29.76	28.87	29.3	46895473.0
2008-10-27 11:00:00	QQQ	ETF	29.3	29.6	29.12	29.3199	22933727.0
2008-10-27 12:00:00	QQQ	ETF	29.32	29.94	29.31	29.91	25537306.0
2008-10-27 13:00:00	QQQ	ETF	29.9	30.2	29.6501	30.01	23683358.0
2008-10-27 14:00:00	QQQ	ETF	30.0	30.04	29.25	29.33	26890036.0
2008-10-27 15:00:00	QQQ	ETF	29.33	29.78	28.66	28.7	44926600.0
2008-10-27 16:00:00	QQQ	ETF	28.73	28.87	28.51	28.56	7153657.0
2008-10-27 17:00:00	QQQ	ETF	28.56	28.69	28.51	28.52	309185.0
2008-10-27 18:00:00	QQQ	ETF	28.51	28.53	28.37	28.43	126906.0
2008-10-27 19:00:00	QQQ	ETF	28.46	28.53	28.41	28.53	117281.0
2008-10-27 08:00:00	IWM	ETF	45.48	46.45	44.65	46.35	430114.0
2008-10-27 09:00:00	IWM	ETF	46.36	47.0	45.68	46.91	10922157.0
2008-10-27 10:00:00	IWM	ETF	46.92	47.67	46.07	46.95	15549455.0
2008-10-27 11:00:00	IWM	ETF	46.96	47.28	46.12	46.29	8628153.0
2008-10-27 12:00:00	IWM	ETF	46.27	47.2	46.26	47.16	8510998.0
2008-10-27 13:00:00	IWM	ETF	47.16	47.34	46.72	46.97	7264755.0
2008-10-27 14:00:00	IWM	ETF	46.97	47.06	45.94	46.08	11311944.0
2008-10-27 15:00:00	IWM	ETF	46.08	46.59	44.7	44.82	22367390.0
2008-10-27 16:00:00	IWM	ETF	44.82	47.09	44.06	44.27	14042339.0
2008-10-27 17:00:00	IWM	ETF	44.28	44.34	44.15	44.16	11075.0
2008-10-27 18:00:00	IWM	ETF	44.06	44.2	44.0	44.0	5090.0
2008-10-27 19:00:00	IWM	ETF	44.0	44.87	43.97	44.79	3650.0
2008-10-27 07:00:00	DIA	ETF	81.0	81.1	81.0	81.05	1900.0
2008-10-27 08:00:00	DIA	ETF	81.12	82.73	81.0	82.73	221625.0
2008-10-27 09:00:00	DIA	ETF	82.71	83.7	82.03	83.46	4078671.0
2008-10-27 10:00:00	DIA	ETF	83.49	84.49	82.52	83.7	6456403.0
2008-10-27 11:00:00	DIA	ETF	83.7	84.58	83.18	83.72	3291666.0
2008-10-27 12:00:00	DIA	ETF	83.73	85.32	83.69	85.23	4121581.0

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

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