PREVIEW / stock_30min / 2014-03-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-04.parquet
  size:    1.7 MB
  rows:    86,661
  symbols: 3,547

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-03-04 04:00:00	AAPL	Stock	18.9175	18.9643	18.9175	18.9214	16800.0
2014-03-04 05:30:00	AAPL	Stock	18.9586	19.025	18.9586	19.025	105896.0
2014-03-04 06:00:00	AAPL	Stock	19.0357	19.0357	19.0	19.0	100324.0
2014-03-04 06:30:00	AAPL	Stock	19.0143	19.0254	18.9804	19.0046	81200.0
2014-03-04 07:00:00	AAPL	Stock	19.0068	19.0307	19.0068	19.0168	159404.0
2014-03-04 07:30:00	AAPL	Stock	19.0168	19.0168	18.995	19.0	120932.0
2014-03-04 08:00:00	AAPL	Stock	19.0036	19.0236	18.9429	18.9464	951608.0
2014-03-04 08:30:00	AAPL	Stock	18.9471	18.9718	18.9379	18.9718	674632.0
2014-03-04 09:00:00	AAPL	Stock	18.9718	18.9796	18.9589	18.96	556976.0
2014-03-04 09:30:00	AAPL	Stock	18.9643	19.0229	18.9	18.9675	31612448.0
2014-03-04 10:00:00	AAPL	Stock	18.9721	18.9904	18.9385	18.9618	14711228.0
2014-03-04 10:30:00	AAPL	Stock	18.9588	18.9882	18.9329	18.9736	14743064.0
2014-03-04 11:00:00	AAPL	Stock	18.9718	19.0071	18.9632	18.9978	13021036.0
2014-03-04 11:30:00	AAPL	Stock	18.9954	19.0014	18.9561	18.9657	8991948.0
2014-03-04 12:00:00	AAPL	Stock	18.9671	18.9768	18.9511	18.9636	6903372.0
2014-03-04 12:30:00	AAPL	Stock	18.9621	18.9896	18.9482	18.9653	8262464.0
2014-03-04 13:00:00	AAPL	Stock	18.9629	18.9711	18.935	18.9375	7602644.0
2014-03-04 13:30:00	AAPL	Stock	18.9368	18.9464	18.8779	18.8807	12725244.0
2014-03-04 14:00:00	AAPL	Stock	18.8796	18.9085	18.8489	18.9016	12051228.0
2014-03-04 14:30:00	AAPL	Stock	18.9036	18.9404	18.884	18.9311	8999172.0
2014-03-04 15:00:00	AAPL	Stock	18.9307	18.9607	18.9147	18.9539	10497284.0
2014-03-04 15:30:00	AAPL	Stock	18.9554	18.9729	18.9446	18.9729	27168596.0
2014-03-04 16:00:00	AAPL	Stock	18.9729	18.975	18.9529	18.9711	10807412.0
2014-03-04 16:30:00	AAPL	Stock	18.9696	18.9767	18.9679	18.9704	192108.0
2014-03-04 17:00:00	AAPL	Stock	18.9696	18.9729	18.9664	18.9729	55244.0
2014-03-04 17:30:00	AAPL	Stock	18.9729	18.9729	18.9671	18.9671	12320.0
2014-03-04 18:00:00	AAPL	Stock	18.9696	18.9729	18.9671	18.9671	147924.0
2014-03-04 18:30:00	AAPL	Stock	18.9729	18.9729	18.9643	18.9643	54236.0
2014-03-04 19:00:00	AAPL	Stock	18.9521	18.9536	18.9475	18.9536	51800.0
2014-03-04 19:30:00	AAPL	Stock	18.9475	18.9643	18.9475	18.9589	104664.0
2014-03-04 05:30:00	MSFT	Stock	37.99	38.02	37.99	38.02	300.0
2014-03-04 06:00:00	MSFT	Stock	38.05	38.11	38.05	38.11	286.0
2014-03-04 07:00:00	MSFT	Stock	38.1	38.1	38.1	38.1	100.0
2014-03-04 07:30:00	MSFT	Stock	38.14	38.25	38.14	38.15	2568.0
2014-03-04 08:00:00	MSFT	Stock	38.11	38.15	38.0	38.08	7754.0
2014-03-04 08:30:00	MSFT	Stock	38.06	38.06	38.0	38.01	3735.0
2014-03-04 09:00:00	MSFT	Stock	38.02	38.33	38.02	38.21	28223.0
2014-03-04 09:30:00	MSFT	Stock	38.23	38.48	38.07	38.435	3408981.0
2014-03-04 10:00:00	MSFT	Stock	38.44	38.48	38.38	38.384	1712999.0
2014-03-04 10:30:00	MSFT	Stock	38.39	38.39	38.21	38.22	1981434.0
2014-03-04 11:00:00	MSFT	Stock	38.22	38.265	38.12	38.21	1756997.0
2014-03-04 11:30:00	MSFT	Stock	38.208	38.23	38.12	38.14	1137161.0
2014-03-04 12:00:00	MSFT	Stock	38.15	38.26	38.14	38.23	1045533.0
2014-03-04 12:30:00	MSFT	Stock	38.23	38.27	38.2	38.255	1661187.0
2014-03-04 13:00:00	MSFT	Stock	38.25	38.38	38.24	38.28	1374976.0
2014-03-04 13:30:00	MSFT	Stock	38.29	38.31	38.24	38.3	1044189.0
2014-03-04 14:00:00	MSFT	Stock	38.3	38.36	38.27	38.32	750838.0
2014-03-04 14:30:00	MSFT	Stock	38.325	38.38	38.27	38.35	1048554.0
2014-03-04 15:00:00	MSFT	Stock	38.36	38.45	38.35	38.43	1754851.0
2014-03-04 15:30:00	MSFT	Stock	38.425	38.44	38.35	38.4	4273639.0

> showing 50 of 86,661 rows — these rows as CSV

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