PREVIEW / etf_1hour / 2011-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-27.parquet
  size:    188 KB
  rows:    5,732

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-07-27 04:00:00	SPY	ETF	133.09	133.09	133.09	133.09	900.0
2011-07-27 05:00:00	SPY	ETF	133.19	133.19	133.14	133.14	10100.0
2011-07-27 06:00:00	SPY	ETF	133.0	133.09	132.92	132.96	43600.0
2011-07-27 07:00:00	SPY	ETF	132.97	133.08	132.82	132.84	917210.0
2011-07-27 08:00:00	SPY	ETF	132.91	132.91	132.35	132.47	4474244.0
2011-07-27 09:00:00	SPY	ETF	132.47	132.72	132.02	132.07	23555435.0
2011-07-27 10:00:00	SPY	ETF	132.07	132.15	131.21	131.7401	53223693.0
2011-07-27 11:00:00	SPY	ETF	131.75	132.12	131.56	131.63	30085759.0
2011-07-27 12:00:00	SPY	ETF	131.62	131.75	131.45	131.47	19149232.0
2011-07-27 13:00:00	SPY	ETF	131.46	131.63	131.31	131.55	16606949.0
2011-07-27 14:00:00	SPY	ETF	131.55	131.57	130.75	130.94	29132484.0
2011-07-27 15:00:00	SPY	ETF	130.94	131.07	130.43	130.61	57080301.0
2011-07-27 16:00:00	SPY	ETF	130.61	131.74	130.29	130.53	9394196.0
2011-07-27 17:00:00	SPY	ETF	130.52	131.3833	130.4	130.48	458077.0
2011-07-27 18:00:00	SPY	ETF	130.43	130.61	130.35	130.59	907026.0
2011-07-27 19:00:00	SPY	ETF	130.59	130.61	130.3	130.37	286827.0
2011-07-27 07:00:00	QQQ	ETF	59.49	59.53	59.4	59.4	226738.0
2011-07-27 08:00:00	QQQ	ETF	59.43	59.43	59.14	59.16	1768063.0
2011-07-27 09:00:00	QQQ	ETF	59.17	59.29	58.89	58.93	7265553.0
2011-07-27 10:00:00	QQQ	ETF	58.93	58.94	58.29	58.66	13337037.0
2011-07-27 11:00:00	QQQ	ETF	58.67	58.88	58.56	58.62	9313384.0
2011-07-27 12:00:00	QQQ	ETF	58.615	58.67	58.5	58.53	6692869.0
2011-07-27 13:00:00	QQQ	ETF	58.53	58.64	58.43	58.5406	4188744.0
2011-07-27 14:00:00	QQQ	ETF	58.54	58.565	58.12	58.28	11293896.0
2011-07-27 15:00:00	QQQ	ETF	58.2771	58.33	57.94	58.09	20374310.0
2011-07-27 16:00:00	QQQ	ETF	58.1	58.125	57.96	58.03	3714043.0
2011-07-27 17:00:00	QQQ	ETF	58.03	58.1838	57.95	58.0	78825.0
2011-07-27 18:00:00	QQQ	ETF	58.0	58.08	57.97	58.04	164822.0
2011-07-27 19:00:00	QQQ	ETF	58.02	58.02	57.9	57.9	113338.0
2011-07-27 05:00:00	IWM	ETF	82.41	82.41	82.41	82.41	100.0
2011-07-27 06:00:00	IWM	ETF	82.17	82.17	82.17	82.17	3500.0
2011-07-27 07:00:00	IWM	ETF	82.21	82.28	82.18	82.23	11700.0
2011-07-27 08:00:00	IWM	ETF	82.18	82.23	81.79	81.86	933982.0
2011-07-27 09:00:00	IWM	ETF	81.9	82.05	81.16	81.24	9296524.0
2011-07-27 10:00:00	IWM	ETF	81.24	81.25	80.34	80.82	18734639.0
2011-07-27 11:00:00	IWM	ETF	80.82	81.15	80.59	80.68	10662504.0
2011-07-27 12:00:00	IWM	ETF	80.67	80.79	80.57	80.59	4383442.0
2011-07-27 13:00:00	IWM	ETF	80.585	80.7	80.45	80.61	3919934.0
2011-07-27 14:00:00	IWM	ETF	80.61	80.63	80.09	80.2	9429088.0
2011-07-27 15:00:00	IWM	ETF	80.2071	80.33	79.85	79.97	15464463.0
2011-07-27 16:00:00	IWM	ETF	79.98	82.3915	79.85	79.98	5461681.0
2011-07-27 17:00:00	IWM	ETF	79.96	80.01	79.9	79.99	385967.0
2011-07-27 18:00:00	IWM	ETF	79.95	80.09	79.95	80.0	30334.0
2011-07-27 19:00:00	IWM	ETF	80.0	80.01	79.92	79.93	11100.0
2011-07-27 05:00:00	DIA	ETF	124.82	124.82	124.82	124.82	100.0
2011-07-27 07:00:00	DIA	ETF	124.7	124.72	124.67	124.67	1300.0
2011-07-27 08:00:00	DIA	ETF	124.6	124.6	124.33	124.36	14900.0
2011-07-27 09:00:00	DIA	ETF	124.5	124.52	123.89	124.01	943119.0
2011-07-27 10:00:00	DIA	ETF	124.0	124.12	123.37	123.77	1756785.0
2011-07-27 11:00:00	DIA	ETF	123.76	124.09	123.59	123.67	770709.0

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

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