PREVIEW / stock_30min / 2013-04-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-23.parquet
  size:    1.5 MB
  rows:    77,763
  symbols: 3,477

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-04-23 04:00:00	AAPL	Stock	14.2643	14.2643	14.2289	14.2289	11928.0
2013-04-23 04:30:00	AAPL	Stock	14.2382	14.2382	14.2143	14.2282	152936.0
2013-04-23 05:00:00	AAPL	Stock	14.2382	14.2429	14.2321	14.2429	33600.0
2013-04-23 06:00:00	AAPL	Stock	14.2711	14.2711	14.2711	14.2711	2800.0
2013-04-23 06:30:00	AAPL	Stock	14.275	14.275	14.275	14.275	2800.0
2013-04-23 07:00:00	AAPL	Stock	14.2857	14.4107	14.2857	14.3625	401772.0
2013-04-23 07:30:00	AAPL	Stock	14.3571	14.4446	14.3564	14.405	1132544.0
2013-04-23 08:00:00	AAPL	Stock	14.3943	14.4286	14.3218	14.375	1489488.0
2013-04-23 08:30:00	AAPL	Stock	14.3689	14.4107	14.3571	14.3886	970788.0
2013-04-23 09:00:00	AAPL	Stock	14.3843	14.4357	14.3414	14.4275	3384472.0
2013-04-23 09:30:00	AAPL	Stock	14.4275	14.4732	14.2593	14.3279	75694668.0
2013-04-23 10:00:00	AAPL	Stock	14.3246	14.3846	14.2432	14.3196	34608084.0
2013-04-23 10:30:00	AAPL	Stock	14.3228	14.4507	14.295	14.4364	35955192.0
2013-04-23 11:00:00	AAPL	Stock	14.4389	14.4839	14.4025	14.4729	32420276.0
2013-04-23 11:30:00	AAPL	Stock	14.4696	14.5093	14.4536	14.4954	19984944.0
2013-04-23 12:00:00	AAPL	Stock	14.4954	14.5534	14.4721	14.5426	26922196.0
2013-04-23 12:30:00	AAPL	Stock	14.5442	14.5536	14.4614	14.4948	22585164.0
2013-04-23 13:00:00	AAPL	Stock	14.495	14.5268	14.3571	14.4714	35600572.0
2013-04-23 13:30:00	AAPL	Stock	14.4741	14.5111	14.4414	14.4891	13819820.0
2013-04-23 14:00:00	AAPL	Stock	14.4893	14.5118	14.4307	14.4354	17089940.0
2013-04-23 14:30:00	AAPL	Stock	14.4307	14.4921	14.3968	14.485	22352764.0
2013-04-23 15:00:00	AAPL	Stock	14.4854	14.5725	14.4682	14.5714	38968132.0
2013-04-23 15:30:00	AAPL	Stock	14.5725	14.585	14.5002	14.5002	58900800.0
2013-04-23 16:00:00	AAPL	Stock	14.5002	14.5536	14.22	14.5	27236944.0
2013-04-23 16:30:00	AAPL	Stock	15.0071	15.3389	14.3929	15.2089	48967072.0
2013-04-23 17:00:00	AAPL	Stock	15.2093	15.3536	14.5046	15.0107	44602572.0
2013-04-23 17:30:00	AAPL	Stock	15.0107	15.0114	14.4086	14.5093	37063068.0
2013-04-23 18:00:00	AAPL	Stock	14.51	14.5679	14.3754	14.4364	13355804.0
2013-04-23 18:30:00	AAPL	Stock	14.4407	14.5357	14.4286	14.4679	3730720.0
2013-04-23 19:00:00	AAPL	Stock	14.4671	14.4893	14.4557	14.4714	1402072.0
2013-04-23 19:30:00	AAPL	Stock	14.4707	14.4714	14.4214	14.4268	2745512.0
2013-04-23 04:00:00	MSFT	Stock	30.9	30.9	30.9	30.9	1000.0
2013-04-23 06:30:00	MSFT	Stock	30.69	30.69	30.69	30.69	100.0
2013-04-23 07:00:00	MSFT	Stock	30.85	30.86	30.85	30.86	1800.0
2013-04-23 07:30:00	MSFT	Stock	30.88	30.9	30.88	30.9	3800.0
2013-04-23 08:00:00	MSFT	Stock	30.85	30.86	30.55	30.8	55114.0
2013-04-23 08:30:00	MSFT	Stock	30.8	30.8	30.74	30.74	6700.0
2013-04-23 09:00:00	MSFT	Stock	30.73	30.82	30.65	30.7	235006.0
2013-04-23 09:30:00	MSFT	Stock	30.7	30.81	30.64	30.78	7969703.0
2013-04-23 10:00:00	MSFT	Stock	30.77	30.9	30.74	30.784	5113227.0
2013-04-23 10:30:00	MSFT	Stock	30.785	30.81	30.75	30.75	3104491.0
2013-04-23 11:00:00	MSFT	Stock	30.755	30.82	30.7	30.81	3461844.0
2013-04-23 11:30:00	MSFT	Stock	30.8	30.85	30.77	30.828	3696800.0
2013-04-23 12:00:00	MSFT	Stock	30.825	30.84	30.77	30.801	3733173.0
2013-04-23 12:30:00	MSFT	Stock	30.801	30.81	30.77	30.78	1849230.0
2013-04-23 13:00:00	MSFT	Stock	30.78	30.8	30.38	30.775	7181758.0
2013-04-23 13:30:00	MSFT	Stock	30.775	30.82	30.76	30.785	1777608.0
2013-04-23 14:00:00	MSFT	Stock	30.785	30.8	30.6	30.605	3122295.0
2013-04-23 14:30:00	MSFT	Stock	30.6	30.69	30.59	30.66	2931855.0
2013-04-23 15:00:00	MSFT	Stock	30.665	30.71	30.64	30.665	3206250.0

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

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