PREVIEW / etf_1hour / 2012-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-06.parquet
  size:    184 KB
  rows:    5,755

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-12-06 04:00:00	SPY	ETF	141.11	141.73	141.11	141.68	16777.0
2012-12-06 05:00:00	SPY	ETF	141.67	141.69	141.58	141.59	32258.0
2012-12-06 06:00:00	SPY	ETF	141.63	141.65	141.29	141.32	29410.0
2012-12-06 07:00:00	SPY	ETF	141.31	141.51	141.29	141.4	155727.0
2012-12-06 08:00:00	SPY	ETF	141.31	141.58	141.09	141.25	1068200.0
2012-12-06 09:00:00	SPY	ETF	141.2	141.72	141.2	141.465	17059641.0
2012-12-06 10:00:00	SPY	ETF	141.46	141.92	141.16	141.83	16784513.0
2012-12-06 11:00:00	SPY	ETF	141.83	142.0	141.72	141.8017	9217383.0
2012-12-06 12:00:00	SPY	ETF	141.81	141.88	141.49	141.49	10035419.0
2012-12-06 13:00:00	SPY	ETF	141.49	141.88	141.45	141.87	6425621.0
2012-12-06 14:00:00	SPY	ETF	141.86	141.96	141.71	141.785	7836103.0
2012-12-06 15:00:00	SPY	ETF	141.78	142.04	141.62	141.96	15056450.0
2012-12-06 16:00:00	SPY	ETF	141.96	142.04	141.5402	142.015	12177297.0
2012-12-06 17:00:00	SPY	ETF	142.02	142.04	141.7569	141.91	5796880.0
2012-12-06 18:00:00	SPY	ETF	141.91	142.06	141.89	142.03	76699.0
2012-12-06 19:00:00	SPY	ETF	142.05	142.12	142.03	142.08	59378.0
2012-12-06 05:00:00	QQQ	ETF	64.9	64.94	64.9	64.94	8300.0
2012-12-06 06:00:00	QQQ	ETF	64.86	64.86	64.86	64.86	100.0
2012-12-06 07:00:00	QQQ	ETF	64.86	64.87	64.8	64.87	89400.0
2012-12-06 08:00:00	QQQ	ETF	64.82	65.19	64.65	64.72	2957995.0
2012-12-06 09:00:00	QQQ	ETF	64.71	65.064	64.53	64.9	7565592.0
2012-12-06 10:00:00	QQQ	ETF	64.9	65.38	64.78	65.35	11056562.0
2012-12-06 11:00:00	QQQ	ETF	65.35	65.4801	65.23	65.38	4523720.0
2012-12-06 12:00:00	QQQ	ETF	65.38	65.43	65.11	65.145	3209808.0
2012-12-06 13:00:00	QQQ	ETF	65.14	65.4	65.08	65.385	2344590.0
2012-12-06 14:00:00	QQQ	ETF	65.4	65.41	65.16	65.22	2097323.0
2012-12-06 15:00:00	QQQ	ETF	65.21	65.39	65.07	65.31	4691421.0
2012-12-06 16:00:00	QQQ	ETF	65.31	65.3674	64.8779	65.32	2912451.0
2012-12-06 17:00:00	QQQ	ETF	65.32	65.34	64.8779	65.34	1018572.0
2012-12-06 18:00:00	QQQ	ETF	65.35	65.36	65.33	65.36	3492.0
2012-12-06 19:00:00	QQQ	ETF	65.35	65.37	65.34	65.37	6320.0
2012-12-06 07:00:00	IWM	ETF	82.03	82.03	81.92	81.97	20200.0
2012-12-06 08:00:00	IWM	ETF	81.88	82.1	81.77	81.84	113158.0
2012-12-06 09:00:00	IWM	ETF	81.85	82.2	81.71	81.8	5745210.0
2012-12-06 10:00:00	IWM	ETF	81.8	82.17	81.61	82.13	5899653.0
2012-12-06 11:00:00	IWM	ETF	82.13	82.31	82.05	82.17	2419650.0
2012-12-06 12:00:00	IWM	ETF	82.17	82.24	81.87	81.98	2442184.0
2012-12-06 13:00:00	IWM	ETF	81.98	82.15	81.95	82.14	1431179.0
2012-12-06 14:00:00	IWM	ETF	82.14	82.18	81.99	82.04	1732853.0
2012-12-06 15:00:00	IWM	ETF	82.04	82.13	81.87	82.1	4780458.0
2012-12-06 16:00:00	IWM	ETF	82.1	82.17	81.9782	82.15	838470.0
2012-12-06 17:00:00	IWM	ETF	82.15	82.16	82.1	82.13	7197.0
2012-12-06 18:00:00	IWM	ETF	82.12	82.12	82.12	82.12	500.0
2012-12-06 19:00:00	IWM	ETF	82.16	82.2	82.16	82.19	16452.0
2012-12-06 07:00:00	DIA	ETF	130.3	130.31	130.25	130.31	700.0
2012-12-06 08:00:00	DIA	ETF	130.25	130.33	130.08	130.19	13470.0
2012-12-06 09:00:00	DIA	ETF	130.18	130.63	130.14	130.31	711842.0
2012-12-06 10:00:00	DIA	ETF	130.31	130.63	130.09	130.53	576419.0
2012-12-06 11:00:00	DIA	ETF	130.56	130.69	130.43	130.44	386503.0
2012-12-06 12:00:00	DIA	ETF	130.45	130.506	130.23	130.255	378571.0

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

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