PREVIEW / stock_30min / 2017-02-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-16.parquet
  size:    1.6 MB
  rows:    82,569
  symbols: 3,103

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
2017-02-16 04:00:00	AAPL	Stock	33.9125	33.925	33.9025	33.9025	4028.0
2017-02-16 04:30:00	AAPL	Stock	33.925	33.925	33.925	33.925	1024.0
2017-02-16 05:00:00	AAPL	Stock	33.925	33.925	33.925	33.925	552.0
2017-02-16 06:00:00	AAPL	Stock	33.8875	33.8975	33.885	33.895	6400.0
2017-02-16 06:30:00	AAPL	Stock	33.9025	33.9025	33.89	33.89	8136.0
2017-02-16 07:00:00	AAPL	Stock	33.885	33.925	33.885	33.925	9756.0
2017-02-16 07:30:00	AAPL	Stock	33.9225	34.005	33.8575	33.8575	139788.0
2017-02-16 08:00:00	AAPL	Stock	33.9025	33.9225	33.7875	33.835	155364.0
2017-02-16 08:30:00	AAPL	Stock	33.82	33.875	33.815	33.8475	107312.0
2017-02-16 09:00:00	AAPL	Stock	33.8675	33.9225	33.8	33.915	399688.0
2017-02-16 09:30:00	AAPL	Stock	33.9175	33.975	33.77	33.7835	15474548.0
2017-02-16 10:00:00	AAPL	Stock	33.7838	33.85	33.71	33.7825	8611160.0
2017-02-16 10:30:00	AAPL	Stock	33.7825	33.84	33.71	33.7625	7727044.0
2017-02-16 11:00:00	AAPL	Stock	33.7625	33.8125	33.7225	33.8065	5247072.0
2017-02-16 11:30:00	AAPL	Stock	33.81	33.8275	33.7725	33.8005	3434036.0
2017-02-16 12:00:00	AAPL	Stock	33.8	33.8625	33.7875	33.86	3548376.0
2017-02-16 12:30:00	AAPL	Stock	33.8588	33.8675	33.81	33.81	3094728.0
2017-02-16 13:00:00	AAPL	Stock	33.8125	33.8325	33.785	33.8165	2493988.0
2017-02-16 13:30:00	AAPL	Stock	33.8175	33.8275	33.7775	33.81	2293832.0
2017-02-16 14:00:00	AAPL	Stock	33.81	33.8452	33.775	33.8225	3034252.0
2017-02-16 14:30:00	AAPL	Stock	33.82	33.82	33.76	33.8112	3932852.0
2017-02-16 15:00:00	AAPL	Stock	33.8112	33.84	33.7775	33.7775	5397664.0
2017-02-16 15:30:00	AAPL	Stock	33.778	33.86	33.7775	33.8362	10329540.0
2017-02-16 16:00:00	AAPL	Stock	33.8362	33.8375	33.8075	33.8362	4825044.0
2017-02-16 16:30:00	AAPL	Stock	33.8175	33.83	33.8125	33.8125	18308.0
2017-02-16 17:00:00	AAPL	Stock	33.8125	33.82	33.8125	33.82	9664.0
2017-02-16 17:30:00	AAPL	Stock	33.815	33.815	33.8125	33.815	14952.0
2017-02-16 18:00:00	AAPL	Stock	33.815	33.8175	33.815	33.815	4552.0
2017-02-16 18:30:00	AAPL	Stock	33.8225	33.8225	33.8225	33.8225	648.0
2017-02-16 19:00:00	AAPL	Stock	33.815	33.815	33.8125	33.8125	21716.0
2017-02-16 19:30:00	AAPL	Stock	33.8125	33.825	33.8125	33.825	14100.0
2017-02-16 06:30:00	MSFT	Stock	64.58	64.58	64.58	64.58	100.0
2017-02-16 07:00:00	MSFT	Stock	64.57	64.57	64.57	64.57	649.0
2017-02-16 07:30:00	MSFT	Stock	64.53	64.53	64.47	64.47	355.0
2017-02-16 08:00:00	MSFT	Stock	64.5	64.53	64.5	64.53	1670.0
2017-02-16 08:30:00	MSFT	Stock	64.49	64.5	64.45	64.5	2359.0
2017-02-16 09:00:00	MSFT	Stock	64.55	64.78	64.55	64.73	5962.0
2017-02-16 09:30:00	MSFT	Stock	64.74	64.99	64.61	64.85	2267291.0
2017-02-16 10:00:00	MSFT	Stock	64.85	65.165	64.81	65.1	2104675.0
2017-02-16 10:30:00	MSFT	Stock	65.1	65.24	64.85	64.974	1824021.0
2017-02-16 11:00:00	MSFT	Stock	64.98	65.03	64.86	64.97	1253944.0
2017-02-16 11:30:00	MSFT	Stock	64.97	65.0	64.88	64.93	609748.0
2017-02-16 12:00:00	MSFT	Stock	64.935	64.95	64.764	64.82	717989.0
2017-02-16 12:30:00	MSFT	Stock	64.82	64.855	64.7	64.7	544239.0
2017-02-16 13:00:00	MSFT	Stock	64.695	64.71	64.56	64.59	1070177.0
2017-02-16 13:30:00	MSFT	Stock	64.59	64.63	64.51	64.534	971565.0
2017-02-16 14:00:00	MSFT	Stock	64.54	64.565	64.44	64.555	988234.0
2017-02-16 14:30:00	MSFT	Stock	64.55	64.57	64.49	64.535	952922.0
2017-02-16 15:00:00	MSFT	Stock	64.54	64.62	64.53	64.595	879385.0
2017-02-16 15:30:00	MSFT	Stock	64.595	64.615	64.47	64.51	3036781.0

> showing 50 of 82,569 rows — these rows as CSV

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