PREVIEW / etf_1hour / 2010-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-04.parquet
  size:    151 KB
  rows:    4,680

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
2010-03-04 04:00:00	SPY	ETF	112.06	112.19	112.06	112.17	21132.0
2010-03-04 05:00:00	SPY	ETF	112.28	112.35	112.25	112.3	3800.0
2010-03-04 06:00:00	SPY	ETF	112.21	112.41	112.17	112.31	35100.0
2010-03-04 07:00:00	SPY	ETF	112.29	112.42	112.19	112.42	1357410.0
2010-03-04 08:00:00	SPY	ETF	112.39	112.63	111.9	112.55	5352441.0
2010-03-04 09:00:00	SPY	ETF	112.55	112.75	112.4	112.66	15120982.0
2010-03-04 10:00:00	SPY	ETF	112.67	112.75	112.03	112.2275	32582445.0
2010-03-04 11:00:00	SPY	ETF	112.23	112.47	112.19	112.39	16774301.0
2010-03-04 12:00:00	SPY	ETF	112.39	112.44	112.26	112.4	8926666.0
2010-03-04 13:00:00	SPY	ETF	112.4	112.55	112.19	112.36	11014224.0
2010-03-04 14:00:00	SPY	ETF	112.35	112.54	112.29	112.51	10598952.0
2010-03-04 15:00:00	SPY	ETF	112.5	112.8	112.38	112.65	26032058.0
2010-03-04 16:00:00	SPY	ETF	112.64	112.79	112.28	112.71	7528669.0
2010-03-04 17:00:00	SPY	ETF	112.7	112.74	112.66	112.74	84381.0
2010-03-04 18:00:00	SPY	ETF	112.73	112.75	112.66	112.75	50828.0
2010-03-04 19:00:00	SPY	ETF	112.77	112.89	112.76	112.8	192571.0
2010-03-04 05:00:00	QQQ	ETF	45.59	45.59	45.59	45.59	204.0
2010-03-04 06:00:00	QQQ	ETF	45.6	45.6	45.6	45.6	400.0
2010-03-04 07:00:00	QQQ	ETF	45.58	45.6	45.52	45.6	1364455.0
2010-03-04 08:00:00	QQQ	ETF	45.4	45.95	45.4	45.68	1953893.0
2010-03-04 09:00:00	QQQ	ETF	45.68	45.76	45.54	45.72	7487257.0
2010-03-04 10:00:00	QQQ	ETF	45.73	45.73	45.4	45.5485	13854310.0
2010-03-04 11:00:00	QQQ	ETF	45.54	45.65	45.53	45.6199	6017474.0
2010-03-04 12:00:00	QQQ	ETF	45.62	45.6201	45.54	45.58	3485082.0
2010-03-04 13:00:00	QQQ	ETF	45.59	45.65	45.525	45.6	3524928.0
2010-03-04 14:00:00	QQQ	ETF	45.6	45.7	45.58	45.68	3807956.0
2010-03-04 15:00:00	QQQ	ETF	45.68	45.81	45.62	45.75	9880738.0
2010-03-04 16:00:00	QQQ	ETF	45.75	45.79	45.679	45.75	2661522.0
2010-03-04 17:00:00	QQQ	ETF	45.75	45.75	45.73	45.73	27759.0
2010-03-04 18:00:00	QQQ	ETF	45.72	45.8	45.72	45.8	47565.0
2010-03-04 19:00:00	QQQ	ETF	45.8	45.82	45.78	45.78	55732.0
2010-03-04 07:00:00	IWM	ETF	65.05	65.12	64.94	65.08	112900.0
2010-03-04 08:00:00	IWM	ETF	65.08	65.24	64.7	65.16	314792.0
2010-03-04 09:00:00	IWM	ETF	65.15	65.35	65.09	65.28	5224595.0
2010-03-04 10:00:00	IWM	ETF	65.27	65.33	64.87	64.98	7874116.0
2010-03-04 11:00:00	IWM	ETF	64.97	65.15	64.96	65.1107	3974482.0
2010-03-04 12:00:00	IWM	ETF	65.11	65.12	64.88	65.05	3973481.0
2010-03-04 13:00:00	IWM	ETF	65.05	65.12	64.9	64.99	4454752.0
2010-03-04 14:00:00	IWM	ETF	64.98	65.11	64.95	65.06	2570709.0
2010-03-04 15:00:00	IWM	ETF	65.0699	65.37	64.983	65.29	11714774.0
2010-03-04 16:00:00	IWM	ETF	65.3	65.42	64.983	65.36	5566444.0
2010-03-04 17:00:00	IWM	ETF	65.35	65.43	65.34	65.36	31063.0
2010-03-04 19:00:00	IWM	ETF	65.35	65.44	65.35	65.42	7094.0
2010-03-04 08:00:00	DIA	ETF	104.1	104.33	104.06	104.3	18075.0
2010-03-04 09:00:00	DIA	ETF	104.26	104.56	104.19	104.45	557277.0
2010-03-04 10:00:00	DIA	ETF	104.45	104.52	103.96	104.1	1485141.0
2010-03-04 11:00:00	DIA	ETF	104.09	104.29	104.085	104.22	840716.0
2010-03-04 12:00:00	DIA	ETF	104.23	104.28	104.135	104.22	455674.0
2010-03-04 13:00:00	DIA	ETF	104.22	104.37	104.08	104.226	719506.0
2010-03-04 14:00:00	DIA	ETF	104.22	104.38	104.18	104.3342	380265.0

> showing 50 of 4,680 rows — these rows as CSV

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