PREVIEW / stock_30min / 2011-11-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-14.parquet
  size:    1.4 MB
  rows:    74,582
  symbols: 3,507

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
2011-11-14 04:30:00	AAPL	Stock	13.7857	13.7861	13.7857	13.7861	21560.0
2011-11-14 05:00:00	AAPL	Stock	13.7861	13.8179	13.7768	13.8179	48160.0
2011-11-14 05:30:00	AAPL	Stock	13.8625	13.8643	13.8211	13.8211	11872.0
2011-11-14 06:00:00	AAPL	Stock	13.7982	13.7982	13.7504	13.7504	13748.0
2011-11-14 07:00:00	AAPL	Stock	13.725	13.7486	13.7186	13.7232	114660.0
2011-11-14 07:30:00	AAPL	Stock	13.7	13.75	13.6914	13.75	384636.0
2011-11-14 08:00:00	AAPL	Stock	13.7357	13.7757	13.725	13.765	891464.0
2011-11-14 08:30:00	AAPL	Stock	13.7589	13.765	13.7286	13.7354	1184120.0
2011-11-14 09:00:00	AAPL	Stock	13.7321	13.7357	13.6464	13.7018	1232056.0
2011-11-14 09:30:00	AAPL	Stock	13.7061	13.7589	13.6046	13.6775	62178116.0
2011-11-14 10:00:00	AAPL	Stock	13.675	13.7343	13.6439	13.6504	42284144.0
2011-11-14 10:30:00	AAPL	Stock	13.6489	13.6764	13.5768	13.5775	35251832.0
2011-11-14 11:00:00	AAPL	Stock	13.5789	13.6364	13.5466	13.6043	46363548.0
2011-11-14 11:30:00	AAPL	Stock	13.6036	13.6518	13.5804	13.5892	21364728.0
2011-11-14 12:00:00	AAPL	Stock	13.5889	13.5968	13.5307	13.5589	33377288.0
2011-11-14 12:30:00	AAPL	Stock	13.5564	13.5646	13.5179	13.5575	23374932.0
2011-11-14 13:00:00	AAPL	Stock	13.5581	13.5864	13.5329	13.5843	16841440.0
2011-11-14 13:30:00	AAPL	Stock	13.5841	13.6061	13.5643	13.5842	16059148.0
2011-11-14 14:00:00	AAPL	Stock	13.586	13.5946	13.5503	13.5573	14275156.0
2011-11-14 14:30:00	AAPL	Stock	13.5568	13.5725	13.5229	13.525	32978680.0
2011-11-14 15:00:00	AAPL	Stock	13.5264	13.5643	13.5071	13.5557	26987688.0
2011-11-14 15:30:00	AAPL	Stock	13.5584	13.5779	13.5204	13.545	35451500.0
2011-11-14 16:00:00	AAPL	Stock	13.545	13.7364	13.5421	13.5607	14618240.0
2011-11-14 16:30:00	AAPL	Stock	13.545	13.6451	13.5423	13.5611	771680.0
2011-11-14 17:00:00	AAPL	Stock	13.5618	13.5636	13.555	13.5589	86884.0
2011-11-14 17:30:00	AAPL	Stock	13.5568	13.5589	13.5568	13.5586	20356.0
2011-11-14 18:00:00	AAPL	Stock	13.5568	13.5568	13.545	13.5514	136080.0
2011-11-14 18:30:00	AAPL	Stock	13.5518	13.5536	13.5504	13.5536	31024.0
2011-11-14 19:00:00	AAPL	Stock	13.5589	13.5589	13.5511	13.5514	19292.0
2011-11-14 19:30:00	AAPL	Stock	13.5582	13.5789	13.5582	13.5786	108668.0
2011-11-14 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2011-11-14 05:30:00	MSFT	Stock	27.06	27.06	27.06	27.06	100.0
2011-11-14 06:00:00	MSFT	Stock	26.87	26.87	26.76	26.76	200.0
2011-11-14 06:30:00	MSFT	Stock	26.9	26.9	26.87	26.87	1200.0
2011-11-14 07:00:00	MSFT	Stock	26.87	26.92	26.87	26.92	800.0
2011-11-14 07:30:00	MSFT	Stock	26.87	26.87	26.8	26.84	2300.0
2011-11-14 08:00:00	MSFT	Stock	26.85	26.89	26.83	26.89	6450.0
2011-11-14 08:30:00	MSFT	Stock	26.89	26.93	26.89	26.91	5032.0
2011-11-14 09:00:00	MSFT	Stock	26.91	26.92	26.81	26.88	26192.0
2011-11-14 09:30:00	MSFT	Stock	26.88	26.98	26.77	26.85	3034619.0
2011-11-14 10:00:00	MSFT	Stock	26.84	27.0	26.81	26.93	2577003.0
2011-11-14 10:30:00	MSFT	Stock	26.94	26.95	26.83	26.915	1901838.0
2011-11-14 11:00:00	MSFT	Stock	26.915	26.99	26.86	26.87	2182960.0
2011-11-14 11:30:00	MSFT	Stock	26.87	26.93	26.81	26.83	1783906.0
2011-11-14 12:00:00	MSFT	Stock	26.83	26.83	26.71	26.745	1792284.0
2011-11-14 12:30:00	MSFT	Stock	26.74	26.745	26.66	26.68	1787145.0
2011-11-14 13:00:00	MSFT	Stock	26.68	26.72	26.65	26.71	1290323.0
2011-11-14 13:30:00	MSFT	Stock	26.71	26.77	26.7	26.76	1565424.0
2011-11-14 14:00:00	MSFT	Stock	26.76	26.8	26.71	26.711	1772201.0
2011-11-14 14:30:00	MSFT	Stock	26.72	26.77	26.66	26.66	2374446.0

> showing 50 of 74,582 rows — these rows as CSV

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