PREVIEW / etf_1hour / 2008-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-10.parquet
  size:    119 KB
  rows:    4,012

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-10 04:00:00	SPY	ETF	89.3	90.0	89.18	89.75	74000.0
2008-10-10 05:00:00	SPY	ETF	89.56	89.93	88.17	88.3	131200.0
2008-10-10 06:00:00	SPY	ETF	88.3	89.0	87.75	88.95	622685.0
2008-10-10 07:00:00	SPY	ETF	88.95	89.32	87.89	88.08	2763576.0
2008-10-10 08:00:00	SPY	ETF	88.08	90.854	86.1	86.62	9980689.0
2008-10-10 09:00:00	SPY	ETF	86.63	89.78	83.58	88.48	133172436.0
2008-10-10 10:00:00	SPY	ETF	88.48	92.06	87.12	87.89	137222164.0
2008-10-10 11:00:00	SPY	ETF	87.9	91.34	85.01	85.77	93969481.0
2008-10-10 12:00:00	SPY	ETF	85.78	91.0173	85.63	87.28	76734248.0
2008-10-10 13:00:00	SPY	ETF	87.28	91.38	84.05	85.19	69574510.0
2008-10-10 14:00:00	SPY	ETF	85.19	87.26	84.34	85.2	93680326.0
2008-10-10 15:00:00	SPY	ETF	85.19	93.94	84.96	90.46	194227688.0
2008-10-10 16:00:00	SPY	ETF	90.45	91.66	84.02	89.2	47128022.0
2008-10-10 17:00:00	SPY	ETF	89.2	91.0178	85.33	89.48	10266566.0
2008-10-10 18:00:00	SPY	ETF	89.48	90.55	89.48	90.48	486372.0
2008-10-10 19:00:00	SPY	ETF	90.4	90.4	89.2	89.6	202537.0
2008-10-10 04:00:00	QQQ	ETF	31.0	31.0	30.87	30.87	4200.0
2008-10-10 05:00:00	QQQ	ETF	30.45	30.45	30.27	30.34	4500.0
2008-10-10 06:00:00	QQQ	ETF	30.5	30.92	30.43	30.92	46980.0
2008-10-10 07:00:00	QQQ	ETF	31.0	31.23	30.53	30.56	664681.0
2008-10-10 08:00:00	QQQ	ETF	30.57	30.96	30.24	30.32	3239628.0
2008-10-10 09:00:00	QQQ	ETF	30.33	31.44	29.52	31.23	82914306.0
2008-10-10 10:00:00	QQQ	ETF	31.24	32.05	30.51	30.74	74059220.0
2008-10-10 11:00:00	QQQ	ETF	30.74	31.03	29.83	29.97	51817111.0
2008-10-10 12:00:00	QQQ	ETF	29.98	30.62	29.92	30.37	42743454.0
2008-10-10 13:00:00	QQQ	ETF	30.36	30.4	29.38	29.69	39271154.0
2008-10-10 14:00:00	QQQ	ETF	29.7	30.41	29.5	29.79	51438767.0
2008-10-10 15:00:00	QQQ	ETF	29.7801	32.48	29.71	31.29	107886999.0
2008-10-10 16:00:00	QQQ	ETF	31.29	31.77	30.365	31.3	8868998.0
2008-10-10 17:00:00	QQQ	ETF	31.3	31.42	31.24	31.42	718645.0
2008-10-10 18:00:00	QQQ	ETF	31.41	31.62	31.41	31.52	115395.0
2008-10-10 19:00:00	QQQ	ETF	31.48	31.59	31.37	31.42	28018.0
2008-10-10 07:00:00	IWM	ETF	48.31	48.31	47.7	47.95	52500.0
2008-10-10 08:00:00	IWM	ETF	47.97	49.18	47.83	47.94	576863.0
2008-10-10 09:00:00	IWM	ETF	47.95	49.85	46.51	48.79	27105820.0
2008-10-10 10:00:00	IWM	ETF	48.81	50.71	48.03	48.54	33219826.0
2008-10-10 11:00:00	IWM	ETF	48.54	48.89	47.41	47.76	18622817.0
2008-10-10 12:00:00	IWM	ETF	47.76	49.99	47.58	48.02	15935825.0
2008-10-10 13:00:00	IWM	ETF	48.04	48.04	46.61	47.31	16093881.0
2008-10-10 14:00:00	IWM	ETF	47.32	48.35	46.83	47.7	20980329.0
2008-10-10 15:00:00	IWM	ETF	47.71	54.67	47.53	52.39	57416476.0
2008-10-10 16:00:00	IWM	ETF	52.39	53.11	48.37	51.8	5450834.0
2008-10-10 17:00:00	IWM	ETF	51.59	51.9	47.6	51.9	3439380.0
2008-10-10 18:00:00	IWM	ETF	51.95	52.2	51.8	52.1	3486.0
2008-10-10 19:00:00	IWM	ETF	52.2	52.2	52.2	52.2	200.0
2008-10-10 07:00:00	DIA	ETF	83.84	84.5	83.07	83.07	44679.0
2008-10-10 08:00:00	DIA	ETF	83.18	84.5	81.93	82.21	326671.0
2008-10-10 09:00:00	DIA	ETF	82.26	84.7	78.94	83.41	8233096.0
2008-10-10 10:00:00	DIA	ETF	83.41	86.73	82.27	83.17	12403364.0
2008-10-10 11:00:00	DIA	ETF	83.19	83.86	79.0	81.49	6719944.0

> showing 50 of 4,012 rows — these rows as CSV

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