PREVIEW / etf_1hour / 2016-08-24

all etf 1-hour files

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

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-08-24 04:00:00	SPY	ETF	218.94	219.1	218.87	219.1	8416.0
2016-08-24 05:00:00	SPY	ETF	219.1	219.19	219.1	219.1	1523.0
2016-08-24 06:00:00	SPY	ETF	219.1	219.18	219.07	219.15	6795.0
2016-08-24 07:00:00	SPY	ETF	219.16	219.18	218.99	219.05	33781.0
2016-08-24 08:00:00	SPY	ETF	219.07	219.15	218.949	219.08	237676.0
2016-08-24 09:00:00	SPY	ETF	219.05	219.09	218.61	218.755	5332050.0
2016-08-24 10:00:00	SPY	ETF	218.75	218.85	218.29	218.47	8158533.0
2016-08-24 11:00:00	SPY	ETF	218.475	218.57	218.34	218.435	5350279.0
2016-08-24 12:00:00	SPY	ETF	218.44	218.77	218.41	218.72	8345664.0
2016-08-24 13:00:00	SPY	ETF	218.721	218.74	218.49	218.5	5062345.0
2016-08-24 14:00:00	SPY	ETF	218.5	218.51	218.05	218.225	7300938.0
2016-08-24 15:00:00	SPY	ETF	218.23	218.23	217.36	217.88	20267616.0
2016-08-24 16:00:00	SPY	ETF	217.89	218.97	217.75	217.95	7734451.0
2016-08-24 17:00:00	SPY	ETF	217.95	217.96	217.93	217.94	500454.0
2016-08-24 18:00:00	SPY	ETF	217.93	217.96	217.83	217.91	112295.0
2016-08-24 19:00:00	SPY	ETF	217.92	217.95	217.89	217.94	52661.0
2016-08-24 04:00:00	QQQ	ETF	117.55	117.6	117.48	117.6	1300.0
2016-08-24 05:00:00	QQQ	ETF	117.66	117.67	117.65	117.65	34900.0
2016-08-24 06:00:00	QQQ	ETF	117.65	117.65	117.65	117.65	4999.0
2016-08-24 07:00:00	QQQ	ETF	117.58	117.62	117.57	117.62	19414.0
2016-08-24 08:00:00	QQQ	ETF	117.62	117.66	117.59	117.62	21839.0
2016-08-24 09:00:00	QQQ	ETF	117.62	117.64	117.4101	117.53	1468036.0
2016-08-24 10:00:00	QQQ	ETF	117.53	117.6	117.27	117.35	1453234.0
2016-08-24 11:00:00	QQQ	ETF	117.35	117.4	117.23	117.295	850034.0
2016-08-24 12:00:00	QQQ	ETF	117.29	117.46	117.27	117.44	1103558.0
2016-08-24 13:00:00	QQQ	ETF	117.4348	117.46	117.26	117.27	1114337.0
2016-08-24 14:00:00	QQQ	ETF	117.26	117.27	116.86	117.03	2740669.0
2016-08-24 15:00:00	QQQ	ETF	117.03	117.0316	116.41	116.76	6605745.0
2016-08-24 16:00:00	QQQ	ETF	116.78	116.83	116.75	116.78	972153.0
2016-08-24 17:00:00	QQQ	ETF	116.81	116.81	116.75	116.75	750.0
2016-08-24 18:00:00	QQQ	ETF	116.75	116.81	116.74	116.81	11175.0
2016-08-24 19:00:00	QQQ	ETF	116.77	116.8	116.76	116.79	56059.0
2016-08-24 07:00:00	IWM	ETF	124.15	124.15	124.04	124.04	3100.0
2016-08-24 08:00:00	IWM	ETF	124.05	124.11	124.04	124.09	10829.0
2016-08-24 09:00:00	IWM	ETF	124.02	124.25	123.87	124.03	1240190.0
2016-08-24 10:00:00	IWM	ETF	124.02	124.12	123.72	123.99	2025206.0
2016-08-24 11:00:00	IWM	ETF	123.99	124.13	123.82	123.84	1715496.0
2016-08-24 12:00:00	IWM	ETF	123.83	124.08	123.8	124.07	1516471.0
2016-08-24 13:00:00	IWM	ETF	124.08	124.08	123.68	123.72	1281907.0
2016-08-24 14:00:00	IWM	ETF	123.72	123.735	123.15	123.29	3804960.0
2016-08-24 15:00:00	IWM	ETF	123.28	123.315	122.77	123.05	5520841.0
2016-08-24 16:00:00	IWM	ETF	123.05	124.0106	122.96	122.98	2184986.0
2016-08-24 17:00:00	IWM	ETF	123.01	123.01	122.97	122.97	1038.0
2016-08-24 19:00:00	IWM	ETF	123.05	123.05	123.05	123.05	1000.0
2016-08-24 09:00:00	DIA	ETF	185.13	185.17	184.931	185.03	234064.0
2016-08-24 10:00:00	DIA	ETF	185.059	185.1358	184.71	184.82	187480.0
2016-08-24 11:00:00	DIA	ETF	184.83	184.94	184.75	184.82	130353.0
2016-08-24 12:00:00	DIA	ETF	184.83	185.2	184.82	185.17	103041.0
2016-08-24 13:00:00	DIA	ETF	185.17	185.17	184.98	185.01	107975.0
2016-08-24 14:00:00	DIA	ETF	185.01	185.02	184.74	184.89	201199.0

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

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