PREVIEW / stock_30min / 2014-08-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-06.parquet
  size:    1.6 MB
  rows:    83,018
  symbols: 3,550

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-08-06 04:00:00	AAPL	Stock	23.875	23.875	23.6225	23.7125	9640.0
2014-08-06 04:30:00	AAPL	Stock	23.7125	23.7125	23.6875	23.6875	7200.0
2014-08-06 05:00:00	AAPL	Stock	23.655	23.685	23.575	23.685	41712.0
2014-08-06 05:30:00	AAPL	Stock	23.6	23.63	23.6	23.63	6840.0
2014-08-06 06:00:00	AAPL	Stock	23.63	23.7	23.62	23.62	27420.0
2014-08-06 06:30:00	AAPL	Stock	23.615	23.65	23.59	23.595	18372.0
2014-08-06 07:00:00	AAPL	Stock	23.6225	23.7225	23.6	23.705	68640.0
2014-08-06 07:30:00	AAPL	Stock	23.72	23.7425	23.6975	23.7	44356.0
2014-08-06 08:00:00	AAPL	Stock	23.7075	23.7675	23.5925	23.6975	288236.0
2014-08-06 08:30:00	AAPL	Stock	23.6975	23.73	23.685	23.6975	235388.0
2014-08-06 09:00:00	AAPL	Stock	23.715	23.72	23.6775	23.6975	279708.0
2014-08-06 09:30:00	AAPL	Stock	23.6875	23.87	23.6775	23.72	22744012.0
2014-08-06 10:00:00	AAPL	Stock	23.72	23.7825	23.68	23.77	15067712.0
2014-08-06 10:30:00	AAPL	Stock	23.77	23.82	23.725	23.8052	10431428.0
2014-08-06 11:00:00	AAPL	Stock	23.805	23.8325	23.78	23.7805	9671304.0
2014-08-06 11:30:00	AAPL	Stock	23.7825	23.8075	23.7275	23.8025	8116232.0
2014-08-06 12:00:00	AAPL	Stock	23.805	23.815	23.725	23.735	7532416.0
2014-08-06 12:30:00	AAPL	Stock	23.735	23.7922	23.735	23.7712	5496588.0
2014-08-06 13:00:00	AAPL	Stock	23.7712	23.7975	23.73	23.7582	5761948.0
2014-08-06 13:30:00	AAPL	Stock	23.7575	23.78	23.7275	23.7375	5559680.0
2014-08-06 14:00:00	AAPL	Stock	23.74	23.7875	23.7	23.785	6290144.0
2014-08-06 14:30:00	AAPL	Stock	23.785	23.795	23.7425	23.775	5408396.0
2014-08-06 15:00:00	AAPL	Stock	23.775	23.8075	23.73	23.7825	7391652.0
2014-08-06 15:30:00	AAPL	Stock	23.78	23.7875	23.735	23.74	11277412.0
2014-08-06 16:00:00	AAPL	Stock	23.7425	23.779	23.725	23.7375	4885168.0
2014-08-06 16:30:00	AAPL	Stock	23.7375	23.75	23.7375	23.75	73572.0
2014-08-06 17:00:00	AAPL	Stock	23.745	23.755	23.7425	23.75	56736.0
2014-08-06 17:30:00	AAPL	Stock	23.7475	23.7475	23.725	23.74	75172.0
2014-08-06 18:00:00	AAPL	Stock	23.7375	23.7425	23.7225	23.7325	42560.0
2014-08-06 18:30:00	AAPL	Stock	23.725	23.7425	23.72	23.735	84980.0
2014-08-06 19:00:00	AAPL	Stock	23.735	23.75	23.7275	23.7325	116620.0
2014-08-06 19:30:00	AAPL	Stock	23.735	23.7525	23.735	23.7425	40836.0
2014-08-06 05:00:00	MSFT	Stock	42.82	42.82	42.81	42.81	850.0
2014-08-06 05:30:00	MSFT	Stock	42.85	42.85	42.6	42.61	1800.0
2014-08-06 06:00:00	MSFT	Stock	42.62	42.74	42.61	42.71	7130.0
2014-08-06 06:30:00	MSFT	Stock	42.65	42.7	42.65	42.7	2800.0
2014-08-06 07:00:00	MSFT	Stock	42.75	42.79	42.75	42.79	3500.0
2014-08-06 07:30:00	MSFT	Stock	42.72	42.79	42.71	42.71	2600.0
2014-08-06 08:00:00	MSFT	Stock	42.74	42.79	42.66	42.76	8567.0
2014-08-06 08:30:00	MSFT	Stock	42.75	42.79	42.72	42.72	8800.0
2014-08-06 09:00:00	MSFT	Stock	42.72	42.78	42.7	42.73	26958.0
2014-08-06 09:30:00	MSFT	Stock	42.75	42.75	42.21	42.653	4413594.0
2014-08-06 10:00:00	MSFT	Stock	42.66	42.86	42.65	42.858	1607398.0
2014-08-06 10:30:00	MSFT	Stock	42.855	43.09	42.77	43.07	1566088.0
2014-08-06 11:00:00	MSFT	Stock	43.06	43.1	42.87	42.875	1080612.0
2014-08-06 11:30:00	MSFT	Stock	42.875	43.15	42.83	43.125	1327659.0
2014-08-06 12:00:00	MSFT	Stock	43.13	43.15	42.96	43.0	953798.0
2014-08-06 12:30:00	MSFT	Stock	43.01	43.17	43.01	43.04	879775.0
2014-08-06 13:00:00	MSFT	Stock	43.04	43.09	42.9	42.975	1408277.0
2014-08-06 13:30:00	MSFT	Stock	42.98	43.01	42.82	42.848	1038427.0

> showing 50 of 83,018 rows — these rows as CSV

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