PREVIEW / etf_1hour / 2008-10-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	91.16	91.78	90.83	91.78	5000.0
2008-10-16 05:00:00	SPY	ETF	91.34	91.45	89.98	89.98	8795.0
2008-10-16 06:00:00	SPY	ETF	90.0	91.67	90.0	91.66	224799.0
2008-10-16 07:00:00	SPY	ETF	91.64	91.75	90.07	90.34	2007788.0
2008-10-16 08:00:00	SPY	ETF	90.48	92.83	88.8	92.2	11751599.0
2008-10-16 09:00:00	SPY	ETF	92.18	92.59	89.78	91.71	84106622.0
2008-10-16 10:00:00	SPY	ETF	91.7	91.76	87.74	87.82	127829500.0
2008-10-16 11:00:00	SPY	ETF	87.82	89.84	86.54	89.25	94318059.0
2008-10-16 12:00:00	SPY	ETF	89.23	92.09	88.52	89.68	108647872.0
2008-10-16 13:00:00	SPY	ETF	89.68	92.56	89.05	90.7201	76958505.0
2008-10-16 14:00:00	SPY	ETF	90.73	91.69	87.8	91.07	67025381.0
2008-10-16 15:00:00	SPY	ETF	91.06	94.77	90.76	94.41	108822396.0
2008-10-16 16:00:00	SPY	ETF	94.41	94.67	89.5877	93.9	21791559.0
2008-10-16 17:00:00	SPY	ETF	93.9	94.25	93.88	94.19	2581584.0
2008-10-16 18:00:00	SPY	ETF	94.19	94.44	94.14	94.36	130016.0
2008-10-16 19:00:00	SPY	ETF	94.38	94.41	94.02	94.2	162317.0
2008-10-16 04:00:00	QQQ	ETF	30.48	30.73	30.48	30.73	700.0
2008-10-16 05:00:00	QQQ	ETF	30.72	30.74	30.06	30.21	17550.0
2008-10-16 06:00:00	QQQ	ETF	30.3	30.67	30.3	30.67	50526.0
2008-10-16 07:00:00	QQQ	ETF	30.63	30.68	30.21	30.29	268133.0
2008-10-16 08:00:00	QQQ	ETF	30.26	31.15	30.2	30.93	4573387.0
2008-10-16 09:00:00	QQQ	ETF	30.93	31.33	30.4	31.07	55661401.0
2008-10-16 10:00:00	QQQ	ETF	31.07	31.08	29.61	29.76	87234663.0
2008-10-16 11:00:00	QQQ	ETF	29.77	30.64	29.25	30.43	65349026.0
2008-10-16 12:00:00	QQQ	ETF	30.43	31.43	30.17	30.57	67568950.0
2008-10-16 13:00:00	QQQ	ETF	30.57	31.22	30.32	31.13	49221643.0
2008-10-16 14:00:00	QQQ	ETF	31.13	31.38	30.4599	31.19	52185966.0
2008-10-16 15:00:00	QQQ	ETF	31.18	32.27	31.07	32.24	80367888.0
2008-10-16 16:00:00	QQQ	ETF	32.22	32.61	29.69	32.35	17449036.0
2008-10-16 17:00:00	QQQ	ETF	32.36	32.47	30.5897	32.45	1308976.0
2008-10-16 18:00:00	QQQ	ETF	32.44	32.48	32.4	32.48	118746.0
2008-10-16 19:00:00	QQQ	ETF	32.49	32.54	32.44	32.52	92144.0
2008-10-16 07:00:00	IWM	ETF	50.48	50.64	49.85	49.9	12255.0
2008-10-16 08:00:00	IWM	ETF	50.45	51.47	49.9	51.16	1189772.0
2008-10-16 09:00:00	IWM	ETF	51.18	52.1	50.09	51.68	16783161.0
2008-10-16 10:00:00	IWM	ETF	51.69	51.73	48.82	48.85	37346447.0
2008-10-16 11:00:00	IWM	ETF	48.84	50.45	48.29	50.05	27454873.0
2008-10-16 12:00:00	IWM	ETF	50.05	51.64	48.7	50.5	22145375.0
2008-10-16 13:00:00	IWM	ETF	50.48	51.36	50.16	51.17	17774209.0
2008-10-16 14:00:00	IWM	ETF	51.18	51.76	50.43	51.32	19309435.0
2008-10-16 15:00:00	IWM	ETF	51.3	53.86	51.12	53.68	37989185.0
2008-10-16 16:00:00	IWM	ETF	53.77	53.88	50.17	52.95	21705278.0
2008-10-16 17:00:00	IWM	ETF	53.19	53.44	53.05	53.28	12500.0
2008-10-16 18:00:00	IWM	ETF	53.36	53.4	53.29	53.31	10600.0
2008-10-16 19:00:00	IWM	ETF	53.31	53.4	53.27	53.39	9560.0
2008-10-16 07:00:00	DIA	ETF	86.3	86.33	85.16	85.33	42100.0
2008-10-16 08:00:00	DIA	ETF	85.38	87.4	85.37	87.03	259150.0
2008-10-16 09:00:00	DIA	ETF	86.95	87.35	84.95	86.62	6015833.0
2008-10-16 10:00:00	DIA	ETF	86.61	86.65	83.0	83.04	10786873.0
2008-10-16 11:00:00	DIA	ETF	83.05	85.0	82.08	84.54	9389245.0

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

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