PREVIEW / stock_30min / 2014-03-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-10.parquet
  size:    1.6 MB
  rows:    81,902
  symbols: 3,527

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
2014-03-10 04:00:00	AAPL	Stock	18.9089	18.9107	18.9089	18.9107	5600.0
2014-03-10 05:30:00	AAPL	Stock	18.9421	18.9421	18.9421	18.9421	2800.0
2014-03-10 06:30:00	AAPL	Stock	18.9304	18.9304	18.9304	18.9304	2800.0
2014-03-10 07:30:00	AAPL	Stock	18.9286	18.9429	18.9286	18.9321	17780.0
2014-03-10 08:00:00	AAPL	Stock	18.9196	18.9425	18.895	18.895	184856.0
2014-03-10 08:30:00	AAPL	Stock	18.9007	18.9007	18.8707	18.8732	407288.0
2014-03-10 09:00:00	AAPL	Stock	18.8764	18.8946	18.86	18.8789	413560.0
2014-03-10 09:30:00	AAPL	Stock	18.87	19.0325	18.8692	19.0095	30262428.0
2014-03-10 10:00:00	AAPL	Stock	19.0129	19.0132	18.9257	18.9596	14533848.0
2014-03-10 10:30:00	AAPL	Stock	18.9689	18.9818	18.9286	18.9351	10974768.0
2014-03-10 11:00:00	AAPL	Stock	18.9379	19.0232	18.9071	19.0046	13064212.0
2014-03-10 11:30:00	AAPL	Stock	19.0039	19.0475	18.9954	19.0136	10979584.0
2014-03-10 12:00:00	AAPL	Stock	19.0136	19.0354	19.0011	19.025	5580876.0
2014-03-10 12:30:00	AAPL	Stock	19.0243	19.0254	18.9739	19.0246	7511280.0
2014-03-10 13:00:00	AAPL	Stock	19.0232	19.0321	18.9818	18.9858	5731992.0
2014-03-10 13:30:00	AAPL	Stock	18.9875	18.9918	18.9493	18.9704	7394996.0
2014-03-10 14:00:00	AAPL	Stock	18.9671	18.9818	18.94	18.9796	5727120.0
2014-03-10 14:30:00	AAPL	Stock	18.9761	18.9996	18.9596	18.9811	6000596.0
2014-03-10 15:00:00	AAPL	Stock	18.9821	18.9829	18.9532	18.9711	5871544.0
2014-03-10 15:30:00	AAPL	Stock	18.9664	18.9957	18.9486	18.9614	15622992.0
2014-03-10 16:00:00	AAPL	Stock	18.9614	19.0082	18.9336	18.9464	6088740.0
2014-03-10 16:30:00	AAPL	Stock	18.9464	18.9614	18.9379	18.955	77476.0
2014-03-10 17:00:00	AAPL	Stock	18.9532	18.9614	18.9532	18.9614	112420.0
2014-03-10 17:30:00	AAPL	Stock	18.9464	18.9571	18.9379	18.9571	13860.0
2014-03-10 18:30:00	AAPL	Stock	18.9429	18.9614	18.9429	18.9614	105868.0
2014-03-10 19:00:00	AAPL	Stock	18.9518	18.9518	18.9518	18.9518	2800.0
2014-03-10 19:30:00	AAPL	Stock	18.9457	18.9464	18.9375	18.9375	40684.0
2014-03-10 06:30:00	MSFT	Stock	37.84	37.84	37.78	37.78	487.0
2014-03-10 07:30:00	MSFT	Stock	37.75	37.75	37.75	37.75	2700.0
2014-03-10 08:00:00	MSFT	Stock	37.82	37.86	37.81	37.86	995.0
2014-03-10 08:30:00	MSFT	Stock	37.88	37.88	37.76	37.8	3200.0
2014-03-10 09:00:00	MSFT	Stock	37.82	37.97	37.79	37.97	5195.0
2014-03-10 09:30:00	MSFT	Stock	37.99	38.01	37.794	37.898	1587771.0
2014-03-10 10:00:00	MSFT	Stock	37.89	37.9	37.76	37.785	1337625.0
2014-03-10 10:30:00	MSFT	Stock	37.79	37.84	37.72	37.83	2068159.0
2014-03-10 11:00:00	MSFT	Stock	37.82	37.875	37.79	37.84	1105135.0
2014-03-10 11:30:00	MSFT	Stock	37.84	37.88	37.78	37.819	766059.0
2014-03-10 12:00:00	MSFT	Stock	37.81	37.89	37.78	37.87	1068213.0
2014-03-10 12:30:00	MSFT	Stock	37.87	37.88	37.815	37.87	841493.0
2014-03-10 13:00:00	MSFT	Stock	37.87	37.9	37.83	37.83	623979.0
2014-03-10 13:30:00	MSFT	Stock	37.83	37.84	37.77	37.81	1052716.0
2014-03-10 14:00:00	MSFT	Stock	37.81	37.84	37.8	37.83	605562.0
2014-03-10 14:30:00	MSFT	Stock	37.83	37.85	37.81	37.83	543689.0
2014-03-10 15:00:00	MSFT	Stock	37.83	37.84	37.8	37.826	1045464.0
2014-03-10 15:30:00	MSFT	Stock	37.83	37.895	37.79	37.82	2696622.0
2014-03-10 16:00:00	MSFT	Stock	37.81	37.85	37.81	37.82	2939190.0
2014-03-10 16:30:00	MSFT	Stock	37.82	37.94	37.82	37.94	9755.0
2014-03-10 17:00:00	MSFT	Stock	37.81	37.83	37.81	37.83	47587.0
2014-03-10 17:30:00	MSFT	Stock	37.83	37.83	37.83	37.83	100.0
2014-03-10 19:30:00	MSFT	Stock	37.82	37.82	37.81	37.81	1070.0

> showing 50 of 81,902 rows — these rows as CSV

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