PREVIEW / etf_30min / 2016-08-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-22.parquet
  size:    393 KB
  rows:    13,495

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-22 04:00:00	SPY	ETF	218.66	218.83	218.66	218.73	6394.0
2016-08-22 04:30:00	SPY	ETF	218.77	218.8	218.75	218.75	1450.0
2016-08-22 05:00:00	SPY	ETF	218.78	218.86	218.54	218.54	6048.0
2016-08-22 05:30:00	SPY	ETF	218.58	218.71	218.53	218.58	3303.0
2016-08-22 06:00:00	SPY	ETF	218.56	218.56	218.23	218.33	6655.0
2016-08-22 06:30:00	SPY	ETF	218.33	218.33	218.13	218.13	17261.0
2016-08-22 07:00:00	SPY	ETF	218.16	218.18	218.06	218.16	38807.0
2016-08-22 07:30:00	SPY	ETF	218.15	218.18	218.1	218.14	74510.0
2016-08-22 08:00:00	SPY	ETF	218.15	218.29	218.08	218.29	152094.0
2016-08-22 08:30:00	SPY	ETF	218.3	218.35	218.21	218.23	164808.0
2016-08-22 09:00:00	SPY	ETF	218.22	218.3	218.17	218.26	182278.0
2016-08-22 09:30:00	SPY	ETF	218.26	218.28	217.83	218.1	8259428.0
2016-08-22 10:00:00	SPY	ETF	218.105	218.71	217.93	218.625	6162323.0
2016-08-22 10:30:00	SPY	ETF	218.63	218.74	218.58	218.59	2628883.0
2016-08-22 11:00:00	SPY	ETF	218.6	218.69	218.0	218.03	4771521.0
2016-08-22 11:30:00	SPY	ETF	218.02	218.25	217.97	218.2	2936018.0
2016-08-22 12:00:00	SPY	ETF	218.2	218.8	218.04	218.66	3438942.0
2016-08-22 12:30:00	SPY	ETF	218.67	218.7	218.39	218.47	2867034.0
2016-08-22 13:00:00	SPY	ETF	218.4608	218.56	218.0	218.185	3386082.0
2016-08-22 13:30:00	SPY	ETF	218.18	218.53	218.08	218.4399	3096462.0
2016-08-22 14:00:00	SPY	ETF	218.44	218.61	218.2473	218.25	4155330.0
2016-08-22 14:30:00	SPY	ETF	218.25	218.51	218.23	218.369	2586015.0
2016-08-22 15:00:00	SPY	ETF	218.36	218.57	218.36	218.52	4215954.0
2016-08-22 15:30:00	SPY	ETF	218.525	218.57	218.4	218.5	6563397.0
2016-08-22 16:00:00	SPY	ETF	218.51	218.62	218.4358	218.57	4442659.0
2016-08-22 16:30:00	SPY	ETF	218.58	218.61	218.48	218.6	168520.0
2016-08-22 17:00:00	SPY	ETF	218.58	218.58	218.56	218.56	1413.0
2016-08-22 17:30:00	SPY	ETF	218.58	218.58	218.54	218.54	9214.0
2016-08-22 18:00:00	SPY	ETF	218.53	218.56	218.49	218.56	18041.0
2016-08-22 18:30:00	SPY	ETF	218.53	218.53	218.49	218.52	6304.0
2016-08-22 19:00:00	SPY	ETF	218.5	218.5	218.42	218.48	8054.0
2016-08-22 19:30:00	SPY	ETF	218.48	218.5	218.47	218.47	16460.0
2016-08-22 04:00:00	QQQ	ETF	117.4	117.46	117.4	117.43	700.0
2016-08-22 04:30:00	QQQ	ETF	117.43	117.47	117.43	117.46	5907.0
2016-08-22 05:00:00	QQQ	ETF	117.51	117.51	117.29	117.3	5400.0
2016-08-22 06:00:00	QQQ	ETF	117.26	117.26	117.1	117.13	12099.0
2016-08-22 06:30:00	QQQ	ETF	117.08	117.09	117.04	117.04	10649.0
2016-08-22 07:00:00	QQQ	ETF	117.04	117.06	117.0	117.06	9967.0
2016-08-22 07:30:00	QQQ	ETF	117.05	117.08	117.03	117.06	57753.0
2016-08-22 08:00:00	QQQ	ETF	117.04	117.11	117.04	117.11	26004.0
2016-08-22 08:30:00	QQQ	ETF	117.11	117.16	117.11	117.11	30678.0
2016-08-22 09:00:00	QQQ	ETF	117.12	117.12	117.08	117.09	45949.0
2016-08-22 09:30:00	QQQ	ETF	117.09	117.19	116.87	117.1393	1513812.0
2016-08-22 10:00:00	QQQ	ETF	117.12	117.55	117.021	117.49	1403923.0
2016-08-22 10:30:00	QQQ	ETF	117.49	117.54	117.38	117.38	904050.0
2016-08-22 11:00:00	QQQ	ETF	117.38	117.44	116.95	116.97	1285640.0
2016-08-22 11:30:00	QQQ	ETF	116.96	117.08	116.92	117.05	659468.0
2016-08-22 12:00:00	QQQ	ETF	117.05	117.4195	116.97	117.34	812854.0
2016-08-22 12:30:00	QQQ	ETF	117.35	117.36	117.22	117.26	645429.0
2016-08-22 13:00:00	QQQ	ETF	117.26	117.34	116.9341	117.07	1026041.0

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

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