PREVIEW / etf_30min / 2016-07-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-28.parquet
  size:    392 KB
  rows:    13,252

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-28 04:00:00	SPY	ETF	216.88	216.97	216.82	216.91	8752.0
2016-07-28 04:30:00	SPY	ETF	216.9	216.91	216.86	216.91	3505.0
2016-07-28 05:00:00	SPY	ETF	216.88	216.91	216.7	216.75	19016.0
2016-07-28 05:30:00	SPY	ETF	216.76	216.8	216.76	216.8	609.0
2016-07-28 06:00:00	SPY	ETF	216.69	216.74	216.68	216.71	3506.0
2016-07-28 06:30:00	SPY	ETF	216.69	216.7	216.52	216.56	6667.0
2016-07-28 07:00:00	SPY	ETF	216.6	216.6	216.28	216.42	177089.0
2016-07-28 07:30:00	SPY	ETF	216.39	216.43	216.04	216.12	93737.0
2016-07-28 08:00:00	SPY	ETF	216.11	217.16	216.09	216.33	257105.0
2016-07-28 08:30:00	SPY	ETF	216.31	216.37	216.22	216.24	106000.0
2016-07-28 09:00:00	SPY	ETF	216.27	216.37	216.16	216.29	140257.0
2016-07-28 09:30:00	SPY	ETF	216.29	216.64	215.8	216.5	10263773.0
2016-07-28 10:00:00	SPY	ETF	216.5	216.65	215.93	216.129	6168613.0
2016-07-28 10:30:00	SPY	ETF	216.13	216.17	215.75	215.82	4449779.0
2016-07-28 11:00:00	SPY	ETF	215.83	216.17	215.78	216.1	4204645.0
2016-07-28 11:30:00	SPY	ETF	216.09	216.22	215.8501	216.17	2949933.0
2016-07-28 12:00:00	SPY	ETF	216.175	216.31	216.0	216.08	2477171.0
2016-07-28 12:30:00	SPY	ETF	216.08	216.22	215.98	216.16	1997303.0
2016-07-28 13:00:00	SPY	ETF	216.1608	216.42	216.11	216.42	2176642.0
2016-07-28 13:30:00	SPY	ETF	216.42	216.63	216.31	216.63	2318302.0
2016-07-28 14:00:00	SPY	ETF	216.63	216.73	216.52	216.615	3415992.0
2016-07-28 14:30:00	SPY	ETF	216.62	216.85	216.58	216.7	3053323.0
2016-07-28 15:00:00	SPY	ETF	216.7	216.9	216.6992	216.86	3989784.0
2016-07-28 15:30:00	SPY	ETF	216.86	217.11	216.77	216.78	10467059.0
2016-07-28 16:00:00	SPY	ETF	216.78	216.97	216.68	216.8228	4640603.0
2016-07-28 16:30:00	SPY	ETF	216.85	216.97	216.83	216.97	255189.0
2016-07-28 17:00:00	SPY	ETF	216.97	217.0	216.77	216.77	101089.0
2016-07-28 17:30:00	SPY	ETF	216.95	216.99	216.88	216.9	84255.0
2016-07-28 18:00:00	SPY	ETF	216.93	217.04	216.91	216.91	49927.0
2016-07-28 18:30:00	SPY	ETF	216.9	217.07	216.83	217.0	63532.0
2016-07-28 19:00:00	SPY	ETF	216.98	217.04	216.98	217.03	36815.0
2016-07-28 19:30:00	SPY	ETF	217.03	217.03	216.94	216.95	27044.0
2016-07-28 04:00:00	QQQ	ETF	114.99	115.08	114.99	115.0	2796.0
2016-07-28 04:30:00	QQQ	ETF	115.0	115.0	115.0	115.0	1000.0
2016-07-28 06:00:00	QQQ	ETF	114.88	114.91	114.88	114.91	400.0
2016-07-28 06:30:00	QQQ	ETF	114.85	114.85	114.85	114.85	100.0
2016-07-28 07:00:00	QQQ	ETF	114.84	114.86	114.77	114.82	12956.0
2016-07-28 07:30:00	QQQ	ETF	114.8	114.85	114.64	114.66	84303.0
2016-07-28 08:00:00	QQQ	ETF	114.8	114.8	114.68	114.73	23432.0
2016-07-28 08:30:00	QQQ	ETF	114.69	114.74	114.67	114.67	15398.0
2016-07-28 09:00:00	QQQ	ETF	114.7	114.77	114.7	114.76	141889.0
2016-07-28 09:30:00	QQQ	ETF	114.76	114.9425	114.4	114.82	2162360.0
2016-07-28 10:00:00	QQQ	ETF	114.82	114.9611	114.55	114.64	1484017.0
2016-07-28 10:30:00	QQQ	ETF	114.64	114.76	114.46	114.61	1401660.0
2016-07-28 11:00:00	QQQ	ETF	114.61	114.75	114.52	114.7299	905122.0
2016-07-28 11:30:00	QQQ	ETF	114.71	114.74	114.54	114.71	575188.0
2016-07-28 12:00:00	QQQ	ETF	114.7093	114.78	114.551	114.62	513644.0
2016-07-28 12:30:00	QQQ	ETF	114.62	114.65	114.53	114.56	533163.0
2016-07-28 13:00:00	QQQ	ETF	114.57	114.739	114.52	114.72	401652.0
2016-07-28 13:30:00	QQQ	ETF	114.72	114.86	114.67	114.8562	1144684.0

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

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