PREVIEW / stock_30min / 2013-09-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-16.parquet
  size:    1.6 MB
  rows:    81,584
  symbols: 3,519

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-09-16 04:00:00	AAPL	Stock	16.7118	16.725	16.7075	16.7154	40656.0
2013-09-16 04:30:00	AAPL	Stock	16.7107	16.7157	16.7029	16.7064	59640.0
2013-09-16 05:00:00	AAPL	Stock	16.7064	16.7071	16.6964	16.7071	8400.0
2013-09-16 05:30:00	AAPL	Stock	16.6986	16.6986	16.6821	16.6821	47264.0
2013-09-16 06:00:00	AAPL	Stock	16.6964	16.6964	16.6957	16.6957	5600.0
2013-09-16 06:30:00	AAPL	Stock	16.6929	16.7	16.6929	16.6996	47488.0
2013-09-16 07:00:00	AAPL	Stock	16.7	16.7179	16.675	16.6857	343924.0
2013-09-16 07:30:00	AAPL	Stock	16.6846	16.6846	16.6089	16.6371	300076.0
2013-09-16 08:00:00	AAPL	Stock	16.6375	16.7214	16.5043	16.5107	2366448.0
2013-09-16 08:30:00	AAPL	Stock	16.5064	16.5321	16.4314	16.5068	4175556.0
2013-09-16 09:00:00	AAPL	Stock	16.5136	16.5375	16.4636	16.4768	2372496.0
2013-09-16 09:30:00	AAPL	Stock	16.4643	16.4861	16.2082	16.2732	123176928.0
2013-09-16 10:00:00	AAPL	Stock	16.2693	16.3464	16.2593	16.2725	44793420.0
2013-09-16 10:30:00	AAPL	Stock	16.2769	16.2814	16.1821	16.2	47553940.0
2013-09-16 11:00:00	AAPL	Stock	16.2	16.25	16.1493	16.2321	33660004.0
2013-09-16 11:30:00	AAPL	Stock	16.2307	16.2646	16.225	16.2531	17638124.0
2013-09-16 12:00:00	AAPL	Stock	16.25	16.265	16.2054	16.2284	15967112.0
2013-09-16 12:30:00	AAPL	Stock	16.2275	16.2436	16.2114	16.2318	12304292.0
2013-09-16 13:00:00	AAPL	Stock	16.2325	16.26	16.2207	16.2461	11687424.0
2013-09-16 13:30:00	AAPL	Stock	16.2443	16.2568	16.1307	16.1489	24083864.0
2013-09-16 14:00:00	AAPL	Stock	16.1514	16.1721	16.121	16.1214	22079792.0
2013-09-16 14:30:00	AAPL	Stock	16.1231	16.125	16.0304	16.0307	50969324.0
2013-09-16 15:00:00	AAPL	Stock	16.0346	16.0557	15.9721	16.0451	48190576.0
2013-09-16 15:30:00	AAPL	Stock	16.0471	16.0768	15.9918	16.0754	58626036.0
2013-09-16 16:00:00	AAPL	Stock	16.0757	16.2857	16.0396	16.174	12983572.0
2013-09-16 16:30:00	AAPL	Stock	16.0504	16.2369	16.0286	16.0286	1021440.0
2013-09-16 17:00:00	AAPL	Stock	16.0286	16.0757	15.9536	15.9536	1331764.0
2013-09-16 17:30:00	AAPL	Stock	15.9504	15.9836	15.9464	15.9668	775796.0
2013-09-16 18:00:00	AAPL	Stock	15.9732	15.9768	15.9643	15.9679	194236.0
2013-09-16 18:30:00	AAPL	Stock	15.9643	15.9686	15.9382	15.945	460880.0
2013-09-16 19:00:00	AAPL	Stock	15.9479	15.9636	15.9429	15.9636	296268.0
2013-09-16 19:30:00	AAPL	Stock	15.9514	15.955	15.9429	15.9464	302708.0
2013-09-16 04:00:00	MSFT	Stock	33.0	33.3	33.0	33.3	5123.0
2013-09-16 04:30:00	MSFT	Stock	33.36	33.36	33.36	33.36	150.0
2013-09-16 05:00:00	MSFT	Stock	33.34	33.34	33.34	33.34	100.0
2013-09-16 06:00:00	MSFT	Stock	33.34	33.34	33.34	33.34	100.0
2013-09-16 06:30:00	MSFT	Stock	33.38	33.4	33.38	33.4	3950.0
2013-09-16 07:00:00	MSFT	Stock	33.38	33.38	33.31	33.31	1605.0
2013-09-16 07:30:00	MSFT	Stock	33.34	33.34	33.34	33.34	2310.0
2013-09-16 08:00:00	MSFT	Stock	33.34	33.34	33.27	33.31	10781.0
2013-09-16 08:30:00	MSFT	Stock	33.32	33.32	33.27	33.3	10865.0
2013-09-16 09:00:00	MSFT	Stock	33.3	33.41	33.3	33.4	46691.0
2013-09-16 09:30:00	MSFT	Stock	33.4	33.5	33.145	33.21	7862312.0
2013-09-16 10:00:00	MSFT	Stock	33.21	33.335	33.17	33.32	5067346.0
2013-09-16 10:30:00	MSFT	Stock	33.32	33.32	33.2	33.31	3953996.0
2013-09-16 11:00:00	MSFT	Stock	33.31	33.375	33.19	33.22	3031995.0
2013-09-16 11:30:00	MSFT	Stock	33.223	33.27	33.1	33.1	1966272.0
2013-09-16 12:00:00	MSFT	Stock	33.105	33.13	33.03	33.05	2725331.0
2013-09-16 12:30:00	MSFT	Stock	33.05	33.06	32.76	32.76	3351679.0
2013-09-16 13:00:00	MSFT	Stock	32.768	32.95	32.755	32.895	2602737.0

> showing 50 of 81,584 rows — these rows as CSV

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