PREVIEW / stock_30min / 2011-02-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-18.parquet
  size:    1.4 MB
  rows:    75,725
  symbols: 3,539

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-02-18 04:00:00	AAPL	Stock	12.675	12.6786	12.6357	12.6436	87640.0
2011-02-18 04:30:00	AAPL	Stock	12.6789	12.6918	12.6768	12.6786	56000.0
2011-02-18 05:00:00	AAPL	Stock	12.6829	12.6829	12.6429	12.6429	33600.0
2011-02-18 05:30:00	AAPL	Stock	12.6589	12.6714	12.6357	12.6714	94360.0
2011-02-18 06:00:00	AAPL	Stock	12.6696	12.6786	12.6461	12.6521	26600.0
2011-02-18 06:30:00	AAPL	Stock	12.6686	12.7086	12.6686	12.6964	62300.0
2011-02-18 07:00:00	AAPL	Stock	12.7061	12.7811	12.7061	12.7725	673904.0
2011-02-18 07:30:00	AAPL	Stock	12.7796	12.7936	12.77	12.7861	356972.0
2011-02-18 08:00:00	AAPL	Stock	12.7861	12.8464	12.7829	12.8357	2188648.0
2011-02-18 08:30:00	AAPL	Stock	12.8321	12.8461	12.8286	12.8432	1273328.0
2011-02-18 09:00:00	AAPL	Stock	12.8461	12.8536	12.7975	12.7975	2756964.0
2011-02-18 09:30:00	AAPL	Stock	12.8004	12.8393	12.7554	12.77	61991692.0
2011-02-18 10:00:00	AAPL	Stock	12.77	12.7818	12.675	12.6879	70273672.0
2011-02-18 10:30:00	AAPL	Stock	12.687	12.6993	12.6232	12.6232	60046476.0
2011-02-18 11:00:00	AAPL	Stock	12.6234	12.6518	12.5818	12.6371	86910292.0
2011-02-18 11:30:00	AAPL	Stock	12.6364	12.6871	12.6332	12.6575	46345852.0
2011-02-18 12:00:00	AAPL	Stock	12.6564	12.6732	12.6446	12.6657	17226104.0
2011-02-18 12:30:00	AAPL	Stock	12.665	12.6661	12.6129	12.6293	29397228.0
2011-02-18 13:00:00	AAPL	Stock	12.6286	12.6296	12.5789	12.5843	34219080.0
2011-02-18 13:30:00	AAPL	Stock	12.5846	12.5846	12.525	12.5807	72177980.0
2011-02-18 14:00:00	AAPL	Stock	12.5793	12.5814	12.52	12.52	47639984.0
2011-02-18 14:30:00	AAPL	Stock	12.5204	12.5446	12.4889	12.5336	69627432.0
2011-02-18 15:00:00	AAPL	Stock	12.5336	12.5377	12.4829	12.5068	53333700.0
2011-02-18 15:30:00	AAPL	Stock	12.5071	12.5225	12.4961	12.52	91170296.0
2011-02-18 16:00:00	AAPL	Stock	12.5175	12.7289	12.5004	12.5036	15943928.0
2011-02-18 16:30:00	AAPL	Stock	12.5018	12.7876	12.5004	12.5039	1171744.0
2011-02-18 17:00:00	AAPL	Stock	12.5036	12.5071	12.4993	12.5	623112.0
2011-02-18 17:30:00	AAPL	Stock	12.5018	12.5036	12.4839	12.4893	450940.0
2011-02-18 18:00:00	AAPL	Stock	12.4839	12.52	12.4682	12.4779	790020.0
2011-02-18 18:30:00	AAPL	Stock	12.4729	12.4786	12.4296	12.4739	850892.0
2011-02-18 19:00:00	AAPL	Stock	12.4714	12.4732	12.4679	12.4679	150528.0
2011-02-18 19:30:00	AAPL	Stock	12.4664	12.4714	12.4639	12.4704	486024.0
2011-02-18 07:30:00	MSFT	Stock	27.28	27.29	27.27	27.27	1300.0
2011-02-18 08:00:00	MSFT	Stock	27.25	27.25	27.23	27.25	3101.0
2011-02-18 08:30:00	MSFT	Stock	27.21	27.25	27.21	27.25	455.0
2011-02-18 09:00:00	MSFT	Stock	27.24	27.24	27.12	27.14	173547.0
2011-02-18 09:30:00	MSFT	Stock	27.13	27.21	27.01	27.07	16161915.0
2011-02-18 10:00:00	MSFT	Stock	27.065	27.11	27.03	27.102	6212277.0
2011-02-18 10:30:00	MSFT	Stock	27.11	27.14	27.09	27.11	2685582.0
2011-02-18 11:00:00	MSFT	Stock	27.11	27.19	27.1	27.17	3813248.0
2011-02-18 11:30:00	MSFT	Stock	27.18	27.2	27.08	27.121	2955312.0
2011-02-18 12:00:00	MSFT	Stock	27.12	27.13	27.06	27.081	2643922.0
2011-02-18 12:30:00	MSFT	Stock	27.09	27.09	26.99	27.03	4031214.0
2011-02-18 13:00:00	MSFT	Stock	27.04	27.07	26.99	27.01	3683020.0
2011-02-18 13:30:00	MSFT	Stock	27.01	27.09	26.99	27.07	3185841.0
2011-02-18 14:00:00	MSFT	Stock	27.065	27.09	27.04	27.07	3482500.0
2011-02-18 14:30:00	MSFT	Stock	27.06	27.09	27.02	27.07	2591693.0
2011-02-18 15:00:00	MSFT	Stock	27.07	27.09	27.0	27.01	2831384.0
2011-02-18 15:30:00	MSFT	Stock	27.01	27.11	26.99	27.1	11034398.0
2011-02-18 16:00:00	MSFT	Stock	27.09	27.12	27.02	27.05	720443.0

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

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