PREVIEW / etf_30min / 2017-02-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-02.parquet
  size:    436 KB
  rows:    14,907

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-02 04:00:00	SPY	ETF	227.04	227.08	226.84	226.87	3560.0
2017-02-02 04:30:00	SPY	ETF	226.82	226.83	226.75	226.83	3916.0
2017-02-02 05:00:00	SPY	ETF	226.77	226.83	226.68	226.81	62943.0
2017-02-02 05:30:00	SPY	ETF	226.85	226.91	226.85	226.89	9608.0
2017-02-02 06:00:00	SPY	ETF	226.93	227.09	226.9	227.01	4435.0
2017-02-02 06:30:00	SPY	ETF	226.97	227.05	226.95	227.02	1502.0
2017-02-02 07:00:00	SPY	ETF	227.0	227.08	226.94	227.01	32285.0
2017-02-02 07:30:00	SPY	ETF	227.02	227.26	227.02	227.15	67361.0
2017-02-02 08:00:00	SPY	ETF	227.15	227.18	226.839	227.02	139898.0
2017-02-02 08:30:00	SPY	ETF	227.02	227.16	226.88	226.98	221611.0
2017-02-02 09:00:00	SPY	ETF	226.95	227.23	226.95	227.22	548838.0
2017-02-02 09:30:00	SPY	ETF	227.2	227.43	226.82	227.42	9531156.0
2017-02-02 10:00:00	SPY	ETF	227.41	227.61	227.24	227.41	6939677.0
2017-02-02 10:30:00	SPY	ETF	227.41	228.01	227.3	227.99	4902967.0
2017-02-02 11:00:00	SPY	ETF	227.99	228.1	227.78	227.79	3377730.0
2017-02-02 11:30:00	SPY	ETF	227.79	227.81	227.19	227.23	5980785.0
2017-02-02 12:00:00	SPY	ETF	227.2301	227.44	227.16	227.435	3759592.0
2017-02-02 12:30:00	SPY	ETF	227.44	227.79	227.4	227.6959	3889935.0
2017-02-02 13:00:00	SPY	ETF	227.69	227.73	227.4099	227.4265	2030444.0
2017-02-02 13:30:00	SPY	ETF	227.42	227.88	227.37	227.78	2960920.0
2017-02-02 14:00:00	SPY	ETF	227.78	227.79	227.28	227.31	2967443.0
2017-02-02 14:30:00	SPY	ETF	227.315	227.425	227.18	227.36	3894509.0
2017-02-02 15:00:00	SPY	ETF	227.3511	227.77	227.29	227.72	4519042.0
2017-02-02 15:30:00	SPY	ETF	227.73	227.83	227.605	227.77	8117744.0
2017-02-02 16:00:00	SPY	ETF	227.77	227.82	227.6	227.64	2854527.0
2017-02-02 16:30:00	SPY	ETF	227.64	227.65	227.54	227.58	252048.0
2017-02-02 17:00:00	SPY	ETF	227.57	227.69	227.45	227.53	2032176.0
2017-02-02 17:30:00	SPY	ETF	227.53	227.58	227.5	227.5	36776.0
2017-02-02 18:00:00	SPY	ETF	227.5	227.69	227.5	227.62	85455.0
2017-02-02 18:30:00	SPY	ETF	227.62	227.63	227.54	227.58	7985.0
2017-02-02 19:00:00	SPY	ETF	227.56	227.58	227.5	227.58	21612.0
2017-02-02 19:30:00	SPY	ETF	227.58	227.62	227.55	227.62	11817.0
2017-02-02 04:00:00	QQQ	ETF	124.99	124.99	124.93	124.93	400.0
2017-02-02 04:30:00	QQQ	ETF	124.92	124.96	124.92	124.96	750.0
2017-02-02 05:00:00	QQQ	ETF	124.93	124.93	124.92	124.93	805.0
2017-02-02 05:30:00	QQQ	ETF	124.97	124.99	124.97	124.99	5100.0
2017-02-02 06:00:00	QQQ	ETF	125.02	125.11	125.01	125.09	1299.0
2017-02-02 06:30:00	QQQ	ETF	125.05	125.06	125.05	125.06	1030.0
2017-02-02 07:00:00	QQQ	ETF	125.08	125.12	125.08	125.09	2605.0
2017-02-02 07:30:00	QQQ	ETF	125.15	125.25	125.15	125.21	9149.0
2017-02-02 08:00:00	QQQ	ETF	125.15	125.18	125.11	125.15	33796.0
2017-02-02 08:30:00	QQQ	ETF	125.15	125.23	125.14	125.18	23484.0
2017-02-02 09:00:00	QQQ	ETF	125.17	125.28	125.17	125.22	77396.0
2017-02-02 09:30:00	QQQ	ETF	125.21	125.58	124.86	125.56	3539984.0
2017-02-02 10:00:00	QQQ	ETF	125.56	125.5672	125.34	125.38	1266389.0
2017-02-02 10:30:00	QQQ	ETF	125.39	125.66	125.34	125.635	776530.0
2017-02-02 11:00:00	QQQ	ETF	125.64	125.7	125.5401	125.56	856824.0
2017-02-02 11:30:00	QQQ	ETF	125.55	125.56	125.13	125.15	717014.0
2017-02-02 12:00:00	QQQ	ETF	125.14	125.23	125.09	125.21	654938.0
2017-02-02 12:30:00	QQQ	ETF	125.215	125.4	125.18	125.28	482352.0

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

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