PREVIEW / etf_1hour / 2015-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-23.parquet
  size:    240 KB
  rows:    7,691

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
2015-03-23 04:00:00	SPY	ETF	210.47	210.47	209.79	209.79	2307.0
2015-03-23 05:00:00	SPY	ETF	209.9	210.12	209.85	209.87	9174.0
2015-03-23 06:00:00	SPY	ETF	209.86	209.91	209.74	209.85	91160.0
2015-03-23 07:00:00	SPY	ETF	209.86	210.29	209.84	210.29	191830.0
2015-03-23 08:00:00	SPY	ETF	210.04	210.49	209.9	210.26	436140.0
2015-03-23 09:00:00	SPY	ETF	210.26	210.98	210.24	210.75	8479035.0
2015-03-23 10:00:00	SPY	ETF	210.75	211.11	210.67	210.81	8601981.0
2015-03-23 11:00:00	SPY	ETF	210.81	210.91	210.55	210.74	8560521.0
2015-03-23 12:00:00	SPY	ETF	210.73	210.89	210.5	210.71	4729234.0
2015-03-23 13:00:00	SPY	ETF	210.7055	210.79	210.55	210.65	4366610.0
2015-03-23 14:00:00	SPY	ETF	210.65	210.98	210.62	210.72	5160257.0
2015-03-23 15:00:00	SPY	ETF	210.725	210.78	210.01	210.04	14418880.0
2015-03-23 16:00:00	SPY	ETF	210.04	210.703	209.805	209.89	9491445.0
2015-03-23 17:00:00	SPY	ETF	209.89	209.89	209.79	209.82	100343.0
2015-03-23 18:00:00	SPY	ETF	209.82	209.93	209.82	209.93	72719.0
2015-03-23 19:00:00	SPY	ETF	209.93	209.98	209.91	209.98	64325.0
2015-03-23 04:00:00	QQQ	ETF	108.47	108.48	108.36	108.45	3000.0
2015-03-23 05:00:00	QQQ	ETF	108.45	108.49	108.45	108.49	200.0
2015-03-23 06:00:00	QQQ	ETF	108.39	108.39	108.31	108.31	400.0
2015-03-23 07:00:00	QQQ	ETF	108.3	108.52	108.3	108.52	59300.0
2015-03-23 08:00:00	QQQ	ETF	108.48	108.53	108.38	108.47	164822.0
2015-03-23 09:00:00	QQQ	ETF	108.45	108.64	108.32	108.43	2847585.0
2015-03-23 10:00:00	QQQ	ETF	108.43	108.75	108.39	108.57	1989891.0
2015-03-23 11:00:00	QQQ	ETF	108.57	108.64	108.41	108.57	1454440.0
2015-03-23 12:00:00	QQQ	ETF	108.57	108.63	108.46	108.5372	1265691.0
2015-03-23 13:00:00	QQQ	ETF	108.54	108.63	108.48	108.58	759992.0
2015-03-23 14:00:00	QQQ	ETF	108.57	108.77	108.55	108.62	1001303.0
2015-03-23 15:00:00	QQQ	ETF	108.62	108.657	108.28	108.29	3454559.0
2015-03-23 16:00:00	QQQ	ETF	108.3	108.32	108.2	108.24	1403778.0
2015-03-23 17:00:00	QQQ	ETF	108.23	108.23	108.22	108.22	6567.0
2015-03-23 18:00:00	QQQ	ETF	108.23	108.29	108.22	108.29	14089.0
2015-03-23 19:00:00	QQQ	ETF	108.29	108.3	108.27	108.3	14154.0
2015-03-23 06:00:00	IWM	ETF	125.65	125.65	125.65	125.65	200.0
2015-03-23 07:00:00	IWM	ETF	125.65	125.65	125.65	125.65	200.0
2015-03-23 08:00:00	IWM	ETF	125.9	125.92	125.75	125.82	91396.0
2015-03-23 09:00:00	IWM	ETF	125.86	126.13	125.77	125.8204	2097782.0
2015-03-23 10:00:00	IWM	ETF	125.83	126.09	125.83	125.97	2089989.0
2015-03-23 11:00:00	IWM	ETF	125.98	126.1	125.91	126.04	1425729.0
2015-03-23 12:00:00	IWM	ETF	126.03	126.31	126.0	126.13	1404688.0
2015-03-23 13:00:00	IWM	ETF	126.125	126.23	126.065	126.18	1251824.0
2015-03-23 14:00:00	IWM	ETF	126.17	126.32	126.105	126.15	1658422.0
2015-03-23 15:00:00	IWM	ETF	126.15	126.19	125.87	125.8749	3306702.0
2015-03-23 16:00:00	IWM	ETF	125.875	126.0836	125.74	125.86	1804497.0
2015-03-23 17:00:00	IWM	ETF	125.83	125.85	125.79	125.83	7160.0
2015-03-23 18:00:00	IWM	ETF	125.8	125.8	125.8	125.8	500.0
2015-03-23 19:00:00	IWM	ETF	125.85	125.85	125.81	125.81	2200.0
2015-03-23 09:00:00	DIA	ETF	180.94	181.64	180.93	181.43	996473.0
2015-03-23 10:00:00	DIA	ETF	181.43	181.7	181.24	181.42	630308.0
2015-03-23 11:00:00	DIA	ETF	181.43	181.57	181.28	181.48	306097.0
2015-03-23 12:00:00	DIA	ETF	181.45	181.64	181.19	181.52	188076.0

> showing 50 of 7,691 rows — these rows as CSV

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