PREVIEW / stock_30min / 2013-01-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-07.parquet
  size:    1.4 MB
  rows:    77,342
  symbols: 3,480

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
2013-01-07 04:00:00	AAPL	Stock	18.8214	18.8214	18.75	18.7564	72800.0
2013-01-07 04:30:00	AAPL	Stock	18.75	18.7636	18.75	18.7636	11200.0
2013-01-07 05:00:00	AAPL	Stock	18.7796	18.7796	18.7796	18.7796	10976.0
2013-01-07 05:30:00	AAPL	Stock	18.7796	18.7796	18.7375	18.7375	70084.0
2013-01-07 06:00:00	AAPL	Stock	18.7325	18.7507	18.7325	18.7507	21000.0
2013-01-07 06:30:00	AAPL	Stock	18.7504	18.7504	18.7504	18.7504	5600.0
2013-01-07 07:00:00	AAPL	Stock	18.7679	18.7679	18.725	18.7571	161308.0
2013-01-07 07:30:00	AAPL	Stock	18.75	18.75	18.6079	18.6407	574392.0
2013-01-07 08:00:00	AAPL	Stock	18.6429	18.6946	18.6089	18.6496	1562176.0
2013-01-07 08:30:00	AAPL	Stock	18.6511	18.6607	18.5804	18.615	2134188.0
2013-01-07 09:00:00	AAPL	Stock	18.6079	18.7321	18.5868	18.6443	2381764.0
2013-01-07 09:30:00	AAPL	Stock	18.6436	18.6629	18.4	18.4411	98446180.0
2013-01-07 10:00:00	AAPL	Stock	18.4336	18.6518	18.4315	18.6404	52510892.0
2013-01-07 10:30:00	AAPL	Stock	18.6371	18.7318	18.5625	18.6772	39271120.0
2013-01-07 11:00:00	AAPL	Stock	18.6821	18.8843	18.6679	18.8643	46672304.0
2013-01-07 11:30:00	AAPL	Stock	18.8643	18.9036	18.6921	18.6989	34740804.0
2013-01-07 12:00:00	AAPL	Stock	18.6964	18.7261	18.6143	18.6357	25555880.0
2013-01-07 12:30:00	AAPL	Stock	18.6343	18.6961	18.6107	18.6875	17593240.0
2013-01-07 13:00:00	AAPL	Stock	18.6834	18.7393	18.6834	18.725	13861652.0
2013-01-07 13:30:00	AAPL	Stock	18.7268	18.7307	18.6229	18.6596	13734672.0
2013-01-07 14:00:00	AAPL	Stock	18.6607	18.7118	18.6529	18.6961	10185756.0
2013-01-07 14:30:00	AAPL	Stock	18.6914	18.6989	18.5814	18.6304	22761956.0
2013-01-07 15:00:00	AAPL	Stock	18.6282	18.8104	18.6021	18.7564	39241944.0
2013-01-07 15:30:00	AAPL	Stock	18.757	18.7714	18.6625	18.7132	42186340.0
2013-01-07 16:00:00	AAPL	Stock	18.7132	18.7219	18.6509	18.6843	15425452.0
2013-01-07 16:30:00	AAPL	Stock	18.6807	18.7542	18.6657	18.6821	457548.0
2013-01-07 17:00:00	AAPL	Stock	18.6786	18.6964	18.6786	18.6929	105364.0
2013-01-07 17:30:00	AAPL	Stock	18.6954	18.6954	18.6786	18.6879	223244.0
2013-01-07 18:00:00	AAPL	Stock	18.6943	18.6964	18.6854	18.6854	117824.0
2013-01-07 18:30:00	AAPL	Stock	18.6857	18.6868	18.6857	18.6868	8960.0
2013-01-07 19:00:00	AAPL	Stock	18.6918	18.6932	18.6721	18.6721	90160.0
2013-01-07 19:30:00	AAPL	Stock	18.6682	18.6704	18.6518	18.6636	356132.0
2013-01-07 04:30:00	MSFT	Stock	26.86	26.86	26.86	26.86	100.0
2013-01-07 06:00:00	MSFT	Stock	26.75	26.86	26.75	26.86	870.0
2013-01-07 06:30:00	MSFT	Stock	26.79	26.79	26.79	26.79	100.0
2013-01-07 07:00:00	MSFT	Stock	26.84	26.84	26.8	26.83	1472.0
2013-01-07 07:30:00	MSFT	Stock	26.83	26.88	26.83	26.88	2850.0
2013-01-07 08:00:00	MSFT	Stock	26.83	26.88	26.73	26.77	33713.0
2013-01-07 08:30:00	MSFT	Stock	26.77	26.86	26.71	26.86	21778.0
2013-01-07 09:00:00	MSFT	Stock	26.81	26.85	26.74	26.75	77058.0
2013-01-07 09:30:00	MSFT	Stock	26.77	26.79	26.64	26.65	6222660.0
2013-01-07 10:00:00	MSFT	Stock	26.66	26.8	26.64	26.8	3858234.0
2013-01-07 10:30:00	MSFT	Stock	26.795	26.88	26.77	26.77	2802384.0
2013-01-07 11:00:00	MSFT	Stock	26.772	26.84	26.77	26.805	2186109.0
2013-01-07 11:30:00	MSFT	Stock	26.81	26.82	26.72	26.75	1907663.0
2013-01-07 12:00:00	MSFT	Stock	26.75	26.79	26.73	26.758	1983519.0
2013-01-07 12:30:00	MSFT	Stock	26.757	26.78	26.75	26.77	1980026.0
2013-01-07 13:00:00	MSFT	Stock	26.77	26.79	26.76	26.775	1439413.0
2013-01-07 13:30:00	MSFT	Stock	26.78	26.78	26.72	26.74	1664697.0
2013-01-07 14:00:00	MSFT	Stock	26.735	26.75	26.7	26.72	1955262.0

> showing 50 of 77,342 rows — these rows as CSV

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