PREVIEW / stock_30min / 2014-07-01

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-01.parquet
  size:    1.6 MB
  rows:    84,303
  symbols: 3,576

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-07-01 04:00:00	AAPL	Stock	23.345	23.345	23.275	23.275	4400.0
2014-07-01 04:30:00	AAPL	Stock	23.275	23.2925	23.275	23.2925	6008.0
2014-07-01 05:00:00	AAPL	Stock	23.3	23.3	23.3	23.3	632.0
2014-07-01 06:00:00	AAPL	Stock	23.3225	23.3625	23.3225	23.3625	7040.0
2014-07-01 06:30:00	AAPL	Stock	23.3625	23.3625	23.335	23.335	10420.0
2014-07-01 07:00:00	AAPL	Stock	23.335	23.3475	23.325	23.3375	26584.0
2014-07-01 07:30:00	AAPL	Stock	23.3425	23.35	23.3275	23.3275	43504.0
2014-07-01 08:00:00	AAPL	Stock	23.3275	23.36	23.2325	23.34	343416.0
2014-07-01 08:30:00	AAPL	Stock	23.3375	23.3825	23.3275	23.38	295064.0
2014-07-01 09:00:00	AAPL	Stock	23.38	23.4	23.3625	23.38	603132.0
2014-07-01 09:30:00	AAPL	Stock	23.38	23.445	23.2825	23.3875	24706408.0
2014-07-01 10:00:00	AAPL	Stock	23.3925	23.4762	23.3625	23.475	15455872.0
2014-07-01 10:30:00	AAPL	Stock	23.4738	23.49	23.4425	23.4525	10691312.0
2014-07-01 11:00:00	AAPL	Stock	23.455	23.4675	23.3925	23.415	9727320.0
2014-07-01 11:30:00	AAPL	Stock	23.415	23.4875	23.4	23.47	8413640.0
2014-07-01 12:00:00	AAPL	Stock	23.47	23.5	23.45	23.458	7291384.0
2014-07-01 12:30:00	AAPL	Stock	23.4592	23.4925	23.455	23.48	4802400.0
2014-07-01 13:00:00	AAPL	Stock	23.4788	23.5175	23.475	23.5175	8357080.0
2014-07-01 13:30:00	AAPL	Stock	23.5175	23.5175	23.4525	23.465	7508096.0
2014-07-01 14:00:00	AAPL	Stock	23.467	23.4725	23.43	23.46	6840144.0
2014-07-01 14:30:00	AAPL	Stock	23.4575	23.4625	23.41	23.4325	7433052.0
2014-07-01 15:00:00	AAPL	Stock	23.4325	23.45	23.395	23.425	7777140.0
2014-07-01 15:30:00	AAPL	Stock	23.425	23.4425	23.3775	23.38	13980816.0
2014-07-01 16:00:00	AAPL	Stock	23.38	23.435	23.1978	23.433	7084952.0
2014-07-01 16:30:00	AAPL	Stock	23.3875	23.3875	23.375	23.375	426624.0
2014-07-01 17:00:00	AAPL	Stock	23.4455	23.4455	23.355	23.3675	46072.0
2014-07-01 17:30:00	AAPL	Stock	23.3675	23.38	23.3625	23.38	71344.0
2014-07-01 18:00:00	AAPL	Stock	23.3825	23.3875	23.3725	23.385	47280.0
2014-07-01 18:30:00	AAPL	Stock	23.3875	23.3875	23.37	23.375	22772.0
2014-07-01 19:00:00	AAPL	Stock	23.385	23.395	23.37	23.3925	69688.0
2014-07-01 19:30:00	AAPL	Stock	23.3775	23.3975	23.3775	23.395	45868.0
2014-07-01 08:00:00	MSFT	Stock	41.7	42.0	41.7	41.89	3366.0
2014-07-01 08:30:00	MSFT	Stock	41.86	41.91	41.86	41.9	1058.0
2014-07-01 09:00:00	MSFT	Stock	41.89	41.93	41.7	41.85	27234.0
2014-07-01 09:30:00	MSFT	Stock	41.86	42.07	41.69	41.91	5101526.0
2014-07-01 10:00:00	MSFT	Stock	41.92	42.06	41.9	41.95	2375734.0
2014-07-01 10:30:00	MSFT	Stock	41.955	42.09	41.95	42.09	1126675.0
2014-07-01 11:00:00	MSFT	Stock	42.09	42.125	42.025	42.1	1343322.0
2014-07-01 11:30:00	MSFT	Stock	42.09	42.15	42.05	42.05	700568.0
2014-07-01 12:00:00	MSFT	Stock	42.05	42.09	41.97	41.97	844620.0
2014-07-01 12:30:00	MSFT	Stock	41.97	42.06	41.97	42.04	894901.0
2014-07-01 13:00:00	MSFT	Stock	42.04	42.07	42.03	42.05	1128155.0
2014-07-01 13:30:00	MSFT	Stock	42.055	42.09	42.0	42.02	952531.0
2014-07-01 14:00:00	MSFT	Stock	42.02	42.05	41.9	41.9	1042681.0
2014-07-01 14:30:00	MSFT	Stock	41.9	41.96	41.88	41.89	1048915.0
2014-07-01 15:00:00	MSFT	Stock	41.895	41.91	41.81	41.835	2313215.0
2014-07-01 15:30:00	MSFT	Stock	41.83	41.92	41.82	41.86	4492235.0
2014-07-01 16:00:00	MSFT	Stock	41.87	41.942	41.638	41.763	2283138.0
2014-07-01 16:30:00	MSFT	Stock	41.87	41.87	41.79	41.79	97111.0
2014-07-01 17:00:00	MSFT	Stock	41.926	41.926	41.926	41.926	259.0

> showing 50 of 84,303 rows — these rows as CSV

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