PREVIEW / etf_30min / 2016-08-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-15.parquet
  size:    395 KB
  rows:    13,602

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-15 04:00:00	SPY	ETF	218.61	218.93	218.61	218.9	67385.0
2016-08-15 04:30:00	SPY	ETF	218.91	218.91	218.78	218.78	2600.0
2016-08-15 05:00:00	SPY	ETF	218.72	218.78	218.72	218.75	1300.0
2016-08-15 05:30:00	SPY	ETF	218.77	218.77	218.75	218.75	1700.0
2016-08-15 06:00:00	SPY	ETF	218.75	218.78	218.75	218.77	14900.0
2016-08-15 06:30:00	SPY	ETF	218.8	218.81	218.75	218.75	14125.0
2016-08-15 07:00:00	SPY	ETF	218.8	218.86	218.78	218.85	33868.0
2016-08-15 07:30:00	SPY	ETF	218.85	218.88	218.85	218.87	42240.0
2016-08-15 08:00:00	SPY	ETF	218.46	218.95	218.46	218.9	194083.0
2016-08-15 08:30:00	SPY	ETF	218.9	219.0	218.9	218.91	194317.0
2016-08-15 09:00:00	SPY	ETF	218.91	218.93	218.87	218.9	269614.0
2016-08-15 09:30:00	SPY	ETF	218.89	219.24	218.88	219.075	7324635.0
2016-08-15 10:00:00	SPY	ETF	219.08	219.33	219.06	219.28	3515032.0
2016-08-15 10:30:00	SPY	ETF	219.28	219.47	219.28	219.39	3234574.0
2016-08-15 11:00:00	SPY	ETF	219.39	219.5	219.35	219.47	2008789.0
2016-08-15 11:30:00	SPY	ETF	219.47	219.5	219.335	219.357	2556475.0
2016-08-15 12:00:00	SPY	ETF	219.36	219.49	219.3592	219.47	1884681.0
2016-08-15 12:30:00	SPY	ETF	219.47	219.48	219.34	219.39	1936661.0
2016-08-15 13:00:00	SPY	ETF	219.38	219.42	219.29	219.4	1675174.0
2016-08-15 13:30:00	SPY	ETF	219.395	219.47	219.35	219.3501	2283050.0
2016-08-15 14:00:00	SPY	ETF	219.35	219.38	219.28	219.31	2417216.0
2016-08-15 14:30:00	SPY	ETF	219.31	219.44	219.29	219.38	2390658.0
2016-08-15 15:00:00	SPY	ETF	219.38	219.41	219.2	219.249	3622643.0
2016-08-15 15:30:00	SPY	ETF	219.24	219.31	219.065	219.125	7010013.0
2016-08-15 16:00:00	SPY	ETF	219.13	219.2777	219.0	219.01	4052957.0
2016-08-15 16:30:00	SPY	ETF	219.02	219.3767	219.0	219.0	305850.0
2016-08-15 17:00:00	SPY	ETF	219.0	219.09	218.94	218.95	84947.0
2016-08-15 17:30:00	SPY	ETF	218.94	219.0	218.94	218.97	39833.0
2016-08-15 18:00:00	SPY	ETF	218.98	219.05	218.95	218.96	29255.0
2016-08-15 18:30:00	SPY	ETF	218.95	218.97	218.94	218.95	28100.0
2016-08-15 19:00:00	SPY	ETF	218.95	218.99	218.94	218.97	11400.0
2016-08-15 19:30:00	SPY	ETF	218.97	219.02	218.94	218.95	23701.0
2016-08-15 04:30:00	QQQ	ETF	117.48	117.48	117.48	117.48	100.0
2016-08-15 05:00:00	QQQ	ETF	117.4	117.41	117.4	117.41	1100.0
2016-08-15 05:30:00	QQQ	ETF	117.41	117.42	117.41	117.42	1422.0
2016-08-15 06:00:00	QQQ	ETF	117.42	117.43	117.42	117.43	300.0
2016-08-15 07:00:00	QQQ	ETF	117.43	117.43	117.42	117.43	4522.0
2016-08-15 07:30:00	QQQ	ETF	117.44	117.46	117.43	117.45	4997.0
2016-08-15 08:00:00	QQQ	ETF	117.43	117.43	117.41	117.42	21290.0
2016-08-15 08:30:00	QQQ	ETF	117.44	117.47	117.41	117.41	15980.0
2016-08-15 09:00:00	QQQ	ETF	117.41	117.42	117.34	117.34	24914.0
2016-08-15 09:30:00	QQQ	ETF	117.33	117.74	117.31	117.635	2044621.0
2016-08-15 10:00:00	QQQ	ETF	117.6399	117.8101	117.59	117.78	1017459.0
2016-08-15 10:30:00	QQQ	ETF	117.79	117.87	117.775	117.82	829945.0
2016-08-15 11:00:00	QQQ	ETF	117.821	117.94	117.81	117.91	465883.0
2016-08-15 11:30:00	QQQ	ETF	117.91	117.94	117.84	117.86	504813.0
2016-08-15 12:00:00	QQQ	ETF	117.855	117.92	117.825	117.915	391007.0
2016-08-15 12:30:00	QQQ	ETF	117.92	117.93	117.85	117.905	523207.0
2016-08-15 13:00:00	QQQ	ETF	117.9	117.93	117.84	117.9	366410.0
2016-08-15 13:30:00	QQQ	ETF	117.9	117.97	117.86	117.87	371756.0

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

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