PREVIEW / stock_30min / 2011-08-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-02.parquet
  size:    1.5 MB
  rows:    76,188
  symbols: 3,517

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-08-02 04:00:00	AAPL	Stock	14.1343	14.1343	14.1343	14.1343	2800.0
2011-08-02 04:30:00	AAPL	Stock	14.1471	14.1471	14.1429	14.1429	11200.0
2011-08-02 05:00:00	AAPL	Stock	14.1343	14.1343	14.1279	14.1279	8400.0
2011-08-02 05:30:00	AAPL	Stock	14.1946	14.1961	14.1279	14.1279	22400.0
2011-08-02 06:00:00	AAPL	Stock	14.1286	14.1482	14.1286	14.1482	28000.0
2011-08-02 06:30:00	AAPL	Stock	14.1482	14.1482	14.1325	14.1425	20720.0
2011-08-02 07:00:00	AAPL	Stock	14.1529	14.1907	14.1357	14.1429	429212.0
2011-08-02 07:30:00	AAPL	Stock	14.1411	14.1554	14.1214	14.1554	199640.0
2011-08-02 08:00:00	AAPL	Stock	14.1518	14.1643	14.1071	14.11	1801044.0
2011-08-02 08:30:00	AAPL	Stock	14.1071	14.1643	14.0893	14.1593	1669948.0
2011-08-02 09:00:00	AAPL	Stock	14.1568	14.1996	14.1464	14.1964	1941240.0
2011-08-02 09:30:00	AAPL	Stock	14.2011	14.2107	14.1136	14.15	82062624.0
2011-08-02 10:00:00	AAPL	Stock	14.1493	14.1893	14.1204	14.1661	52034724.0
2011-08-02 10:30:00	AAPL	Stock	14.1646	14.1786	14.1161	14.1329	32791556.0
2011-08-02 11:00:00	AAPL	Stock	14.1329	14.14	14.0839	14.1082	39219628.0
2011-08-02 11:30:00	AAPL	Stock	14.1082	14.1286	14.0982	14.1226	23640036.0
2011-08-02 12:00:00	AAPL	Stock	14.1239	14.1511	14.1079	14.1482	21157444.0
2011-08-02 12:30:00	AAPL	Stock	14.1482	14.1489	14.025	14.0446	47945184.0
2011-08-02 13:00:00	AAPL	Stock	14.0439	14.0936	14.0393	14.0607	34132616.0
2011-08-02 13:30:00	AAPL	Stock	14.0633	14.0724	13.9068	13.9282	56521388.0
2011-08-02 14:00:00	AAPL	Stock	13.9296	14.0036	13.9246	13.9796	46201232.0
2011-08-02 14:30:00	AAPL	Stock	13.9768	14.0414	13.9346	14.0254	37193240.0
2011-08-02 15:00:00	AAPL	Stock	14.0232	14.0318	13.9404	13.9532	47525268.0
2011-08-02 15:30:00	AAPL	Stock	13.9532	13.98	13.8696	13.89	80712492.0
2011-08-02 16:00:00	AAPL	Stock	13.8836	14.0545	13.8779	13.8929	24526320.0
2011-08-02 16:30:00	AAPL	Stock	13.8929	14.1728	13.8843	13.8893	699524.0
2011-08-02 17:00:00	AAPL	Stock	13.8954	13.9211	13.8839	13.8911	637196.0
2011-08-02 17:30:00	AAPL	Stock	13.8914	13.9064	13.8896	13.8996	160412.0
2011-08-02 18:00:00	AAPL	Stock	13.8996	13.9	13.8879	13.9	318920.0
2011-08-02 18:30:00	AAPL	Stock	13.8939	13.9211	13.8932	13.9136	279216.0
2011-08-02 19:00:00	AAPL	Stock	13.9139	13.9232	13.9089	13.9232	198464.0
2011-08-02 19:30:00	AAPL	Stock	13.9164	13.9175	13.9082	13.9107	165424.0
2011-08-02 07:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	300.0
2011-08-02 07:30:00	MSFT	Stock	27.06	27.09	27.05	27.05	1200.0
2011-08-02 08:00:00	MSFT	Stock	27.09	27.1	27.0	27.0	9296.0
2011-08-02 08:30:00	MSFT	Stock	26.98	27.27	26.85	27.04	92793.0
2011-08-02 09:00:00	MSFT	Stock	27.04	27.07	26.89	26.92	28567.0
2011-08-02 09:30:00	MSFT	Stock	26.95	27.36	26.91	27.31	5720216.0
2011-08-02 10:00:00	MSFT	Stock	27.32	27.45	27.14	27.175	6754953.0
2011-08-02 10:30:00	MSFT	Stock	27.17	27.32	27.12	27.246	4007040.0
2011-08-02 11:00:00	MSFT	Stock	27.24	27.28	27.08	27.16	4682072.0
2011-08-02 11:30:00	MSFT	Stock	27.15	27.22	27.14	27.19	2984582.0
2011-08-02 12:00:00	MSFT	Stock	27.19	27.3	27.17	27.3	2523004.0
2011-08-02 12:30:00	MSFT	Stock	27.3	27.33	27.025	27.07	4758365.0
2011-08-02 13:00:00	MSFT	Stock	27.07	27.24	27.07	27.14	2649056.0
2011-08-02 13:30:00	MSFT	Stock	27.14	27.15	27.0	27.015	3718352.0
2011-08-02 14:00:00	MSFT	Stock	27.014	27.136	26.98	27.04	3253915.0
2011-08-02 14:30:00	MSFT	Stock	27.03	27.11	26.96	27.08	3127739.0
2011-08-02 15:00:00	MSFT	Stock	27.075	27.11	26.88	26.915	4343764.0
2011-08-02 15:30:00	MSFT	Stock	26.915	26.98	26.76	26.81	10484170.0

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

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