PREVIEW / etf_1hour / 2008-11-10

all etf 1-hour files

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

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-10 04:00:00	SPY	ETF	95.81	96.03	95.69	95.93	12257.0
2008-11-10 05:00:00	SPY	ETF	95.85	96.55	95.85	96.35	38723.0
2008-11-10 06:00:00	SPY	ETF	96.33	96.46	95.96	95.96	60100.0
2008-11-10 07:00:00	SPY	ETF	95.96	96.0	95.43	95.89	1167053.0
2008-11-10 08:00:00	SPY	ETF	95.9	96.3	95.52	95.59	4124494.0
2008-11-10 09:00:00	SPY	ETF	95.6	95.6	94.4	94.66	37210876.0
2008-11-10 10:00:00	SPY	ETF	94.67	94.98	93.61	93.78	33726173.0
2008-11-10 11:00:00	SPY	ETF	93.79	93.94	92.56	92.71	29265857.0
2008-11-10 12:00:00	SPY	ETF	92.72	93.13	91.56	91.81	32854436.0
2008-11-10 13:00:00	SPY	ETF	91.81	92.76	91.49	92.621	36406542.0
2008-11-10 14:00:00	SPY	ETF	92.63	92.92	91.41	91.62	31386429.0
2008-11-10 15:00:00	SPY	ETF	91.62	92.31	90.92	92.23	71238987.0
2008-11-10 16:00:00	SPY	ETF	92.23	92.68	92.173	92.43	14060991.0
2008-11-10 17:00:00	SPY	ETF	92.14	93.3148	92.14	92.51	2230936.0
2008-11-10 18:00:00	SPY	ETF	92.53	93.3148	92.11	92.25	3216554.0
2008-11-10 19:00:00	SPY	ETF	92.23	92.43	92.06	92.08	34855.0
2008-11-10 04:00:00	QQQ	ETF	32.15	32.35	32.15	32.35	5100.0
2008-11-10 05:00:00	QQQ	ETF	32.2	32.42	32.2	32.4	11400.0
2008-11-10 06:00:00	QQQ	ETF	32.42	32.45	32.41	32.41	2500.0
2008-11-10 07:00:00	QQQ	ETF	32.39	32.4	32.15	32.25	288256.0
2008-11-10 08:00:00	QQQ	ETF	32.27	32.31	32.15	32.15	1072095.0
2008-11-10 09:00:00	QQQ	ETF	32.15	32.15	31.38	31.54	23629749.0
2008-11-10 10:00:00	QQQ	ETF	31.55	31.6	31.32	31.37	16387571.0
2008-11-10 11:00:00	QQQ	ETF	31.37	31.3701	30.89	30.9399	16033302.0
2008-11-10 12:00:00	QQQ	ETF	30.93	31.17	30.55	30.66	19681054.0
2008-11-10 13:00:00	QQQ	ETF	30.67	31.02	30.57	30.9701	14602467.0
2008-11-10 14:00:00	QQQ	ETF	30.97	31.05	30.5	30.62	12938207.0
2008-11-10 15:00:00	QQQ	ETF	30.61	30.85	30.4	30.77	30798428.0
2008-11-10 16:00:00	QQQ	ETF	30.76	31.2754	30.6613	30.91	4643783.0
2008-11-10 17:00:00	QQQ	ETF	30.9	30.97	30.87	30.88	81547.0
2008-11-10 18:00:00	QQQ	ETF	30.92	30.92	30.78	30.78	149472.0
2008-11-10 19:00:00	QQQ	ETF	30.8	30.82	30.71	30.75	27624.0
2008-11-10 06:00:00	IWM	ETF	52.42	52.42	52.42	52.42	5000.0
2008-11-10 07:00:00	IWM	ETF	52.21	52.26	51.96	52.19	32100.0
2008-11-10 08:00:00	IWM	ETF	52.23	52.7	50.62	52.04	412949.0
2008-11-10 09:00:00	IWM	ETF	52.02	52.05	50.94	51.14	6824401.0
2008-11-10 10:00:00	IWM	ETF	51.16	51.25	50.51	50.55	5629779.0
2008-11-10 11:00:00	IWM	ETF	50.55	50.57	49.99	50.16	5916066.0
2008-11-10 12:00:00	IWM	ETF	50.16	50.24	49.35	49.46	6370947.0
2008-11-10 13:00:00	IWM	ETF	49.47	50.08	49.24	50.01	4918058.0
2008-11-10 14:00:00	IWM	ETF	50.0	50.22	49.38	49.49	4478321.0
2008-11-10 15:00:00	IWM	ETF	49.48	49.72	48.93	49.33	12198238.0
2008-11-10 16:00:00	IWM	ETF	49.33	49.83	49.26	49.7	1835092.0
2008-11-10 17:00:00	IWM	ETF	49.65	49.66	49.6	49.6	5500.0
2008-11-10 18:00:00	IWM	ETF	49.6	49.6	49.6	49.6	500.0
2008-11-10 19:00:00	IWM	ETF	49.6	49.6	49.6	49.6	300.0
2008-11-10 06:00:00	DIA	ETF	92.02	92.11	92.02	92.11	200.0
2008-11-10 07:00:00	DIA	ETF	91.96	91.96	91.62	91.83	4644.0
2008-11-10 08:00:00	DIA	ETF	91.91	91.99	91.65	91.79	56727.0
2008-11-10 09:00:00	DIA	ETF	91.71	91.75	90.8	91.0	3182967.0

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

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