PREVIEW / stock_30min / 2012-09-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-06.parquet
  size:    1.4 MB
  rows:    76,539
  symbols: 3,480

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
2012-09-06 04:00:00	AAPL	Stock	23.9814	24.0393	23.9814	24.0389	72800.0
2012-09-06 04:30:00	AAPL	Stock	24.0486	24.0486	24.0464	24.0464	12992.0
2012-09-06 05:00:00	AAPL	Stock	24.0629	24.0757	24.0629	24.0714	14000.0
2012-09-06 05:30:00	AAPL	Stock	24.0668	24.0714	24.0668	24.0714	9520.0
2012-09-06 06:00:00	AAPL	Stock	24.0714	24.0786	24.0714	24.0732	8400.0
2012-09-06 06:30:00	AAPL	Stock	24.075	24.0846	24.075	24.0846	5600.0
2012-09-06 07:00:00	AAPL	Stock	24.0714	24.0714	23.9846	24.0254	157696.0
2012-09-06 07:30:00	AAPL	Stock	24.0332	24.0332	23.9821	24.0329	218064.0
2012-09-06 08:00:00	AAPL	Stock	24.0286	24.0336	23.9561	23.9946	1189104.0
2012-09-06 08:30:00	AAPL	Stock	23.99	24.0286	23.9679	24.0071	1670284.0
2012-09-06 09:00:00	AAPL	Stock	24.0071	24.0439	23.9964	24.0436	1331904.0
2012-09-06 09:30:00	AAPL	Stock	24.0454	24.0786	23.9571	23.9961	56985376.0
2012-09-06 10:00:00	AAPL	Stock	23.9961	24.1029	23.9832	24.0961	38011092.0
2012-09-06 10:30:00	AAPL	Stock	24.0961	24.1136	24.0436	24.0754	27153448.0
2012-09-06 11:00:00	AAPL	Stock	24.075	24.0857	24.0357	24.0411	16256408.0
2012-09-06 11:30:00	AAPL	Stock	24.0443	24.0868	24.0404	24.0782	14597828.0
2012-09-06 12:00:00	AAPL	Stock	24.0782	24.1968	24.0679	24.1818	42673400.0
2012-09-06 12:30:00	AAPL	Stock	24.18	24.1911	24.15	24.1571	17565548.0
2012-09-06 13:00:00	AAPL	Stock	24.1571	24.1936	24.1304	24.1806	18522448.0
2012-09-06 13:30:00	AAPL	Stock	24.1804	24.2246	24.154	24.2168	22447964.0
2012-09-06 14:00:00	AAPL	Stock	24.215	24.2232	24.125	24.1536	25458132.0
2012-09-06 14:30:00	AAPL	Stock	24.1536	24.2011	24.1372	24.1839	19321736.0
2012-09-06 15:00:00	AAPL	Stock	24.1875	24.1964	24.1382	24.1521	21593768.0
2012-09-06 15:30:00	AAPL	Stock	24.1511	24.1786	24.1129	24.155	38752476.0
2012-09-06 16:00:00	AAPL	Stock	24.1543	24.1693	24.1119	24.1629	16199428.0
2012-09-06 16:30:00	AAPL	Stock	24.1625	24.1768	24.0747	24.175	298172.0
2012-09-06 17:00:00	AAPL	Stock	24.1768	24.1821	24.175	24.1821	332696.0
2012-09-06 17:30:00	AAPL	Stock	24.1814	24.1814	24.1714	24.1782	103936.0
2012-09-06 18:00:00	AAPL	Stock	24.175	24.175	24.1525	24.1732	77224.0
2012-09-06 18:30:00	AAPL	Stock	24.1779	24.1786	24.1643	24.1696	57680.0
2012-09-06 19:00:00	AAPL	Stock	24.1671	24.1743	24.1643	24.1643	85372.0
2012-09-06 19:30:00	AAPL	Stock	24.1625	24.175	24.1607	24.175	102508.0
2012-09-06 05:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	100.0
2012-09-06 07:30:00	MSFT	Stock	30.55	30.56	30.5	30.55	3720.0
2012-09-06 08:00:00	MSFT	Stock	30.5	30.5	30.4	30.49	10861.0
2012-09-06 08:30:00	MSFT	Stock	30.5	30.5	30.4	30.43	8184.0
2012-09-06 09:00:00	MSFT	Stock	30.45	30.52	30.39	30.41	76075.0
2012-09-06 09:30:00	MSFT	Stock	30.5	30.9	30.46	30.89	4787795.0
2012-09-06 10:00:00	MSFT	Stock	30.9	31.08	30.89	31.04	6652542.0
2012-09-06 10:30:00	MSFT	Stock	31.04	31.15	30.99	31.1	7629141.0
2012-09-06 11:00:00	MSFT	Stock	31.11	31.19	31.1	31.18	3149853.0
2012-09-06 11:30:00	MSFT	Stock	31.176	31.335	31.17	31.3	3925187.0
2012-09-06 12:00:00	MSFT	Stock	31.3	31.35	31.29	31.29	2081461.0
2012-09-06 12:30:00	MSFT	Stock	31.29	31.3	31.25	31.28	1383778.0
2012-09-06 13:00:00	MSFT	Stock	31.28	31.29	31.23	31.246	1678521.0
2012-09-06 13:30:00	MSFT	Stock	31.245	31.3	31.24	31.29	1568271.0
2012-09-06 14:00:00	MSFT	Stock	31.295	31.3	31.25	31.281	1854425.0
2012-09-06 14:30:00	MSFT	Stock	31.285	31.32	31.25	31.27	1955403.0
2012-09-06 15:00:00	MSFT	Stock	31.277	31.29	31.26	31.265	2195004.0
2012-09-06 15:30:00	MSFT	Stock	31.265	31.36	31.26	31.36	6669975.0

> showing 50 of 76,539 rows — these rows as CSV

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