PREVIEW / stock_30min / 2014-06-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-19.parquet
  size:    1.6 MB
  rows:    82,808
  symbols: 3,564

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-06-19 04:00:00	AAPL	Stock	23.125	23.1675	23.1025	23.14	23600.0
2014-06-19 04:30:00	AAPL	Stock	23.135	23.14	23.1025	23.14	2400.0
2014-06-19 05:00:00	AAPL	Stock	23.1325	23.1425	23.125	23.1325	12080.0
2014-06-19 06:00:00	AAPL	Stock	23.1325	23.1325	23.1125	23.13	4000.0
2014-06-19 06:30:00	AAPL	Stock	23.135	23.14	23.1325	23.1375	59444.0
2014-06-19 07:00:00	AAPL	Stock	23.1375	23.145	23.1075	23.125	55196.0
2014-06-19 07:30:00	AAPL	Stock	23.1125	23.1225	23.035	23.04	146940.0
2014-06-19 08:00:00	AAPL	Stock	23.0425	23.13	23.02	23.0325	261312.0
2014-06-19 08:30:00	AAPL	Stock	23.06	23.1	23.04	23.0725	264760.0
2014-06-19 09:00:00	AAPL	Stock	23.0725	23.08	23.0675	23.0725	146948.0
2014-06-19 09:30:00	AAPL	Stock	23.0725	23.075	22.975	23.0025	14761324.0
2014-06-19 10:00:00	AAPL	Stock	23.005	23.07	22.9625	23.055	10714580.0
2014-06-19 10:30:00	AAPL	Stock	23.055	23.055	22.97	22.9825	7224460.0
2014-06-19 11:00:00	AAPL	Stock	22.98	22.9975	22.9125	22.9175	7267704.0
2014-06-19 11:30:00	AAPL	Stock	22.92	22.94	22.9025	22.9188	5302984.0
2014-06-19 12:00:00	AAPL	Stock	22.9195	22.9675	22.9125	22.925	4336088.0
2014-06-19 12:30:00	AAPL	Stock	22.925	22.9325	22.86	22.865	6387592.0
2014-06-19 13:00:00	AAPL	Stock	22.8638	22.88	22.8525	22.8675	5384432.0
2014-06-19 13:30:00	AAPL	Stock	22.87	22.8875	22.8425	22.875	5054400.0
2014-06-19 14:00:00	AAPL	Stock	22.875	22.895	22.8625	22.8825	4709548.0
2014-06-19 14:30:00	AAPL	Stock	22.88	22.9935	22.8575	22.935	12478072.0
2014-06-19 15:00:00	AAPL	Stock	22.9375	23.0175	22.9275	22.9925	18115664.0
2014-06-19 15:30:00	AAPL	Stock	22.9938	23.005	22.915	22.96	18792120.0
2014-06-19 16:00:00	AAPL	Stock	22.965	23.045	22.92	22.925	12299312.0
2014-06-19 16:30:00	AAPL	Stock	22.9275	22.989	22.9025	22.965	197000.0
2014-06-19 17:00:00	AAPL	Stock	22.91	22.925	22.91	22.91	10012.0
2014-06-19 17:30:00	AAPL	Stock	22.9175	22.9275	22.9125	22.9275	17820.0
2014-06-19 18:00:00	AAPL	Stock	22.9125	22.9275	22.9125	22.925	36848.0
2014-06-19 18:30:00	AAPL	Stock	22.925	22.925	22.8925	22.9	55052.0
2014-06-19 19:00:00	AAPL	Stock	22.895	22.91	22.8925	22.905	35808.0
2014-06-19 19:30:00	AAPL	Stock	22.905	22.905	22.875	22.8775	50016.0
2014-06-19 04:00:00	MSFT	Stock	41.48	41.48	41.48	41.48	325.0
2014-06-19 07:30:00	MSFT	Stock	41.64	41.64	41.64	41.64	525.0
2014-06-19 08:00:00	MSFT	Stock	41.66	41.66	41.66	41.66	100.0
2014-06-19 09:00:00	MSFT	Stock	41.57	41.57	41.57	41.57	400.0
2014-06-19 09:30:00	MSFT	Stock	41.57	41.77	41.56	41.66	2393229.0
2014-06-19 10:00:00	MSFT	Stock	41.66	41.745	41.62	41.655	982243.0
2014-06-19 10:30:00	MSFT	Stock	41.66	41.66	41.48	41.544	1865868.0
2014-06-19 11:00:00	MSFT	Stock	41.54	41.56	41.43	41.435	1031263.0
2014-06-19 11:30:00	MSFT	Stock	41.431	41.51	41.42	41.505	1365146.0
2014-06-19 12:00:00	MSFT	Stock	41.503	41.615	41.49	41.547	592216.0
2014-06-19 12:30:00	MSFT	Stock	41.55	41.55	41.43	41.442	379342.0
2014-06-19 13:00:00	MSFT	Stock	41.44	41.48	41.33	41.42	937173.0
2014-06-19 13:30:00	MSFT	Stock	41.415	41.47	41.4	41.43	708967.0
2014-06-19 14:00:00	MSFT	Stock	41.43	41.475	41.41	41.44	542138.0
2014-06-19 14:30:00	MSFT	Stock	41.43	41.45	41.39	41.45	740473.0
2014-06-19 15:00:00	MSFT	Stock	41.45	41.45	41.39	41.41	1027034.0
2014-06-19 15:30:00	MSFT	Stock	41.415	41.5	41.38	41.5	3251076.0
2014-06-19 16:00:00	MSFT	Stock	41.51	41.529	41.33	41.51	3044011.0
2014-06-19 16:30:00	MSFT	Stock	41.4	41.51	41.38	41.51	17286.0

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

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