PREVIEW / etf_1hour / 2016-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-30.parquet
  size:    264 KB
  rows:    8,441

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-06-30 04:00:00	SPY	ETF	207.28	207.5	207.04	207.26	23148.0
2016-06-30 05:00:00	SPY	ETF	207.33	207.74	207.12	207.68	26023.0
2016-06-30 06:00:00	SPY	ETF	207.7	207.82	207.5	207.51	198049.0
2016-06-30 07:00:00	SPY	ETF	207.56	207.56	206.95	206.99	592414.0
2016-06-30 08:00:00	SPY	ETF	207.0	207.53	206.74	207.22	1161983.0
2016-06-30 09:00:00	SPY	ETF	207.24	207.34	206.56	206.67	12725319.0
2016-06-30 10:00:00	SPY	ETF	206.675	207.67	206.56	207.65	15823630.0
2016-06-30 11:00:00	SPY	ETF	207.65	208.21	207.48	208.03	16398051.0
2016-06-30 12:00:00	SPY	ETF	208.03	208.92	207.98	208.8499	19522014.0
2016-06-30 13:00:00	SPY	ETF	208.85	208.96	208.54	208.79	13355070.0
2016-06-30 14:00:00	SPY	ETF	208.79	209.3	208.735	209.2	19612072.0
2016-06-30 15:00:00	SPY	ETF	209.2	209.54	208.8	209.5	37717077.0
2016-06-30 16:00:00	SPY	ETF	209.5	209.57	209.03	209.1	19047558.0
2016-06-30 17:00:00	SPY	ETF	209.1	209.475	209.1	209.13	1892741.0
2016-06-30 18:00:00	SPY	ETF	209.15	209.475	209.01	209.07	1236100.0
2016-06-30 19:00:00	SPY	ETF	209.03	209.1	208.95	209.03	135693.0
2016-06-30 04:00:00	QQQ	ETF	106.5	106.65	106.5	106.51	2982.0
2016-06-30 05:00:00	QQQ	ETF	106.55	106.65	106.55	106.65	2100.0
2016-06-30 06:00:00	QQQ	ETF	106.7	106.74	106.62	106.62	8406.0
2016-06-30 07:00:00	QQQ	ETF	106.59	106.66	106.38	106.38	125831.0
2016-06-30 08:00:00	QQQ	ETF	106.36	106.48	106.19	106.46	253211.0
2016-06-30 09:00:00	QQQ	ETF	106.45	106.66	106.18	106.25	4176644.0
2016-06-30 10:00:00	QQQ	ETF	106.25	106.73	106.13	106.72	4748360.0
2016-06-30 11:00:00	QQQ	ETF	106.72	107.14	106.61	106.99	4766249.0
2016-06-30 12:00:00	QQQ	ETF	106.99	107.335	106.92	107.28	4113938.0
2016-06-30 13:00:00	QQQ	ETF	107.29	107.34	107.08	107.23	1793123.0
2016-06-30 14:00:00	QQQ	ETF	107.24	107.49	107.21	107.45	4055458.0
2016-06-30 15:00:00	QQQ	ETF	107.46	107.6	107.27	107.6	5354623.0
2016-06-30 16:00:00	QQQ	ETF	107.61	107.61	106.2921	107.4	4103225.0
2016-06-30 17:00:00	QQQ	ETF	107.35	107.54	107.35	107.42	373006.0
2016-06-30 18:00:00	QQQ	ETF	107.39	107.54	107.3	107.3	122687.0
2016-06-30 19:00:00	QQQ	ETF	107.3	107.31	107.27	107.29	21957.0
2016-06-30 05:00:00	IWM	ETF	113.13	113.33	113.13	113.33	5800.0
2016-06-30 06:00:00	IWM	ETF	113.3	113.4	113.22	113.26	13080.0
2016-06-30 07:00:00	IWM	ETF	113.32	113.32	112.96	112.96	130048.0
2016-06-30 08:00:00	IWM	ETF	113.0	113.11	112.81	113.11	253369.0
2016-06-30 09:00:00	IWM	ETF	113.11	113.38	112.57	112.8	3849707.0
2016-06-30 10:00:00	IWM	ETF	112.8	113.5399	112.64	113.5	3533333.0
2016-06-30 11:00:00	IWM	ETF	113.5	113.82	113.38	113.61	3444207.0
2016-06-30 12:00:00	IWM	ETF	113.61	114.23	113.49	114.12	4006377.0
2016-06-30 13:00:00	IWM	ETF	114.12	114.2	113.78	113.99	2389055.0
2016-06-30 14:00:00	IWM	ETF	113.99	114.42	113.98	114.354	3314090.0
2016-06-30 15:00:00	IWM	ETF	114.36	115.02	114.06	115.01	9536921.0
2016-06-30 16:00:00	IWM	ETF	115.01	115.05	114.076	114.98	4644321.0
2016-06-30 17:00:00	IWM	ETF	114.98	115.02	114.85	114.88	746447.0
2016-06-30 18:00:00	IWM	ETF	114.81	114.88	114.81	114.88	3700.0
2016-06-30 19:00:00	IWM	ETF	114.85	114.85	114.84	114.85	1500.0
2016-06-30 07:00:00	DIA	ETF	177.05	177.05	177.0	177.0	600.0
2016-06-30 08:00:00	DIA	ETF	176.95	177.0	176.8	177.0	1865.0
2016-06-30 09:00:00	DIA	ETF	177.02	177.26	176.89	176.96	692649.0

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

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