PREVIEW / etf_1hour / 2016-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-24.parquet
  size:    252 KB
  rows:    8,092

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-05-24 04:00:00	SPY	ETF	205.16	205.6	205.16	205.51	8644.0
2016-05-24 05:00:00	SPY	ETF	205.43	205.82	205.43	205.73	19804.0
2016-05-24 06:00:00	SPY	ETF	205.76	205.86	205.64	205.72	82805.0
2016-05-24 07:00:00	SPY	ETF	205.75	205.95	205.75	205.88	131682.0
2016-05-24 08:00:00	SPY	ETF	205.88	206.35	205.235	206.2	940050.0
2016-05-24 09:00:00	SPY	ETF	206.21	207.09	206.12	206.87	10915322.0
2016-05-24 10:00:00	SPY	ETF	206.88	207.71	206.8708	207.58	18521044.0
2016-05-24 11:00:00	SPY	ETF	207.585	207.835	207.49	207.8	11366688.0
2016-05-24 12:00:00	SPY	ETF	207.7999	207.89	207.61	207.89	5366390.0
2016-05-24 13:00:00	SPY	ETF	207.885	207.96	207.57	207.65	5729641.0
2016-05-24 14:00:00	SPY	ETF	207.66	207.92	207.55	207.7929	7053259.0
2016-05-24 15:00:00	SPY	ETF	207.79	208.24	207.78	207.85	20023346.0
2016-05-24 16:00:00	SPY	ETF	207.85	208.12	207.82	208.04	5539524.0
2016-05-24 17:00:00	SPY	ETF	208.03	208.06	207.87	208.05	223832.0
2016-05-24 18:00:00	SPY	ETF	208.05	208.15	207.9	208.14	89860.0
2016-05-24 19:00:00	SPY	ETF	208.15	208.44	208.15	208.36	213780.0
2016-05-24 04:00:00	QQQ	ETF	106.41	106.41	106.41	106.41	133.0
2016-05-24 05:00:00	QQQ	ETF	106.49	106.66	106.49	106.66	3900.0
2016-05-24 07:00:00	QQQ	ETF	106.69	106.75	106.63	106.73	11786.0
2016-05-24 08:00:00	QQQ	ETF	106.68	106.98	106.68	106.95	98852.0
2016-05-24 09:00:00	QQQ	ETF	106.93	107.565	106.87	107.44	4106546.0
2016-05-24 10:00:00	QQQ	ETF	107.45	108.09	107.45	108.05	4886328.0
2016-05-24 11:00:00	QQQ	ETF	108.055	108.29	108.01	108.28	2791826.0
2016-05-24 12:00:00	QQQ	ETF	108.28	108.32	108.155	108.32	1232280.0
2016-05-24 13:00:00	QQQ	ETF	108.32	108.38	108.22	108.315	1503056.0
2016-05-24 14:00:00	QQQ	ETF	108.31	108.47	108.27	108.39	2117981.0
2016-05-24 15:00:00	QQQ	ETF	108.38	108.59	108.36	108.45	5029169.0
2016-05-24 16:00:00	QQQ	ETF	108.45	108.57	108.44	108.52	1116275.0
2016-05-24 17:00:00	QQQ	ETF	108.53	108.53	108.49	108.5	1276.0
2016-05-24 18:00:00	QQQ	ETF	108.52	108.6	108.47	108.6	12482.0
2016-05-24 19:00:00	QQQ	ETF	108.63	108.76	108.63	108.7	36503.0
2016-05-24 06:00:00	IWM	ETF	110.98	110.99	110.97	110.97	6700.0
2016-05-24 07:00:00	IWM	ETF	110.95	111.09	110.95	111.07	20050.0
2016-05-24 08:00:00	IWM	ETF	111.07	111.37	111.07	111.29	124266.0
2016-05-24 09:00:00	IWM	ETF	111.29	111.98	111.21	111.83	3289657.0
2016-05-24 10:00:00	IWM	ETF	111.84	112.6001	111.84	112.6	4827501.0
2016-05-24 11:00:00	IWM	ETF	112.6	112.83	112.47	112.78	5115213.0
2016-05-24 12:00:00	IWM	ETF	112.78	112.98	112.61	112.975	3022602.0
2016-05-24 13:00:00	IWM	ETF	112.98	113.08	112.78	112.91	2316605.0
2016-05-24 14:00:00	IWM	ETF	112.91	113.01	112.78	112.925	1880144.0
2016-05-24 15:00:00	IWM	ETF	112.92	113.22	112.92	112.95	5968338.0
2016-05-24 16:00:00	IWM	ETF	112.95	113.13	112.91	113.03	1919104.0
2016-05-24 17:00:00	IWM	ETF	113.08	113.08	113.05	113.05	800.0
2016-05-24 18:00:00	IWM	ETF	113.03	113.05	113.03	113.05	4919.0
2016-05-24 19:00:00	IWM	ETF	113.08	113.2	113.08	113.13	4500.0
2016-05-24 07:00:00	DIA	ETF	175.48	175.48	175.48	175.48	100.0
2016-05-24 08:00:00	DIA	ETF	175.49	175.8	175.49	175.8	5150.0
2016-05-24 09:00:00	DIA	ETF	175.79	176.57	175.65	176.3799	557939.0
2016-05-24 10:00:00	DIA	ETF	176.38	176.95	176.38	176.78	548947.0
2016-05-24 11:00:00	DIA	ETF	176.78	176.9264	176.64	176.88	305813.0

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

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