PREVIEW / stock_30min / 2012-10-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-26.parquet
  size:    1.4 MB
  rows:    72,756
  symbols: 3,465

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-26 04:00:00	AAPL	Stock	21.7143	21.7893	21.6429	21.7893	240184.0
2012-10-26 04:30:00	AAPL	Stock	21.7861	21.8393	21.7536	21.7857	349664.0
2012-10-26 05:00:00	AAPL	Stock	21.7889	21.7889	21.7857	21.7857	162400.0
2012-10-26 05:30:00	AAPL	Stock	21.7857	21.7861	21.7164	21.7729	148568.0
2012-10-26 06:00:00	AAPL	Stock	21.75	21.7504	21.7325	21.7496	120344.0
2012-10-26 06:30:00	AAPL	Stock	21.7496	21.7496	21.7446	21.7446	31892.0
2012-10-26 07:00:00	AAPL	Stock	21.7446	21.8393	21.7189	21.8125	1666812.0
2012-10-26 07:30:00	AAPL	Stock	21.81	21.8746	21.7857	21.8571	1950760.0
2012-10-26 08:00:00	AAPL	Stock	21.8236	21.8718	21.7325	21.8246	10221316.0
2012-10-26 08:30:00	AAPL	Stock	21.8457	21.8571	21.8046	21.8143	10093356.0
2012-10-26 09:00:00	AAPL	Stock	21.8096	21.8357	21.7368	21.7661	10316628.0
2012-10-26 09:30:00	AAPL	Stock	21.7661	21.9286	21.5604	21.7332	177871344.0
2012-10-26 10:00:00	AAPL	Stock	21.7332	21.8443	21.6829	21.7175	54746580.0
2012-10-26 10:30:00	AAPL	Stock	21.7179	21.7679	21.5614	21.5679	49509796.0
2012-10-26 11:00:00	AAPL	Stock	21.5632	21.5725	21.4429	21.5129	68755596.0
2012-10-26 11:30:00	AAPL	Stock	21.5104	21.5475	21.2857	21.3382	67695068.0
2012-10-26 12:00:00	AAPL	Stock	21.3325	21.3368	21.1071	21.1782	100995356.0
2012-10-26 12:30:00	AAPL	Stock	21.1768	21.3332	21.1357	21.3304	56644336.0
2012-10-26 13:00:00	AAPL	Stock	21.3307	21.4	21.2768	21.35	41539568.0
2012-10-26 13:30:00	AAPL	Stock	21.3493	21.6704	21.3282	21.6368	78062656.0
2012-10-26 14:00:00	AAPL	Stock	21.6368	21.7886	21.5646	21.7092	72614836.0
2012-10-26 14:30:00	AAPL	Stock	21.7032	21.7932	21.5982	21.6911	56757484.0
2012-10-26 15:00:00	AAPL	Stock	21.6911	21.7661	21.6754	21.7279	44997960.0
2012-10-26 15:30:00	AAPL	Stock	21.7304	21.7636	21.5343	21.5704	75493908.0
2012-10-26 16:00:00	AAPL	Stock	21.5714	21.7768	21.5029	21.5629	16781296.0
2012-10-26 16:30:00	AAPL	Stock	21.5643	21.7945	21.5593	21.5625	873572.0
2012-10-26 17:00:00	AAPL	Stock	21.5629	21.5664	21.5571	21.5596	302792.0
2012-10-26 17:30:00	AAPL	Stock	21.5582	21.5689	21.5482	21.5643	433384.0
2012-10-26 18:00:00	AAPL	Stock	21.5643	21.5643	21.5554	21.5557	66500.0
2012-10-26 18:30:00	AAPL	Stock	21.5604	21.5604	21.5464	21.5571	62692.0
2012-10-26 19:00:00	AAPL	Stock	21.5468	21.5632	21.5461	21.5496	50120.0
2012-10-26 19:30:00	AAPL	Stock	21.5486	21.5589	21.5468	21.5486	174804.0
2012-10-26 04:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	497.0
2012-10-26 06:30:00	MSFT	Stock	27.75	27.75	27.75	27.75	247.0
2012-10-26 07:00:00	MSFT	Stock	27.76	27.82	27.75	27.8	5200.0
2012-10-26 07:30:00	MSFT	Stock	27.8	27.8	27.8	27.8	3485.0
2012-10-26 08:00:00	MSFT	Stock	27.79	27.9	27.74	27.88	56240.0
2012-10-26 08:30:00	MSFT	Stock	27.88	28.0	27.86	27.88	43809.0
2012-10-26 09:00:00	MSFT	Stock	27.93	27.93	27.76	27.85	92851.0
2012-10-26 09:30:00	MSFT	Stock	27.86	28.05	27.84	27.96	6505362.0
2012-10-26 10:00:00	MSFT	Stock	27.97	28.05	27.945	27.96	3544150.0
2012-10-26 10:30:00	MSFT	Stock	27.96	28.02	27.92	27.98	4154174.0
2012-10-26 11:00:00	MSFT	Stock	27.98	28.09	27.95	28.09	2713420.0
2012-10-26 11:30:00	MSFT	Stock	28.08	28.12	28.01	28.01	2981047.0
2012-10-26 12:00:00	MSFT	Stock	28.01	28.02	27.95	27.998	4469467.0
2012-10-26 12:30:00	MSFT	Stock	27.99	28.06	27.972	28.059	1895961.0
2012-10-26 13:00:00	MSFT	Stock	28.05	28.07	27.95	28.01	3217326.0
2012-10-26 13:30:00	MSFT	Stock	28.01	28.09	28.0	28.05	2318639.0
2012-10-26 14:00:00	MSFT	Stock	28.05	28.14	28.0	28.12	3642185.0
2012-10-26 14:30:00	MSFT	Stock	28.12	28.18	28.1	28.18	3961120.0

> showing 50 of 72,756 rows — these rows as CSV

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