PREVIEW / etf_1hour / 2008-10-31

all etf 1-hour files

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

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-31 04:00:00	SPY	ETF	94.67	94.67	94.5	94.6	4500.0
2008-10-31 05:00:00	SPY	ETF	94.48	94.57	94.25	94.55	17100.0
2008-10-31 06:00:00	SPY	ETF	94.62	95.0	94.4	94.68	97800.0
2008-10-31 07:00:00	SPY	ETF	94.68	94.94	94.47	94.58	853039.0
2008-10-31 08:00:00	SPY	ETF	94.58	95.72	94.47	95.65	5365939.0
2008-10-31 09:00:00	SPY	ETF	95.65	95.88	94.48	95.07	37915659.0
2008-10-31 10:00:00	SPY	ETF	95.07	96.04	94.75	95.42	51796281.0
2008-10-31 11:00:00	SPY	ETF	95.4278	96.83	95.41	96.44	51232723.0
2008-10-31 12:00:00	SPY	ETF	96.44	96.56	95.78	96.37	28772758.0
2008-10-31 13:00:00	SPY	ETF	96.38	98.2	96.34	97.51	46133736.0
2008-10-31 14:00:00	SPY	ETF	97.51	98.15	95.0	98.0	48078969.0
2008-10-31 15:00:00	SPY	ETF	98.02	98.57	95.72	97.17	122029972.0
2008-10-31 16:00:00	SPY	ETF	97.24	97.37	96.5891	97.12	17492967.0
2008-10-31 17:00:00	SPY	ETF	97.15	97.65	97.12	97.31	237236.0
2008-10-31 18:00:00	SPY	ETF	97.3	97.35	97.08	97.2	98302.0
2008-10-31 19:00:00	SPY	ETF	97.4	97.4	97.06	97.33	13984.0
2008-10-31 04:00:00	QQQ	ETF	32.45	32.45	32.37	32.42	2000.0
2008-10-31 05:00:00	QQQ	ETF	32.35	32.4	32.32	32.39	3400.0
2008-10-31 06:00:00	QQQ	ETF	32.42	32.42	32.18	32.27	64000.0
2008-10-31 07:00:00	QQQ	ETF	32.3	32.41	32.27	32.35	58999.0
2008-10-31 08:00:00	QQQ	ETF	32.35	32.66	32.32	32.65	1436510.0
2008-10-31 09:00:00	QQQ	ETF	32.64	32.66	32.09	32.31	25047456.0
2008-10-31 10:00:00	QQQ	ETF	32.3	32.73	32.28	32.59	29978182.0
2008-10-31 11:00:00	QQQ	ETF	32.59	33.0	32.57	32.84	26666417.0
2008-10-31 12:00:00	QQQ	ETF	32.84	32.86	32.56	32.8	16711186.0
2008-10-31 13:00:00	QQQ	ETF	32.79	33.34	32.77	33.13	20892474.0
2008-10-31 14:00:00	QQQ	ETF	33.13	33.3	32.89	33.23	25955527.0
2008-10-31 15:00:00	QQQ	ETF	33.23	33.43	32.43	32.86	69216410.0
2008-10-31 16:00:00	QQQ	ETF	32.86	33.0	32.65	32.99	4486153.0
2008-10-31 17:00:00	QQQ	ETF	32.95	33.12	32.95	33.07	257557.0
2008-10-31 18:00:00	QQQ	ETF	33.04	33.06	33.02	33.02	8162.0
2008-10-31 19:00:00	QQQ	ETF	33.02	33.08	32.99	32.99	11567.0
2008-10-31 07:00:00	IWM	ETF	51.07	51.1	50.9	50.97	66500.0
2008-10-31 08:00:00	IWM	ETF	50.93	51.32	50.81	51.27	862530.0
2008-10-31 09:00:00	IWM	ETF	51.26	51.39	50.48	51.02	8673094.0
2008-10-31 10:00:00	IWM	ETF	51.02	52.42	50.93	52.23	13893099.0
2008-10-31 11:00:00	IWM	ETF	52.25	53.15	52.17	53.04	11638367.0
2008-10-31 12:00:00	IWM	ETF	53.05	53.07	52.49	52.87	8284624.0
2008-10-31 13:00:00	IWM	ETF	52.87	53.82	52.84	53.58	12734117.0
2008-10-31 14:00:00	IWM	ETF	53.58	53.81	53.2	53.77	11976225.0
2008-10-31 15:00:00	IWM	ETF	53.78	54.09	52.36	53.72	30015770.0
2008-10-31 16:00:00	IWM	ETF	53.45	53.91	51.42	53.8	9278038.0
2008-10-31 17:00:00	IWM	ETF	53.8	53.82	53.48	53.82	2822895.0
2008-10-31 18:00:00	IWM	ETF	53.82	53.82	53.8	53.8	2199.0
2008-10-31 06:00:00	DIA	ETF	91.16	91.16	90.9	90.9	750.0
2008-10-31 07:00:00	DIA	ETF	91.06	91.16	90.89	90.93	6550.0
2008-10-31 08:00:00	DIA	ETF	91.0	91.91	90.9	91.78	237706.0
2008-10-31 09:00:00	DIA	ETF	91.81	92.04	91.13	91.65	3899363.0
2008-10-31 10:00:00	DIA	ETF	91.65	92.4	91.48	91.83	7244271.0
2008-10-31 11:00:00	DIA	ETF	91.84	93.07	91.8	92.59	4687724.0

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

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