PREVIEW / stock_30min / 2012-04-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-19.parquet
  size:    1.4 MB
  rows:    75,875
  symbols: 3,506

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
2012-04-19 04:00:00	AAPL	Stock	21.6818	21.75	21.6818	21.7482	33040.0
2012-04-19 04:30:00	AAPL	Stock	21.7421	21.7482	21.6764	21.6764	67620.0
2012-04-19 05:00:00	AAPL	Stock	21.6893	21.6893	21.6429	21.6429	32732.0
2012-04-19 05:30:00	AAPL	Stock	21.6361	21.7143	21.6357	21.7143	56000.0
2012-04-19 06:00:00	AAPL	Stock	21.7139	21.75	21.7139	21.75	46088.0
2012-04-19 06:30:00	AAPL	Stock	21.75	21.75	21.6982	21.7143	37800.0
2012-04-19 07:00:00	AAPL	Stock	21.7143	21.8214	21.6807	21.7143	825328.0
2012-04-19 07:30:00	AAPL	Stock	21.7046	21.7264	21.6518	21.7143	678356.0
2012-04-19 08:00:00	AAPL	Stock	21.7143	21.7854	21.6507	21.6521	2609432.0
2012-04-19 08:30:00	AAPL	Stock	21.6539	21.6607	21.3857	21.4211	7744464.0
2012-04-19 09:00:00	AAPL	Stock	21.4196	21.4607	21.4096	21.4311	7981092.0
2012-04-19 09:30:00	AAPL	Stock	21.4289	21.5976	21.2965	21.4475	122362688.0
2012-04-19 10:00:00	AAPL	Stock	21.4414	21.5089	21.2786	21.4586	81540424.0
2012-04-19 10:30:00	AAPL	Stock	21.4636	21.5489	21.3864	21.4789	49425068.0
2012-04-19 11:00:00	AAPL	Stock	21.4789	21.5404	21.4125	21.4354	31566332.0
2012-04-19 11:30:00	AAPL	Stock	21.4382	21.495	21.3868	21.4121	27350288.0
2012-04-19 12:00:00	AAPL	Stock	21.4164	21.4282	21.3143	21.3164	36854972.0
2012-04-19 12:30:00	AAPL	Stock	21.3154	21.3493	21.25	21.2768	43750084.0
2012-04-19 13:00:00	AAPL	Stock	21.2746	21.3439	21.25	21.2729	32345516.0
2012-04-19 13:30:00	AAPL	Stock	21.2679	21.3296	21.0221	21.0593	64312080.0
2012-04-19 14:00:00	AAPL	Stock	21.0525	21.1246	20.9286	20.9414	80184636.0
2012-04-19 14:30:00	AAPL	Stock	20.9482	21.1022	20.8757	21.0714	87478720.0
2012-04-19 15:00:00	AAPL	Stock	21.0711	21.1354	20.94	21.0175	61376644.0
2012-04-19 15:30:00	AAPL	Stock	21.0125	21.0439	20.9471	20.9982	77022204.0
2012-04-19 16:00:00	AAPL	Stock	20.9909	21.3264	20.9754	21.025	8254792.0
2012-04-19 16:30:00	AAPL	Stock	21.0246	21.0321	20.98	21.0179	779072.0
2012-04-19 17:00:00	AAPL	Stock	21.0254	21.0279	20.98	21.0071	449988.0
2012-04-19 17:30:00	AAPL	Stock	21.0071	21.0071	20.99	20.9982	322644.0
2012-04-19 18:00:00	AAPL	Stock	20.9996	21.0	20.9761	20.9818	285796.0
2012-04-19 18:30:00	AAPL	Stock	20.9768	20.9946	20.9768	20.9918	150472.0
2012-04-19 19:00:00	AAPL	Stock	20.9925	20.9925	20.9675	20.9682	234444.0
2012-04-19 19:30:00	AAPL	Stock	20.9696	20.9786	20.9339	20.9486	482244.0
2012-04-19 04:00:00	MSFT	Stock	31.22	31.22	31.22	31.22	100.0
2012-04-19 04:30:00	MSFT	Stock	31.22	31.27	31.22	31.27	500.0
2012-04-19 07:00:00	MSFT	Stock	31.25	31.25	31.1	31.1	3100.0
2012-04-19 07:30:00	MSFT	Stock	31.14	31.2	31.11	31.12	5110.0
2012-04-19 08:00:00	MSFT	Stock	31.18	31.19	31.09	31.14	11325.0
2012-04-19 08:30:00	MSFT	Stock	31.19	31.19	31.0	31.09	35113.0
2012-04-19 09:00:00	MSFT	Stock	31.1	31.19	31.03	31.14	12790.0
2012-04-19 09:30:00	MSFT	Stock	31.13	31.48	31.01	31.44	6327772.0
2012-04-19 10:00:00	MSFT	Stock	31.44	31.49	31.2	31.39	5169055.0
2012-04-19 10:30:00	MSFT	Stock	31.39	31.68	31.39	31.54	4452804.0
2012-04-19 11:00:00	MSFT	Stock	31.54	31.61	31.48	31.48	2317854.0
2012-04-19 11:30:00	MSFT	Stock	31.485	31.49	31.37	31.44	1817572.0
2012-04-19 12:00:00	MSFT	Stock	31.43	31.45	31.21	31.22	2725952.0
2012-04-19 12:30:00	MSFT	Stock	31.22	31.29	31.16	31.16	2307303.0
2012-04-19 13:00:00	MSFT	Stock	31.16	31.23	31.04	31.19	2728372.0
2012-04-19 13:30:00	MSFT	Stock	31.188	31.26	31.17	31.18	2259221.0
2012-04-19 14:00:00	MSFT	Stock	31.18	31.2	31.04	31.06	2586098.0
2012-04-19 14:30:00	MSFT	Stock	31.06	31.09	30.94	31.065	3713904.0

> showing 50 of 75,875 rows — these rows as CSV

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