PREVIEW / stock_30min / 2011-01-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-20.parquet
  size:    1.4 MB
  rows:    76,036
  symbols: 3,514

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-01-20 04:30:00	AAPL	Stock	12.0736	12.0821	12.0696	12.0821	16800.0
2011-01-20 05:30:00	AAPL	Stock	12.0714	12.0771	12.0714	12.0714	56560.0
2011-01-20 06:00:00	AAPL	Stock	12.0707	12.0707	12.0707	12.0707	22400.0
2011-01-20 06:30:00	AAPL	Stock	12.0714	12.0714	12.0429	12.0714	23520.0
2011-01-20 07:00:00	AAPL	Stock	12.0693	12.0936	12.0361	12.0586	412160.0
2011-01-20 07:30:00	AAPL	Stock	12.0532	12.0714	12.0436	12.0532	266000.0
2011-01-20 08:00:00	AAPL	Stock	12.0536	12.0646	12.0179	12.0368	1121316.0
2011-01-20 08:30:00	AAPL	Stock	12.0464	12.0661	12.0425	12.0636	1117452.0
2011-01-20 09:00:00	AAPL	Stock	12.0621	12.0646	12.0004	12.0004	3073756.0
2011-01-20 09:30:00	AAPL	Stock	12.0154	12.0821	11.88	11.9393	143594920.0
2011-01-20 10:00:00	AAPL	Stock	11.9393	11.942	11.79	11.8754	148388940.0
2011-01-20 10:30:00	AAPL	Stock	11.8739	11.9029	11.8214	11.8411	65409512.0
2011-01-20 11:00:00	AAPL	Stock	11.8411	11.8814	11.8314	11.8368	36388408.0
2011-01-20 11:30:00	AAPL	Stock	11.8367	11.8493	11.8107	11.8279	37001104.0
2011-01-20 12:00:00	AAPL	Stock	11.8293	11.8536	11.8114	11.8536	33836964.0
2011-01-20 12:30:00	AAPL	Stock	11.8536	11.8875	11.84	11.8782	34708632.0
2011-01-20 13:00:00	AAPL	Stock	11.8782	11.8796	11.8404	11.8479	24461080.0
2011-01-20 13:30:00	AAPL	Stock	11.8485	11.8807	11.845	11.8742	19364828.0
2011-01-20 14:00:00	AAPL	Stock	11.8746	11.9214	11.86	11.92	38227196.0
2011-01-20 14:30:00	AAPL	Stock	11.9197	11.9457	11.9143	11.9414	39973556.0
2011-01-20 15:00:00	AAPL	Stock	11.9414	11.9429	11.8875	11.8925	32474456.0
2011-01-20 15:30:00	AAPL	Stock	11.8929	11.9036	11.8625	11.8864	62332032.0
2011-01-20 16:00:00	AAPL	Stock	11.8875	11.9286	11.8411	11.8786	25713856.0
2011-01-20 16:30:00	AAPL	Stock	11.8789	11.8975	11.838	11.8946	1627920.0
2011-01-20 17:00:00	AAPL	Stock	11.8946	11.9977	11.8864	11.8893	1150324.0
2011-01-20 17:30:00	AAPL	Stock	11.8893	11.8918	11.8814	11.8886	276332.0
2011-01-20 18:00:00	AAPL	Stock	11.8882	11.8929	11.8814	11.8914	406532.0
2011-01-20 18:30:00	AAPL	Stock	11.8893	11.8929	11.8832	11.8839	115668.0
2011-01-20 19:00:00	AAPL	Stock	11.8832	11.8857	11.8714	11.8814	169960.0
2011-01-20 19:30:00	AAPL	Stock	11.875	11.8804	11.8611	11.8786	148372.0
2011-01-20 07:00:00	MSFT	Stock	28.45	28.47	28.45	28.47	400.0
2011-01-20 07:30:00	MSFT	Stock	28.47	28.47	28.36	28.36	600.0
2011-01-20 08:00:00	MSFT	Stock	28.41	28.47	28.37	28.4	4500.0
2011-01-20 08:30:00	MSFT	Stock	28.4	28.47	28.4	28.45	2478.0
2011-01-20 09:00:00	MSFT	Stock	28.45	28.51	28.4	28.5	138640.0
2011-01-20 09:30:00	MSFT	Stock	28.5	28.55	28.23	28.31	6909502.0
2011-01-20 10:00:00	MSFT	Stock	28.31	28.38	28.23	28.285	4065032.0
2011-01-20 10:30:00	MSFT	Stock	28.285	28.305	28.13	28.17	4139344.0
2011-01-20 11:00:00	MSFT	Stock	28.18	28.26	28.15	28.19	2688136.0
2011-01-20 11:30:00	MSFT	Stock	28.19	28.26	28.16	28.22	3356641.0
2011-01-20 12:00:00	MSFT	Stock	28.225	28.28	28.205	28.248	3094338.0
2011-01-20 12:30:00	MSFT	Stock	28.25	28.3	28.23	28.275	1147680.0
2011-01-20 13:00:00	MSFT	Stock	28.28	28.29	28.18	28.21	2169871.0
2011-01-20 13:30:00	MSFT	Stock	28.21	28.31	28.2	28.299	2542754.0
2011-01-20 14:00:00	MSFT	Stock	28.3	28.35	28.25	28.35	2521829.0
2011-01-20 14:30:00	MSFT	Stock	28.35	28.4	28.32	28.32	3037025.0
2011-01-20 15:00:00	MSFT	Stock	28.33	28.34	28.215	28.225	2907979.0
2011-01-20 15:30:00	MSFT	Stock	28.224	28.39	28.21	28.36	6240865.0
2011-01-20 16:00:00	MSFT	Stock	28.35	28.4	28.255	28.366	9963413.0
2011-01-20 16:30:00	MSFT	Stock	28.31	28.37	28.29	28.35	1043325.0

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

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