PREVIEW / stock_30min / 2012-07-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-02.parquet
  size:    1.4 MB
  rows:    76,050
  symbols: 3,490

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-07-02 04:00:00	AAPL	Stock	20.875	20.9532	20.875	20.9464	126000.0
2012-07-02 05:00:00	AAPL	Stock	20.9532	20.9536	20.9532	20.9536	13720.0
2012-07-02 05:30:00	AAPL	Stock	20.9482	20.9482	20.9286	20.9286	40600.0
2012-07-02 06:00:00	AAPL	Stock	20.9214	20.9214	20.9	20.9	25200.0
2012-07-02 06:30:00	AAPL	Stock	20.8982	20.9168	20.8982	20.9018	31080.0
2012-07-02 07:00:00	AAPL	Stock	20.9	20.9561	20.9	20.9104	128212.0
2012-07-02 07:30:00	AAPL	Stock	20.9107	20.9139	20.8929	20.8929	143304.0
2012-07-02 08:00:00	AAPL	Stock	20.8929	20.8982	20.8196	20.8429	784168.0
2012-07-02 08:30:00	AAPL	Stock	20.8464	20.8661	20.8457	20.8661	469364.0
2012-07-02 09:00:00	AAPL	Stock	20.8607	20.8929	20.8411	20.8804	838488.0
2012-07-02 09:30:00	AAPL	Stock	20.8804	21.1389	20.8429	21.0791	83562752.0
2012-07-02 10:00:00	AAPL	Stock	21.0825	21.1954	20.9679	21.1386	67060196.0
2012-07-02 10:30:00	AAPL	Stock	21.1425	21.1786	21.1071	21.1143	32927580.0
2012-07-02 11:00:00	AAPL	Stock	21.1129	21.15	21.0921	21.1271	26308716.0
2012-07-02 11:30:00	AAPL	Stock	21.1229	21.1607	21.08	21.08	24696476.0
2012-07-02 12:00:00	AAPL	Stock	21.0832	21.0961	21.0139	21.0611	30182180.0
2012-07-02 12:30:00	AAPL	Stock	21.0607	21.1189	21.0607	21.0954	17233020.0
2012-07-02 13:00:00	AAPL	Stock	21.0954	21.1168	21.0714	21.0993	12372192.0
2012-07-02 13:30:00	AAPL	Stock	21.0989	21.1446	21.0939	21.1107	10926972.0
2012-07-02 14:00:00	AAPL	Stock	21.1107	21.1371	21.0871	21.1216	15066436.0
2012-07-02 14:30:00	AAPL	Stock	21.1221	21.1296	21.0961	21.1248	10741080.0
2012-07-02 15:00:00	AAPL	Stock	21.1236	21.1357	21.08	21.1071	15105412.0
2012-07-02 15:30:00	AAPL	Stock	21.1071	21.17	21.09	21.1682	37334052.0
2012-07-02 16:00:00	AAPL	Stock	21.1616	21.1732	21.1034	21.1664	5820948.0
2012-07-02 16:30:00	AAPL	Stock	21.1707	21.175	21.1045	21.1664	1321516.0
2012-07-02 17:00:00	AAPL	Stock	21.1661	21.1679	21.1614	21.1614	102424.0
2012-07-02 17:30:00	AAPL	Stock	21.1643	21.1764	21.1614	21.1761	221480.0
2012-07-02 18:00:00	AAPL	Stock	21.1768	21.1821	21.175	21.1821	204372.0
2012-07-02 18:30:00	AAPL	Stock	21.1889	21.1889	21.1821	21.1861	126084.0
2012-07-02 19:00:00	AAPL	Stock	21.18	21.1857	21.1796	21.1818	133560.0
2012-07-02 19:30:00	AAPL	Stock	21.1796	21.1814	21.1679	21.1786	130704.0
2012-07-02 08:00:00	MSFT	Stock	30.55	30.59	30.48	30.48	8993.0
2012-07-02 08:30:00	MSFT	Stock	30.49	30.5	30.49	30.5	1200.0
2012-07-02 09:00:00	MSFT	Stock	30.52	30.64	30.5	30.64	20781.0
2012-07-02 09:30:00	MSFT	Stock	30.62	30.62	30.39	30.51	3029253.0
2012-07-02 10:00:00	MSFT	Stock	30.51	30.515	30.32	30.45	2903344.0
2012-07-02 10:30:00	MSFT	Stock	30.45	30.5	30.282	30.36	2239582.0
2012-07-02 11:00:00	MSFT	Stock	30.363	30.38	30.21	30.26	1958628.0
2012-07-02 11:30:00	MSFT	Stock	30.265	30.43	30.262	30.39	1318820.0
2012-07-02 12:00:00	MSFT	Stock	30.395	30.4	30.29	30.35	1678752.0
2012-07-02 12:30:00	MSFT	Stock	30.355	30.49	30.35	30.455	1681076.0
2012-07-02 13:00:00	MSFT	Stock	30.45	30.5	30.41	30.495	892829.0
2012-07-02 13:30:00	MSFT	Stock	30.5	30.5	30.44	30.45	853487.0
2012-07-02 14:00:00	MSFT	Stock	30.442	30.52	30.43	30.46	1910630.0
2012-07-02 14:30:00	MSFT	Stock	30.47	30.51	30.45	30.485	1333941.0
2012-07-02 15:00:00	MSFT	Stock	30.49	30.5	30.41	30.46	1400627.0
2012-07-02 15:30:00	MSFT	Stock	30.47	30.57	30.46	30.54	4153927.0
2012-07-02 16:00:00	MSFT	Stock	30.55	30.57	30.436	30.56	4212892.0
2012-07-02 16:30:00	MSFT	Stock	30.52	30.52	30.35	30.42	22000.0
2012-07-02 17:00:00	MSFT	Stock	30.47	30.49	30.44	30.44	4724.0

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

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