PREVIEW / etf_1hour / 2011-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-30.parquet
  size:    185 KB
  rows:    5,696

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-30 04:00:00	SPY	ETF	115.45	115.45	115.17	115.43	35730.0
2011-09-30 05:00:00	SPY	ETF	115.35	115.35	114.79	114.79	49051.0
2011-09-30 06:00:00	SPY	ETF	114.81	115.01	114.54	114.8	563339.0
2011-09-30 07:00:00	SPY	ETF	114.83	115.09	114.65	114.75	590777.0
2011-09-30 08:00:00	SPY	ETF	114.7	115.2	114.6	114.67	3298113.0
2011-09-30 09:00:00	SPY	ETF	114.67	115.09	114.05	114.13	43457235.0
2011-09-30 10:00:00	SPY	ETF	114.11	115.34	114.0	114.33	37761311.0
2011-09-30 11:00:00	SPY	ETF	114.34	115.45	114.32	115.09	25646802.0
2011-09-30 12:00:00	SPY	ETF	115.1	115.27	114.62	114.6301	13780469.0
2011-09-30 13:00:00	SPY	ETF	114.64	115.11	114.43	114.8001	15640702.0
2011-09-30 14:00:00	SPY	ETF	114.8	114.93	113.78	114.285	38549717.0
2011-09-30 15:00:00	SPY	ETF	114.32	114.67	113.07	113.15	73824519.0
2011-09-30 16:00:00	SPY	ETF	113.15	116.0183	112.76	113.03	30512470.0
2011-09-30 17:00:00	SPY	ETF	113.0	113.09	112.9	112.95	763457.0
2011-09-30 18:00:00	SPY	ETF	112.95	113.02	112.88	112.9	195946.0
2011-09-30 19:00:00	SPY	ETF	112.94	113.17	112.83	112.89	202077.0
2011-09-30 04:00:00	QQQ	ETF	53.57	53.57	53.57	53.57	100.0
2011-09-30 05:00:00	QQQ	ETF	53.48	53.48	53.46	53.46	300.0
2011-09-30 06:00:00	QQQ	ETF	53.35	53.4	53.25	53.35	8600.0
2011-09-30 07:00:00	QQQ	ETF	53.39	53.47	53.26	53.29	126224.0
2011-09-30 08:00:00	QQQ	ETF	53.29	53.5	53.26	53.26	369340.0
2011-09-30 09:00:00	QQQ	ETF	53.26	53.29	52.83	52.92	14719107.0
2011-09-30 10:00:00	QQQ	ETF	52.92	53.59	52.86	53.06	15386030.0
2011-09-30 11:00:00	QQQ	ETF	53.06	53.61	53.06	53.41	8133358.0
2011-09-30 12:00:00	QQQ	ETF	53.41	53.5	53.16	53.17	5981847.0
2011-09-30 13:00:00	QQQ	ETF	53.16	53.36	53.05	53.225	5303226.0
2011-09-30 14:00:00	QQQ	ETF	53.22	53.26	52.77	53.01	15830849.0
2011-09-30 15:00:00	QQQ	ETF	53.01	53.16	52.46	52.49	19336674.0
2011-09-30 16:00:00	QQQ	ETF	52.49	52.52	52.23	52.38	6485750.0
2011-09-30 17:00:00	QQQ	ETF	52.41	52.44	52.35	52.38	28039.0
2011-09-30 18:00:00	QQQ	ETF	52.36	52.38	52.25	52.29	42452.0
2011-09-30 19:00:00	QQQ	ETF	52.29	52.31	52.25	52.28	47157.0
2011-09-30 04:00:00	IWM	ETF	66.0	66.0	65.81	65.81	415.0
2011-09-30 05:00:00	IWM	ETF	65.62	65.62	65.52	65.52	32436.0
2011-09-30 06:00:00	IWM	ETF	65.25	65.31	65.1	65.1	1697.0
2011-09-30 07:00:00	IWM	ETF	65.35	65.36	65.14	65.14	11110.0
2011-09-30 08:00:00	IWM	ETF	65.18	66.1	65.18	65.26	495406.0
2011-09-30 09:00:00	IWM	ETF	65.24	65.857	65.04	65.23	11355440.0
2011-09-30 10:00:00	IWM	ETF	65.23	66.03	65.18	65.319	10718856.0
2011-09-30 11:00:00	IWM	ETF	65.33	66.18	65.295	65.81	6043900.0
2011-09-30 12:00:00	IWM	ETF	65.82	65.94	65.42	65.5	5395069.0
2011-09-30 13:00:00	IWM	ETF	65.5	65.74	65.3301	65.442	4046337.0
2011-09-30 14:00:00	IWM	ETF	65.44	65.515	64.84	65.2	7982725.0
2011-09-30 15:00:00	IWM	ETF	65.2	65.4	64.24	64.28	18044667.0
2011-09-30 16:00:00	IWM	ETF	64.29	64.546	64.05	64.19	4478179.0
2011-09-30 17:00:00	IWM	ETF	64.15	64.25	64.1	64.12	36759.0
2011-09-30 18:00:00	IWM	ETF	64.12	64.16	64.1	64.14	2900.0
2011-09-30 19:00:00	IWM	ETF	64.14	64.18	64.1	64.15	12100.0
2011-09-30 04:00:00	DIA	ETF	110.65	110.65	110.6	110.6	1000.0
2011-09-30 05:00:00	DIA	ETF	110.55	110.55	110.3	110.3	3106.0

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

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