PREVIEW / etf_30min / 2016-08-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-09.parquet
  size:    392 KB
  rows:    13,327

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-08-09 04:00:00	SPY	ETF	218.0	218.05	218.0	218.03	400.0
2016-08-09 04:30:00	SPY	ETF	217.95	218.02	217.95	217.99	600.0
2016-08-09 05:00:00	SPY	ETF	217.99	218.04	217.99	218.04	300.0
2016-08-09 05:30:00	SPY	ETF	218.05	218.05	218.04	218.04	440.0
2016-08-09 06:00:00	SPY	ETF	218.02	218.04	217.99	218.01	3005.0
2016-08-09 06:30:00	SPY	ETF	218.05	218.19	218.02	218.12	32510.0
2016-08-09 07:00:00	SPY	ETF	218.12	218.23	218.12	218.15	33560.0
2016-08-09 07:30:00	SPY	ETF	218.17	218.25	218.16	218.22	9850.0
2016-08-09 08:00:00	SPY	ETF	218.2	218.33	218.12	218.23	150199.0
2016-08-09 08:30:00	SPY	ETF	218.23	218.23	218.05	218.15	149523.0
2016-08-09 09:00:00	SPY	ETF	218.15	218.22	218.1	218.13	130528.0
2016-08-09 09:30:00	SPY	ETF	218.13	218.43	218.03	218.41	5042944.0
2016-08-09 10:00:00	SPY	ETF	218.41	218.655	218.17	218.58	4826577.0
2016-08-09 10:30:00	SPY	ETF	218.59	218.66	218.49	218.55	2752837.0
2016-08-09 11:00:00	SPY	ETF	218.55	218.76	218.55	218.65	3050067.0
2016-08-09 11:30:00	SPY	ETF	218.64	218.69	218.54	218.58	2543608.0
2016-08-09 12:00:00	SPY	ETF	218.589	218.68	218.3	218.3301	2414774.0
2016-08-09 12:30:00	SPY	ETF	218.3301	218.35	218.175	218.235	3049274.0
2016-08-09 13:00:00	SPY	ETF	218.239	218.34	218.19	218.24	2234375.0
2016-08-09 13:30:00	SPY	ETF	218.24	218.3	218.02	218.12	2619584.0
2016-08-09 14:00:00	SPY	ETF	218.12	218.16	217.97	217.98	2312274.0
2016-08-09 14:30:00	SPY	ETF	217.98	218.03	217.8	218.03	4305727.0
2016-08-09 15:00:00	SPY	ETF	218.035	218.16	217.91	218.14	3724501.0
2016-08-09 15:30:00	SPY	ETF	218.14	218.21	218.05	218.17	7387445.0
2016-08-09 16:00:00	SPY	ETF	218.17	218.25	218.0522	218.18	1808811.0
2016-08-09 16:30:00	SPY	ETF	218.18	218.26	218.1415	218.22	481783.0
2016-08-09 17:00:00	SPY	ETF	218.21	218.23	218.18	218.18	43309.0
2016-08-09 17:30:00	SPY	ETF	218.18	218.21	218.18	218.2	39374.0
2016-08-09 18:00:00	SPY	ETF	218.22	218.22	218.02	218.06	114451.0
2016-08-09 18:30:00	SPY	ETF	218.06	218.06	218.02	218.06	6451.0
2016-08-09 19:00:00	SPY	ETF	218.06	218.1	218.05	218.07	2340.0
2016-08-09 19:30:00	SPY	ETF	218.06	218.1379	218.01	218.01	533143.0
2016-08-09 04:00:00	QQQ	ETF	116.64	116.69	116.64	116.69	300.0
2016-08-09 04:30:00	QQQ	ETF	116.63	116.63	116.63	116.63	200.0
2016-08-09 06:00:00	QQQ	ETF	116.64	116.65	116.64	116.65	750.0
2016-08-09 06:30:00	QQQ	ETF	116.65	116.73	116.65	116.73	1883.0
2016-08-09 07:00:00	QQQ	ETF	116.72	116.76	116.72	116.73	4100.0
2016-08-09 07:30:00	QQQ	ETF	116.76	116.78	116.75	116.76	10092.0
2016-08-09 08:00:00	QQQ	ETF	116.78	116.83	116.78	116.79	10206.0
2016-08-09 08:30:00	QQQ	ETF	116.76	116.76	116.71	116.76	26879.0
2016-08-09 09:00:00	QQQ	ETF	116.75	116.78	116.73	116.73	10977.0
2016-08-09 09:30:00	QQQ	ETF	116.73	117.06	116.67	116.97	1395830.0
2016-08-09 10:00:00	QQQ	ETF	116.98	117.15	116.86	117.1	873160.0
2016-08-09 10:30:00	QQQ	ETF	117.1	117.23	117.04	117.14	579823.0
2016-08-09 11:00:00	QQQ	ETF	117.14	117.29	117.1274	117.23	623528.0
2016-08-09 11:30:00	QQQ	ETF	117.23	117.24	117.14	117.181	612930.0
2016-08-09 12:00:00	QQQ	ETF	117.18	117.26	117.0	117.05	599833.0
2016-08-09 12:30:00	QQQ	ETF	117.05	117.06	116.91	116.965	820188.0
2016-08-09 13:00:00	QQQ	ETF	116.97	117.06	116.97	116.996	408712.0
2016-08-09 13:30:00	QQQ	ETF	117.0	117.03	116.868	116.95	1274087.0

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

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