PREVIEW / etf_1hour / 2008-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-04.parquet
  size:    114 KB
  rows:    3,757

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-11-04 04:00:00	SPY	ETF	97.7	98.65	97.7	98.65	13400.0
2008-11-04 05:00:00	SPY	ETF	98.72	99.14	98.72	99.14	9500.0
2008-11-04 06:00:00	SPY	ETF	99.14	99.38	98.91	98.93	295406.0
2008-11-04 07:00:00	SPY	ETF	98.93	99.73	98.93	99.49	1486920.0
2008-11-04 08:00:00	SPY	ETF	99.49	99.67	97.35	99.11	3442159.0
2008-11-04 09:00:00	SPY	ETF	99.11	99.31	98.25	98.35	34374486.0
2008-11-04 10:00:00	SPY	ETF	98.36	100.29	98.19	100.02	53880285.0
2008-11-04 11:00:00	SPY	ETF	100.02	100.72	96.7142	100.518	40765231.0
2008-11-04 12:00:00	SPY	ETF	100.518	100.59	99.81	99.97	27371595.0
2008-11-04 13:00:00	SPY	ETF	99.97	100.63	99.75	100.24	33150848.0
2008-11-04 14:00:00	SPY	ETF	100.24	100.25	98.97	99.22	48195523.0
2008-11-04 15:00:00	SPY	ETF	99.22	100.86	98.7	100.4	87982031.0
2008-11-04 16:00:00	SPY	ETF	100.37	100.621	99.69	100.3	10492072.0
2008-11-04 17:00:00	SPY	ETF	100.32	100.42	100.27	100.36	151416.0
2008-11-04 18:00:00	SPY	ETF	100.36	100.65	100.32	100.59	124889.0
2008-11-04 19:00:00	SPY	ETF	100.55	100.55	100.3	100.48	63993.0
2008-11-04 04:00:00	QQQ	ETF	33.2	33.54	33.2	33.54	5500.0
2008-11-04 05:00:00	QQQ	ETF	33.6	33.66	33.58	33.66	6700.0
2008-11-04 06:00:00	QQQ	ETF	33.75	33.85	33.68	33.7	92001.0
2008-11-04 07:00:00	QQQ	ETF	33.66	33.81	33.65	33.7	302858.0
2008-11-04 08:00:00	QQQ	ETF	33.8	33.8	33.53	33.57	1038006.0
2008-11-04 09:00:00	QQQ	ETF	33.57	33.6	32.98	33.07	23012437.0
2008-11-04 10:00:00	QQQ	ETF	33.08	33.72	32.98	33.61	28876926.0
2008-11-04 11:00:00	QQQ	ETF	33.61	34.01	33.25	33.93	17652242.0
2008-11-04 12:00:00	QQQ	ETF	33.93	33.96	33.67	33.77	17228455.0
2008-11-04 13:00:00	QQQ	ETF	33.772	33.96	33.69	33.83	12453287.0
2008-11-04 14:00:00	QQQ	ETF	33.8399	33.85	33.41	33.4905	24256695.0
2008-11-04 15:00:00	QQQ	ETF	33.49	33.94	33.27	33.9	45492446.0
2008-11-04 16:00:00	QQQ	ETF	33.91	33.959	33.2794	33.92	5551624.0
2008-11-04 17:00:00	QQQ	ETF	33.9	33.96	33.89	33.93	121558.0
2008-11-04 18:00:00	QQQ	ETF	33.93	33.96	33.87	33.96	44333.0
2008-11-04 19:00:00	QQQ	ETF	33.96	33.96	33.88	33.95	16820.0
2008-11-04 05:00:00	IWM	ETF	54.9	54.9	54.9	54.9	1000.0
2008-11-04 06:00:00	IWM	ETF	55.06	55.24	55.06	55.24	4100.0
2008-11-04 07:00:00	IWM	ETF	55.01	55.47	55.01	55.42	44724.0
2008-11-04 08:00:00	IWM	ETF	55.3	55.4	55.0	55.08	413153.0
2008-11-04 09:00:00	IWM	ETF	55.09	55.15	53.83	53.91	6535011.0
2008-11-04 10:00:00	IWM	ETF	53.9	55.1	53.74	54.93	10997636.0
2008-11-04 11:00:00	IWM	ETF	54.93	55.21	54.62	54.93	7976052.0
2008-11-04 12:00:00	IWM	ETF	54.93	54.98	54.46	54.6	5607697.0
2008-11-04 13:00:00	IWM	ETF	54.61	54.69	54.13	54.26	6661629.0
2008-11-04 14:00:00	IWM	ETF	54.27	54.27	53.47	53.65	9746741.0
2008-11-04 15:00:00	IWM	ETF	53.65	54.8	53.39	54.49	13599199.0
2008-11-04 16:00:00	IWM	ETF	54.49	54.55	53.85	54.38	11397750.0
2008-11-04 17:00:00	IWM	ETF	54.4	54.4	53.85	54.4	4598209.0
2008-11-04 19:00:00	IWM	ETF	54.4	54.44	54.4	54.44	400.0
2008-11-04 06:00:00	DIA	ETF	95.42	95.42	95.42	95.42	100.0
2008-11-04 07:00:00	DIA	ETF	95.27	95.84	95.27	95.67	15125.0
2008-11-04 08:00:00	DIA	ETF	95.63	95.72	95.01	95.12	151568.0
2008-11-04 09:00:00	DIA	ETF	95.12	95.3	94.4	94.5	2700545.0

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

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