PREVIEW / etf_1hour / 2008-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-30.parquet
  size:    112 KB
  rows:    3,718

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-30 04:00:00	SPY	ETF	95.57	95.57	95.0	95.55	1300.0
2008-10-30 05:00:00	SPY	ETF	94.78	95.45	94.78	95.26	23800.0
2008-10-30 06:00:00	SPY	ETF	95.33	96.05	95.14	95.88	245242.0
2008-10-30 07:00:00	SPY	ETF	95.86	96.03	95.25	95.93	1082836.0
2008-10-30 08:00:00	SPY	ETF	95.97	96.46	93.7	96.15	6124679.0
2008-10-30 09:00:00	SPY	ETF	96.15	96.51	95.2	95.55	43058034.0
2008-10-30 10:00:00	SPY	ETF	95.54	96.14	93.9	94.55	57685544.0
2008-10-30 11:00:00	SPY	ETF	94.55	95.29	92.9	93.34	60602165.0
2008-10-30 12:00:00	SPY	ETF	93.33	94.59	93.22	93.86	41880207.0
2008-10-30 13:00:00	SPY	ETF	93.86	95.08	93.66	94.52	35219635.0
2008-10-30 14:00:00	SPY	ETF	94.51	95.65	94.42	95.22	42980127.0
2008-10-30 15:00:00	SPY	ETF	95.23	95.95	93.77	95.47	106238098.0
2008-10-30 16:00:00	SPY	ETF	95.46	96.55	93.0974	96.0	9322427.0
2008-10-30 17:00:00	SPY	ETF	96.04	96.1	95.88	96.0	1786999.0
2008-10-30 18:00:00	SPY	ETF	96.0	96.2	95.82	95.84	112198.0
2008-10-30 19:00:00	SPY	ETF	95.82	95.87	95.58	95.64	80869.0
2008-10-30 04:00:00	QQQ	ETF	32.62	32.66	32.5	32.53	1300.0
2008-10-30 05:00:00	QQQ	ETF	32.54	32.69	32.5	32.69	11700.0
2008-10-30 06:00:00	QQQ	ETF	32.75	33.0	32.73	32.88	14500.0
2008-10-30 07:00:00	QQQ	ETF	32.87	32.95	32.64	32.78	141154.0
2008-10-30 08:00:00	QQQ	ETF	32.79	33.19	32.4	32.76	2806795.0
2008-10-30 09:00:00	QQQ	ETF	32.75	33.06	32.6	32.77	28359567.0
2008-10-30 10:00:00	QQQ	ETF	32.76	32.9	32.28	32.45	46151958.0
2008-10-30 11:00:00	QQQ	ETF	32.45	32.71	31.98	32.12	36940373.0
2008-10-30 12:00:00	QQQ	ETF	32.12	32.51	32.09	32.2795	19781552.0
2008-10-30 13:00:00	QQQ	ETF	32.27	32.77	32.22	32.61	25354597.0
2008-10-30 14:00:00	QQQ	ETF	32.6	32.99	32.57	32.84	24412598.0
2008-10-30 15:00:00	QQQ	ETF	32.84	33.02	32.29	32.81	59791491.0
2008-10-30 16:00:00	QQQ	ETF	32.79	33.19	32.015	32.93	7405640.0
2008-10-30 17:00:00	QQQ	ETF	32.93	32.93	32.86	32.92	138035.0
2008-10-30 18:00:00	QQQ	ETF	32.92	32.96	32.88	32.88	61660.0
2008-10-30 19:00:00	QQQ	ETF	32.87	32.89	32.8	32.8	166698.0
2008-10-30 06:00:00	IWM	ETF	50.26	50.26	50.26	50.26	1000.0
2008-10-30 07:00:00	IWM	ETF	50.27	50.44	49.99	50.22	111100.0
2008-10-30 08:00:00	IWM	ETF	50.29	50.6	49.9	50.6	663177.0
2008-10-30 09:00:00	IWM	ETF	50.6	51.02	48.7	50.38	8108984.0
2008-10-30 10:00:00	IWM	ETF	50.38	50.6	49.67	50.07	9945138.0
2008-10-30 11:00:00	IWM	ETF	50.08	50.54	49.52	49.61	10695573.0
2008-10-30 12:00:00	IWM	ETF	49.6	50.16	49.56	49.87	4990022.0
2008-10-30 13:00:00	IWM	ETF	49.88	50.41	49.78	50.2	5449624.0
2008-10-30 14:00:00	IWM	ETF	50.19	51.05	50.17	50.98	9214739.0
2008-10-30 15:00:00	IWM	ETF	50.97	51.48	50.26	51.4	20347585.0
2008-10-30 16:00:00	IWM	ETF	51.41	51.93	50.54	51.75	5813331.0
2008-10-30 17:00:00	IWM	ETF	51.75	51.8	51.64	51.65	580239.0
2008-10-30 18:00:00	IWM	ETF	51.79	51.8	51.79	51.8	200.0
2008-10-30 06:00:00	DIA	ETF	91.59	91.92	91.59	91.92	500.0
2008-10-30 07:00:00	DIA	ETF	91.83	91.93	91.44	91.87	8770.0
2008-10-30 08:00:00	DIA	ETF	91.89	92.24	91.28	92.1	139019.0
2008-10-30 09:00:00	DIA	ETF	92.12	92.66	91.37	91.62	4866805.0
2008-10-30 10:00:00	DIA	ETF	91.63	92.23	90.33	90.94	5402540.0

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

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