PREVIEW / etf_1hour / 2016-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-30.parquet
  size:    249 KB
  rows:    8,029

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-30 04:00:00	SPY	ETF	218.33	218.48	218.32	218.45	4657.0
2016-08-30 05:00:00	SPY	ETF	218.38	218.38	218.26	218.26	21814.0
2016-08-30 06:00:00	SPY	ETF	218.26	218.35	218.12	218.35	54737.0
2016-08-30 07:00:00	SPY	ETF	218.33	218.35	218.27	218.3	28313.0
2016-08-30 08:00:00	SPY	ETF	218.28	218.39	218.22	218.25	231319.0
2016-08-30 09:00:00	SPY	ETF	218.3	218.59	218.19	218.32	5549398.0
2016-08-30 10:00:00	SPY	ETF	218.33	218.45	217.61	217.82	12210969.0
2016-08-30 11:00:00	SPY	ETF	217.83	218.02	217.7	217.92	5576989.0
2016-08-30 12:00:00	SPY	ETF	217.92	218.1	217.85	217.8737	4858431.0
2016-08-30 13:00:00	SPY	ETF	217.87	217.96	217.66	217.74	3723391.0
2016-08-30 14:00:00	SPY	ETF	217.74	217.74	217.35	217.63	7757193.0
2016-08-30 15:00:00	SPY	ETF	217.635	217.98	217.515	217.97	12006294.0
2016-08-30 16:00:00	SPY	ETF	217.97	218.1	217.9	218.02	4713190.0
2016-08-30 17:00:00	SPY	ETF	218.0	218.04	217.99	218.04	125624.0
2016-08-30 18:00:00	SPY	ETF	218.05	218.05	217.97	217.99	499553.0
2016-08-30 19:00:00	SPY	ETF	217.99	218.0	217.89	217.91	18471.0
2016-08-30 04:00:00	QQQ	ETF	116.93	116.97	116.93	116.97	200.0
2016-08-30 05:00:00	QQQ	ETF	116.8	116.8	116.79	116.79	2483.0
2016-08-30 06:00:00	QQQ	ETF	116.69	116.69	116.65	116.67	5798.0
2016-08-30 07:00:00	QQQ	ETF	116.73	116.76	116.72	116.76	19850.0
2016-08-30 08:00:00	QQQ	ETF	116.74	116.81	116.68	116.71	102569.0
2016-08-30 09:00:00	QQQ	ETF	116.73	117.09	116.72	116.97	1968006.0
2016-08-30 10:00:00	QQQ	ETF	116.98	117.06	116.32	116.49	2904467.0
2016-08-30 11:00:00	QQQ	ETF	116.48	116.66	116.39	116.4601	1664278.0
2016-08-30 12:00:00	QQQ	ETF	116.46	116.62	116.458	116.49	924507.0
2016-08-30 13:00:00	QQQ	ETF	116.49	116.53	116.33	116.4	741184.0
2016-08-30 14:00:00	QQQ	ETF	116.4	116.4	116.16	116.32	2969386.0
2016-08-30 15:00:00	QQQ	ETF	116.33	116.57	116.27	116.57	4629034.0
2016-08-30 16:00:00	QQQ	ETF	116.56	116.63	116.49	116.6	1664428.0
2016-08-30 17:00:00	QQQ	ETF	116.56	116.56	116.56	116.56	129.0
2016-08-30 18:00:00	QQQ	ETF	116.56	116.56	116.5	116.55	3394.0
2016-08-30 19:00:00	QQQ	ETF	116.5	116.52	116.5	116.52	2100.0
2016-08-30 06:00:00	IWM	ETF	123.81	123.81	123.81	123.81	2000.0
2016-08-30 07:00:00	IWM	ETF	123.85	123.85	123.8	123.8	2500.0
2016-08-30 08:00:00	IWM	ETF	123.86	123.87	123.78	123.81	60638.0
2016-08-30 09:00:00	IWM	ETF	123.85	124.14	123.8101	124.07	1470960.0
2016-08-30 10:00:00	IWM	ETF	124.09	124.17	123.69	123.825	2267512.0
2016-08-30 11:00:00	IWM	ETF	123.82	124.02	123.78	123.99	1273687.0
2016-08-30 12:00:00	IWM	ETF	123.99	124.15	123.86	123.86	935219.0
2016-08-30 13:00:00	IWM	ETF	123.86	123.915	123.62	123.69	1122240.0
2016-08-30 14:00:00	IWM	ETF	123.69	123.69	123.38	123.62	1617192.0
2016-08-30 15:00:00	IWM	ETF	123.62	123.94	123.52	123.93	2765666.0
2016-08-30 16:00:00	IWM	ETF	123.95	124.05	123.88	124.01	899270.0
2016-08-30 17:00:00	IWM	ETF	123.99	123.99	123.93	123.93	458.0
2016-08-30 18:00:00	IWM	ETF	124.05	124.05	124.05	124.05	100.0
2016-08-30 19:00:00	IWM	ETF	124.0	124.0	124.0	124.0	1000.0
2016-08-30 08:00:00	DIA	ETF	184.83	184.83	184.83	184.83	100.0
2016-08-30 09:00:00	DIA	ETF	184.93	185.15	184.76	184.79	236762.0
2016-08-30 10:00:00	DIA	ETF	184.79	184.88	184.21	184.4	460074.0
2016-08-30 11:00:00	DIA	ETF	184.38	184.54	184.28	184.41	186877.0

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

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