PREVIEW / etf_1hour / 2008-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-24.parquet
  size:    113 KB
  rows:    3,796

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-24 04:00:00	SPY	ETF	86.16	86.42	85.85	85.88	10600.0
2008-10-24 05:00:00	SPY	ETF	85.9	85.9	85.47	85.47	216290.0
2008-10-24 06:00:00	SPY	ETF	85.48	85.8	85.0	85.4	455938.0
2008-10-24 07:00:00	SPY	ETF	85.4	85.7	84.9	85.2	1228166.0
2008-10-24 08:00:00	SPY	ETF	85.55	87.41	83.25	84.25	6026269.0
2008-10-24 09:00:00	SPY	ETF	84.25	87.56	83.35	87.1	80415036.0
2008-10-24 10:00:00	SPY	ETF	87.09	88.0	85.71	87.27	95654688.0
2008-10-24 11:00:00	SPY	ETF	87.27	89.0	86.81	87.96	67129376.0
2008-10-24 12:00:00	SPY	ETF	87.95	88.45	86.65	87.1	41914169.0
2008-10-24 13:00:00	SPY	ETF	87.1	88.4	86.18	86.18	45332140.0
2008-10-24 14:00:00	SPY	ETF	86.19	88.93	85.98	88.71	69303785.0
2008-10-24 15:00:00	SPY	ETF	88.72	89.92	86.5	87.63	108466823.0
2008-10-24 16:00:00	SPY	ETF	87.44	88.5691	85.4627	87.17	23473485.0
2008-10-24 17:00:00	SPY	ETF	87.14	87.28	87.06	87.18	151986.0
2008-10-24 18:00:00	SPY	ETF	87.18	87.8	87.18	87.48	105048.0
2008-10-24 19:00:00	SPY	ETF	87.41	87.67	87.36	87.6	84597.0
2008-10-24 04:00:00	QQQ	ETF	29.2	29.32	28.93	28.93	5530.0
2008-10-24 05:00:00	QQQ	ETF	28.75	28.8	28.75	28.8	1300.0
2008-10-24 06:00:00	QQQ	ETF	28.92	29.04	28.6	28.75	60200.0
2008-10-24 07:00:00	QQQ	ETF	28.74	28.82	28.58	28.59	154866.0
2008-10-24 08:00:00	QQQ	ETF	28.6	28.79	28.35	28.4	1519471.0
2008-10-24 09:00:00	QQQ	ETF	28.4	29.65	28.02	29.44	46580820.0
2008-10-24 10:00:00	QQQ	ETF	29.4299	29.82	28.87	29.41	51452120.0
2008-10-24 11:00:00	QQQ	ETF	29.41	30.13	29.22	29.86	39081170.0
2008-10-24 12:00:00	QQQ	ETF	29.86	30.07	29.32	29.51	25977505.0
2008-10-24 13:00:00	QQQ	ETF	29.5	29.89	29.07	29.08	27489801.0
2008-10-24 14:00:00	QQQ	ETF	29.072	29.97	29.04	29.89	43125652.0
2008-10-24 15:00:00	QQQ	ETF	29.89	30.25	29.4379	29.53	70564086.0
2008-10-24 16:00:00	QQQ	ETF	29.53	29.8589	29.13	29.3	9817617.0
2008-10-24 17:00:00	QQQ	ETF	29.3	29.4	29.28	29.35	63250.0
2008-10-24 18:00:00	QQQ	ETF	29.27	29.39	29.24	29.35	63464.0
2008-10-24 19:00:00	QQQ	ETF	29.38	29.45	29.28	29.45	45170.0
2008-10-24 07:00:00	IWM	ETF	45.05	45.27	44.9	45.27	31120.0
2008-10-24 08:00:00	IWM	ETF	45.25	46.2	44.2	44.28	1106093.0
2008-10-24 09:00:00	IWM	ETF	44.25	47.58	44.2	47.28	15841376.0
2008-10-24 10:00:00	IWM	ETF	47.28	47.59	46.44	47.31	22545471.0
2008-10-24 11:00:00	IWM	ETF	47.31	48.11	47.06	47.75	11633830.0
2008-10-24 12:00:00	IWM	ETF	47.74	47.97	47.04	47.45	7187142.0
2008-10-24 13:00:00	IWM	ETF	47.41	47.96	46.92	46.92	8192823.0
2008-10-24 14:00:00	IWM	ETF	46.92	47.83	46.69	47.71	12314330.0
2008-10-24 15:00:00	IWM	ETF	47.7	48.2	47.02	47.16	21117350.0
2008-10-24 16:00:00	IWM	ETF	47.15	47.71	45.96	46.99	3201456.0
2008-10-24 17:00:00	IWM	ETF	46.4	46.4	46.4	46.4	1000.0
2008-10-24 18:00:00	IWM	ETF	46.3	46.3	46.15	46.25	3200.0
2008-10-24 19:00:00	IWM	ETF	46.34	46.48	46.34	46.48	650.0
2008-10-24 04:00:00	DIA	ETF	84.0	84.0	84.0	84.0	100.0
2008-10-24 06:00:00	DIA	ETF	82.86	82.86	82.86	82.86	500.0
2008-10-24 07:00:00	DIA	ETF	82.49	82.76	81.55	81.75	3980.0
2008-10-24 08:00:00	DIA	ETF	82.02	83.0	80.5	80.75	137962.0
2008-10-24 09:00:00	DIA	ETF	80.75	84.05	79.73	83.62	6805069.0

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

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