PREVIEW / stock_30min / 2013-02-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-13.parquet
  size:    1.4 MB
  rows:    75,829
  symbols: 3,476

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
2013-02-13 04:30:00	AAPL	Stock	16.7071	16.7071	16.7071	16.7071	5600.0
2013-02-13 06:30:00	AAPL	Stock	16.6793	16.6793	16.6686	16.6786	83020.0
2013-02-13 07:00:00	AAPL	Stock	16.6961	16.7321	16.6786	16.7079	142408.0
2013-02-13 07:30:00	AAPL	Stock	16.7189	16.7496	16.6954	16.6954	183064.0
2013-02-13 08:00:00	AAPL	Stock	16.6957	16.7482	16.6786	16.7357	1584296.0
2013-02-13 08:30:00	AAPL	Stock	16.7307	16.7464	16.6486	16.6736	1883364.0
2013-02-13 09:00:00	AAPL	Stock	16.6754	16.7054	16.6704	16.6707	1301356.0
2013-02-13 09:30:00	AAPL	Stock	16.6861	16.8529	16.5436	16.8379	94921848.0
2013-02-13 10:00:00	AAPL	Stock	16.8443	16.8511	16.7214	16.7996	49694344.0
2013-02-13 10:30:00	AAPL	Stock	16.7996	16.9139	16.7446	16.9096	45983924.0
2013-02-13 11:00:00	AAPL	Stock	16.9118	16.9157	16.7596	16.7654	31268972.0
2013-02-13 11:30:00	AAPL	Stock	16.7632	16.7993	16.7029	16.7357	25276132.0
2013-02-13 12:00:00	AAPL	Stock	16.7379	16.7836	16.6875	16.7736	23077432.0
2013-02-13 12:30:00	AAPL	Stock	16.7739	16.8005	16.6214	16.6279	32216380.0
2013-02-13 13:00:00	AAPL	Stock	16.6246	16.7129	16.6218	16.6689	18716768.0
2013-02-13 13:30:00	AAPL	Stock	16.6661	16.7618	16.6661	16.7469	15202908.0
2013-02-13 14:00:00	AAPL	Stock	16.7507	16.7696	16.6318	16.6554	19673220.0
2013-02-13 14:30:00	AAPL	Stock	16.6514	16.6889	16.625	16.6486	19930624.0
2013-02-13 15:00:00	AAPL	Stock	16.6482	16.6889	16.6286	16.6646	19647096.0
2013-02-13 15:30:00	AAPL	Stock	16.6696	16.6786	16.6025	16.6786	36152368.0
2013-02-13 16:00:00	AAPL	Stock	16.6789	16.8288	16.6725	16.6821	19159420.0
2013-02-13 16:30:00	AAPL	Stock	16.6925	16.6954	16.6656	16.6732	440748.0
2013-02-13 17:00:00	AAPL	Stock	16.6721	16.6786	16.6629	16.6786	98840.0
2013-02-13 17:30:00	AAPL	Stock	16.6786	16.6911	16.6761	16.6796	140560.0
2013-02-13 18:00:00	AAPL	Stock	16.6818	16.6821	16.6739	16.6739	43400.0
2013-02-13 18:30:00	AAPL	Stock	16.675	16.6764	16.675	16.6764	16184.0
2013-02-13 19:00:00	AAPL	Stock	16.6714	16.675	16.6714	16.6732	21056.0
2013-02-13 19:30:00	AAPL	Stock	16.6714	16.6714	16.6436	16.6611	236264.0
2013-02-13 08:00:00	MSFT	Stock	27.91	27.93	27.82	27.93	14508.0
2013-02-13 08:30:00	MSFT	Stock	27.93	27.93	27.88	27.93	79221.0
2013-02-13 09:00:00	MSFT	Stock	27.92	28.0	27.9	27.95	39920.0
2013-02-13 09:30:00	MSFT	Stock	27.93	27.98	27.88	27.962	4348154.0
2013-02-13 10:00:00	MSFT	Stock	27.97	28.11	27.97	28.06	7354626.0
2013-02-13 10:30:00	MSFT	Stock	28.06	28.075	28.0	28.04	3952908.0
2013-02-13 11:00:00	MSFT	Stock	28.04	28.07	27.92	27.96	4746066.0
2013-02-13 11:30:00	MSFT	Stock	27.955	27.97	27.905	27.94	2291418.0
2013-02-13 12:00:00	MSFT	Stock	27.95	27.96	27.92	27.955	1856498.0
2013-02-13 12:30:00	MSFT	Stock	27.95	28.02	27.93	27.98	1377206.0
2013-02-13 13:00:00	MSFT	Stock	27.98	28.04	27.96	28.04	1793928.0
2013-02-13 13:30:00	MSFT	Stock	28.03	28.07	28.01	28.025	2329214.0
2013-02-13 14:00:00	MSFT	Stock	28.035	28.08	28.02	28.06	2521624.0
2013-02-13 14:30:00	MSFT	Stock	28.055	28.06	27.995	28.01	2140932.0
2013-02-13 15:00:00	MSFT	Stock	28.01	28.02	27.97	28.0	1445741.0
2013-02-13 15:30:00	MSFT	Stock	28.005	28.04	27.96	28.02	3514587.0
2013-02-13 16:00:00	MSFT	Stock	28.03	28.06	27.969	28.02	1088457.0
2013-02-13 16:30:00	MSFT	Stock	28.03	28.04	27.998	28.04	13957.0
2013-02-13 17:00:00	MSFT	Stock	28.04	28.04	28.02	28.03	2300.0
2013-02-13 17:30:00	MSFT	Stock	28.0	28.0	27.98	28.0	1200.0
2013-02-13 18:30:00	MSFT	Stock	27.98	27.98	27.98	27.98	280.0
2013-02-13 19:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	250.0

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

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