PREVIEW / stock_30min / 2012-10-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-24.parquet
  size:    1.4 MB
  rows:    73,766
  symbols: 3,462

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-10-24 04:30:00	AAPL	Stock	21.9732	22.0536	21.9732	22.04	11200.0
2012-10-24 06:00:00	AAPL	Stock	22.0357	22.0357	22.0286	22.0357	16800.0
2012-10-24 06:30:00	AAPL	Stock	22.0357	22.0379	22.0357	22.0379	8400.0
2012-10-24 07:00:00	AAPL	Stock	22.0357	22.0857	22.0357	22.0357	140616.0
2012-10-24 07:30:00	AAPL	Stock	22.0375	22.0586	21.9464	22.0189	639492.0
2012-10-24 08:00:00	AAPL	Stock	22.0189	22.0982	21.9536	22.0964	1552544.0
2012-10-24 08:30:00	AAPL	Stock	22.0982	22.0982	22.0243	22.0539	1136520.0
2012-10-24 09:00:00	AAPL	Stock	22.0575	22.2143	22.0536	22.1886	2787372.0
2012-10-24 09:30:00	AAPL	Stock	22.1964	22.3768	22.1436	22.3157	97707120.0
2012-10-24 10:00:00	AAPL	Stock	22.3096	22.3207	22.0289	22.0443	54024432.0
2012-10-24 10:30:00	AAPL	Stock	22.0432	22.0857	21.9407	21.9536	49780612.0
2012-10-24 11:00:00	AAPL	Stock	21.9568	22.0439	21.8929	22.0193	44548252.0
2012-10-24 11:30:00	AAPL	Stock	22.0214	22.0371	21.8518	21.8796	28893284.0
2012-10-24 12:00:00	AAPL	Stock	21.8797	21.9107	21.8086	21.8807	29529500.0
2012-10-24 12:30:00	AAPL	Stock	21.8757	22.0782	21.8757	22.0161	32198544.0
2012-10-24 13:00:00	AAPL	Stock	22.0051	22.0454	21.9214	21.9714	18430748.0
2012-10-24 13:30:00	AAPL	Stock	21.9729	22.0789	21.9286	22.0325	19481280.0
2012-10-24 14:00:00	AAPL	Stock	22.0375	22.0982	21.9464	22.0787	32677008.0
2012-10-24 14:30:00	AAPL	Stock	22.0829	22.2054	22.0571	22.1004	44920708.0
2012-10-24 15:00:00	AAPL	Stock	22.0911	22.1071	21.9604	22.0475	39274088.0
2012-10-24 15:30:00	AAPL	Stock	22.0489	22.0675	21.9557	22.0175	39227776.0
2012-10-24 16:00:00	AAPL	Stock	22.0189	22.0856	21.9221	22.0357	11213412.0
2012-10-24 16:30:00	AAPL	Stock	22.0357	22.0625	22.0171	22.0357	765436.0
2012-10-24 17:00:00	AAPL	Stock	22.0429	22.0439	22.0039	22.0175	490588.0
2012-10-24 17:30:00	AAPL	Stock	22.0143	22.0143	21.9471	21.9821	637896.0
2012-10-24 18:00:00	AAPL	Stock	21.9786	22.0121	21.9689	22.0	186816.0
2012-10-24 18:30:00	AAPL	Stock	21.9868	22.0	21.9721	21.9721	159292.0
2012-10-24 19:00:00	AAPL	Stock	21.9736	21.9754	21.9536	21.9539	273616.0
2012-10-24 19:30:00	AAPL	Stock	21.9646	21.9768	21.9643	21.965	219044.0
2012-10-24 05:00:00	MSFT	Stock	28.07	28.07	28.07	28.07	1000.0
2012-10-24 05:30:00	MSFT	Stock	28.07	28.07	28.07	28.07	300.0
2012-10-24 06:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	10600.0
2012-10-24 07:00:00	MSFT	Stock	28.1	28.1	27.94	28.05	2415.0
2012-10-24 07:30:00	MSFT	Stock	28.0	28.0	28.0	28.0	3100.0
2012-10-24 08:00:00	MSFT	Stock	28.0	28.14	28.0	28.14	17972.0
2012-10-24 08:30:00	MSFT	Stock	28.14	28.23	28.14	28.23	51830.0
2012-10-24 09:00:00	MSFT	Stock	28.21	28.23	28.15	28.17	52006.0
2012-10-24 09:30:00	MSFT	Stock	28.16	28.2	27.93	28.052	7601704.0
2012-10-24 10:00:00	MSFT	Stock	28.05	28.11	27.98	28.055	3264446.0
2012-10-24 10:30:00	MSFT	Stock	28.055	28.1	28.04	28.05	3495198.0
2012-10-24 11:00:00	MSFT	Stock	28.055	28.07	27.97	27.975	3194309.0
2012-10-24 11:30:00	MSFT	Stock	27.97	28.0	27.92	27.956	3264436.0
2012-10-24 12:00:00	MSFT	Stock	27.96	28.06	27.94	27.997	2459094.0
2012-10-24 12:30:00	MSFT	Stock	27.99	28.01	27.96	27.967	1391297.0
2012-10-24 13:00:00	MSFT	Stock	27.97	28.03	27.955	28.01	2835068.0
2012-10-24 13:30:00	MSFT	Stock	28.0	28.15	27.99	28.08	5514801.0
2012-10-24 14:00:00	MSFT	Stock	28.08	28.14	28.0	28.065	3650682.0
2012-10-24 14:30:00	MSFT	Stock	28.07	28.1	28.03	28.04	2871456.0
2012-10-24 15:00:00	MSFT	Stock	28.04	28.05	27.94	27.995	3062564.0
2012-10-24 15:30:00	MSFT	Stock	27.995	28.0	27.87	27.89	6917667.0

> showing 50 of 73,766 rows — these rows as CSV

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