PREVIEW / stock_30min / 2011-06-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-28.parquet
  size:    1.4 MB
  rows:    75,278
  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
2011-06-28 04:30:00	AAPL	Stock	11.8696	11.8696	11.8696	11.8696	2800.0
2011-06-28 07:00:00	AAPL	Stock	11.8575	11.8643	11.8393	11.8393	127540.0
2011-06-28 07:30:00	AAPL	Stock	11.8289	11.8571	11.8214	11.8425	286524.0
2011-06-28 08:00:00	AAPL	Stock	11.8643	11.9007	11.8482	11.8846	451108.0
2011-06-28 08:30:00	AAPL	Stock	11.8946	11.9096	11.8889	11.8986	674492.0
2011-06-28 09:00:00	AAPL	Stock	11.8986	11.9196	11.8586	11.9179	2500484.0
2011-06-28 09:30:00	AAPL	Stock	11.9179	12.025	11.9086	11.9682	67448220.0
2011-06-28 10:00:00	AAPL	Stock	11.9679	12.0079	11.9607	11.9956	27284824.0
2011-06-28 10:30:00	AAPL	Stock	11.9946	12.005	11.9786	11.9823	20905024.0
2011-06-28 11:00:00	AAPL	Stock	11.9849	12.0007	11.9725	11.9946	15192016.0
2011-06-28 11:30:00	AAPL	Stock	11.9954	12.0032	11.9804	11.9882	13361124.0
2011-06-28 12:00:00	AAPL	Stock	11.9868	11.9925	11.9689	11.9725	11167548.0
2011-06-28 12:30:00	AAPL	Stock	11.9727	11.9816	11.9489	11.9507	13923644.0
2011-06-28 13:00:00	AAPL	Stock	11.9507	11.9629	11.9286	11.9461	17992912.0
2011-06-28 13:30:00	AAPL	Stock	11.9475	11.9693	11.9404	11.9639	12337892.0
2011-06-28 14:00:00	AAPL	Stock	11.965	11.9714	11.9496	11.9668	8558732.0
2011-06-28 14:30:00	AAPL	Stock	11.9654	11.9879	11.9621	11.9714	14888944.0
2011-06-28 15:00:00	AAPL	Stock	11.9721	11.9829	11.9643	11.9693	13636616.0
2011-06-28 15:30:00	AAPL	Stock	11.97	11.9768	11.9286	11.9736	36567832.0
2011-06-28 16:00:00	AAPL	Stock	11.9736	11.9957	11.9664	11.9736	7579964.0
2011-06-28 16:30:00	AAPL	Stock	11.9829	11.9857	11.964	11.9857	2132564.0
2011-06-28 17:00:00	AAPL	Stock	11.9857	11.9882	11.9821	11.9882	84504.0
2011-06-28 17:30:00	AAPL	Stock	11.9825	11.9918	11.9818	11.9886	105028.0
2011-06-28 18:00:00	AAPL	Stock	11.9846	11.9886	11.9736	11.9854	364952.0
2011-06-28 18:30:00	AAPL	Stock	11.9811	11.9854	11.9811	11.9854	17220.0
2011-06-28 19:00:00	AAPL	Stock	11.9793	11.9793	11.9679	11.9693	237440.0
2011-06-28 19:30:00	AAPL	Stock	11.9686	11.9714	11.9643	11.9654	103040.0
2011-06-28 07:00:00	MSFT	Stock	25.29	25.29	25.28	25.28	600.0
2011-06-28 07:30:00	MSFT	Stock	25.21	25.29	25.21	25.29	2600.0
2011-06-28 08:00:00	MSFT	Stock	25.28	25.28	25.23	25.25	6296.0
2011-06-28 08:30:00	MSFT	Stock	25.25	25.39	25.25	25.37	72927.0
2011-06-28 09:00:00	MSFT	Stock	25.39	25.39	25.2	25.3	351417.0
2011-06-28 09:30:00	MSFT	Stock	25.3	25.37	25.16	25.198	7809248.0
2011-06-28 10:00:00	MSFT	Stock	25.2	25.29	25.17	25.27	5769207.0
2011-06-28 10:30:00	MSFT	Stock	25.272	25.34	25.24	25.32	4639436.0
2011-06-28 11:00:00	MSFT	Stock	25.32	25.418	25.3	25.385	3366989.0
2011-06-28 11:30:00	MSFT	Stock	25.38	25.47	25.37	25.42	3149527.0
2011-06-28 12:00:00	MSFT	Stock	25.42	25.48	25.4	25.45	2958529.0
2011-06-28 12:30:00	MSFT	Stock	25.44	25.46	25.4	25.45	2202912.0
2011-06-28 13:00:00	MSFT	Stock	25.46	25.48	25.4	25.45	2496614.0
2011-06-28 13:30:00	MSFT	Stock	25.46	25.5	25.43	25.48	2817374.0
2011-06-28 14:00:00	MSFT	Stock	25.49	25.53	25.475	25.52	3890664.0
2011-06-28 14:30:00	MSFT	Stock	25.52	25.56	25.47	25.518	3483325.0
2011-06-28 15:00:00	MSFT	Stock	25.52	25.57	25.48	25.51	4311567.0
2011-06-28 15:30:00	MSFT	Stock	25.515	25.92	25.45	25.85	19924565.0
2011-06-28 16:00:00	MSFT	Stock	25.85	25.9	25.387	25.77	12265503.0
2011-06-28 16:30:00	MSFT	Stock	25.77	25.8	25.421	25.77	422336.0
2011-06-28 17:00:00	MSFT	Stock	25.77	25.83	25.77	25.77	47881.0
2011-06-28 17:30:00	MSFT	Stock	25.8	25.81	25.77	25.77	1800.0
2011-06-28 18:00:00	MSFT	Stock	25.78	25.8	25.75	25.76	75719.0

> showing 50 of 75,278 rows — these rows as CSV

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