PREVIEW / etf_1hour / 2008-10-29

all etf 1-hour files

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

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-29 04:00:00	SPY	ETF	92.02	92.24	91.94	91.95	4600.0
2008-10-29 05:00:00	SPY	ETF	92.0	92.1	91.73	92.0	39500.0
2008-10-29 06:00:00	SPY	ETF	92.21	93.8	92.21	93.7	317312.0
2008-10-29 07:00:00	SPY	ETF	93.7	94.64	92.94	94.24	1778454.0
2008-10-29 08:00:00	SPY	ETF	94.25	95.23	92.0	93.74	9200394.0
2008-10-29 09:00:00	SPY	ETF	93.74	94.25	92.79	93.3	51394641.0
2008-10-29 10:00:00	SPY	ETF	93.29	94.72	92.94	93.14	69665291.0
2008-10-29 11:00:00	SPY	ETF	93.15	94.25	92.97	94.22	40889638.0
2008-10-29 12:00:00	SPY	ETF	94.2325	95.42	93.75	94.5801	33029096.0
2008-10-29 13:00:00	SPY	ETF	94.58	95.58	94.37	94.87	33737330.0
2008-10-29 14:00:00	SPY	ETF	94.87	95.38	92.81	94.43	106344054.0
2008-10-29 15:00:00	SPY	ETF	94.43	97.17	92.1	92.32	160691266.0
2008-10-29 16:00:00	SPY	ETF	92.31	94.4955	92.22	93.51	19626104.0
2008-10-29 17:00:00	SPY	ETF	93.45	94.12	93.35	93.5	1779647.0
2008-10-29 18:00:00	SPY	ETF	93.55	93.73	93.46	93.7	55826.0
2008-10-29 19:00:00	SPY	ETF	93.65	93.73	93.46	93.63	69650.0
2008-10-29 04:00:00	QQQ	ETF	31.45	31.45	31.33	31.33	8200.0
2008-10-29 05:00:00	QQQ	ETF	31.34	31.4	31.22	31.35	5500.0
2008-10-29 06:00:00	QQQ	ETF	31.41	31.88	31.41	31.83	12200.0
2008-10-29 07:00:00	QQQ	ETF	31.88	32.31	31.65	32.16	569600.0
2008-10-29 08:00:00	QQQ	ETF	32.15	32.4	31.4	31.87	2498749.0
2008-10-29 09:00:00	QQQ	ETF	31.9	32.05	31.25	31.57	35326332.0
2008-10-29 10:00:00	QQQ	ETF	31.57	32.08	31.41	31.48	37985175.0
2008-10-29 11:00:00	QQQ	ETF	31.48	31.95	31.443	31.9299	25498050.0
2008-10-29 12:00:00	QQQ	ETF	31.9299	32.43	31.82	32.26	24527980.0
2008-10-29 13:00:00	QQQ	ETF	32.26	32.59	32.19	32.28	23537177.0
2008-10-29 14:00:00	QQQ	ETF	32.29	32.53	31.6601	32.28	67136156.0
2008-10-29 15:00:00	QQQ	ETF	32.28	33.08	31.76	31.84	101883809.0
2008-10-29 16:00:00	QQQ	ETF	31.84	32.36	31.35	31.95	8662117.0
2008-10-29 17:00:00	QQQ	ETF	31.95	32.07	31.88	32.07	210085.0
2008-10-29 18:00:00	QQQ	ETF	32.03	32.03	31.97	32.02	32628.0
2008-10-29 19:00:00	QQQ	ETF	32.04	32.05	31.99	32.04	57624.0
2008-10-29 07:00:00	IWM	ETF	48.55	49.12	48.24	49.07	285466.0
2008-10-29 08:00:00	IWM	ETF	48.0	49.67	48.0	48.64	679223.0
2008-10-29 09:00:00	IWM	ETF	48.7	49.03	47.82	48.22	9120035.0
2008-10-29 10:00:00	IWM	ETF	48.21	49.3	48.15	48.32	13509258.0
2008-10-29 11:00:00	IWM	ETF	48.32	48.99	48.2	48.85	5616308.0
2008-10-29 12:00:00	IWM	ETF	48.85	49.35	48.51	48.98	5914550.0
2008-10-29 13:00:00	IWM	ETF	48.98	49.5	48.7	49.12	4939045.0
2008-10-29 14:00:00	IWM	ETF	49.13	49.63	48.28	49.52	16980154.0
2008-10-29 15:00:00	IWM	ETF	49.54	50.73	48.67	49.06	29853811.0
2008-10-29 16:00:00	IWM	ETF	48.71	49.93	48.61	49.11	4385265.0
2008-10-29 17:00:00	IWM	ETF	49.1	49.1	48.92	48.92	60300.0
2008-10-29 18:00:00	IWM	ETF	49.04	49.1	49.04	49.1	4775.0
2008-10-29 19:00:00	IWM	ETF	49.09	49.2	49.06	49.2	4000.0
2008-10-29 04:00:00	DIA	ETF	93.5	100.41	90.2	90.2	1580.0
2008-10-29 06:00:00	DIA	ETF	90.5	90.83	90.5	90.83	1200.0
2008-10-29 07:00:00	DIA	ETF	90.71	91.58	90.39	91.3	17418.0
2008-10-29 08:00:00	DIA	ETF	91.3	92.0	90.49	90.58	192910.0
2008-10-29 09:00:00	DIA	ETF	90.64	91.12	89.61	90.17	4283274.0

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

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