PREVIEW / etf_1hour / 2012-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-04.parquet
  size:    186 KB
  rows:    5,818

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
2012-09-04 04:00:00	SPY	ETF	141.3	141.35	141.3	141.3	600.0
2012-09-04 06:00:00	SPY	ETF	141.37	141.37	140.92	140.92	94200.0
2012-09-04 07:00:00	SPY	ETF	140.99	141.22	140.93	141.19	143320.0
2012-09-04 08:00:00	SPY	ETF	141.18	141.22	141.02	141.04	611060.0
2012-09-04 09:00:00	SPY	ETF	141.03	141.24	140.85	140.97	10963441.0
2012-09-04 10:00:00	SPY	ETF	140.97	141.04	140.13	140.27	23829973.0
2012-09-04 11:00:00	SPY	ETF	140.26	140.5	140.19	140.4313	10314462.0
2012-09-04 12:00:00	SPY	ETF	140.44	140.52	140.31	140.49	6039650.0
2012-09-04 13:00:00	SPY	ETF	140.49	140.65	140.45	140.53	5768912.0
2012-09-04 14:00:00	SPY	ETF	140.53	141.46	140.48	141.24	21815488.0
2012-09-04 15:00:00	SPY	ETF	141.25	141.37	140.95	140.95	23416530.0
2012-09-04 16:00:00	SPY	ETF	140.95	141.29	140.7457	141.09	13534368.0
2012-09-04 17:00:00	SPY	ETF	141.06	141.51	140.97	141.0	598014.0
2012-09-04 18:00:00	SPY	ETF	141.02	141.18	141.0	141.09	570419.0
2012-09-04 19:00:00	SPY	ETF	141.09	141.1	141.0	141.03	101635.0
2012-09-04 04:00:00	QQQ	ETF	68.27	68.33	68.27	68.33	600.0
2012-09-04 06:00:00	QQQ	ETF	68.2	68.2	68.07	68.07	1000.0
2012-09-04 07:00:00	QQQ	ETF	68.07	68.15	68.05	68.15	14695.0
2012-09-04 08:00:00	QQQ	ETF	68.15	68.16	68.04	68.05	74073.0
2012-09-04 09:00:00	QQQ	ETF	68.0	68.14	67.87	68.05	2440340.0
2012-09-04 10:00:00	QQQ	ETF	68.05	68.11	67.42	67.5	7031694.0
2012-09-04 11:00:00	QQQ	ETF	67.5	67.7	67.44	67.67	5284268.0
2012-09-04 12:00:00	QQQ	ETF	67.67	67.76	67.59	67.76	1329622.0
2012-09-04 13:00:00	QQQ	ETF	67.75	67.87	67.74	67.81	2035954.0
2012-09-04 14:00:00	QQQ	ETF	67.811	68.35	67.795	68.24	4243873.0
2012-09-04 15:00:00	QQQ	ETF	68.24	68.29	68.09	68.1	6048322.0
2012-09-04 16:00:00	QQQ	ETF	68.12	68.2858	67.698	68.16	2520583.0
2012-09-04 17:00:00	QQQ	ETF	68.17	68.21	68.08	68.09	20775.0
2012-09-04 18:00:00	QQQ	ETF	68.13	68.2	68.13	68.2	3248.0
2012-09-04 19:00:00	QQQ	ETF	68.18	68.18	68.1	68.11	35405.0
2012-09-04 04:00:00	IWM	ETF	81.5	81.5	81.5	81.5	200.0
2012-09-04 06:00:00	IWM	ETF	81.35	81.35	81.19	81.2	3300.0
2012-09-04 07:00:00	IWM	ETF	81.19	81.33	81.18	81.33	7550.0
2012-09-04 08:00:00	IWM	ETF	81.33	81.33	81.16	81.21	120614.0
2012-09-04 09:00:00	IWM	ETF	81.17	81.5	81.06	81.24	4455850.0
2012-09-04 10:00:00	IWM	ETF	81.23	81.3	80.5501	80.67	8822253.0
2012-09-04 11:00:00	IWM	ETF	80.67	80.81	80.6	80.79	3975377.0
2012-09-04 12:00:00	IWM	ETF	80.785	81.05	80.7	81.04	3574732.0
2012-09-04 13:00:00	IWM	ETF	81.04	81.34	81.03	81.3	3576769.0
2012-09-04 14:00:00	IWM	ETF	81.3001	82.27	81.27	82.19	13507081.0
2012-09-04 15:00:00	IWM	ETF	82.2	82.4	82.05	82.13	20181483.0
2012-09-04 16:00:00	IWM	ETF	82.14	82.34	81.6437	82.23	3768325.0
2012-09-04 17:00:00	IWM	ETF	82.23	82.3	82.05	82.13	103610.0
2012-09-04 18:00:00	IWM	ETF	82.13	82.15	82.11	82.11	3200.0
2012-09-04 19:00:00	IWM	ETF	82.12	82.15	82.11	82.11	3000.0
2012-09-04 07:00:00	DIA	ETF	130.71	130.71	130.71	130.71	100.0
2012-09-04 08:00:00	DIA	ETF	130.79	130.86	130.79	130.79	3600.0
2012-09-04 09:00:00	DIA	ETF	130.74	130.82	130.406	130.482	377423.0
2012-09-04 10:00:00	DIA	ETF	130.47	130.58	129.63	129.74	1008762.0
2012-09-04 11:00:00	DIA	ETF	129.74	129.9425	129.68	129.8798	405821.0

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

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