PREVIEW / etf_30min / 2017-02-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-17.parquet
  size:    428 KB
  rows:    14,706

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-17 04:00:00	SPY	ETF	234.5	234.5	234.23	234.23	26510.0
2017-02-17 04:30:00	SPY	ETF	234.15	234.21	234.08	234.21	13225.0
2017-02-17 05:00:00	SPY	ETF	234.03	234.15	234.0	234.1	37705.0
2017-02-17 05:30:00	SPY	ETF	234.03	234.16	234.02	234.06	32596.0
2017-02-17 06:00:00	SPY	ETF	234.01	234.01	233.86	233.94	37115.0
2017-02-17 06:30:00	SPY	ETF	233.99	234.23	233.99	234.23	13170.0
2017-02-17 07:00:00	SPY	ETF	234.23	234.29	234.15	234.26	35405.0
2017-02-17 07:30:00	SPY	ETF	234.21	234.28	234.16	234.2	84446.0
2017-02-17 08:00:00	SPY	ETF	234.25	234.25	233.85	233.91	1088412.0
2017-02-17 08:30:00	SPY	ETF	233.91	234.15	233.89	234.1	267007.0
2017-02-17 09:00:00	SPY	ETF	234.11	234.18	233.87	233.94	1157596.0
2017-02-17 09:30:00	SPY	ETF	233.95	234.45	233.93	234.3173	10082416.0
2017-02-17 10:00:00	SPY	ETF	234.31	234.49	234.22	234.41	4448525.0
2017-02-17 10:30:00	SPY	ETF	234.41	234.45	234.17	234.21	4016849.0
2017-02-17 11:00:00	SPY	ETF	234.21	234.35	233.98	234.1053	4324757.0
2017-02-17 11:30:00	SPY	ETF	234.1	234.33	234.09	234.25	3513358.0
2017-02-17 12:00:00	SPY	ETF	234.26	234.44	234.2	234.37	2183548.0
2017-02-17 12:30:00	SPY	ETF	234.37	234.4	234.27	234.395	1753389.0
2017-02-17 13:00:00	SPY	ETF	234.39	234.42	234.24	234.34	3220450.0
2017-02-17 13:30:00	SPY	ETF	234.35	234.45	234.33	234.38	1902166.0
2017-02-17 14:00:00	SPY	ETF	234.38	234.58	234.36	234.55	2129948.0
2017-02-17 14:30:00	SPY	ETF	234.55	234.71	234.54	234.575	2656169.0
2017-02-17 15:00:00	SPY	ETF	234.58	234.78	234.57	234.76	5552117.0
2017-02-17 15:30:00	SPY	ETF	234.755	235.07	234.69	235.06	13128722.0
2017-02-17 16:00:00	SPY	ETF	235.06	235.1299	234.95	234.95	8799677.0
2017-02-17 16:30:00	SPY	ETF	234.97	235.09	234.95	235.04	1675694.0
2017-02-17 17:00:00	SPY	ETF	235.03	235.1	235.0	235.1	3138559.0
2017-02-17 17:30:00	SPY	ETF	235.05	235.09	235.04	235.06	30637.0
2017-02-17 18:00:00	SPY	ETF	235.05	235.09	235.01	235.07	231502.0
2017-02-17 18:30:00	SPY	ETF	235.08	235.15	235.06	235.11	18620.0
2017-02-17 19:00:00	SPY	ETF	235.13	235.13	235.07	235.07	10735.0
2017-02-17 19:30:00	SPY	ETF	235.1	235.11	235.1	235.1	31934.0
2017-02-17 04:30:00	QQQ	ETF	129.0	129.01	128.94	129.01	1100.0
2017-02-17 05:00:00	QQQ	ETF	128.99	128.99	128.99	128.99	1000.0
2017-02-17 05:30:00	QQQ	ETF	128.95	128.97	128.95	128.97	350.0
2017-02-17 06:00:00	QQQ	ETF	128.95	128.95	128.91	128.93	890.0
2017-02-17 06:30:00	QQQ	ETF	129.03	129.08	129.03	129.05	23396.0
2017-02-17 07:00:00	QQQ	ETF	129.04	129.08	129.0	129.02	16014.0
2017-02-17 07:30:00	QQQ	ETF	129.04	129.11	129.02	129.06	14031.0
2017-02-17 08:00:00	QQQ	ETF	129.04	129.08	128.92	128.95	188816.0
2017-02-17 08:30:00	QQQ	ETF	128.95	129.1	128.95	129.08	40990.0
2017-02-17 09:00:00	QQQ	ETF	129.07	129.13	128.99	129.09	333020.0
2017-02-17 09:30:00	QQQ	ETF	129.09	129.35	129.04	129.31	2155979.0
2017-02-17 10:00:00	QQQ	ETF	129.32	129.47	129.24	129.45	810855.0
2017-02-17 10:30:00	QQQ	ETF	129.455	129.46	129.2952	129.31	1029925.0
2017-02-17 11:00:00	QQQ	ETF	129.31	129.37	129.19	129.241	644864.0
2017-02-17 11:30:00	QQQ	ETF	129.25	129.38	129.2444	129.34	497653.0
2017-02-17 12:00:00	QQQ	ETF	129.34	129.45	129.3	129.4	348860.0
2017-02-17 12:30:00	QQQ	ETF	129.4	129.49	129.365	129.4857	391717.0
2017-02-17 13:00:00	QQQ	ETF	129.49	129.51	129.4	129.475	402031.0

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

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