PREVIEW / etf_30min / 2017-03-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-20.parquet
  size:    419 KB
  rows:    14,274

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-03-20 04:00:00	SPY	ETF	237.06	237.06	236.94	236.99	546.0
2017-03-20 04:30:00	SPY	ETF	237.07	237.07	236.88	236.88	1724.0
2017-03-20 05:00:00	SPY	ETF	236.91	236.92	236.91	236.92	2799.0
2017-03-20 05:30:00	SPY	ETF	236.86	236.86	236.78	236.78	8000.0
2017-03-20 06:00:00	SPY	ETF	236.87	236.87	236.83	236.85	2502.0
2017-03-20 06:30:00	SPY	ETF	236.85	236.97	236.82	236.97	122106.0
2017-03-20 07:00:00	SPY	ETF	236.95	237.1	236.94	237.03	57508.0
2017-03-20 07:30:00	SPY	ETF	237.04	237.1	236.99	237.04	100501.0
2017-03-20 08:00:00	SPY	ETF	237.03	237.1	236.95	236.98	247853.0
2017-03-20 08:30:00	SPY	ETF	236.98	236.98	236.79	236.83	313190.0
2017-03-20 09:00:00	SPY	ETF	236.84	237.06	236.84	237.03	276188.0
2017-03-20 09:30:00	SPY	ETF	237.03	237.05	236.7	236.88	5215709.0
2017-03-20 10:00:00	SPY	ETF	236.87	237.34	236.84	237.28	4260094.0
2017-03-20 10:30:00	SPY	ETF	237.2705	237.36	237.08	237.26	5208716.0
2017-03-20 11:00:00	SPY	ETF	237.26	237.32	237.01	237.04	2750728.0
2017-03-20 11:30:00	SPY	ETF	237.035	237.2	236.98	237.1666	1632164.0
2017-03-20 12:00:00	SPY	ETF	237.17	237.19	236.92	237.0	2498870.0
2017-03-20 12:30:00	SPY	ETF	237.0	237.19	236.97	237.1	1320175.0
2017-03-20 13:00:00	SPY	ETF	237.0938	237.1	236.93	236.99	1898029.0
2017-03-20 13:30:00	SPY	ETF	236.98	237.0402	236.5	236.67	2961493.0
2017-03-20 14:00:00	SPY	ETF	236.6773	236.81	236.62	236.81	1953042.0
2017-03-20 14:30:00	SPY	ETF	236.81	236.815	236.32	236.52	3993677.0
2017-03-20 15:00:00	SPY	ETF	236.525	236.94	236.48	236.91	2824048.0
2017-03-20 15:30:00	SPY	ETF	236.91	237.015	236.68	236.74	9607310.0
2017-03-20 16:00:00	SPY	ETF	236.74	236.81	236.43	236.79	3792384.0
2017-03-20 16:30:00	SPY	ETF	236.79	236.83	236.66	236.71	667551.0
2017-03-20 17:00:00	SPY	ETF	236.71	236.72	236.65	236.69	26013.0
2017-03-20 17:30:00	SPY	ETF	236.69	236.77	236.65	236.67	27578.0
2017-03-20 18:00:00	SPY	ETF	236.67	237.23	236.67	236.72	29444.0
2017-03-20 18:30:00	SPY	ETF	236.71	236.8	236.71	236.72	25091.0
2017-03-20 19:00:00	SPY	ETF	236.71	236.71	236.6	236.64	35911.0
2017-03-20 19:30:00	SPY	ETF	236.66	236.75	236.66	236.75	1005478.0
2017-03-20 04:00:00	QQQ	ETF	131.59	131.59	131.59	131.59	500.0
2017-03-20 05:30:00	QQQ	ETF	131.56	131.56	131.53	131.53	1000.0
2017-03-20 06:00:00	QQQ	ETF	131.51	131.51	131.51	131.51	1299.0
2017-03-20 06:30:00	QQQ	ETF	131.55	131.58	131.55	131.58	19099.0
2017-03-20 07:00:00	QQQ	ETF	131.58	131.64	131.58	131.6	39336.0
2017-03-20 07:30:00	QQQ	ETF	131.61	131.63	131.61	131.63	20096.0
2017-03-20 08:00:00	QQQ	ETF	131.63	131.63	131.57	131.6	12409.0
2017-03-20 08:30:00	QQQ	ETF	131.59	131.61	131.56	131.6	31755.0
2017-03-20 09:00:00	QQQ	ETF	131.6	131.66	131.59	131.66	68700.0
2017-03-20 09:30:00	QQQ	ETF	131.65	131.8	131.56	131.739	1382975.0
2017-03-20 10:00:00	QQQ	ETF	131.73	132.11	131.73	132.065	1030227.0
2017-03-20 10:30:00	QQQ	ETF	132.0683	132.08	131.97	132.01	724961.0
2017-03-20 11:00:00	QQQ	ETF	132.005	132.0524	131.85	131.88	526551.0
2017-03-20 11:30:00	QQQ	ETF	131.885	131.97	131.86	131.92	345841.0
2017-03-20 12:00:00	QQQ	ETF	131.9256	131.94	131.78	131.83	461107.0
2017-03-20 12:30:00	QQQ	ETF	131.83	131.949	131.83	131.91	426128.0
2017-03-20 13:00:00	QQQ	ETF	131.905	131.91	131.8	131.8262	388228.0
2017-03-20 13:30:00	QQQ	ETF	131.83	131.84	131.53	131.64	678592.0

> showing 50 of 14,274 rows — these rows as CSV

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