PREVIEW / etf_30min / 2016-07-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-12.parquet
  size:    418 KB
  rows:    14,269

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-12 04:00:00	SPY	ETF	213.74	214.2	213.74	214.19	7868.0
2016-07-12 04:30:00	SPY	ETF	214.31	214.58	214.31	214.48	3585.0
2016-07-12 05:00:00	SPY	ETF	214.43	214.47	214.31	214.47	33046.0
2016-07-12 05:30:00	SPY	ETF	214.46	214.51	214.35	214.35	26960.0
2016-07-12 06:00:00	SPY	ETF	214.36	214.41	214.3	214.37	6922.0
2016-07-12 06:30:00	SPY	ETF	214.37	214.59	214.35	214.42	22245.0
2016-07-12 07:00:00	SPY	ETF	214.47	214.49	214.35	214.46	148164.0
2016-07-12 07:30:00	SPY	ETF	214.44	214.47	214.38	214.46	133472.0
2016-07-12 08:00:00	SPY	ETF	214.44	214.53	213.565	214.41	298753.0
2016-07-12 08:30:00	SPY	ETF	214.37	214.56	214.37	214.5	511132.0
2016-07-12 09:00:00	SPY	ETF	214.49	214.62	214.43	214.53	456488.0
2016-07-12 09:30:00	SPY	ETF	214.53	214.935	214.5	214.605	10577360.0
2016-07-12 10:00:00	SPY	ETF	214.62	214.71	214.25	214.45	8564470.0
2016-07-12 10:30:00	SPY	ETF	214.45	214.655	214.4	214.6	4958720.0
2016-07-12 11:00:00	SPY	ETF	214.605	214.93	214.535	214.87	5807776.0
2016-07-12 11:30:00	SPY	ETF	214.87	215.13	214.84	215.07	8896962.0
2016-07-12 12:00:00	SPY	ETF	215.07	215.25	215.04	215.23	4381499.0
2016-07-12 12:30:00	SPY	ETF	215.24	215.28	215.01	215.09	4724607.0
2016-07-12 13:00:00	SPY	ETF	215.1	215.181	215.065	215.18	2370662.0
2016-07-12 13:30:00	SPY	ETF	215.18	215.28	214.95	214.98	6565008.0
2016-07-12 14:00:00	SPY	ETF	214.98	215.25	214.96	215.17	6459965.0
2016-07-12 14:30:00	SPY	ETF	215.16	215.3	215.02	215.0507	6423419.0
2016-07-12 15:00:00	SPY	ETF	215.058	215.18	214.88	215.03	5451455.0
2016-07-12 15:30:00	SPY	ETF	215.03	215.15	214.84	214.94	12217850.0
2016-07-12 16:00:00	SPY	ETF	214.93	215.02	214.82	215.01	3783759.0
2016-07-12 16:30:00	SPY	ETF	214.98	215.01	214.95	214.99	2532236.0
2016-07-12 17:00:00	SPY	ETF	214.98	215.0	214.96	214.97	31038.0
2016-07-12 17:30:00	SPY	ETF	214.96	215.05	214.93	214.97	167093.0
2016-07-12 18:00:00	SPY	ETF	214.95	215.01	214.84	214.93	86422.0
2016-07-12 18:30:00	SPY	ETF	214.93	214.96	214.91	214.91	22330.0
2016-07-12 19:00:00	SPY	ETF	214.91	214.97	214.91	214.95	7914.0
2016-07-12 19:30:00	SPY	ETF	214.95	214.99	214.94	214.95	14008.0
2016-07-12 04:00:00	QQQ	ETF	111.5	111.53	111.5	111.53	599.0
2016-07-12 04:30:00	QQQ	ETF	111.63	111.63	111.62	111.62	4026.0
2016-07-12 05:00:00	QQQ	ETF	111.59	111.59	111.59	111.59	600.0
2016-07-12 05:30:00	QQQ	ETF	111.61	111.61	111.61	111.61	700.0
2016-07-12 06:00:00	QQQ	ETF	111.58	111.58	111.53	111.55	25515.0
2016-07-12 06:30:00	QQQ	ETF	111.63	111.64	111.63	111.64	600.0
2016-07-12 07:00:00	QQQ	ETF	111.55	111.59	111.53	111.59	61085.0
2016-07-12 07:30:00	QQQ	ETF	111.59	111.6	111.56	111.6	44516.0
2016-07-12 08:00:00	QQQ	ETF	111.58	111.65	111.54	111.6	43829.0
2016-07-12 08:30:00	QQQ	ETF	111.61	111.65	111.6	111.61	16533.0
2016-07-12 09:00:00	QQQ	ETF	111.64	111.68	111.61	111.61	126471.0
2016-07-12 09:30:00	QQQ	ETF	111.59	111.79	111.54	111.59	2617905.0
2016-07-12 10:00:00	QQQ	ETF	111.595	111.66	111.34	111.455	1961922.0
2016-07-12 10:30:00	QQQ	ETF	111.46	111.58	111.43	111.5	1069040.0
2016-07-12 11:00:00	QQQ	ETF	111.5	111.64	111.445	111.6	1601939.0
2016-07-12 11:30:00	QQQ	ETF	111.59	111.705	111.58	111.6538	1308215.0
2016-07-12 12:00:00	QQQ	ETF	111.65	111.735	111.615	111.715	733942.0
2016-07-12 12:30:00	QQQ	ETF	111.73	111.74	111.5434	111.57	912886.0

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

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