PREVIEW / etf_1hour / 2017-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-15.parquet
  size:    281 KB
  rows:    9,067

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
2017-02-15 04:00:00	SPY	ETF	233.9	233.9	233.78	233.78	1300.0
2017-02-15 05:00:00	SPY	ETF	233.83	233.83	233.64	233.64	9451.0
2017-02-15 06:00:00	SPY	ETF	233.69	233.77	233.67	233.7	5420.0
2017-02-15 07:00:00	SPY	ETF	233.74	233.85	233.7	233.75	49452.0
2017-02-15 08:00:00	SPY	ETF	233.71	233.79	233.35	233.4	804979.0
2017-02-15 09:00:00	SPY	ETF	233.4	233.79	233.32	233.765	6881478.0
2017-02-15 10:00:00	SPY	ETF	233.76	234.14	233.53	234.13	12496044.0
2017-02-15 11:00:00	SPY	ETF	234.12	234.46	233.9034	234.11	9821641.0
2017-02-15 12:00:00	SPY	ETF	234.11	234.39	233.99	234.29	6739483.0
2017-02-15 13:00:00	SPY	ETF	234.29	234.74	234.14	234.5665	7923024.0
2017-02-15 14:00:00	SPY	ETF	234.5608	234.82	234.5	234.805	7974522.0
2017-02-15 15:00:00	SPY	ETF	234.8098	235.14	234.72	234.87	20768901.0
2017-02-15 16:00:00	SPY	ETF	234.87	235.3	234.86	235.21	11019435.0
2017-02-15 17:00:00	SPY	ETF	235.19	235.26	234.92	235.23	513699.0
2017-02-15 18:00:00	SPY	ETF	235.22	235.24	235.11	235.15	174438.0
2017-02-15 19:00:00	SPY	ETF	235.16	235.16	235.0	235.01	156005.0
2017-02-15 04:00:00	QQQ	ETF	128.69	128.69	128.62	128.62	300.0
2017-02-15 05:00:00	QQQ	ETF	128.62	128.62	128.54	128.54	4200.0
2017-02-15 06:00:00	QQQ	ETF	128.55	128.64	128.55	128.57	17003.0
2017-02-15 07:00:00	QQQ	ETF	128.6	128.65	128.57	128.57	20779.0
2017-02-15 08:00:00	QQQ	ETF	128.66	128.66	128.36	128.41	302668.0
2017-02-15 09:00:00	QQQ	ETF	128.4	128.67	128.37	128.659	1589443.0
2017-02-15 10:00:00	QQQ	ETF	128.65	128.77	128.505	128.7465	2210562.0
2017-02-15 11:00:00	QQQ	ETF	128.73	128.98	128.68	128.81	2339603.0
2017-02-15 12:00:00	QQQ	ETF	128.815	128.95	128.74	128.9	999413.0
2017-02-15 13:00:00	QQQ	ETF	128.9	129.1	128.8	129.02	1265886.0
2017-02-15 14:00:00	QQQ	ETF	129.02	129.185	128.971	129.17	1266070.0
2017-02-15 15:00:00	QQQ	ETF	129.18	129.35	129.145	129.29	3475689.0
2017-02-15 16:00:00	QQQ	ETF	129.27	129.53	129.27	129.52	669211.0
2017-02-15 17:00:00	QQQ	ETF	129.49	129.51	129.46	129.46	30832.0
2017-02-15 18:00:00	QQQ	ETF	129.49	129.49	129.37	129.41	20927.0
2017-02-15 19:00:00	QQQ	ETF	129.42	129.44	129.2911	129.42	108830.0
2017-02-15 04:00:00	IWM	ETF	138.95	138.95	138.73	138.73	2560.0
2017-02-15 05:00:00	IWM	ETF	138.74	138.74	138.61	138.61	460.0
2017-02-15 06:00:00	IWM	ETF	138.62	138.62	138.57	138.57	568.0
2017-02-15 07:00:00	IWM	ETF	138.68	138.8	138.65	138.65	19080.0
2017-02-15 08:00:00	IWM	ETF	138.65	138.65	138.05	138.11	140760.0
2017-02-15 09:00:00	IWM	ETF	138.13	139.0	137.92	138.91	1835292.0
2017-02-15 10:00:00	IWM	ETF	138.92	138.92	138.55	138.745	1847867.0
2017-02-15 11:00:00	IWM	ETF	138.74	139.05	138.42	138.61	2283309.0
2017-02-15 12:00:00	IWM	ETF	138.6	139.01	138.525	138.875	1281142.0
2017-02-15 13:00:00	IWM	ETF	138.89	139.39	138.76	139.26	1705387.0
2017-02-15 14:00:00	IWM	ETF	139.27	139.6	139.138	139.585	2262515.0
2017-02-15 15:00:00	IWM	ETF	139.58	139.77	139.45	139.58	3925210.0
2017-02-15 16:00:00	IWM	ETF	139.59	139.87	138.772	139.67	1027225.0
2017-02-15 17:00:00	IWM	ETF	139.71	139.75	139.71	139.75	11600.0
2017-02-15 18:00:00	IWM	ETF	139.66	139.74	139.66	139.74	1669.0
2017-02-15 19:00:00	IWM	ETF	139.74	139.74	139.5785	139.69	144106.0
2017-02-15 04:00:00	DIA	ETF	205.6	205.6	205.6	205.6	100.0
2017-02-15 07:00:00	DIA	ETF	205.6	205.6	205.48	205.48	3606.0

> showing 50 of 9,067 rows — these rows as CSV

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