PREVIEW / stock_30min / 2011-10-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-14.parquet
  size:    1.4 MB
  rows:    74,027
  symbols: 3,504

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-10-14 04:00:00	AAPL	Stock	14.7268	14.75	14.7193	14.7307	25200.0
2011-10-14 04:30:00	AAPL	Stock	14.7518	14.7714	14.75	14.7679	42560.0
2011-10-14 05:00:00	AAPL	Stock	14.7786	14.7786	14.7736	14.7786	25172.0
2011-10-14 05:30:00	AAPL	Stock	14.7843	14.8214	14.7843	14.8214	11200.0
2011-10-14 06:00:00	AAPL	Stock	14.8307	14.8307	14.8307	14.8307	2800.0
2011-10-14 06:30:00	AAPL	Stock	14.8379	14.8689	14.8379	14.8689	18760.0
2011-10-14 07:00:00	AAPL	Stock	14.8893	14.9554	14.8482	14.8707	609280.0
2011-10-14 07:30:00	AAPL	Stock	14.8714	14.8743	14.8	14.8514	1004556.0
2011-10-14 08:00:00	AAPL	Stock	14.8518	14.9286	14.8214	14.8929	4093488.0
2011-10-14 08:30:00	AAPL	Stock	14.8929	14.9464	14.8786	14.9286	4064284.0
2011-10-14 09:00:00	AAPL	Stock	14.9279	14.9361	14.8775	14.89	3214792.0
2011-10-14 09:30:00	AAPL	Stock	14.8868	14.9593	14.8396	14.8664	111099912.0
2011-10-14 10:00:00	AAPL	Stock	14.8661	14.9032	14.8311	14.8704	45836868.0
2011-10-14 10:30:00	AAPL	Stock	14.8691	14.9	14.8689	14.8861	28782544.0
2011-10-14 11:00:00	AAPL	Stock	14.8868	14.9029	14.845	14.8521	30111816.0
2011-10-14 11:30:00	AAPL	Stock	14.8525	14.8732	14.8425	14.8657	21795340.0
2011-10-14 12:00:00	AAPL	Stock	14.8643	14.8857	14.8532	14.8779	13049400.0
2011-10-14 12:30:00	AAPL	Stock	14.8757	14.9125	14.8732	14.8939	24899756.0
2011-10-14 13:00:00	AAPL	Stock	14.8964	14.9364	14.8943	14.9168	25373628.0
2011-10-14 13:30:00	AAPL	Stock	14.9164	14.9739	14.9146	14.9684	32329444.0
2011-10-14 14:00:00	AAPL	Stock	14.9679	14.9907	14.9564	14.9832	29305640.0
2011-10-14 14:30:00	AAPL	Stock	14.9836	15.01	14.9725	15.0075	38714060.0
2011-10-14 15:00:00	AAPL	Stock	15.0075	15.0179	14.9514	15.0161	41271776.0
2011-10-14 15:30:00	AAPL	Stock	15.0168	15.0714	14.9957	15.0714	80112900.0
2011-10-14 16:00:00	AAPL	Stock	15.0693	15.0818	14.9322	15.0625	27874000.0
2011-10-14 16:30:00	AAPL	Stock	15.0629	15.0714	14.9706	15.0607	1383508.0
2011-10-14 17:00:00	AAPL	Stock	15.0643	15.0661	15.0379	15.0536	1142260.0
2011-10-14 17:30:00	AAPL	Stock	15.0539	15.0571	15.0432	15.0464	414204.0
2011-10-14 18:00:00	AAPL	Stock	15.0511	15.0714	15.0411	15.045	558852.0
2011-10-14 18:30:00	AAPL	Stock	15.0489	15.0536	15.045	15.0536	103880.0
2011-10-14 19:00:00	AAPL	Stock	15.0489	15.06	15.0468	15.0557	354480.0
2011-10-14 19:30:00	AAPL	Stock	15.0621	15.0714	15.0554	15.0714	221368.0
2011-10-14 04:30:00	MSFT	Stock	27.17	27.17	27.17	27.17	1000.0
2011-10-14 07:00:00	MSFT	Stock	27.23	27.29	27.23	27.29	3400.0
2011-10-14 07:30:00	MSFT	Stock	27.26	27.27	27.26	27.27	700.0
2011-10-14 08:00:00	MSFT	Stock	27.27	27.39	27.23	27.37	30962.0
2011-10-14 08:30:00	MSFT	Stock	27.37	27.44	27.33	27.33	66423.0
2011-10-14 09:00:00	MSFT	Stock	27.34	27.39	27.18	27.26	54246.0
2011-10-14 09:30:00	MSFT	Stock	27.27	27.5	27.18	27.34	6710162.0
2011-10-14 10:00:00	MSFT	Stock	27.34	27.48	27.27	27.27	3488407.0
2011-10-14 10:30:00	MSFT	Stock	27.27	27.42	27.27	27.378	2154643.0
2011-10-14 11:00:00	MSFT	Stock	27.374	27.42	27.06	27.08	3142892.0
2011-10-14 11:30:00	MSFT	Stock	27.08	27.38	27.06	27.1	2667352.0
2011-10-14 12:00:00	MSFT	Stock	27.09	27.1	27.02	27.04	1816214.0
2011-10-14 12:30:00	MSFT	Stock	27.05	27.16	27.04	27.141	2596487.0
2011-10-14 13:00:00	MSFT	Stock	27.145	27.26	27.14	27.24	3191193.0
2011-10-14 13:30:00	MSFT	Stock	27.23	27.255	27.17	27.2	2358438.0
2011-10-14 14:00:00	MSFT	Stock	27.2	27.24	27.16	27.19	1901250.0
2011-10-14 14:30:00	MSFT	Stock	27.185	27.23	27.17	27.22	2235344.0
2011-10-14 15:00:00	MSFT	Stock	27.22	27.24	27.17	27.199	2561107.0

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

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