PREVIEW / stock_30min / 2011-09-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-19.parquet
  size:    1.4 MB
  rows:    74,971
  symbols: 3,507

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-09-19 04:00:00	AAPL	Stock	14.1786	14.1786	14.1254	14.1414	30800.0
2011-09-19 04:30:00	AAPL	Stock	14.1593	14.1596	14.1071	14.1071	36400.0
2011-09-19 05:00:00	AAPL	Stock	14.1071	14.1554	14.1071	14.1229	63840.0
2011-09-19 06:00:00	AAPL	Stock	14.1289	14.1464	14.1286	14.1429	36260.0
2011-09-19 06:30:00	AAPL	Stock	14.1404	14.1514	14.1404	14.1411	110600.0
2011-09-19 07:00:00	AAPL	Stock	14.1454	14.2029	14.1411	14.1714	364644.0
2011-09-19 07:30:00	AAPL	Stock	14.1764	14.2054	14.1764	14.1786	724444.0
2011-09-19 08:00:00	AAPL	Stock	14.1736	14.1993	14.15	14.1882	2819628.0
2011-09-19 08:30:00	AAPL	Stock	14.1804	14.1993	14.1696	14.1811	1849036.0
2011-09-19 09:00:00	AAPL	Stock	14.1807	14.1964	14.1714	14.1786	2702924.0
2011-09-19 09:30:00	AAPL	Stock	14.1779	14.2229	14.1144	14.1214	79911384.0
2011-09-19 10:00:00	AAPL	Stock	14.1214	14.2079	14.1214	14.2	48760852.0
2011-09-19 10:30:00	AAPL	Stock	14.2007	14.2829	14.1964	14.2706	42759136.0
2011-09-19 11:00:00	AAPL	Stock	14.2704	14.5332	14.2693	14.49	117603948.0
2011-09-19 11:30:00	AAPL	Stock	14.4907	14.6964	14.4857	14.6243	111405280.0
2011-09-19 12:00:00	AAPL	Stock	14.6251	14.6568	14.5646	14.5997	48325004.0
2011-09-19 12:30:00	AAPL	Stock	14.6029	14.6757	14.5989	14.6393	42558880.0
2011-09-19 13:00:00	AAPL	Stock	14.6396	14.6404	14.5396	14.6004	40100060.0
2011-09-19 13:30:00	AAPL	Stock	14.6007	14.6604	14.5954	14.6443	24909080.0
2011-09-19 14:00:00	AAPL	Stock	14.645	14.6639	14.6107	14.6361	29866368.0
2011-09-19 14:30:00	AAPL	Stock	14.6361	14.7089	14.6168	14.6203	57901956.0
2011-09-19 15:00:00	AAPL	Stock	14.6243	14.725	14.5536	14.7215	74996516.0
2011-09-19 15:30:00	AAPL	Stock	14.7239	14.7582	14.7014	14.7014	78435952.0
2011-09-19 16:00:00	AAPL	Stock	14.7033	14.7269	14.5152	14.6982	8490496.0
2011-09-19 16:30:00	AAPL	Stock	14.6961	14.7428	14.1554	14.6993	516544.0
2011-09-19 17:00:00	AAPL	Stock	14.7007	14.7054	14.6929	14.6993	202384.0
2011-09-19 17:30:00	AAPL	Stock	14.6964	14.7036	14.6921	14.6954	90244.0
2011-09-19 18:00:00	AAPL	Stock	14.7011	14.7389	14.6786	14.6968	1388184.0
2011-09-19 18:30:00	AAPL	Stock	14.7036	14.7036	14.6614	14.6614	418740.0
2011-09-19 19:00:00	AAPL	Stock	14.6618	14.6664	14.6307	14.6611	438256.0
2011-09-19 19:30:00	AAPL	Stock	14.6693	14.6779	14.6286	14.6429	249116.0
2011-09-19 04:00:00	MSFT	Stock	27.0	27.0	26.7	26.7	400.0
2011-09-19 06:00:00	MSFT	Stock	26.75	26.75	26.75	26.75	700.0
2011-09-19 07:30:00	MSFT	Stock	26.82	26.82	26.76	26.78	2200.0
2011-09-19 08:00:00	MSFT	Stock	26.78	26.87	26.78	26.87	41089.0
2011-09-19 08:30:00	MSFT	Stock	26.89	26.89	26.84	26.84	24212.0
2011-09-19 09:00:00	MSFT	Stock	26.84	26.86	26.76	26.79	56389.0
2011-09-19 09:30:00	MSFT	Stock	26.8	26.82	26.6	26.63	6230479.0
2011-09-19 10:00:00	MSFT	Stock	26.63	26.785	26.63	26.745	2862422.0
2011-09-19 10:30:00	MSFT	Stock	26.75	26.79	26.69	26.755	2879469.0
2011-09-19 11:00:00	MSFT	Stock	26.75	26.93	26.74	26.79	3053336.0
2011-09-19 11:30:00	MSFT	Stock	26.795	26.87	26.76	26.82	2738817.0
2011-09-19 12:00:00	MSFT	Stock	26.82	26.88	26.78	26.81	2344437.0
2011-09-19 12:30:00	MSFT	Stock	26.813	26.85	26.75	26.78	1600310.0
2011-09-19 13:00:00	MSFT	Stock	26.77	26.85	26.76	26.84	1525513.0
2011-09-19 13:30:00	MSFT	Stock	26.84	26.89	26.805	26.89	2155959.0
2011-09-19 14:00:00	MSFT	Stock	26.89	27.0	26.855	26.969	2742264.0
2011-09-19 14:30:00	MSFT	Stock	26.969	27.02	26.92	26.925	3389299.0
2011-09-19 15:00:00	MSFT	Stock	26.92	27.25	26.87	27.24	8756898.0
2011-09-19 15:30:00	MSFT	Stock	27.25	27.31	27.19	27.2	8463323.0

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

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