PREVIEW / stock_30min / 2012-08-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-02.parquet
  size:    1.4 MB
  rows:    74,897
  symbols: 3,454

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-08-02 04:00:00	AAPL	Stock	21.7071	21.7143	21.7	21.7143	15400.0
2012-08-02 05:30:00	AAPL	Stock	21.7321	21.75	21.7321	21.75	24360.0
2012-08-02 06:30:00	AAPL	Stock	21.7429	21.75	21.7429	21.75	31528.0
2012-08-02 07:00:00	AAPL	Stock	21.7321	21.775	21.7075	21.7075	168308.0
2012-08-02 07:30:00	AAPL	Stock	21.7143	21.7846	21.7143	21.7732	384496.0
2012-08-02 08:00:00	AAPL	Stock	21.7679	21.7946	21.7575	21.7686	916720.0
2012-08-02 08:30:00	AAPL	Stock	21.7768	21.8071	21.5357	21.5625	3423728.0
2012-08-02 09:00:00	AAPL	Stock	21.5532	21.5661	21.5182	21.5289	1976884.0
2012-08-02 09:30:00	AAPL	Stock	21.53	21.6946	21.4375	21.6829	56885248.0
2012-08-02 10:00:00	AAPL	Stock	21.6829	21.7786	21.6	21.7746	35381276.0
2012-08-02 10:30:00	AAPL	Stock	21.7686	21.8104	21.6875	21.7054	35383236.0
2012-08-02 11:00:00	AAPL	Stock	21.6982	21.7286	21.6111	21.6643	24334632.0
2012-08-02 11:30:00	AAPL	Stock	21.6643	21.6657	21.5471	21.5821	20331192.0
2012-08-02 12:00:00	AAPL	Stock	21.5814	21.6107	21.5536	21.5666	13173356.0
2012-08-02 12:30:00	AAPL	Stock	21.565	21.6231	21.5214	21.6069	16994712.0
2012-08-02 13:00:00	AAPL	Stock	21.6029	21.6257	21.5714	21.5879	9228492.0
2012-08-02 13:30:00	AAPL	Stock	21.5854	21.6125	21.565	21.5786	7249844.0
2012-08-02 14:00:00	AAPL	Stock	21.5744	21.6164	21.5546	21.6071	9383556.0
2012-08-02 14:30:00	AAPL	Stock	21.604	21.6764	21.5986	21.6571	17111752.0
2012-08-02 15:00:00	AAPL	Stock	21.6582	21.7207	21.6511	21.6559	19665520.0
2012-08-02 15:30:00	AAPL	Stock	21.6543	21.75	21.6525	21.7054	32449648.0
2012-08-02 16:00:00	AAPL	Stock	21.7068	21.7318	21.64	21.7318	4486076.0
2012-08-02 16:30:00	AAPL	Stock	21.7243	21.7329	21.6779	21.7329	982520.0
2012-08-02 17:00:00	AAPL	Stock	21.7264	21.7271	21.7179	21.7179	20104.0
2012-08-02 17:30:00	AAPL	Stock	21.7186	21.7211	21.715	21.7196	43736.0
2012-08-02 18:00:00	AAPL	Stock	21.7193	21.7193	21.7125	21.7193	18928.0
2012-08-02 18:30:00	AAPL	Stock	21.7143	21.7143	21.7143	21.7143	9100.0
2012-08-02 19:00:00	AAPL	Stock	21.7179	21.7214	21.7179	21.7214	22400.0
2012-08-02 19:30:00	AAPL	Stock	21.7196	21.7214	21.7071	21.7139	52080.0
2012-08-02 08:30:00	MSFT	Stock	29.57	29.59	29.25	29.26	8950.0
2012-08-02 09:00:00	MSFT	Stock	29.24	29.41	29.2	29.22	27959.0
2012-08-02 09:30:00	MSFT	Stock	29.2	29.38	29.03	29.34	4984332.0
2012-08-02 10:00:00	MSFT	Stock	29.33	29.525	29.29	29.48	3501251.0
2012-08-02 10:30:00	MSFT	Stock	29.475	29.49	29.23	29.25	3421836.0
2012-08-02 11:00:00	MSFT	Stock	29.25	29.32	29.14	29.25	3768571.0
2012-08-02 11:30:00	MSFT	Stock	29.25	29.255	29.04	29.105	3049920.0
2012-08-02 12:00:00	MSFT	Stock	29.105	29.13	29.05	29.05	1690085.0
2012-08-02 12:30:00	MSFT	Stock	29.055	29.13	28.97	29.11	2209017.0
2012-08-02 13:00:00	MSFT	Stock	29.115	29.14	29.05	29.08	1459123.0
2012-08-02 13:30:00	MSFT	Stock	29.075	29.08	28.99	29.0	2159799.0
2012-08-02 14:00:00	MSFT	Stock	29.005	29.105	28.98	29.08	1645585.0
2012-08-02 14:30:00	MSFT	Stock	29.08	29.18	29.03	29.05	2461124.0
2012-08-02 15:00:00	MSFT	Stock	29.055	29.14	29.05	29.07	2076842.0
2012-08-02 15:30:00	MSFT	Stock	29.08	29.25	29.06	29.16	5364470.0
2012-08-02 16:00:00	MSFT	Stock	29.19	29.21	29.13	29.13	1419311.0
2012-08-02 16:30:00	MSFT	Stock	29.16	29.19	29.085	29.085	167081.0
2012-08-02 17:00:00	MSFT	Stock	29.16	29.16	29.16	29.16	100.0
2012-08-02 17:30:00	MSFT	Stock	29.15	29.19	29.05	29.19	5880.0
2012-08-02 18:00:00	MSFT	Stock	29.11	29.16	29.11	29.16	1790.0
2012-08-02 19:00:00	MSFT	Stock	29.19	29.19	29.19	29.19	330.0

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

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