PREVIEW / etf_1hour / 2011-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-13.parquet
  size:    180 KB
  rows:    5,569

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-13 04:00:00	SPY	ETF	116.0	116.1	115.19	115.64	29516.0
2011-09-13 05:00:00	SPY	ETF	115.8	115.99	115.39	115.39	57775.0
2011-09-13 06:00:00	SPY	ETF	115.4	116.0	115.18	115.69	133200.0
2011-09-13 07:00:00	SPY	ETF	115.77	117.11	115.77	116.28	3418765.0
2011-09-13 08:00:00	SPY	ETF	116.27	117.06	115.85	116.68	5591018.0
2011-09-13 09:00:00	SPY	ETF	116.67	117.55	116.22	117.46	37815531.0
2011-09-13 10:00:00	SPY	ETF	117.46	117.96	116.92	117.09	49064550.0
2011-09-13 11:00:00	SPY	ETF	117.1	117.33	116.55	116.97	28354081.0
2011-09-13 12:00:00	SPY	ETF	116.9628	117.43	116.6	117.32	21694914.0
2011-09-13 13:00:00	SPY	ETF	117.33	117.93	117.32	117.73	22112757.0
2011-09-13 14:00:00	SPY	ETF	117.73	118.18	117.45	117.66	32414422.0
2011-09-13 15:00:00	SPY	ETF	117.65	118.08	117.03	117.74	54905081.0
2011-09-13 16:00:00	SPY	ETF	117.73	117.83	116.458	117.54	14145202.0
2011-09-13 17:00:00	SPY	ETF	117.52	117.69	117.42	117.63	222355.0
2011-09-13 18:00:00	SPY	ETF	117.63	117.63	117.28	117.54	277796.0
2011-09-13 19:00:00	SPY	ETF	117.55	117.58	117.21	117.3	147773.0
2011-09-13 04:00:00	QQQ	ETF	53.95	53.95	53.34	53.45	8843.0
2011-09-13 05:00:00	QQQ	ETF	53.46	53.55	53.46	53.49	6700.0
2011-09-13 06:00:00	QQQ	ETF	53.42	53.61	53.42	53.6	6400.0
2011-09-13 07:00:00	QQQ	ETF	53.59	54.15	53.59	53.9	446472.0
2011-09-13 08:00:00	QQQ	ETF	53.86	54.13	53.54	53.97	1005094.0
2011-09-13 09:00:00	QQQ	ETF	53.96	54.26	53.8	54.22	8928306.0
2011-09-13 10:00:00	QQQ	ETF	54.22	54.43	53.97	54.07	9571101.0
2011-09-13 11:00:00	QQQ	ETF	54.06	54.17	53.88	54.07	5378972.0
2011-09-13 12:00:00	QQQ	ETF	54.07	54.28	53.9	54.23	4239862.0
2011-09-13 13:00:00	QQQ	ETF	54.24	54.58	54.24	54.51	4840382.0
2011-09-13 14:00:00	QQQ	ETF	54.5	54.69	54.4	54.5	7369476.0
2011-09-13 15:00:00	QQQ	ETF	54.49	54.69	54.24	54.57	12365932.0
2011-09-13 16:00:00	QQQ	ETF	54.57	54.62	54.41	54.47	1531070.0
2011-09-13 17:00:00	QQQ	ETF	54.47	54.62	54.47	54.62	11158.0
2011-09-13 18:00:00	QQQ	ETF	54.49	54.58	54.42	54.52	28427.0
2011-09-13 19:00:00	QQQ	ETF	54.52	54.56	54.39	54.56	13904.0
2011-09-13 04:00:00	IWM	ETF	68.02	68.02	67.05	67.51	3815.0
2011-09-13 06:00:00	IWM	ETF	67.25	67.53	67.25	67.51	5100.0
2011-09-13 07:00:00	IWM	ETF	67.71	68.3	67.51	67.85	1436292.0
2011-09-13 08:00:00	IWM	ETF	67.85	68.31	67.55	68.11	3072840.0
2011-09-13 09:00:00	IWM	ETF	68.11	68.84	67.829	68.74	9445385.0
2011-09-13 10:00:00	IWM	ETF	68.73	69.28	68.48	68.68	12691050.0
2011-09-13 11:00:00	IWM	ETF	68.67	68.83	67.99	68.5	7432853.0
2011-09-13 12:00:00	IWM	ETF	68.5	68.93	68.19	68.86	7109386.0
2011-09-13 13:00:00	IWM	ETF	68.87	69.25	68.58	69.035	6048009.0
2011-09-13 14:00:00	IWM	ETF	69.03	69.46	68.9	69.11	8842418.0
2011-09-13 15:00:00	IWM	ETF	69.09	69.44	68.44	69.21	14685675.0
2011-09-13 16:00:00	IWM	ETF	69.22	69.3	68.0465	69.03	9145131.0
2011-09-13 17:00:00	IWM	ETF	69.01	69.21	69.01	69.08	12000.0
2011-09-13 18:00:00	IWM	ETF	69.06	69.08	69.01	69.08	4500.0
2011-09-13 19:00:00	IWM	ETF	69.07	69.12	68.95	68.99	12700.0
2011-09-13 07:00:00	DIA	ETF	110.24	110.24	110.0	110.0	200.0
2011-09-13 08:00:00	DIA	ETF	109.95	110.65	109.87	110.42	358731.0
2011-09-13 09:00:00	DIA	ETF	110.35	110.93	109.82	110.86	1539353.0

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

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