PREVIEW / stock_30min / 2012-02-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-07.parquet
  size:    1.4 MB
  rows:    76,488
  symbols: 3,533

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-02-07 04:00:00	AAPL	Stock	16.6071	16.6071	16.6068	16.6071	25200.0
2012-02-07 04:30:00	AAPL	Stock	16.6068	16.6071	16.6068	16.6071	19600.0
2012-02-07 05:30:00	AAPL	Stock	16.62	16.62	16.62	16.62	2800.0
2012-02-07 06:00:00	AAPL	Stock	16.6071	16.6071	16.6071	16.6071	29512.0
2012-02-07 06:30:00	AAPL	Stock	16.5982	16.5982	16.5982	16.5982	33600.0
2012-02-07 07:00:00	AAPL	Stock	16.5907	16.5907	16.5589	16.5679	54488.0
2012-02-07 07:30:00	AAPL	Stock	16.5618	16.5961	16.5607	16.5714	110964.0
2012-02-07 08:00:00	AAPL	Stock	16.5854	16.6054	16.5357	16.6	320292.0
2012-02-07 08:30:00	AAPL	Stock	16.6032	16.6232	16.5786	16.5889	806988.0
2012-02-07 09:00:00	AAPL	Stock	16.5893	16.6368	16.5893	16.6161	927136.0
2012-02-07 09:30:00	AAPL	Stock	16.6239	16.675	16.5922	16.6285	52593856.0
2012-02-07 10:00:00	AAPL	Stock	16.6282	16.6671	16.6071	16.658	24986836.0
2012-02-07 10:30:00	AAPL	Stock	16.6579	16.6964	16.6275	16.6918	23836372.0
2012-02-07 11:00:00	AAPL	Stock	16.6939	16.7214	16.679	16.7168	23744476.0
2012-02-07 11:30:00	AAPL	Stock	16.7164	16.7654	16.7146	16.7517	27816572.0
2012-02-07 12:00:00	AAPL	Stock	16.7518	16.7736	16.7379	16.7531	16761752.0
2012-02-07 12:30:00	AAPL	Stock	16.7532	16.7679	16.7464	16.7625	12516112.0
2012-02-07 13:00:00	AAPL	Stock	16.7636	16.7675	16.7096	16.73	21515564.0
2012-02-07 13:30:00	AAPL	Stock	16.7305	16.7486	16.7261	16.7355	11721696.0
2012-02-07 14:00:00	AAPL	Stock	16.7357	16.7439	16.7196	16.7375	11829748.0
2012-02-07 14:30:00	AAPL	Stock	16.7371	16.7768	16.7329	16.7486	20942348.0
2012-02-07 15:00:00	AAPL	Stock	16.7489	16.7714	16.72	16.77	21325752.0
2012-02-07 15:30:00	AAPL	Stock	16.77	16.7711	16.7271	16.7432	33953808.0
2012-02-07 16:00:00	AAPL	Stock	16.7311	16.7446	16.6841	16.6841	4571644.0
2012-02-07 16:30:00	AAPL	Stock	16.7439	16.7651	16.7321	16.7393	583576.0
2012-02-07 17:00:00	AAPL	Stock	16.7389	16.7429	16.7389	16.7393	85568.0
2012-02-07 17:30:00	AAPL	Stock	16.7411	16.7446	16.7411	16.7443	11200.0
2012-02-07 18:00:00	AAPL	Stock	16.7375	16.7393	16.735	16.735	25368.0
2012-02-07 18:30:00	AAPL	Stock	16.7421	16.7421	16.7382	16.7421	45500.0
2012-02-07 19:00:00	AAPL	Stock	16.7425	16.7468	16.7418	16.7429	211232.0
2012-02-07 19:30:00	AAPL	Stock	16.7429	16.7446	16.7357	16.7379	144956.0
2012-02-07 04:30:00	MSFT	Stock	30.2	30.2	30.2	30.2	250.0
2012-02-07 05:30:00	MSFT	Stock	30.2	30.2	30.2	30.2	1200.0
2012-02-07 07:00:00	MSFT	Stock	30.13	30.15	30.1	30.1	1740.0
2012-02-07 07:30:00	MSFT	Stock	30.1	30.14	30.1	30.14	740.0
2012-02-07 08:00:00	MSFT	Stock	30.05	30.09	30.05	30.09	4839.0
2012-02-07 08:30:00	MSFT	Stock	30.14	30.19	30.09	30.09	3500.0
2012-02-07 09:00:00	MSFT	Stock	30.09	30.15	30.02	30.15	10566.0
2012-02-07 09:30:00	MSFT	Stock	30.11	30.2	30.05	30.132	4147365.0
2012-02-07 10:00:00	MSFT	Stock	30.14	30.15	30.06	30.07	3144389.0
2012-02-07 10:30:00	MSFT	Stock	30.07	30.32	30.05	30.31	3257704.0
2012-02-07 11:00:00	MSFT	Stock	30.315	30.41	30.27	30.39	3926334.0
2012-02-07 11:30:00	MSFT	Stock	30.398	30.46	30.38	30.448	3328867.0
2012-02-07 12:00:00	MSFT	Stock	30.448	30.485	30.43	30.44	2044392.0
2012-02-07 12:30:00	MSFT	Stock	30.44	30.48	30.42	30.453	1980773.0
2012-02-07 13:00:00	MSFT	Stock	30.45	30.48	30.4	30.43	1942512.0
2012-02-07 13:30:00	MSFT	Stock	30.43	30.48	30.4	30.47	1703079.0
2012-02-07 14:00:00	MSFT	Stock	30.47	30.48	30.42	30.42	1883079.0
2012-02-07 14:30:00	MSFT	Stock	30.42	30.44	30.29	30.3	2084730.0
2012-02-07 15:00:00	MSFT	Stock	30.305	30.43	30.3	30.425	2558642.0

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

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