PREVIEW / etf_30min / 2016-07-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-21.parquet
  size:    398 KB
  rows:    13,324

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-07-21 04:00:00	SPY	ETF	217.15	217.2	217.09	217.16	4000.0
2016-07-21 04:30:00	SPY	ETF	217.17	217.19	216.76	216.96	17549.0
2016-07-21 05:00:00	SPY	ETF	216.94	216.95	216.8	216.8	7987.0
2016-07-21 05:30:00	SPY	ETF	216.79	216.82	216.68	216.8	22039.0
2016-07-21 06:00:00	SPY	ETF	216.84	216.95	216.84	216.94	28855.0
2016-07-21 06:30:00	SPY	ETF	216.92	217.05	216.92	216.98	8580.0
2016-07-21 07:00:00	SPY	ETF	216.94	216.99	216.89	216.97	139217.0
2016-07-21 07:30:00	SPY	ETF	216.99	217.08	216.96	217.05	38670.0
2016-07-21 08:00:00	SPY	ETF	217.06	217.07	216.89	216.9	118318.0
2016-07-21 08:30:00	SPY	ETF	216.91	217.11	216.76	216.9	367907.0
2016-07-21 09:00:00	SPY	ETF	216.9	217.07	216.9	216.95	560520.0
2016-07-21 09:30:00	SPY	ETF	216.96	217.22	216.8	216.91	6066686.0
2016-07-21 10:00:00	SPY	ETF	216.9	217.13	216.82	216.92	4004364.0
2016-07-21 10:30:00	SPY	ETF	216.93	217.18	216.89	217.16	3617367.0
2016-07-21 11:00:00	SPY	ETF	217.16	217.18	217.02	217.04	2042424.0
2016-07-21 11:30:00	SPY	ETF	217.04	217.045	216.39	216.55	5945450.0
2016-07-21 12:00:00	SPY	ETF	216.56	216.64	216.34	216.46	5115419.0
2016-07-21 12:30:00	SPY	ETF	216.465	216.5	216.27	216.335	3525449.0
2016-07-21 13:00:00	SPY	ETF	216.33	216.5	216.22	216.44	3383007.0
2016-07-21 13:30:00	SPY	ETF	216.445	216.45	216.06	216.18	3387003.0
2016-07-21 14:00:00	SPY	ETF	216.18	216.22	215.97	216.0867	3852188.0
2016-07-21 14:30:00	SPY	ETF	216.08	216.15	215.9225	216.01	2909134.0
2016-07-21 15:00:00	SPY	ETF	216.01	217.0789	215.75	216.06	7536234.0
2016-07-21 15:30:00	SPY	ETF	216.06	216.36	216.02	216.25	9998717.0
2016-07-21 16:00:00	SPY	ETF	216.24	216.3	216.0467	216.23	2640689.0
2016-07-21 16:30:00	SPY	ETF	216.23	216.34	216.18	216.3	1043484.0
2016-07-21 17:00:00	SPY	ETF	216.29	216.3	216.2	216.29	90812.0
2016-07-21 17:30:00	SPY	ETF	216.28	216.28	216.25	216.25	19617.0
2016-07-21 18:00:00	SPY	ETF	216.27	216.3	216.23	216.3	71060.0
2016-07-21 18:30:00	SPY	ETF	216.31	216.31	216.19	216.24	45310.0
2016-07-21 19:00:00	SPY	ETF	216.24	216.27	216.16	216.22	10550.0
2016-07-21 19:30:00	SPY	ETF	216.22	216.27	216.2	216.24	20779.0
2016-07-21 04:00:00	QQQ	ETF	113.51	113.57	113.51	113.57	200.0
2016-07-21 05:00:00	QQQ	ETF	113.39	113.39	113.38	113.38	1700.0
2016-07-21 05:30:00	QQQ	ETF	113.36	113.36	113.34	113.34	7897.0
2016-07-21 06:00:00	QQQ	ETF	113.39	113.39	113.38	113.38	1100.0
2016-07-21 06:30:00	QQQ	ETF	113.43	113.43	113.43	113.43	100.0
2016-07-21 07:00:00	QQQ	ETF	113.45	113.52	113.45	113.52	43997.0
2016-07-21 07:30:00	QQQ	ETF	113.51	113.56	113.5	113.55	2101.0
2016-07-21 08:00:00	QQQ	ETF	113.52	113.57	113.5	113.51	3850.0
2016-07-21 08:30:00	QQQ	ETF	113.5	113.53	113.42	113.49	44353.0
2016-07-21 09:00:00	QQQ	ETF	113.49	113.59	113.48	113.56	211226.0
2016-07-21 09:30:00	QQQ	ETF	113.52	113.74	113.42	113.47	2404730.0
2016-07-21 10:00:00	QQQ	ETF	113.47	113.68	113.41	113.4556	998755.0
2016-07-21 10:30:00	QQQ	ETF	113.47	113.575	113.39	113.52	780515.0
2016-07-21 11:00:00	QQQ	ETF	113.52	113.61	113.441	113.53	310711.0
2016-07-21 11:30:00	QQQ	ETF	113.53	113.53	113.16	113.28	972961.0
2016-07-21 12:00:00	QQQ	ETF	113.28	113.311	113.171	113.26	407972.0
2016-07-21 12:30:00	QQQ	ETF	113.25	113.28	113.141	113.193	531948.0
2016-07-21 13:00:00	QQQ	ETF	113.19	113.31	113.14	113.28	940698.0

> showing 50 of 13,324 rows — these rows as CSV

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