PREVIEW / etf_30min / 2013-12-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-02.parquet
  size:    339 KB
  rows:    11,321

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
2013-12-02 04:00:00	SPY	ETF	180.89	181.0	180.87	180.93	900.0
2013-12-02 05:00:00	SPY	ETF	180.89	180.89	180.72	180.72	900.0
2013-12-02 05:30:00	SPY	ETF	180.74	180.8	180.7	180.8	800.0
2013-12-02 06:00:00	SPY	ETF	180.85	180.85	180.8	180.8	1100.0
2013-12-02 06:30:00	SPY	ETF	180.83	180.89	180.8	180.8	12891.0
2013-12-02 07:00:00	SPY	ETF	180.8	180.83	180.7	180.81	62753.0
2013-12-02 07:30:00	SPY	ETF	180.79	181.005	180.77	181.0	219538.0
2013-12-02 08:00:00	SPY	ETF	181.0	181.05	180.82	180.99	173294.0
2013-12-02 08:30:00	SPY	ETF	181.01	181.01	180.94	180.95	242525.0
2013-12-02 09:00:00	SPY	ETF	180.95	181.08	180.93	181.08	604657.0
2013-12-02 09:30:00	SPY	ETF	181.09	181.22	180.67	180.79	12478896.0
2013-12-02 10:00:00	SPY	ETF	180.8	181.06	180.63	181.0	9532640.0
2013-12-02 10:30:00	SPY	ETF	181.0	181.16	180.86	181.03	4148135.0
2013-12-02 11:00:00	SPY	ETF	181.04	181.16	181.005	181.01	3149098.0
2013-12-02 11:30:00	SPY	ETF	181.02	181.29	180.95	181.22	4203931.0
2013-12-02 12:00:00	SPY	ETF	181.225	181.4199	181.19	181.41	2513462.0
2013-12-02 12:30:00	SPY	ETF	181.401	181.43	181.32	181.365	2136299.0
2013-12-02 13:00:00	SPY	ETF	181.36	181.375	181.2	181.225	5101017.0
2013-12-02 13:30:00	SPY	ETF	181.22	181.37	181.05	181.14	3002392.0
2013-12-02 14:00:00	SPY	ETF	181.14	181.18	180.81	180.95	3652302.0
2013-12-02 14:30:00	SPY	ETF	180.95	181.015	180.76	180.97	3734706.0
2013-12-02 15:00:00	SPY	ETF	180.97	181.01	180.65	180.67	4018453.0
2013-12-02 15:30:00	SPY	ETF	180.67	180.68	180.25	180.53	19934917.0
2013-12-02 16:00:00	SPY	ETF	180.52	180.987	180.4409	180.54	18163178.0
2013-12-02 16:30:00	SPY	ETF	180.53	180.54	180.51	180.53	207835.0
2013-12-02 17:00:00	SPY	ETF	180.54	180.54	180.48	180.48	22307.0
2013-12-02 17:30:00	SPY	ETF	180.48	180.52	180.48	180.52	8690.0
2013-12-02 18:00:00	SPY	ETF	180.53	180.65	180.48	180.63	99277.0
2013-12-02 18:30:00	SPY	ETF	180.63	180.65	180.58	180.59	17900.0
2013-12-02 19:00:00	SPY	ETF	180.6	180.6	180.53	180.59	20325.0
2013-12-02 19:30:00	SPY	ETF	180.55	180.66	180.55	180.65	15325.0
2013-12-02 04:30:00	QQQ	ETF	85.71	85.72	85.71	85.72	1400.0
2013-12-02 05:00:00	QQQ	ETF	85.68	85.71	85.65	85.65	5600.0
2013-12-02 06:30:00	QQQ	ETF	85.68	85.74	85.68	85.71	4500.0
2013-12-02 07:00:00	QQQ	ETF	85.71	85.73	85.69	85.69	2400.0
2013-12-02 07:30:00	QQQ	ETF	85.73	85.79	85.72	85.79	2500.0
2013-12-02 08:00:00	QQQ	ETF	85.69	85.79	85.69	85.78	31568.0
2013-12-02 08:30:00	QQQ	ETF	85.8	85.8	85.76	85.78	84480.0
2013-12-02 09:00:00	QQQ	ETF	85.78	85.85	85.73	85.84	132160.0
2013-12-02 09:30:00	QQQ	ETF	85.83	85.96	85.57	85.5899	3783268.0
2013-12-02 10:00:00	QQQ	ETF	85.59	85.75	85.5	85.71	2916538.0
2013-12-02 10:30:00	QQQ	ETF	85.71	85.75	85.53	85.68	1588600.0
2013-12-02 11:00:00	QQQ	ETF	85.68	85.72	85.56	85.59	990613.0
2013-12-02 11:30:00	QQQ	ETF	85.59	85.67	85.51	85.62	1154392.0
2013-12-02 12:00:00	QQQ	ETF	85.63	85.75	85.61	85.74	1449119.0
2013-12-02 12:30:00	QQQ	ETF	85.74	85.77	85.71	85.73	738613.0
2013-12-02 13:00:00	QQQ	ETF	85.73	85.75	85.63	85.64	852391.0
2013-12-02 13:30:00	QQQ	ETF	85.63	85.6838	85.59	85.645	1017074.0
2013-12-02 14:00:00	QQQ	ETF	85.64	85.655	85.485	85.56	1107297.0
2013-12-02 14:30:00	QQQ	ETF	85.555	85.67	85.49	85.66	948653.0

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

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