PREVIEW / etf_30min / 2016-07-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-14.parquet
  size:    409 KB
  rows:    13,888

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-14 04:00:00	SPY	ETF	216.0	216.43	215.2	216.3	134672.0
2016-07-14 04:30:00	SPY	ETF	216.27	216.36	216.27	216.28	12455.0
2016-07-14 05:00:00	SPY	ETF	216.3	216.5	216.27	216.36	33298.0
2016-07-14 05:30:00	SPY	ETF	216.38	217.15	216.37	217.06	138206.0
2016-07-14 06:00:00	SPY	ETF	217.06	217.06	216.53	216.55	115080.0
2016-07-14 06:30:00	SPY	ETF	216.6	216.63	216.41	216.62	305663.0
2016-07-14 07:00:00	SPY	ETF	216.58	216.58	216.0	216.46	477787.0
2016-07-14 07:30:00	SPY	ETF	216.46	216.89	216.44	216.77	417767.0
2016-07-14 08:00:00	SPY	ETF	216.78	216.83	214.789	216.61	679413.0
2016-07-14 08:30:00	SPY	ETF	216.61	216.73	216.47	216.67	492123.0
2016-07-14 09:00:00	SPY	ETF	216.68	216.68	216.4	216.41	889456.0
2016-07-14 09:30:00	SPY	ETF	216.4	216.5	215.93	216.26	13505053.0
2016-07-14 10:00:00	SPY	ETF	216.27	216.67	216.2301	216.395	9760354.0
2016-07-14 10:30:00	SPY	ETF	216.395	216.62	216.14	216.2651	5160589.0
2016-07-14 11:00:00	SPY	ETF	216.269	216.55	216.235	216.35	4763537.0
2016-07-14 11:30:00	SPY	ETF	216.35	216.36	216.09	216.15	3728671.0
2016-07-14 12:00:00	SPY	ETF	216.15	216.33	216.01	216.05	3929408.0
2016-07-14 12:30:00	SPY	ETF	216.05	216.23	216.04	216.11	3349864.0
2016-07-14 13:00:00	SPY	ETF	216.115	216.12	215.66	215.69	4984280.0
2016-07-14 13:30:00	SPY	ETF	215.69	215.93	215.68	215.82	2820285.0
2016-07-14 14:00:00	SPY	ETF	215.8199	216.12	215.75	216.0956	3656141.0
2016-07-14 14:30:00	SPY	ETF	216.1	216.22	216.01	216.11	4219489.0
2016-07-14 15:00:00	SPY	ETF	216.113	216.43	216.07	216.39	6930365.0
2016-07-14 15:30:00	SPY	ETF	216.39	216.44	216.06	216.07	12301076.0
2016-07-14 16:00:00	SPY	ETF	216.08	216.15	215.92	216.12	4612267.0
2016-07-14 16:30:00	SPY	ETF	216.11	216.25	216.09	216.14	763782.0
2016-07-14 17:00:00	SPY	ETF	216.17	216.25	216.16	216.17	259207.0
2016-07-14 17:30:00	SPY	ETF	216.16	216.2	216.07	216.07	52728.0
2016-07-14 18:00:00	SPY	ETF	216.07	216.11	215.86	215.86	201863.0
2016-07-14 18:30:00	SPY	ETF	215.85	215.91	215.77	215.82	31020.0
2016-07-14 19:00:00	SPY	ETF	215.82	215.82	215.68	215.73	111694.0
2016-07-14 19:30:00	SPY	ETF	215.71	215.81	215.66	215.74	122213.0
2016-07-14 04:00:00	QQQ	ETF	111.85	112.03	111.85	112.02	8350.0
2016-07-14 04:30:00	QQQ	ETF	111.98	111.99	111.94	111.96	1800.0
2016-07-14 05:00:00	QQQ	ETF	111.98	112.02	111.98	112.0	2696.0
2016-07-14 05:30:00	QQQ	ETF	112.02	112.3	112.0	112.3	7393.0
2016-07-14 06:00:00	QQQ	ETF	112.3	112.3	112.1	112.1	1100.0
2016-07-14 06:30:00	QQQ	ETF	112.06	112.06	112.0	112.05	7899.0
2016-07-14 07:00:00	QQQ	ETF	111.95	111.95	111.73	111.94	92057.0
2016-07-14 07:30:00	QQQ	ETF	111.93	112.11	111.92	112.11	30291.0
2016-07-14 08:00:00	QQQ	ETF	112.07	112.07	111.98	112.01	74977.0
2016-07-14 08:30:00	QQQ	ETF	111.99	112.09	111.95	112.07	29291.0
2016-07-14 09:00:00	QQQ	ETF	112.06	112.07	111.96	111.96	86090.0
2016-07-14 09:30:00	QQQ	ETF	111.96	111.99	111.72	111.84	2177951.0
2016-07-14 10:00:00	QQQ	ETF	111.84	112.1273	111.84	112.03	2171616.0
2016-07-14 10:30:00	QQQ	ETF	112.03	112.19	111.91	111.98	1820566.0
2016-07-14 11:00:00	QQQ	ETF	111.98	112.11	111.94	111.9701	1057892.0
2016-07-14 11:30:00	QQQ	ETF	111.97	111.9799	111.82	111.895	827073.0
2016-07-14 12:00:00	QQQ	ETF	111.9	112.0	111.85	111.86	728104.0
2016-07-14 12:30:00	QQQ	ETF	111.85	112.0	111.85	111.92	559178.0

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

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