PREVIEW / stock_30min / 2012-06-22

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-22.parquet
  size:    1.6 MB
  rows:    82,899
  symbols: 3,530

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-06-22 05:30:00	AAPL	Stock	20.7	20.7	20.6964	20.6964	15400.0
2012-06-22 06:00:00	AAPL	Stock	20.6961	20.7	20.6961	20.7	36400.0
2012-06-22 07:00:00	AAPL	Stock	20.7036	20.7043	20.6607	20.6607	85680.0
2012-06-22 07:30:00	AAPL	Stock	20.6614	20.6982	20.6518	20.695	156408.0
2012-06-22 08:00:00	AAPL	Stock	20.6893	20.6975	20.6643	20.6864	292880.0
2012-06-22 08:30:00	AAPL	Stock	20.6829	20.7	20.63	20.6832	386288.0
2012-06-22 09:00:00	AAPL	Stock	20.6789	20.7211	20.665	20.6768	1203020.0
2012-06-22 09:30:00	AAPL	Stock	20.6757	20.7232	20.6071	20.6489	43892268.0
2012-06-22 10:00:00	AAPL	Stock	20.6436	20.7139	20.6364	20.6384	23728348.0
2012-06-22 10:30:00	AAPL	Stock	20.6371	20.6479	20.5507	20.5735	27998964.0
2012-06-22 11:00:00	AAPL	Stock	20.5728	20.6506	20.5596	20.63	19492088.0
2012-06-22 11:30:00	AAPL	Stock	20.6296	20.65	20.6079	20.6189	11941496.0
2012-06-22 12:00:00	AAPL	Stock	20.6182	20.6286	20.5861	20.5925	10074176.0
2012-06-22 12:30:00	AAPL	Stock	20.5932	20.6493	20.5925	20.6361	11327232.0
2012-06-22 13:00:00	AAPL	Stock	20.6361	20.6414	20.6043	20.6214	8333052.0
2012-06-22 13:30:00	AAPL	Stock	20.6189	20.66	20.5982	20.66	9928884.0
2012-06-22 14:00:00	AAPL	Stock	20.6599	20.6964	20.6529	20.6757	13243440.0
2012-06-22 14:30:00	AAPL	Stock	20.6766	20.7211	20.6707	20.7204	16680608.0
2012-06-22 15:00:00	AAPL	Stock	20.72	20.7314	20.6796	20.6943	14071680.0
2012-06-22 15:30:00	AAPL	Stock	20.6957	20.7925	20.69	20.7857	38009888.0
2012-06-22 16:00:00	AAPL	Stock	20.7857	20.7905	20.6632	20.7768	25356968.0
2012-06-22 16:30:00	AAPL	Stock	20.7546	20.7966	20.6153	20.7874	4039616.0
2012-06-22 17:00:00	AAPL	Stock	20.7525	20.7891	20.7518	20.7629	100744.0
2012-06-22 17:30:00	AAPL	Stock	20.7607	20.783	20.7561	20.7611	686280.0
2012-06-22 18:00:00	AAPL	Stock	20.7789	20.7789	20.7571	20.7571	384496.0
2012-06-22 18:30:00	AAPL	Stock	20.7589	20.7864	20.7579	20.7586	278852.0
2012-06-22 19:00:00	AAPL	Stock	20.7579	20.7643	20.7579	20.7643	58968.0
2012-06-22 19:30:00	AAPL	Stock	20.7614	20.7625	20.7536	20.7625	104580.0
2012-06-22 08:00:00	MSFT	Stock	30.27	30.33	30.2	30.3	8436.0
2012-06-22 08:30:00	MSFT	Stock	30.32	30.38	30.26	30.34	10720.0
2012-06-22 09:00:00	MSFT	Stock	30.3	30.39	30.23	30.33	27565.0
2012-06-22 09:30:00	MSFT	Stock	30.3	30.39	30.05	30.23	3644362.0
2012-06-22 10:00:00	MSFT	Stock	30.24	30.3	30.06	30.085	2658495.0
2012-06-22 10:30:00	MSFT	Stock	30.09	30.19	30.03	30.18	2045259.0
2012-06-22 11:00:00	MSFT	Stock	30.18	30.265	30.17	30.198	1751997.0
2012-06-22 11:30:00	MSFT	Stock	30.2	30.35	30.19	30.33	1490742.0
2012-06-22 12:00:00	MSFT	Stock	30.33	30.36	30.27	30.3	1528792.0
2012-06-22 12:30:00	MSFT	Stock	30.3	30.36	30.28	30.35	1347881.0
2012-06-22 13:00:00	MSFT	Stock	30.345	30.45	30.34	30.42	1701949.0
2012-06-22 13:30:00	MSFT	Stock	30.42	30.48	30.42	30.47	1379043.0
2012-06-22 14:00:00	MSFT	Stock	30.465	30.49	30.42	30.47	1618543.0
2012-06-22 14:30:00	MSFT	Stock	30.47	30.6	30.46	30.575	2312365.0
2012-06-22 15:00:00	MSFT	Stock	30.58	30.59	30.44	30.455	2817976.0
2012-06-22 15:30:00	MSFT	Stock	30.455	30.73	30.45	30.7	10391350.0
2012-06-22 16:00:00	MSFT	Stock	30.7	30.706	30.417	30.698	7805946.0
2012-06-22 16:30:00	MSFT	Stock	30.66	30.711	30.167	30.65	742871.0
2012-06-22 17:00:00	MSFT	Stock	30.67	30.67	30.64	30.64	1950.0
2012-06-22 17:30:00	MSFT	Stock	30.63	30.67	30.63	30.63	2200.0
2012-06-22 18:00:00	MSFT	Stock	30.67	30.67	30.67	30.67	800.0
2012-06-22 18:30:00	MSFT	Stock	30.67	30.696	30.66	30.696	70256.0

> showing 50 of 82,899 rows — these rows as CSV

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