PREVIEW / stock_30min / 2011-06-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-14.parquet
  size:    1.5 MB
  rows:    79,905
  symbols: 3,563

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-14 04:00:00	AAPL	Stock	11.7182	11.7182	11.7	11.7	5600.0
2011-06-14 05:30:00	AAPL	Stock	11.7321	11.7321	11.7321	11.7321	5600.0
2011-06-14 06:00:00	AAPL	Stock	11.7493	11.7493	11.7493	11.7493	4200.0
2011-06-14 06:30:00	AAPL	Stock	11.7493	11.7493	11.7464	11.7464	8400.0
2011-06-14 07:00:00	AAPL	Stock	11.7471	11.7471	11.7279	11.7429	79660.0
2011-06-14 07:30:00	AAPL	Stock	11.7457	11.7636	11.7457	11.7536	146552.0
2011-06-14 08:00:00	AAPL	Stock	11.7604	11.7604	11.7379	11.75	423108.0
2011-06-14 08:30:00	AAPL	Stock	11.75	11.8179	11.75	11.8139	2017568.0
2011-06-14 09:00:00	AAPL	Stock	11.8125	11.8143	11.7857	11.7857	1281420.0
2011-06-14 09:30:00	AAPL	Stock	11.7864	11.8429	11.7611	11.8361	59101028.0
2011-06-14 10:00:00	AAPL	Stock	11.8357	11.865	11.8257	11.8464	30871960.0
2011-06-14 10:30:00	AAPL	Stock	11.8479	11.8725	11.8343	11.836	24243604.0
2011-06-14 11:00:00	AAPL	Stock	11.835	11.8429	11.8161	11.8196	14492744.0
2011-06-14 11:30:00	AAPL	Stock	11.8189	11.8304	11.8057	11.8236	17832528.0
2011-06-14 12:00:00	AAPL	Stock	11.8246	11.8364	11.8179	11.8304	11079572.0
2011-06-14 12:30:00	AAPL	Stock	11.8318	11.8364	11.8132	11.8257	15169532.0
2011-06-14 13:00:00	AAPL	Stock	11.8268	11.8536	11.82	11.8464	11971456.0
2011-06-14 13:30:00	AAPL	Stock	11.846	11.8632	11.8429	11.8529	14209384.0
2011-06-14 14:00:00	AAPL	Stock	11.8543	11.8971	11.8496	11.8911	19957728.0
2011-06-14 14:30:00	AAPL	Stock	11.8918	11.8946	11.875	11.8814	17086720.0
2011-06-14 15:00:00	AAPL	Stock	11.8814	11.9018	11.8693	11.8746	24067428.0
2011-06-14 15:30:00	AAPL	Stock	11.8757	11.8764	11.8457	11.8689	40638304.0
2011-06-14 16:00:00	AAPL	Stock	11.8661	11.8811	11.8426	11.8696	12774384.0
2011-06-14 16:30:00	AAPL	Stock	11.87	11.8786	11.8679	11.8786	260260.0
2011-06-14 17:00:00	AAPL	Stock	11.875	11.8804	11.8729	11.8739	109536.0
2011-06-14 17:30:00	AAPL	Stock	11.8775	11.8779	11.8775	11.8779	9016.0
2011-06-14 18:00:00	AAPL	Stock	11.8746	11.8989	11.8729	11.8954	303856.0
2011-06-14 18:30:00	AAPL	Stock	11.8964	11.8986	11.8868	11.8875	136108.0
2011-06-14 19:00:00	AAPL	Stock	11.8918	11.8929	11.8893	11.8893	29596.0
2011-06-14 19:30:00	AAPL	Stock	11.8929	11.8979	11.8929	11.8979	86772.0
2011-06-14 04:00:00	MSFT	Stock	24.1	24.15	24.1	24.15	1400.0
2011-06-14 05:30:00	MSFT	Stock	24.15	24.15	24.15	24.15	200.0
2011-06-14 06:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	200.0
2011-06-14 07:00:00	MSFT	Stock	24.15	24.15	24.15	24.15	706.0
2011-06-14 07:30:00	MSFT	Stock	24.15	24.17	24.15	24.17	1600.0
2011-06-14 08:00:00	MSFT	Stock	24.19	24.31	24.16	24.3	304634.0
2011-06-14 08:30:00	MSFT	Stock	24.3	24.32	24.25	24.26	77923.0
2011-06-14 09:00:00	MSFT	Stock	24.29	24.399	24.26	24.3	277609.0
2011-06-14 09:30:00	MSFT	Stock	24.3	24.41	24.21	24.37	5890620.0
2011-06-14 10:00:00	MSFT	Stock	24.37	24.42	24.35	24.39	3679549.0
2011-06-14 10:30:00	MSFT	Stock	24.395	24.45	24.37	24.39	2792482.0
2011-06-14 11:00:00	MSFT	Stock	24.385	24.39	24.3	24.31	1844895.0
2011-06-14 11:30:00	MSFT	Stock	24.31	24.32	24.2	24.25	2167077.0
2011-06-14 12:00:00	MSFT	Stock	24.255	24.31	24.23	24.31	1834407.0
2011-06-14 12:30:00	MSFT	Stock	24.31	24.32	24.27	24.29	1494019.0
2011-06-14 13:00:00	MSFT	Stock	24.29	24.35	24.26	24.338	1805435.0
2011-06-14 13:30:00	MSFT	Stock	24.34	24.36	24.28	24.3	1947080.0
2011-06-14 14:00:00	MSFT	Stock	24.29	24.32	24.27	24.3	2073547.0
2011-06-14 14:30:00	MSFT	Stock	24.295	24.32	24.28	24.28	1946539.0
2011-06-14 15:00:00	MSFT	Stock	24.28	24.32	24.22	24.24	2321319.0

> showing 50 of 79,905 rows — these rows as CSV

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