PREVIEW / etf_30min / 2014-04-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-09.parquet
  size:    337 KB
  rows:    11,330

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
2014-04-09 04:00:00	SPY	ETF	185.09	185.33	185.02	185.33	9497.0
2014-04-09 04:30:00	SPY	ETF	185.34	185.41	185.3	185.34	8835.0
2014-04-09 05:00:00	SPY	ETF	185.31	185.36	185.24	185.28	4997.0
2014-04-09 05:30:00	SPY	ETF	185.25	185.32	185.24	185.32	5839.0
2014-04-09 06:00:00	SPY	ETF	185.26	185.3	185.11	185.11	22698.0
2014-04-09 06:30:00	SPY	ETF	185.16	185.26	185.16	185.18	42590.0
2014-04-09 07:00:00	SPY	ETF	185.17	185.18	185.07	185.14	106365.0
2014-04-09 07:30:00	SPY	ETF	185.14	185.33	185.11	185.32	61863.0
2014-04-09 08:00:00	SPY	ETF	185.12	185.42	185.0	185.38	191231.0
2014-04-09 08:30:00	SPY	ETF	185.4	185.64	185.4	185.56	368852.0
2014-04-09 09:00:00	SPY	ETF	185.56	185.63	185.53	185.61	870155.0
2014-04-09 09:30:00	SPY	ETF	185.6	185.7	185.11	185.31	11752459.0
2014-04-09 10:00:00	SPY	ETF	185.31	185.69	185.06	185.47	8685253.0
2014-04-09 10:30:00	SPY	ETF	185.48	185.77	185.35	185.37	5609904.0
2014-04-09 11:00:00	SPY	ETF	185.37	185.58	185.24	185.42	4936859.0
2014-04-09 11:30:00	SPY	ETF	185.42	185.74	185.36	185.67	3400896.0
2014-04-09 12:00:00	SPY	ETF	185.67	185.97	185.592	185.92	3850235.0
2014-04-09 12:30:00	SPY	ETF	185.92	186.0	185.8	185.83	3043632.0
2014-04-09 13:00:00	SPY	ETF	185.83	185.95	185.79	185.79	3064833.0
2014-04-09 13:30:00	SPY	ETF	185.799	185.93	185.69	185.75	2649600.0
2014-04-09 14:00:00	SPY	ETF	185.75	186.87	185.75	186.78	16555413.0
2014-04-09 14:30:00	SPY	ETF	186.78	186.9	186.5	186.58	8126911.0
2014-04-09 15:00:00	SPY	ETF	186.58	186.9	186.52	186.775	5292434.0
2014-04-09 15:30:00	SPY	ETF	186.771	187.15	186.74	187.12	13234274.0
2014-04-09 16:00:00	SPY	ETF	187.11	187.15	185.9298	187.02	4639216.0
2014-04-09 16:30:00	SPY	ETF	187.02	187.07	187.01	187.06	281488.0
2014-04-09 17:00:00	SPY	ETF	187.07	187.11	187.06	187.11	1068713.0
2014-04-09 17:30:00	SPY	ETF	187.07	187.1	187.05	187.06	26340.0
2014-04-09 18:00:00	SPY	ETF	187.07	187.16	187.07	187.16	92349.0
2014-04-09 18:30:00	SPY	ETF	187.14	187.16	187.11	187.13	46700.0
2014-04-09 19:00:00	SPY	ETF	187.15	187.22	187.13	187.21	36176.0
2014-04-09 19:30:00	SPY	ETF	187.21	187.21	187.16	187.2	49410.0
2014-04-09 04:00:00	QQQ	ETF	86.36	86.48	86.36	86.48	12500.0
2014-04-09 04:30:00	QQQ	ETF	86.51	86.54	86.51	86.54	1000.0
2014-04-09 05:00:00	QQQ	ETF	86.52	86.52	86.52	86.52	120.0
2014-04-09 06:00:00	QQQ	ETF	86.42	86.42	86.42	86.42	50000.0
2014-04-09 06:30:00	QQQ	ETF	86.45	86.5	86.43	86.5	56800.0
2014-04-09 07:00:00	QQQ	ETF	86.45	86.45	86.4	86.4	6000.0
2014-04-09 07:30:00	QQQ	ETF	86.41	86.51	86.41	86.5	8900.0
2014-04-09 08:00:00	QQQ	ETF	86.51	86.55	86.44	86.53	124562.0
2014-04-09 08:30:00	QQQ	ETF	86.53	86.7	86.53	86.69	138790.0
2014-04-09 09:00:00	QQQ	ETF	86.67	86.74	86.63	86.68	264468.0
2014-04-09 09:30:00	QQQ	ETF	86.67	86.81	86.43	86.6727	7572404.0
2014-04-09 10:00:00	QQQ	ETF	86.67	86.96	86.44	86.79	4451076.0
2014-04-09 10:30:00	QQQ	ETF	86.79	86.95	86.719	86.79	2621100.0
2014-04-09 11:00:00	QQQ	ETF	86.79	86.88	86.66	86.8175	1860868.0
2014-04-09 11:30:00	QQQ	ETF	86.81	87.0	86.78	86.925	1276568.0
2014-04-09 12:00:00	QQQ	ETF	86.92	87.08	86.865	87.0604	1206486.0
2014-04-09 12:30:00	QQQ	ETF	87.07	87.1498	87.0	87.03	1403548.0
2014-04-09 13:00:00	QQQ	ETF	87.04	87.12	87.01	87.02	1122150.0

> showing 50 of 11,330 rows — these rows as CSV

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