PREVIEW / etf_1hour / 2012-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-17.parquet
  size:    178 KB
  rows:    5,516

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-08-17 04:00:00	SPY	ETF	141.99	141.99	141.8	141.8	345.0
2012-08-17 05:00:00	SPY	ETF	141.89	141.92	141.89	141.91	1600.0
2012-08-17 06:00:00	SPY	ETF	141.87	141.88	141.74	141.77	28130.0
2012-08-17 07:00:00	SPY	ETF	141.78	141.88	141.72	141.77	143615.0
2012-08-17 08:00:00	SPY	ETF	141.77	141.88	141.73	141.86	500239.0
2012-08-17 09:00:00	SPY	ETF	141.86	142.26	141.83	142.13	14903216.0
2012-08-17 10:00:00	SPY	ETF	142.13	142.15	141.86	141.96	14928969.0
2012-08-17 11:00:00	SPY	ETF	141.96	142.15	141.87	142.12	9540124.0
2012-08-17 12:00:00	SPY	ETF	142.12	142.13	141.9	141.95	8890583.0
2012-08-17 13:00:00	SPY	ETF	141.95	142.055	141.93	142.0	5687243.0
2012-08-17 14:00:00	SPY	ETF	142.0	142.14	141.95	142.12	9194710.0
2012-08-17 15:00:00	SPY	ETF	142.12	142.3	141.96	142.19	16231046.0
2012-08-17 16:00:00	SPY	ETF	142.18	142.29	141.994	142.12	8272596.0
2012-08-17 17:00:00	SPY	ETF	142.12	142.13	142.11	142.13	101819.0
2012-08-17 18:00:00	SPY	ETF	142.13	142.13	142.1	142.12	10362.0
2012-08-17 19:00:00	SPY	ETF	142.12	142.13	142.07	142.13	18467.0
2012-08-17 04:00:00	QQQ	ETF	68.07	68.07	68.07	68.07	1000.0
2012-08-17 05:00:00	QQQ	ETF	68.09	68.09	68.09	68.09	400.0
2012-08-17 06:00:00	QQQ	ETF	68.06	68.07	68.0	68.0	7100.0
2012-08-17 07:00:00	QQQ	ETF	68.0	68.02	68.0	68.02	2800.0
2012-08-17 08:00:00	QQQ	ETF	67.99	68.08	67.99	68.06	398753.0
2012-08-17 09:00:00	QQQ	ETF	68.06	68.23	68.02	68.21	3620079.0
2012-08-17 10:00:00	QQQ	ETF	68.21	68.25	68.02	68.12	3867443.0
2012-08-17 11:00:00	QQQ	ETF	68.11	68.24	68.01	68.23	2492179.0
2012-08-17 12:00:00	QQQ	ETF	68.239	68.26	68.11	68.14	2819803.0
2012-08-17 13:00:00	QQQ	ETF	68.1401	68.23	68.14	68.1689	2137888.0
2012-08-17 14:00:00	QQQ	ETF	68.165	68.25	68.13	68.23	1765556.0
2012-08-17 15:00:00	QQQ	ETF	68.24	68.33	68.171	68.3099	4287962.0
2012-08-17 16:00:00	QQQ	ETF	68.31	68.33	68.2	68.21	745640.0
2012-08-17 17:00:00	QQQ	ETF	68.25	68.25	68.22	68.22	10098.0
2012-08-17 18:00:00	QQQ	ETF	68.25	68.25	68.25	68.25	350.0
2012-08-17 19:00:00	QQQ	ETF	68.24	68.25	68.22	68.25	10533.0
2012-08-17 07:00:00	IWM	ETF	80.93	81.04	80.93	80.98	41103.0
2012-08-17 08:00:00	IWM	ETF	81.0	81.05	80.96	81.05	93000.0
2012-08-17 09:00:00	IWM	ETF	81.06	81.335	80.99	81.31	3519738.0
2012-08-17 10:00:00	IWM	ETF	81.31	81.36	81.11	81.25	3344119.0
2012-08-17 11:00:00	IWM	ETF	81.26	81.5	81.1901	81.47	4215434.0
2012-08-17 12:00:00	IWM	ETF	81.47	81.49	81.38	81.428	2311503.0
2012-08-17 13:00:00	IWM	ETF	81.43	81.64	81.41	81.56	1859885.0
2012-08-17 14:00:00	IWM	ETF	81.55	81.79	81.48	81.78	2853932.0
2012-08-17 15:00:00	IWM	ETF	81.79	81.86	81.56	81.73	6754615.0
2012-08-17 16:00:00	IWM	ETF	81.73	81.85	81.6	81.66	2593458.0
2012-08-17 17:00:00	IWM	ETF	81.7	81.7	81.7	81.7	2500.0
2012-08-17 18:00:00	IWM	ETF	81.7	81.71	81.7	81.71	2059.0
2012-08-17 19:00:00	IWM	ETF	81.71	81.72	81.71	81.72	280.0
2012-08-17 06:00:00	DIA	ETF	132.25	132.25	132.25	132.25	1000.0
2012-08-17 07:00:00	DIA	ETF	132.18	132.18	132.18	132.18	100.0
2012-08-17 08:00:00	DIA	ETF	132.1	132.2	132.1	132.19	8070.0
2012-08-17 09:00:00	DIA	ETF	132.22	132.49	132.15	132.37	746460.0
2012-08-17 10:00:00	DIA	ETF	132.41	132.43	132.19	132.26	622877.0

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

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