PREVIEW / stock_30min / 2013-10-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-30.parquet
  size:    1.5 MB
  rows:    80,581
  symbols: 3,535

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-10-30 04:30:00	AAPL	Stock	18.5679	18.5679	18.5679	18.5679	6440.0
2013-10-30 05:00:00	AAPL	Stock	18.5625	18.5625	18.5321	18.5321	14000.0
2013-10-30 05:30:00	AAPL	Stock	18.5321	18.5625	18.5321	18.5625	36372.0
2013-10-30 06:00:00	AAPL	Stock	18.5761	18.5779	18.5411	18.5696	56700.0
2013-10-30 06:30:00	AAPL	Stock	18.5679	18.5786	18.5421	18.575	99372.0
2013-10-30 07:00:00	AAPL	Stock	18.5714	18.5954	18.5464	18.5821	415940.0
2013-10-30 07:30:00	AAPL	Stock	18.5893	18.6	18.5179	18.5396	331128.0
2013-10-30 08:00:00	AAPL	Stock	18.5429	18.5893	18.5271	18.5668	1302840.0
2013-10-30 08:30:00	AAPL	Stock	18.5664	18.5789	18.5357	18.5707	1505812.0
2013-10-30 09:00:00	AAPL	Stock	18.5679	18.5782	18.5396	18.5464	1383592.0
2013-10-30 09:30:00	AAPL	Stock	18.5575	18.7282	18.465	18.7075	68292868.0
2013-10-30 10:00:00	AAPL	Stock	18.7093	18.7132	18.6093	18.6814	36905316.0
2013-10-30 10:30:00	AAPL	Stock	18.6796	18.8282	18.6775	18.8125	38475052.0
2013-10-30 11:00:00	AAPL	Stock	18.81	18.84	18.7571	18.7711	24640616.0
2013-10-30 11:30:00	AAPL	Stock	18.7693	18.7867	18.7043	18.7454	18716040.0
2013-10-30 12:00:00	AAPL	Stock	18.745	18.7818	18.7143	18.7554	14900620.0
2013-10-30 12:30:00	AAPL	Stock	18.7564	18.7786	18.6964	18.7696	14459396.0
2013-10-30 13:00:00	AAPL	Stock	18.7704	18.7818	18.7218	18.7218	9370060.0
2013-10-30 13:30:00	AAPL	Stock	18.7254	18.7489	18.7107	18.7343	8620108.0
2013-10-30 14:00:00	AAPL	Stock	18.7429	18.8036	18.5975	18.6586	32713072.0
2013-10-30 14:30:00	AAPL	Stock	18.66	18.7279	18.6539	18.71	18789568.0
2013-10-30 15:00:00	AAPL	Stock	18.7079	18.7286	18.6482	18.7195	15135120.0
2013-10-30 15:30:00	AAPL	Stock	18.7161	18.7639	18.704	18.7457	24987788.0
2013-10-30 16:00:00	AAPL	Stock	18.7479	18.7954	18.4909	18.7836	9192652.0
2013-10-30 16:30:00	AAPL	Stock	18.7821	18.7879	18.7025	18.7729	692888.0
2013-10-30 17:00:00	AAPL	Stock	18.7696	18.7718	18.7479	18.75	653156.0
2013-10-30 17:30:00	AAPL	Stock	18.7464	18.7496	18.7196	18.7321	319648.0
2013-10-30 18:00:00	AAPL	Stock	18.7225	18.7357	18.6807	18.6943	241332.0
2013-10-30 18:30:00	AAPL	Stock	18.6964	18.7021	18.6875	18.6875	101668.0
2013-10-30 19:00:00	AAPL	Stock	18.6789	18.7479	18.6607	18.6893	446040.0
2013-10-30 19:30:00	AAPL	Stock	18.6875	18.6875	18.6714	18.6786	502292.0
2013-10-30 05:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	100.0
2013-10-30 05:30:00	MSFT	Stock	35.68	35.68	35.68	35.68	100.0
2013-10-30 07:00:00	MSFT	Stock	35.68	35.71	35.68	35.68	8200.0
2013-10-30 07:30:00	MSFT	Stock	35.67	35.67	35.67	35.67	2000.0
2013-10-30 08:00:00	MSFT	Stock	35.68	35.68	35.62	35.62	13255.0
2013-10-30 08:30:00	MSFT	Stock	35.52	35.63	35.52	35.6	3290.0
2013-10-30 09:00:00	MSFT	Stock	35.6	35.61	35.52	35.59	57611.0
2013-10-30 09:30:00	MSFT	Stock	35.53	35.69	35.53	35.65	3973351.0
2013-10-30 10:00:00	MSFT	Stock	35.64	35.675	35.58	35.636	1939856.0
2013-10-30 10:30:00	MSFT	Stock	35.635	35.79	35.62	35.695	2555091.0
2013-10-30 11:00:00	MSFT	Stock	35.695	35.74	35.49	35.595	3121435.0
2013-10-30 11:30:00	MSFT	Stock	35.595	35.61	35.53	35.555	1497647.0
2013-10-30 12:00:00	MSFT	Stock	35.56	35.67	35.55	35.585	2187439.0
2013-10-30 12:30:00	MSFT	Stock	35.58	35.689	35.56	35.68	1764798.0
2013-10-30 13:00:00	MSFT	Stock	35.67	35.68	35.59	35.61	751340.0
2013-10-30 13:30:00	MSFT	Stock	35.61	35.69	35.59	35.67	1446326.0
2013-10-30 14:00:00	MSFT	Stock	35.665	35.78	35.43	35.54	3221870.0
2013-10-30 14:30:00	MSFT	Stock	35.54	35.63	35.51	35.6	2029858.0
2013-10-30 15:00:00	MSFT	Stock	35.6	35.73	35.6	35.65	3147534.0

> showing 50 of 80,581 rows — these rows as CSV

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