PREVIEW / etf_1hour / 2012-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-20.parquet
  size:    186 KB
  rows:    5,733

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-06-20 04:00:00	SPY	ETF	135.31	135.68	135.31	135.61	17140.0
2012-06-20 05:00:00	SPY	ETF	135.71	135.79	135.64	135.69	3800.0
2012-06-20 06:00:00	SPY	ETF	135.65	135.71	135.5	135.63	34750.0
2012-06-20 07:00:00	SPY	ETF	135.7	136.0	135.66	135.87	243180.0
2012-06-20 08:00:00	SPY	ETF	135.89	135.92	135.74	135.77	576549.0
2012-06-20 09:00:00	SPY	ETF	135.77	135.86	135.33	135.53	14125097.0
2012-06-20 10:00:00	SPY	ETF	135.52	135.73	135.31	135.35	15663514.0
2012-06-20 11:00:00	SPY	ETF	135.35	135.58	135.33	135.37	11835375.0
2012-06-20 12:00:00	SPY	ETF	135.371	135.52	134.27	135.42	45609543.0
2012-06-20 13:00:00	SPY	ETF	135.4215	136.1	135.4	135.68	33596022.0
2012-06-20 14:00:00	SPY	ETF	135.68	135.82	134.79	135.05	34739889.0
2012-06-20 15:00:00	SPY	ETF	135.05	135.5	134.63	135.48	33091349.0
2012-06-20 16:00:00	SPY	ETF	135.48	135.74	135.1343	135.73	15017710.0
2012-06-20 17:00:00	SPY	ETF	135.7	135.74	135.66	135.67	380772.0
2012-06-20 18:00:00	SPY	ETF	135.69	135.69	135.47	135.53	93229.0
2012-06-20 19:00:00	SPY	ETF	135.54	135.6	135.47	135.5	75177.0
2012-06-20 04:00:00	QQQ	ETF	64.3	64.3	64.3	64.3	100.0
2012-06-20 05:00:00	QQQ	ETF	64.32	64.32	64.32	64.32	100.0
2012-06-20 06:00:00	QQQ	ETF	64.29	64.29	64.2	64.28	9400.0
2012-06-20 07:00:00	QQQ	ETF	64.29	64.41	64.29	64.34	18690.0
2012-06-20 08:00:00	QQQ	ETF	64.33	64.39	64.3	64.33	96024.0
2012-06-20 09:00:00	QQQ	ETF	64.32	64.45	64.15	64.33	3259176.0
2012-06-20 10:00:00	QQQ	ETF	64.3201	64.37	64.18	64.2	4662574.0
2012-06-20 11:00:00	QQQ	ETF	64.2	64.36	64.19	64.2401	3396150.0
2012-06-20 12:00:00	QQQ	ETF	64.24	64.37	63.81	64.33	11147186.0
2012-06-20 13:00:00	QQQ	ETF	64.3265	64.57	64.25	64.41	6679969.0
2012-06-20 14:00:00	QQQ	ETF	64.41	64.46	63.99	64.11	7072622.0
2012-06-20 15:00:00	QQQ	ETF	64.12	64.32	63.9	64.32	7656977.0
2012-06-20 16:00:00	QQQ	ETF	64.31	64.43	64.1122	64.35	618830.0
2012-06-20 17:00:00	QQQ	ETF	64.35	64.35	64.29	64.33	647187.0
2012-06-20 18:00:00	QQQ	ETF	64.32	64.34	64.25	64.29	45350.0
2012-06-20 19:00:00	QQQ	ETF	64.26	64.3	64.25	64.27	5900.0
2012-06-20 07:00:00	IWM	ETF	78.75	78.83	78.75	78.81	25616.0
2012-06-20 08:00:00	IWM	ETF	78.72	78.85	78.68	78.68	38525.0
2012-06-20 09:00:00	IWM	ETF	78.65	78.74	78.3	78.66	4430316.0
2012-06-20 10:00:00	IWM	ETF	78.66	78.8	78.445	78.49	6442125.0
2012-06-20 11:00:00	IWM	ETF	78.48	78.71	78.47	78.57	3192883.0
2012-06-20 12:00:00	IWM	ETF	78.57	78.788	77.98	78.7499	12897302.0
2012-06-20 13:00:00	IWM	ETF	78.75	79.08	78.5	78.8	7768885.0
2012-06-20 14:00:00	IWM	ETF	78.8	78.86	78.21	78.34	7665096.0
2012-06-20 15:00:00	IWM	ETF	78.36	78.53	78.09	78.5	8095886.0
2012-06-20 16:00:00	IWM	ETF	78.51	78.95	78.25	78.55	1123380.0
2012-06-20 17:00:00	IWM	ETF	78.58	78.6	78.53	78.53	217181.0
2012-06-20 18:00:00	IWM	ETF	78.52	78.52	78.47	78.47	10322.0
2012-06-20 19:00:00	IWM	ETF	78.47	78.5	78.47	78.5	500.0
2012-06-20 07:00:00	DIA	ETF	128.37	128.37	128.37	128.37	250.0
2012-06-20 08:00:00	DIA	ETF	128.19	128.3	128.17	128.17	5455.0
2012-06-20 09:00:00	DIA	ETF	128.16	128.22	127.83	127.91	428453.0
2012-06-20 10:00:00	DIA	ETF	127.91	128.1691	127.83	127.9	610813.0
2012-06-20 11:00:00	DIA	ETF	127.9	128.09	127.84	127.84	587360.0

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

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