PREVIEW / stock_30min / 2012-02-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-28.parquet
  size:    1.4 MB
  rows:    75,299
  symbols: 3,538

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-02-28 04:00:00	AAPL	Stock	18.875	18.8757	18.8571	18.8757	20020.0
2012-02-28 04:30:00	AAPL	Stock	18.8679	18.8679	18.8679	18.8679	19600.0
2012-02-28 05:00:00	AAPL	Stock	18.8732	18.875	18.8732	18.875	11592.0
2012-02-28 05:30:00	AAPL	Stock	18.8596	18.8661	18.8579	18.8607	50120.0
2012-02-28 06:00:00	AAPL	Stock	18.875	18.88	18.875	18.8789	8400.0
2012-02-28 06:30:00	AAPL	Stock	18.8632	18.8632	18.8611	18.8611	19600.0
2012-02-28 07:00:00	AAPL	Stock	18.8607	18.8729	18.8393	18.8679	321804.0
2012-02-28 07:30:00	AAPL	Stock	18.8639	18.8718	18.8596	18.8646	163100.0
2012-02-28 08:00:00	AAPL	Stock	18.865	18.8732	18.85	18.8679	2094484.0
2012-02-28 08:30:00	AAPL	Stock	18.8646	18.8654	18.7754	18.8171	3895388.0
2012-02-28 09:00:00	AAPL	Stock	18.8125	18.8571	18.8036	18.8564	1536752.0
2012-02-28 09:30:00	AAPL	Stock	18.8557	18.9275	18.7804	18.9275	76122228.0
2012-02-28 10:00:00	AAPL	Stock	18.9279	18.9893	18.8996	18.9846	63841204.0
2012-02-28 10:30:00	AAPL	Stock	18.9843	19.0429	18.9479	18.9857	63916496.0
2012-02-28 11:00:00	AAPL	Stock	18.9889	19.0314	18.9611	19.0136	38676876.0
2012-02-28 11:30:00	AAPL	Stock	19.0121	19.0273	18.9771	19.0164	26454484.0
2012-02-28 12:00:00	AAPL	Stock	19.0146	19.0425	18.9811	19.0014	26062148.0
2012-02-28 12:30:00	AAPL	Stock	19.0034	19.0886	19.0025	19.0732	34731788.0
2012-02-28 13:00:00	AAPL	Stock	19.0764	19.0936	19.0536	19.0893	26393584.0
2012-02-28 13:30:00	AAPL	Stock	19.0843	19.085	18.9686	19.0071	38195500.0
2012-02-28 14:00:00	AAPL	Stock	19.0118	19.0571	18.995	19.0104	35953344.0
2012-02-28 14:30:00	AAPL	Stock	19.0104	19.0643	18.9843	19.0464	31907036.0
2012-02-28 15:00:00	AAPL	Stock	19.0461	19.1071	19.0433	19.0846	42725984.0
2012-02-28 15:30:00	AAPL	Stock	19.0846	19.1207	19.065	19.1182	61462184.0
2012-02-28 16:00:00	AAPL	Stock	19.1218	19.1407	18.9857	19.1393	13382628.0
2012-02-28 16:30:00	AAPL	Stock	19.1386	19.1607	18.7771	19.1518	1829688.0
2012-02-28 17:00:00	AAPL	Stock	19.1493	19.1571	19.1218	19.1554	355432.0
2012-02-28 17:30:00	AAPL	Stock	19.1554	19.1586	19.1536	19.1564	377720.0
2012-02-28 18:00:00	AAPL	Stock	19.1571	19.1871	19.1554	19.1857	896196.0
2012-02-28 18:30:00	AAPL	Stock	19.1861	19.1861	19.1768	19.1821	413672.0
2012-02-28 19:00:00	AAPL	Stock	19.1793	19.1979	19.1768	19.1964	484092.0
2012-02-28 19:30:00	AAPL	Stock	19.1864	19.1946	19.1814	19.1904	448364.0
2012-02-28 06:00:00	MSFT	Stock	31.46	31.61	31.46	31.61	3000.0
2012-02-28 07:00:00	MSFT	Stock	31.49	31.5	31.49	31.5	1000.0
2012-02-28 07:30:00	MSFT	Stock	31.45	31.45	31.45	31.45	3222.0
2012-02-28 08:00:00	MSFT	Stock	31.45	31.48	31.45	31.48	12255.0
2012-02-28 08:30:00	MSFT	Stock	31.43	31.43	31.34	31.38	10733.0
2012-02-28 09:00:00	MSFT	Stock	31.39	31.44	31.39	31.43	10627.0
2012-02-28 09:30:00	MSFT	Stock	31.41	31.65	31.38	31.635	4098783.0
2012-02-28 10:00:00	MSFT	Stock	31.65	31.69	31.52	31.63	3619390.0
2012-02-28 10:30:00	MSFT	Stock	31.625	31.74	31.62	31.715	3182337.0
2012-02-28 11:00:00	MSFT	Stock	31.71	31.73	31.66	31.725	2679800.0
2012-02-28 11:30:00	MSFT	Stock	31.725	31.75	31.71	31.75	2242766.0
2012-02-28 12:00:00	MSFT	Stock	31.75	31.8	31.74	31.77	2546631.0
2012-02-28 12:30:00	MSFT	Stock	31.76	31.85	31.72	31.82	3117557.0
2012-02-28 13:00:00	MSFT	Stock	31.824	31.93	31.81	31.88	2632870.0
2012-02-28 13:30:00	MSFT	Stock	31.88	31.93	31.74	31.75	3242485.0
2012-02-28 14:00:00	MSFT	Stock	31.75	31.78	31.62	31.65	3200545.0
2012-02-28 14:30:00	MSFT	Stock	31.649	31.755	31.63	31.725	2427694.0
2012-02-28 15:00:00	MSFT	Stock	31.73	31.87	31.71	31.84	3188386.0

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

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