PREVIEW / etf_1hour / 2016-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-15.parquet
  size:    245 KB
  rows:    7,892

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-15 04:00:00	SPY	ETF	207.84	207.84	207.67	207.75	9430.0
2016-04-15 05:00:00	SPY	ETF	207.77	207.89	207.74	207.85	5170.0
2016-04-15 06:00:00	SPY	ETF	207.85	207.85	207.63	207.72	143711.0
2016-04-15 07:00:00	SPY	ETF	207.71	207.81	207.59	207.66	308982.0
2016-04-15 08:00:00	SPY	ETF	207.62	208.16	207.58	207.8	623025.0
2016-04-15 09:00:00	SPY	ETF	207.8	208.11	207.68	207.92	12626198.0
2016-04-15 10:00:00	SPY	ETF	207.93	208.1721	207.58	207.865	13243455.0
2016-04-15 11:00:00	SPY	ETF	207.86	208.09	207.8208	207.93	5776100.0
2016-04-15 12:00:00	SPY	ETF	207.93	208.0	207.72	207.73	5928460.0
2016-04-15 13:00:00	SPY	ETF	207.73	207.79	207.43	207.56	7258922.0
2016-04-15 14:00:00	SPY	ETF	207.56	207.89	207.4	207.88	6818053.0
2016-04-15 15:00:00	SPY	ETF	207.8785	207.95	207.66	207.81	14344136.0
2016-04-15 16:00:00	SPY	ETF	207.8	208.09	207.71	207.95	4504031.0
2016-04-15 17:00:00	SPY	ETF	207.95	207.97	207.91	207.93	234371.0
2016-04-15 18:00:00	SPY	ETF	207.93	207.93	207.89	207.9	22776.0
2016-04-15 19:00:00	SPY	ETF	207.89	207.92	207.89	207.89	28486.0
2016-04-15 05:00:00	QQQ	ETF	110.8	110.8	110.8	110.8	200.0
2016-04-15 06:00:00	QQQ	ETF	110.73	110.73	110.66	110.71	2401.0
2016-04-15 07:00:00	QQQ	ETF	110.66	110.73	110.65	110.66	12556.0
2016-04-15 08:00:00	QQQ	ETF	110.65	110.75	110.64	110.71	19448.0
2016-04-15 09:00:00	QQQ	ETF	110.73	110.95	110.61	110.81	2299982.0
2016-04-15 10:00:00	QQQ	ETF	110.81	111.0	110.61	110.9	2686432.0
2016-04-15 11:00:00	QQQ	ETF	110.9	111.055	110.87	110.88	1946463.0
2016-04-15 12:00:00	QQQ	ETF	110.88	110.95	110.79	110.79	1209725.0
2016-04-15 13:00:00	QQQ	ETF	110.785	110.815	110.37	110.5275	2816696.0
2016-04-15 14:00:00	QQQ	ETF	110.52	110.72	110.36	110.72	1803764.0
2016-04-15 15:00:00	QQQ	ETF	110.712	110.77	110.59	110.64	4021737.0
2016-04-15 16:00:00	QQQ	ETF	110.66	110.76	110.6	110.71	641422.0
2016-04-15 17:00:00	QQQ	ETF	110.73	110.73	110.65	110.7	530257.0
2016-04-15 18:00:00	QQQ	ETF	110.64	110.65	110.64	110.65	1253.0
2016-04-15 19:00:00	QQQ	ETF	110.62	110.64	110.62	110.64	2257.0
2016-04-15 04:00:00	IWM	ETF	111.92	111.92	111.89	111.89	200.0
2016-04-15 06:00:00	IWM	ETF	111.81	111.89	111.81	111.89	3100.0
2016-04-15 07:00:00	IWM	ETF	111.87	111.89	111.78	111.78	16154.0
2016-04-15 08:00:00	IWM	ETF	111.83	111.9	111.79	111.86	26044.0
2016-04-15 09:00:00	IWM	ETF	111.92	112.1	111.81	112.07	1601171.0
2016-04-15 10:00:00	IWM	ETF	112.07	112.44	111.9	112.245	2856884.0
2016-04-15 11:00:00	IWM	ETF	112.245	112.56	112.23	112.46	2024436.0
2016-04-15 12:00:00	IWM	ETF	112.47	112.485	112.29	112.3	1608276.0
2016-04-15 13:00:00	IWM	ETF	112.3	112.36	112.095	112.3	1653431.0
2016-04-15 14:00:00	IWM	ETF	112.29	112.51	112.24	112.49	1645085.0
2016-04-15 15:00:00	IWM	ETF	112.49	112.63	112.3	112.46	5311079.0
2016-04-15 16:00:00	IWM	ETF	112.46	112.56	112.3503	112.45	1526417.0
2016-04-15 17:00:00	IWM	ETF	112.45	112.49	112.41	112.49	831361.0
2016-04-15 18:00:00	IWM	ETF	112.45	112.45	112.45	112.45	300.0
2016-04-15 19:00:00	IWM	ETF	112.45	112.45	112.45	112.45	200.0
2016-04-15 07:00:00	DIA	ETF	178.8	178.8	178.63	178.63	1821.0
2016-04-15 08:00:00	DIA	ETF	178.93	178.93	178.8	178.8	1500.0
2016-04-15 09:00:00	DIA	ETF	178.95	179.14	178.91	179.0	406554.0
2016-04-15 10:00:00	DIA	ETF	178.99	179.06	178.69	178.95	615435.0

> showing 50 of 7,892 rows — these rows as CSV

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