PREVIEW / stock_30min / 2013-01-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-25.parquet
  size:    1.4 MB
  rows:    76,109
  symbols: 3,469

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-25 04:00:00	AAPL	Stock	16.0711	16.1929	16.0711	16.175	328356.0
2013-01-25 04:30:00	AAPL	Stock	16.1786	16.1964	16.1786	16.1964	70000.0
2013-01-25 05:00:00	AAPL	Stock	16.1839	16.1911	16.1657	16.1893	30940.0
2013-01-25 05:30:00	AAPL	Stock	16.1857	16.1857	16.125	16.1429	110320.0
2013-01-25 06:00:00	AAPL	Stock	16.1493	16.15	16.1357	16.1357	94444.0
2013-01-25 06:30:00	AAPL	Stock	16.1514	16.1679	16.125	16.1429	61600.0
2013-01-25 07:00:00	AAPL	Stock	16.1307	16.1775	16.1221	16.1486	674268.0
2013-01-25 07:30:00	AAPL	Stock	16.1486	16.1996	16.1486	16.1821	1276072.0
2013-01-25 08:00:00	AAPL	Stock	16.1871	16.2118	16.1161	16.1621	4625516.0
2013-01-25 08:30:00	AAPL	Stock	16.1704	16.1786	16.15	16.1696	1273720.0
2013-01-25 09:00:00	AAPL	Stock	16.1686	16.1686	16.0736	16.1286	4583628.0
2013-01-25 09:30:00	AAPL	Stock	16.1307	16.2939	16.0143	16.1704	161031108.0
2013-01-25 10:00:00	AAPL	Stock	16.1768	16.1982	15.9543	15.9564	78120896.0
2013-01-25 10:30:00	AAPL	Stock	15.9564	16.0104	15.8636	15.9202	94634680.0
2013-01-25 11:00:00	AAPL	Stock	15.92	15.9864	15.8929	15.9107	51142056.0
2013-01-25 11:30:00	AAPL	Stock	15.9118	15.9454	15.7346	15.7471	85243368.0
2013-01-25 12:00:00	AAPL	Stock	15.75	15.7986	15.6968	15.698	87678108.0
2013-01-25 12:30:00	AAPL	Stock	15.6993	15.7407	15.6182	15.6796	91146804.0
2013-01-25 13:00:00	AAPL	Stock	15.6793	15.7554	15.6471	15.7439	60517912.0
2013-01-25 13:30:00	AAPL	Stock	15.7432	15.9736	15.7375	15.9025	125189008.0
2013-01-25 14:00:00	AAPL	Stock	15.9054	15.9161	15.7775	15.875	51822148.0
2013-01-25 14:30:00	AAPL	Stock	15.875	15.9764	15.8571	15.9286	61824140.0
2013-01-25 15:00:00	AAPL	Stock	15.9286	15.9864	15.8214	15.9407	59420984.0
2013-01-25 15:30:00	AAPL	Stock	15.9407	15.9571	15.5357	15.7089	117488560.0
2013-01-25 16:00:00	AAPL	Stock	15.7089	15.9494	15.6404	15.7107	36935248.0
2013-01-25 16:30:00	AAPL	Stock	15.7107	16.0016	15.6804	15.6879	4036760.0
2013-01-25 17:00:00	AAPL	Stock	15.6875	15.7314	15.6875	15.725	1483104.0
2013-01-25 17:30:00	AAPL	Stock	15.7254	15.9243	15.7214	15.7214	510888.0
2013-01-25 18:00:00	AAPL	Stock	15.7214	15.7279	15.7	15.7182	222964.0
2013-01-25 18:30:00	AAPL	Stock	15.7271	15.7375	15.7254	15.7286	217784.0
2013-01-25 19:00:00	AAPL	Stock	15.7268	15.7354	15.7232	15.7346	95816.0
2013-01-25 19:30:00	AAPL	Stock	15.7339	15.75	15.7339	15.75	353472.0
2013-01-25 04:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	100.0
2013-01-25 05:30:00	MSFT	Stock	27.25	27.25	27.19	27.19	7170.0
2013-01-25 06:00:00	MSFT	Stock	27.35	27.35	27.35	27.35	220.0
2013-01-25 07:00:00	MSFT	Stock	27.21	27.36	27.21	27.36	5580.0
2013-01-25 07:30:00	MSFT	Stock	27.3	27.42	27.3	27.4	40000.0
2013-01-25 08:00:00	MSFT	Stock	27.37	27.45	27.25	27.4	188131.0
2013-01-25 08:30:00	MSFT	Stock	27.36	27.63	27.34	27.45	265415.0
2013-01-25 09:00:00	MSFT	Stock	27.45	27.59	27.37	27.59	339074.0
2013-01-25 09:30:00	MSFT	Stock	27.58	28.23	27.39	28.18	19863106.0
2013-01-25 10:00:00	MSFT	Stock	28.17	28.19	27.71	27.79	11731054.0
2013-01-25 10:30:00	MSFT	Stock	27.798	27.94	27.79	27.9	5788770.0
2013-01-25 11:00:00	MSFT	Stock	27.895	27.99	27.88	27.95	5548124.0
2013-01-25 11:30:00	MSFT	Stock	27.94	27.96	27.85	27.85	3354806.0
2013-01-25 12:00:00	MSFT	Stock	27.85	27.91	27.81	27.84	4235553.0
2013-01-25 12:30:00	MSFT	Stock	27.845	27.91	27.8	27.862	2175279.0
2013-01-25 13:00:00	MSFT	Stock	27.865	27.9	27.84	27.88	2086842.0
2013-01-25 13:30:00	MSFT	Stock	27.88	27.94	27.87	27.925	2973535.0
2013-01-25 14:00:00	MSFT	Stock	27.925	27.95	27.89	27.93	2564428.0

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

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