PREVIEW / etf_1hour / 2011-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-04.parquet
  size:    180 KB
  rows:    5,509

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-11-04 04:00:00	SPY	ETF	126.16	126.16	125.7	125.74	4250.0
2011-11-04 05:00:00	SPY	ETF	125.82	126.21	125.65	126.21	1700.0
2011-11-04 06:00:00	SPY	ETF	126.13	126.26	126.06	126.2	41790.0
2011-11-04 07:00:00	SPY	ETF	126.17	126.17	125.63	125.66	331738.0
2011-11-04 08:00:00	SPY	ETF	125.65	126.4	125.0	125.41	10367900.0
2011-11-04 09:00:00	SPY	ETF	125.4	125.52	124.8	124.9	25794580.0
2011-11-04 10:00:00	SPY	ETF	124.9	125.2155	124.01	124.46	36550298.0
2011-11-04 11:00:00	SPY	ETF	124.46	124.72	124.12	124.68	38204668.0
2011-11-04 12:00:00	SPY	ETF	124.6884	124.9	124.44	124.73	26794285.0
2011-11-04 13:00:00	SPY	ETF	124.73	125.7	124.66	125.46	25844404.0
2011-11-04 14:00:00	SPY	ETF	125.45	125.66	125.22	125.4	18222654.0
2011-11-04 15:00:00	SPY	ETF	125.41	125.63	124.905	125.47	47211763.0
2011-11-04 16:00:00	SPY	ETF	125.45	126.2728	124.65	125.7	18832669.0
2011-11-04 17:00:00	SPY	ETF	125.65	125.85	125.52	125.78	207537.0
2011-11-04 18:00:00	SPY	ETF	125.74	125.93	125.45	125.87	353814.0
2011-11-04 19:00:00	SPY	ETF	125.87	126.2	125.86	126.15	180220.0
2011-11-04 04:00:00	QQQ	ETF	58.08	58.08	58.08	58.08	1000.0
2011-11-04 05:00:00	QQQ	ETF	57.89	57.89	57.89	57.89	100.0
2011-11-04 06:00:00	QQQ	ETF	58.03	58.07	58.03	58.07	1700.0
2011-11-04 07:00:00	QQQ	ETF	58.05	58.05	57.67	57.69	187224.0
2011-11-04 08:00:00	QQQ	ETF	57.7	58.09	57.6	57.7	4606557.0
2011-11-04 09:00:00	QQQ	ETF	57.72	57.91	57.5	57.53	7467261.0
2011-11-04 10:00:00	QQQ	ETF	57.53	57.63	57.22	57.4	6412649.0
2011-11-04 11:00:00	QQQ	ETF	57.4	57.56	57.2819	57.52	5492994.0
2011-11-04 12:00:00	QQQ	ETF	57.53	57.68	57.47	57.6	6758550.0
2011-11-04 13:00:00	QQQ	ETF	57.59	58.05	57.55	57.949	7354631.0
2011-11-04 14:00:00	QQQ	ETF	57.955	58.01	57.83	57.905	3692265.0
2011-11-04 15:00:00	QQQ	ETF	57.9	57.905	57.67	57.82	7713808.0
2011-11-04 16:00:00	QQQ	ETF	57.82	57.93	57.6213	57.89	933710.0
2011-11-04 17:00:00	QQQ	ETF	57.9	57.91	57.64	57.65	98805.0
2011-11-04 18:00:00	QQQ	ETF	57.62	57.94	57.62	57.92	68048.0
2011-11-04 19:00:00	QQQ	ETF	57.9	58.03	57.85	58.0	25760.0
2011-11-04 05:00:00	IWM	ETF	74.53	74.81	74.53	74.81	400.0
2011-11-04 07:00:00	IWM	ETF	74.72	74.91	74.67	74.67	56590.0
2011-11-04 08:00:00	IWM	ETF	74.61	75.17	74.32	74.38	2858193.0
2011-11-04 09:00:00	IWM	ETF	74.36	74.59	73.95	74.03	8272972.0
2011-11-04 10:00:00	IWM	ETF	74.01	74.24	73.55	74.0335	7732735.0
2011-11-04 11:00:00	IWM	ETF	74.04	74.26	73.83	74.17	4623230.0
2011-11-04 12:00:00	IWM	ETF	74.19	74.38	73.81	74.12	7475912.0
2011-11-04 13:00:00	IWM	ETF	74.11	74.795	74.06	74.48	7571033.0
2011-11-04 14:00:00	IWM	ETF	74.48	74.75	74.43	74.57	3275412.0
2011-11-04 15:00:00	IWM	ETF	74.568	74.82	74.13	74.6	10717735.0
2011-11-04 16:00:00	IWM	ETF	74.59	75.0976	74.37	74.68	4314491.0
2011-11-04 17:00:00	IWM	ETF	74.68	74.71	74.52	74.52	86468.0
2011-11-04 18:00:00	IWM	ETF	74.63	74.73	74.63	74.73	10300.0
2011-11-04 19:00:00	IWM	ETF	74.75	75.01	74.75	74.99	9870.0
2011-11-04 06:00:00	DIA	ETF	120.13	120.13	120.13	120.13	100.0
2011-11-04 07:00:00	DIA	ETF	120.1	120.1	119.88	119.88	3000.0
2011-11-04 08:00:00	DIA	ETF	119.84	120.29	119.5	119.59	45008.0
2011-11-04 09:00:00	DIA	ETF	119.59	119.59	118.96	119.02	543276.0

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

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