PREVIEW / etf_1hour / 2016-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-05.parquet
  size:    249 KB
  rows:    8,027

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
2016-04-05 04:00:00	SPY	ETF	205.25	205.4	204.4	204.73	88467.0
2016-04-05 05:00:00	SPY	ETF	204.8	204.8	204.21	204.39	159456.0
2016-04-05 06:00:00	SPY	ETF	204.38	204.69	204.31	204.67	73037.0
2016-04-05 07:00:00	SPY	ETF	204.69	204.9	204.49	204.6	556254.0
2016-04-05 08:00:00	SPY	ETF	204.6	204.84	204.4	204.6	1157378.0
2016-04-05 09:00:00	SPY	ETF	204.58	205.0	204.16	204.6	14607567.0
2016-04-05 10:00:00	SPY	ETF	204.6	205.26	204.38	204.45	13400814.0
2016-04-05 11:00:00	SPY	ETF	204.45	206.2642	204.39	204.58	8358541.0
2016-04-05 12:00:00	SPY	ETF	204.585	204.8	204.2	204.3053	8064435.0
2016-04-05 13:00:00	SPY	ETF	204.31	204.74	204.11	204.54	7589116.0
2016-04-05 14:00:00	SPY	ETF	204.54	205.04	204.451	204.92	6564020.0
2016-04-05 15:00:00	SPY	ETF	204.93	204.97	203.89	204.19	24750108.0
2016-04-05 16:00:00	SPY	ETF	204.19	204.66	204.14	204.61	4565891.0
2016-04-05 17:00:00	SPY	ETF	204.63	205.04	204.4	204.63	8019228.0
2016-04-05 18:00:00	SPY	ETF	204.64	204.73	204.58	204.63	126473.0
2016-04-05 19:00:00	SPY	ETF	204.63	204.78	204.63	204.76	78021.0
2016-04-05 04:00:00	QQQ	ETF	109.43	109.43	109.0	109.11	3205.0
2016-04-05 05:00:00	QQQ	ETF	109.11	109.14	108.98	108.98	12449.0
2016-04-05 06:00:00	QQQ	ETF	109.05	109.21	109.04	109.15	1445.0
2016-04-05 07:00:00	QQQ	ETF	109.17	109.25	108.98	109.03	175086.0
2016-04-05 08:00:00	QQQ	ETF	109.05	109.25	108.95	109.06	137913.0
2016-04-05 09:00:00	QQQ	ETF	109.06	109.2101	108.77	109.01	2938734.0
2016-04-05 10:00:00	QQQ	ETF	109.01	109.5	109.006	109.15	3249555.0
2016-04-05 11:00:00	QQQ	ETF	109.1499	109.3801	108.94	109.0	1839856.0
2016-04-05 12:00:00	QQQ	ETF	109.0	109.14	108.74	108.87	1741716.0
2016-04-05 13:00:00	QQQ	ETF	108.87	109.27	108.76	109.14	1996144.0
2016-04-05 14:00:00	QQQ	ETF	109.14	109.41	109.041	109.33	1547665.0
2016-04-05 15:00:00	QQQ	ETF	109.34	109.365	108.74	108.9	3640754.0
2016-04-05 16:00:00	QQQ	ETF	108.92	109.8952	108.88	109.2	1467848.0
2016-04-05 17:00:00	QQQ	ETF	109.24	109.24	109.15	109.18	5670.0
2016-04-05 18:00:00	QQQ	ETF	109.18	109.21	109.18	109.2	1860.0
2016-04-05 19:00:00	QQQ	ETF	109.2	109.28	109.2	109.27	11605.0
2016-04-05 04:00:00	IWM	ETF	109.7	109.7	109.19	109.19	1964.0
2016-04-05 05:00:00	IWM	ETF	109.37	109.38	109.15	109.15	3559.0
2016-04-05 06:00:00	IWM	ETF	109.23	109.26	109.07	109.2	8000.0
2016-04-05 07:00:00	IWM	ETF	109.26	109.42	109.16	109.24	186297.0
2016-04-05 08:00:00	IWM	ETF	109.24	109.33	109.12	109.25	100325.0
2016-04-05 09:00:00	IWM	ETF	109.22	109.63	109.05	109.41	3665085.0
2016-04-05 10:00:00	IWM	ETF	109.41	109.855	109.4	109.42	4834305.0
2016-04-05 11:00:00	IWM	ETF	109.42	109.775	109.37	109.61	2438656.0
2016-04-05 12:00:00	IWM	ETF	109.6	109.71	109.08	109.09	3028083.0
2016-04-05 13:00:00	IWM	ETF	109.09	109.51	108.94	109.39	2476855.0
2016-04-05 14:00:00	IWM	ETF	109.38	109.62	109.25	109.55	2211689.0
2016-04-05 15:00:00	IWM	ETF	109.55	109.58	108.84	108.92	6163728.0
2016-04-05 16:00:00	IWM	ETF	108.93	110.1968	106.0185	109.15	1437226.0
2016-04-05 17:00:00	IWM	ETF	109.17	109.2	109.17	109.2	654.0
2016-04-05 18:00:00	IWM	ETF	109.05	109.05	109.05	109.05	190.0
2016-04-05 19:00:00	IWM	ETF	109.2	109.34	109.05	109.34	6052.0
2016-04-05 04:00:00	DIA	ETF	176.0	176.0	176.0	176.0	700.0
2016-04-05 06:00:00	DIA	ETF	175.93	175.93	175.93	175.93	100.0

> showing 50 of 8,027 rows — these rows as CSV

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