PREVIEW / etf_1hour / 2011-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-23.parquet
  size:    189 KB
  rows:    5,826

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
2011-09-23 04:00:00	SPY	ETF	113.66	114.23	113.66	114.04	9427.0
2011-09-23 05:00:00	SPY	ETF	114.2	114.23	113.02	113.02	6827.0
2011-09-23 06:00:00	SPY	ETF	113.28	113.28	111.75	112.25	294519.0
2011-09-23 07:00:00	SPY	ETF	112.2	112.35	111.16	111.28	3262155.0
2011-09-23 08:00:00	SPY	ETF	111.32	114.33	110.85	111.76	10749893.0
2011-09-23 09:00:00	SPY	ETF	111.75	113.47	111.7	113.1	44492503.0
2011-09-23 10:00:00	SPY	ETF	113.1	113.66	112.12	113.51	55067274.0
2011-09-23 11:00:00	SPY	ETF	113.52	114.03	113.1	113.467	34400397.0
2011-09-23 12:00:00	SPY	ETF	113.46	113.78	112.87	113.13	31257307.0
2011-09-23 13:00:00	SPY	ETF	113.13	114.01	112.8	113.95	34041180.0
2011-09-23 14:00:00	SPY	ETF	113.95	114.16	112.86	112.93	29270498.0
2011-09-23 15:00:00	SPY	ETF	112.93	113.85	112.93	113.44	43530354.0
2011-09-23 16:00:00	SPY	ETF	113.43	113.8	112.8995	113.64	13307316.0
2011-09-23 17:00:00	SPY	ETF	113.66	113.68	113.14	113.15	2276517.0
2011-09-23 18:00:00	SPY	ETF	113.15	113.54	113.01	113.23	997646.0
2011-09-23 19:00:00	SPY	ETF	113.23	113.44	113.2	113.44	62068.0
2011-09-23 04:00:00	QQQ	ETF	53.88	53.88	53.88	53.88	800.0
2011-09-23 05:00:00	QQQ	ETF	53.88	53.88	53.84	53.84	2000.0
2011-09-23 06:00:00	QQQ	ETF	53.51	53.51	52.86	52.86	14622.0
2011-09-23 07:00:00	QQQ	ETF	53.02	53.13	52.6	52.66	204999.0
2011-09-23 08:00:00	QQQ	ETF	52.68	53.16	52.5	52.94	2516605.0
2011-09-23 09:00:00	QQQ	ETF	52.93	53.84	52.93	53.641	13195391.0
2011-09-23 10:00:00	QQQ	ETF	53.65	54.01	53.4	53.95	12973248.0
2011-09-23 11:00:00	QQQ	ETF	53.95	54.27	53.79	53.98	7892709.0
2011-09-23 12:00:00	QQQ	ETF	53.981	54.13	53.69	53.8	6882611.0
2011-09-23 13:00:00	QQQ	ETF	53.81	54.3099	53.71	54.28	9360625.0
2011-09-23 14:00:00	QQQ	ETF	54.29	54.38	53.84	53.87	7852589.0
2011-09-23 15:00:00	QQQ	ETF	53.87	54.27	53.85	54.13	14443689.0
2011-09-23 16:00:00	QQQ	ETF	54.12	54.29	53.92	54.17	3181014.0
2011-09-23 17:00:00	QQQ	ETF	54.17	54.22	54.05	54.08	54767.0
2011-09-23 18:00:00	QQQ	ETF	54.08	54.08	54.02	54.08	5786.0
2011-09-23 19:00:00	QQQ	ETF	54.05	54.25	54.05	54.13	18780.0
2011-09-23 04:00:00	IWM	ETF	64.93	65.21	64.91	65.21	2850.0
2011-09-23 05:00:00	IWM	ETF	65.05	65.1	64.45	64.45	4452.0
2011-09-23 06:00:00	IWM	ETF	64.4	64.4	63.6	63.69	28500.0
2011-09-23 07:00:00	IWM	ETF	63.84	63.92	63.21	63.3	485506.0
2011-09-23 08:00:00	IWM	ETF	63.39	65.61	63.07	63.87	1335840.0
2011-09-23 09:00:00	IWM	ETF	63.86	65.13	63.83	64.7	14265097.0
2011-09-23 10:00:00	IWM	ETF	64.7	65.09	64.13	64.92	13093975.0
2011-09-23 11:00:00	IWM	ETF	64.92	65.53	64.71	64.99	11949228.0
2011-09-23 12:00:00	IWM	ETF	64.99	65.22	64.49	64.7	6801257.0
2011-09-23 13:00:00	IWM	ETF	64.7	65.25	64.5	65.22	6752994.0
2011-09-23 14:00:00	IWM	ETF	65.22	65.32	64.42	64.46	5319165.0
2011-09-23 15:00:00	IWM	ETF	64.47	65.2	64.46	65.13	14151805.0
2011-09-23 16:00:00	IWM	ETF	65.13	65.23	64.95	65.11	2282107.0
2011-09-23 17:00:00	IWM	ETF	65.1	65.12	64.93	65.04	75784.0
2011-09-23 18:00:00	IWM	ETF	64.97	65.15	64.94	65.15	7467.0
2011-09-23 19:00:00	IWM	ETF	65.16	65.17	65.02	65.11	2700.0
2011-09-23 06:00:00	DIA	ETF	106.4	106.4	106.1	106.1	4500.0
2011-09-23 07:00:00	DIA	ETF	106.06	106.18	105.65	105.65	9159.0

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

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