PREVIEW / etf_1hour / 2010-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-10.parquet
  size:    163 KB
  rows:    5,005

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-08-10 04:00:00	SPY	ETF	112.35	112.84	112.21	112.46	5865.0
2010-08-10 05:00:00	SPY	ETF	112.3	112.33	112.26	112.33	12050.0
2010-08-10 06:00:00	SPY	ETF	112.41	112.49	112.33	112.45	41900.0
2010-08-10 07:00:00	SPY	ETF	112.45	112.53	112.24	112.27	1051243.0
2010-08-10 08:00:00	SPY	ETF	112.27	113.02	111.81	112.01	6034057.0
2010-08-10 09:00:00	SPY	ETF	112.0	113.01	111.3701	111.67	26421966.0
2010-08-10 10:00:00	SPY	ETF	111.67	111.92	111.53	111.67	22327738.0
2010-08-10 11:00:00	SPY	ETF	111.67	112.03	111.65	111.96	14260441.0
2010-08-10 12:00:00	SPY	ETF	111.96	111.99	111.82	111.87	10761382.0
2010-08-10 13:00:00	SPY	ETF	111.87	111.88	111.55	111.73	12475906.0
2010-08-10 14:00:00	SPY	ETF	111.73	112.98	111.73	112.58	84466352.0
2010-08-10 15:00:00	SPY	ETF	112.59	112.85	112.16	112.42	48643529.0
2010-08-10 16:00:00	SPY	ETF	112.42	113.0254	111.555	112.45	12129007.0
2010-08-10 17:00:00	SPY	ETF	112.47	113.0255	112.44	112.5	3582818.0
2010-08-10 18:00:00	SPY	ETF	112.48	112.48	112.39	112.45	128277.0
2010-08-10 19:00:00	SPY	ETF	112.43	112.44	112.23	112.23	98500.0
2010-08-10 04:00:00	QQQ	ETF	47.02	47.02	46.78	46.8	13361.0
2010-08-10 05:00:00	QQQ	ETF	46.81	46.81	46.78	46.78	7840.0
2010-08-10 06:00:00	QQQ	ETF	46.9	46.9	46.86	46.88	1200.0
2010-08-10 07:00:00	QQQ	ETF	46.87	46.9	46.78	46.8	694982.0
2010-08-10 08:00:00	QQQ	ETF	46.8	46.87	46.6	46.69	3821806.0
2010-08-10 09:00:00	QQQ	ETF	46.69	46.77	46.28	46.37	12208117.0
2010-08-10 10:00:00	QQQ	ETF	46.38	46.54	46.34	46.42	8724659.0
2010-08-10 11:00:00	QQQ	ETF	46.43	46.61	46.417	46.5721	5076583.0
2010-08-10 12:00:00	QQQ	ETF	46.58	46.5996	46.48	46.5	3267392.0
2010-08-10 13:00:00	QQQ	ETF	46.5	46.5	46.31	46.39	4347081.0
2010-08-10 14:00:00	QQQ	ETF	46.39	46.95	46.36	46.815	31715054.0
2010-08-10 15:00:00	QQQ	ETF	46.82	46.91	46.66	46.69	11088580.0
2010-08-10 16:00:00	QQQ	ETF	46.695	47.0954	46.39	46.66	2694491.0
2010-08-10 17:00:00	QQQ	ETF	46.65	46.67	46.65	46.66	5025.0
2010-08-10 18:00:00	QQQ	ETF	46.68	46.68	46.65	46.67	43686.0
2010-08-10 19:00:00	QQQ	ETF	46.67	46.67	46.56	46.56	37832.0
2010-08-10 04:00:00	IWM	ETF	65.35	65.51	65.35	65.51	1585.0
2010-08-10 06:00:00	IWM	ETF	65.45	65.46	65.44	65.44	2300.0
2010-08-10 07:00:00	IWM	ETF	65.45	65.52	65.33	65.36	60350.0
2010-08-10 08:00:00	IWM	ETF	65.36	65.96	65.09	65.22	1204274.0
2010-08-10 09:00:00	IWM	ETF	65.21	65.33	64.37	64.66	8413149.0
2010-08-10 10:00:00	IWM	ETF	64.64	65.1	64.4717	64.61	4657398.0
2010-08-10 11:00:00	IWM	ETF	64.61	64.86	64.59	64.74	2882607.0
2010-08-10 12:00:00	IWM	ETF	64.74	64.75	64.47	64.49	2117282.0
2010-08-10 13:00:00	IWM	ETF	64.49	64.51	64.13	64.33	3947760.0
2010-08-10 14:00:00	IWM	ETF	64.33	65.41	64.33	65.14	20009776.0
2010-08-10 15:00:00	IWM	ETF	65.14	65.35	64.59	64.66	11966021.0
2010-08-10 16:00:00	IWM	ETF	64.66	65.0	64.32	64.72	3249245.0
2010-08-10 17:00:00	IWM	ETF	64.7	65.9663	64.67	64.67	1002300.0
2010-08-10 18:00:00	IWM	ETF	64.69	64.73	64.69	64.72	5250.0
2010-08-10 19:00:00	IWM	ETF	64.67	64.67	64.56	64.56	3000.0
2010-08-10 04:00:00	DIA	ETF	107.0	107.0	106.7	106.7	2236.0
2010-08-10 05:00:00	DIA	ETF	106.58	106.58	106.58	106.58	400.0
2010-08-10 07:00:00	DIA	ETF	106.68	106.68	106.5	106.53	10180.0

> showing 50 of 5,005 rows — these rows as CSV

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