PREVIEW / stock_30min / 2011-03-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-02.parquet
  size:    1.4 MB
  rows:    74,906
  symbols: 3,525

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
2011-03-02 04:00:00	AAPL	Stock	12.4607	12.4907	12.4607	12.4907	8400.0
2011-03-02 05:00:00	AAPL	Stock	12.5	12.5232	12.5	12.5232	8400.0
2011-03-02 05:30:00	AAPL	Stock	12.5214	12.5725	12.5214	12.5343	44800.0
2011-03-02 06:30:00	AAPL	Stock	12.5139	12.5343	12.5139	12.5343	5600.0
2011-03-02 07:00:00	AAPL	Stock	12.5071	12.5357	12.5004	12.5357	172032.0
2011-03-02 07:30:00	AAPL	Stock	12.5264	12.55	12.5214	12.55	243348.0
2011-03-02 08:00:00	AAPL	Stock	12.5379	12.5621	12.4604	12.4679	1340444.0
2011-03-02 08:30:00	AAPL	Stock	12.4704	12.5114	12.4643	12.4964	637364.0
2011-03-02 09:00:00	AAPL	Stock	12.4946	12.5125	12.4839	12.4993	1038940.0
2011-03-02 09:30:00	AAPL	Stock	12.5046	12.5446	12.4486	12.5168	54036808.0
2011-03-02 10:00:00	AAPL	Stock	12.5171	12.5321	12.4429	12.4811	38038644.0
2011-03-02 10:30:00	AAPL	Stock	12.48	12.5661	12.4657	12.5496	34145048.0
2011-03-02 11:00:00	AAPL	Stock	12.55	12.5868	12.5325	12.5361	32032560.0
2011-03-02 11:30:00	AAPL	Stock	12.5338	12.5525	12.5	12.505	22855504.0
2011-03-02 12:00:00	AAPL	Stock	12.505	12.5286	12.4911	12.5157	19029976.0
2011-03-02 12:30:00	AAPL	Stock	12.5168	12.5461	12.5039	12.5098	21237664.0
2011-03-02 13:00:00	AAPL	Stock	12.5104	12.6407	12.51	12.5843	123478376.0
2011-03-02 13:30:00	AAPL	Stock	12.5843	12.6093	12.5364	12.5579	41422136.0
2011-03-02 14:00:00	AAPL	Stock	12.5604	12.5921	12.5236	12.5643	55107780.0
2011-03-02 14:30:00	AAPL	Stock	12.565	12.6211	12.555	12.6182	43429736.0
2011-03-02 15:00:00	AAPL	Stock	12.6185	12.6554	12.6179	12.6179	52656912.0
2011-03-02 15:30:00	AAPL	Stock	12.619	12.619	12.5596	12.5757	48733272.0
2011-03-02 16:00:00	AAPL	Stock	12.5757	12.5897	12.5621	12.58	6655684.0
2011-03-02 16:30:00	AAPL	Stock	12.5779	12.6198	12.5139	12.5768	331492.0
2011-03-02 17:00:00	AAPL	Stock	12.5768	12.5839	12.5768	12.5818	216132.0
2011-03-02 17:30:00	AAPL	Stock	12.5789	12.5954	12.5789	12.5946	174972.0
2011-03-02 18:00:00	AAPL	Stock	12.5946	12.6046	12.5757	12.5964	211848.0
2011-03-02 18:30:00	AAPL	Stock	12.5961	12.6068	12.5946	12.6054	66388.0
2011-03-02 19:00:00	AAPL	Stock	12.6054	12.6064	12.6018	12.6018	140756.0
2011-03-02 19:30:00	AAPL	Stock	12.6068	12.6068	12.6	12.6032	341684.0
2011-03-02 07:00:00	MSFT	Stock	26.25	26.25	26.11	26.25	4587.0
2011-03-02 07:30:00	MSFT	Stock	26.26	26.26	26.2	26.2	1063.0
2011-03-02 08:00:00	MSFT	Stock	26.2	26.2	26.16	26.18	5618.0
2011-03-02 08:30:00	MSFT	Stock	26.15	26.16	26.12	26.14	4901.0
2011-03-02 09:00:00	MSFT	Stock	26.16	26.25	26.11	26.12	68200.0
2011-03-02 09:30:00	MSFT	Stock	26.13	26.3	26.1	26.2	5271300.0
2011-03-02 10:00:00	MSFT	Stock	26.2	26.29	26.175	26.24	3413554.0
2011-03-02 10:30:00	MSFT	Stock	26.24	26.32	26.235	26.285	3671639.0
2011-03-02 11:00:00	MSFT	Stock	26.29	26.37	26.28	26.29	3204700.0
2011-03-02 11:30:00	MSFT	Stock	26.285	26.35	26.2	26.21	2674186.0
2011-03-02 12:00:00	MSFT	Stock	26.21	26.32	26.2	26.3	2274243.0
2011-03-02 12:30:00	MSFT	Stock	26.3	26.33	26.2	26.21	2841086.0
2011-03-02 13:00:00	MSFT	Stock	26.21	26.23	26.12	26.17	3490098.0
2011-03-02 13:30:00	MSFT	Stock	26.165	26.18	26.06	26.09	3810198.0
2011-03-02 14:00:00	MSFT	Stock	26.1	26.16	26.06	26.1	3246242.0
2011-03-02 14:30:00	MSFT	Stock	26.1	26.16	26.06	26.14	3332167.0
2011-03-02 15:00:00	MSFT	Stock	26.14	26.24	26.14	26.15	3281409.0
2011-03-02 15:30:00	MSFT	Stock	26.14	26.17	26.04	26.07	6358360.0
2011-03-02 16:00:00	MSFT	Stock	26.07	26.2	26.05	26.07	1467414.0
2011-03-02 16:30:00	MSFT	Stock	26.05	26.16	26.04	26.07	46850.0

> showing 50 of 74,906 rows — these rows as CSV

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