PREVIEW / stock_30min / 2012-03-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-21.parquet
  size:    1.4 MB
  rows:    76,610
  symbols: 3,511

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-03-21 04:00:00	AAPL	Stock	21.6679	21.6932	21.6679	21.6721	100800.0
2012-03-21 04:30:00	AAPL	Stock	21.6786	21.6786	21.65	21.6571	19600.0
2012-03-21 05:00:00	AAPL	Stock	21.6607	21.6607	21.6146	21.6146	33740.0
2012-03-21 05:30:00	AAPL	Stock	21.6196	21.6196	21.5964	21.6196	11200.0
2012-03-21 06:00:00	AAPL	Stock	21.6107	21.6107	21.6075	21.6075	11172.0
2012-03-21 06:30:00	AAPL	Stock	21.6196	21.6196	21.6018	21.6018	5600.0
2012-03-21 07:00:00	AAPL	Stock	21.5982	21.6339	21.5611	21.5714	215936.0
2012-03-21 07:30:00	AAPL	Stock	21.5625	21.5793	21.5464	21.5789	404908.0
2012-03-21 08:00:00	AAPL	Stock	21.5721	21.6414	21.5025	21.5446	4340420.0
2012-03-21 08:30:00	AAPL	Stock	21.5514	21.5621	21.4682	21.4929	4503128.0
2012-03-21 09:00:00	AAPL	Stock	21.4993	21.5357	21.4896	21.5354	2994992.0
2012-03-21 09:30:00	AAPL	Stock	21.5357	21.6732	21.4789	21.6504	108228624.0
2012-03-21 10:00:00	AAPL	Stock	21.6554	21.6964	21.5968	21.6518	53837196.0
2012-03-21 10:30:00	AAPL	Stock	21.6518	21.7107	21.6179	21.6404	49444304.0
2012-03-21 11:00:00	AAPL	Stock	21.6374	21.7	21.6107	21.6871	32974704.0
2012-03-21 11:30:00	AAPL	Stock	21.685	21.6882	21.6289	21.6404	27721064.0
2012-03-21 12:00:00	AAPL	Stock	21.6389	21.6811	21.6371	21.6629	19267836.0
2012-03-21 12:30:00	AAPL	Stock	21.6637	21.7054	21.6539	21.6989	23411388.0
2012-03-21 13:00:00	AAPL	Stock	21.6979	21.6996	21.6571	21.6804	20081124.0
2012-03-21 13:30:00	AAPL	Stock	21.6786	21.7407	21.6632	21.7234	29037176.0
2012-03-21 14:00:00	AAPL	Stock	21.7239	21.7643	21.7179	21.7484	36280524.0
2012-03-21 14:30:00	AAPL	Stock	21.7485	21.7711	21.7179	21.7557	29208816.0
2012-03-21 15:00:00	AAPL	Stock	21.7568	21.7732	21.7318	21.75	32839016.0
2012-03-21 15:30:00	AAPL	Stock	21.75	21.7568	21.5179	21.5179	118170416.0
2012-03-21 16:00:00	AAPL	Stock	21.5179	21.6611	21.5164	21.5286	32868892.0
2012-03-21 16:30:00	AAPL	Stock	21.5268	21.7539	21.5179	21.5371	5896128.0
2012-03-21 17:00:00	AAPL	Stock	21.5361	21.5482	21.5179	21.5429	1006684.0
2012-03-21 17:30:00	AAPL	Stock	21.5429	21.5504	21.5364	21.5464	823620.0
2012-03-21 18:00:00	AAPL	Stock	21.5475	21.5568	21.5393	21.5554	255584.0
2012-03-21 18:30:00	AAPL	Stock	21.5554	21.5704	21.5554	21.5643	276780.0
2012-03-21 19:00:00	AAPL	Stock	21.5636	21.5671	21.5611	21.5611	332920.0
2012-03-21 19:30:00	AAPL	Stock	21.5611	21.5661	21.5571	21.5629	526680.0
2012-03-21 07:00:00	MSFT	Stock	32.06	32.06	32.0	32.0	5437.0
2012-03-21 07:30:00	MSFT	Stock	32.0	32.05	32.0	32.05	1400.0
2012-03-21 08:00:00	MSFT	Stock	32.0	32.06	31.99	32.0	83152.0
2012-03-21 08:30:00	MSFT	Stock	32.0	32.02	32.0	32.01	17271.0
2012-03-21 09:00:00	MSFT	Stock	32.03	32.04	31.92	31.99	14899.0
2012-03-21 09:30:00	MSFT	Stock	31.98	32.15	31.94	31.99	5162949.0
2012-03-21 10:00:00	MSFT	Stock	31.99	32.01	31.87	31.923	2626620.0
2012-03-21 10:30:00	MSFT	Stock	31.92	32.01	31.905	31.926	1634352.0
2012-03-21 11:00:00	MSFT	Stock	31.92	31.94	31.85	31.87	1743299.0
2012-03-21 11:30:00	MSFT	Stock	31.87	31.92	31.82	31.83	1566163.0
2012-03-21 12:00:00	MSFT	Stock	31.83	31.938	31.82	31.925	1633882.0
2012-03-21 12:30:00	MSFT	Stock	31.925	32.02	31.89	32.005	1688768.0
2012-03-21 13:00:00	MSFT	Stock	32.005	32.03	31.91	32.02	2619678.0
2012-03-21 13:30:00	MSFT	Stock	32.02	32.03	31.94	31.985	1439119.0
2012-03-21 14:00:00	MSFT	Stock	31.99	32.03	31.97	31.99	1884742.0
2012-03-21 14:30:00	MSFT	Stock	32.0	32.04	31.98	31.995	1952720.0
2012-03-21 15:00:00	MSFT	Stock	32.0	32.1	31.99	32.07	2163904.0
2012-03-21 15:30:00	MSFT	Stock	32.07	32.075	31.91	31.935	4872670.0

> showing 50 of 76,610 rows — these rows as CSV

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