PREVIEW / stock_30min / 2013-02-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-27.parquet
  size:    1.4 MB
  rows:    76,083
  symbols: 3,487

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-02-27 05:30:00	AAPL	Stock	15.9768	15.9768	15.9768	15.9768	8400.0
2013-02-27 06:00:00	AAPL	Stock	15.9886	15.9886	15.9886	15.9886	11200.0
2013-02-27 06:30:00	AAPL	Stock	16.0	16.0	16.0	16.0	49560.0
2013-02-27 07:00:00	AAPL	Stock	15.9821	16.0232	15.9821	16.0	192080.0
2013-02-27 07:30:00	AAPL	Stock	16.0064	16.0064	15.9657	15.975	410788.0
2013-02-27 08:00:00	AAPL	Stock	15.9929	16.0179	15.9546	15.9796	975268.0
2013-02-27 08:30:00	AAPL	Stock	15.9718	15.9832	15.9571	15.9711	309764.0
2013-02-27 09:00:00	AAPL	Stock	15.9668	16.0393	15.9668	16.0321	1763972.0
2013-02-27 09:30:00	AAPL	Stock	16.0221	16.0346	15.8518	15.9043	55583948.0
2013-02-27 10:00:00	AAPL	Stock	15.9075	15.9996	15.8414	15.9582	34562864.0
2013-02-27 10:30:00	AAPL	Stock	15.9636	15.9821	15.9021	15.9375	23166612.0
2013-02-27 11:00:00	AAPL	Stock	15.9386	16.0832	15.9364	16.053	33896408.0
2013-02-27 11:30:00	AAPL	Stock	16.0532	16.0536	15.9468	15.9695	21580244.0
2013-02-27 12:00:00	AAPL	Stock	15.9629	16.1586	15.8782	16.0079	58097284.0
2013-02-27 12:30:00	AAPL	Stock	16.0032	16.0861	15.8054	15.9304	80770788.0
2013-02-27 13:00:00	AAPL	Stock	15.9304	15.9868	15.7375	15.8693	72447536.0
2013-02-27 13:30:00	AAPL	Stock	15.8711	15.9379	15.8239	15.8536	25464376.0
2013-02-27 14:00:00	AAPL	Stock	15.8536	15.9068	15.825	15.8536	22542744.0
2013-02-27 14:30:00	AAPL	Stock	15.8536	16.1179	15.8489	16.095	56686812.0
2013-02-27 15:00:00	AAPL	Stock	16.0958	16.0964	15.9857	15.9936	36754928.0
2013-02-27 15:30:00	AAPL	Stock	15.9961	16.0231	15.8682	15.8775	44116856.0
2013-02-27 16:00:00	AAPL	Stock	15.8774	15.976	15.8418	15.8557	12619936.0
2013-02-27 16:30:00	AAPL	Stock	15.8518	15.9929	15.85	15.8671	238784.0
2013-02-27 17:00:00	AAPL	Stock	15.8661	15.8804	15.8657	15.8761	376264.0
2013-02-27 17:30:00	AAPL	Stock	15.8714	15.8775	15.8493	15.8493	432572.0
2013-02-27 18:00:00	AAPL	Stock	15.85	15.8529	15.8311	15.8464	324324.0
2013-02-27 18:30:00	AAPL	Stock	15.8464	15.8543	15.8464	15.8543	98532.0
2013-02-27 19:00:00	AAPL	Stock	15.8554	15.8571	15.8479	15.8479	84448.0
2013-02-27 19:30:00	AAPL	Stock	15.85	15.8571	15.8464	15.85	141680.0
2013-02-27 07:30:00	MSFT	Stock	27.41	27.41	27.41	27.41	3000.0
2013-02-27 08:00:00	MSFT	Stock	27.32	27.41	27.32	27.4	7100.0
2013-02-27 08:30:00	MSFT	Stock	27.38	27.39	27.38	27.39	600.0
2013-02-27 09:00:00	MSFT	Stock	27.35	27.4	27.35	27.4	2085.0
2013-02-27 09:30:00	MSFT	Stock	27.4	27.49	27.33	27.45	3041109.0
2013-02-27 10:00:00	MSFT	Stock	27.45	27.56	27.44	27.55	2686470.0
2013-02-27 10:30:00	MSFT	Stock	27.55	27.669	27.52	27.62	2815704.0
2013-02-27 11:00:00	MSFT	Stock	27.615	27.79	27.61	27.77	3413459.0
2013-02-27 11:30:00	MSFT	Stock	27.765	27.89	27.75	27.875	2782131.0
2013-02-27 12:00:00	MSFT	Stock	27.88	27.94	27.85	27.896	1805908.0
2013-02-27 12:30:00	MSFT	Stock	27.895	27.93	27.82	27.865	2002663.0
2013-02-27 13:00:00	MSFT	Stock	27.86	27.87	27.81	27.825	1351514.0
2013-02-27 13:30:00	MSFT	Stock	27.82	27.87	27.82	27.845	1012553.0
2013-02-27 14:00:00	MSFT	Stock	27.85	27.93	27.83	27.9	1512503.0
2013-02-27 14:30:00	MSFT	Stock	27.9	27.98	27.9	27.98	2205852.0
2013-02-27 15:00:00	MSFT	Stock	27.98	28.0	27.92	27.971	2217610.0
2013-02-27 15:30:00	MSFT	Stock	27.98	27.99	27.8	27.8	6453535.0
2013-02-27 16:00:00	MSFT	Stock	27.81	27.896	27.765	27.81	1695942.0
2013-02-27 16:30:00	MSFT	Stock	27.84	27.97	27.766	27.85	18964.0
2013-02-27 17:00:00	MSFT	Stock	27.84	27.84	27.81	27.81	10950.0
2013-02-27 17:30:00	MSFT	Stock	27.81	27.81	27.81	27.81	16759.0

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

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