PREVIEW / stock_30min / 2015-02-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-06.parquet
  size:    1.6 MB
  rows:    82,311
  symbols: 3,525

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
2015-02-06 04:00:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2015-02-06 04:30:00	AAPL	Stock	29.9025	29.94	29.9	29.9175	4400.0
2015-02-06 05:30:00	AAPL	Stock	29.9025	29.94	29.9	29.94	2400.0
2015-02-06 06:00:00	AAPL	Stock	29.925	29.925	29.925	29.925	400.0
2015-02-06 06:30:00	AAPL	Stock	29.925	29.925	29.9	29.925	2232.0
2015-02-06 07:00:00	AAPL	Stock	29.95	29.9925	29.95	29.9825	15600.0
2015-02-06 07:30:00	AAPL	Stock	29.99	29.99	29.9525	29.9725	52712.0
2015-02-06 08:00:00	AAPL	Stock	29.965	29.9925	29.92	29.9225	202228.0
2015-02-06 08:30:00	AAPL	Stock	29.94	30.05	29.94	30.0375	1025224.0
2015-02-06 09:00:00	AAPL	Stock	30.0375	30.06	29.9975	30.01	491480.0
2015-02-06 09:30:00	AAPL	Stock	30.0125	30.0575	29.8625	29.9475	23073164.0
2015-02-06 10:00:00	AAPL	Stock	29.9475	30.0212	29.9325	29.9608	10473428.0
2015-02-06 10:30:00	AAPL	Stock	29.965	30.045	29.965	30.0275	9876240.0
2015-02-06 11:00:00	AAPL	Stock	30.03	30.0525	29.9945	30.0275	7404508.0
2015-02-06 11:30:00	AAPL	Stock	30.0275	30.0625	30.0125	30.06	7028500.0
2015-02-06 12:00:00	AAPL	Stock	30.058	30.0625	30.015	30.0175	6614628.0
2015-02-06 12:30:00	AAPL	Stock	30.0175	30.025	29.9275	29.9575	9984152.0
2015-02-06 13:00:00	AAPL	Stock	29.9578	29.9675	29.7175	29.746	16103184.0
2015-02-06 13:30:00	AAPL	Stock	29.7475	29.8875	29.715	29.855	12247828.0
2015-02-06 14:00:00	AAPL	Stock	29.855	29.895	29.755	29.8875	7968128.0
2015-02-06 14:30:00	AAPL	Stock	29.8898	29.93	29.7838	29.795	7554400.0
2015-02-06 15:00:00	AAPL	Stock	29.795	29.8	29.65	29.6725	17729672.0
2015-02-06 15:30:00	AAPL	Stock	29.6725	29.7325	29.6125	29.7275	19538640.0
2015-02-06 16:00:00	AAPL	Stock	29.7325	30.0172	29.69	29.725	5999332.0
2015-02-06 16:30:00	AAPL	Stock	29.72	29.985	29.7	29.74	943012.0
2015-02-06 17:00:00	AAPL	Stock	29.7325	29.7475	29.725	29.725	128232.0
2015-02-06 17:30:00	AAPL	Stock	29.7375	29.7375	29.7125	29.7125	98276.0
2015-02-06 18:00:00	AAPL	Stock	29.7125	29.725	29.7075	29.71	54164.0
2015-02-06 18:30:00	AAPL	Stock	29.71	29.7225	29.71	29.715	5680.0
2015-02-06 19:00:00	AAPL	Stock	29.7175	29.72	29.7125	29.715	10808.0
2015-02-06 19:30:00	AAPL	Stock	29.7225	29.725	29.6925	29.7075	79620.0
2015-02-06 04:30:00	MSFT	Stock	42.55	42.55	42.5	42.5	500.0
2015-02-06 06:30:00	MSFT	Stock	42.5	42.5	42.5	42.5	1700.0
2015-02-06 07:00:00	MSFT	Stock	42.5	42.5	42.49	42.49	345.0
2015-02-06 07:30:00	MSFT	Stock	42.5	42.55	42.5	42.55	400.0
2015-02-06 08:00:00	MSFT	Stock	42.5	42.55	42.4	42.52	7362.0
2015-02-06 08:30:00	MSFT	Stock	42.52	42.63	42.5	42.62	5601.0
2015-02-06 09:00:00	MSFT	Stock	42.6	42.74	42.58	42.73	36038.0
2015-02-06 09:30:00	MSFT	Stock	42.68	42.79	42.45	42.52	5293766.0
2015-02-06 10:00:00	MSFT	Stock	42.53	42.63	42.5	42.545	1889664.0
2015-02-06 10:30:00	MSFT	Stock	42.54	42.64	42.52	42.61	1773693.0
2015-02-06 11:00:00	MSFT	Stock	42.61	42.62	42.52	42.571	1340641.0
2015-02-06 11:30:00	MSFT	Stock	42.575	42.6	42.52	42.55	1363954.0
2015-02-06 12:00:00	MSFT	Stock	42.55	42.61	42.51	42.51	1323978.0
2015-02-06 12:30:00	MSFT	Stock	42.51	42.54	42.34	42.485	1798215.0
2015-02-06 13:00:00	MSFT	Stock	42.487	42.5	42.25	42.313	2155245.0
2015-02-06 13:30:00	MSFT	Stock	42.31	42.35	42.26	42.295	1476245.0
2015-02-06 14:00:00	MSFT	Stock	42.29	42.49	42.27	42.45	2075425.0
2015-02-06 14:30:00	MSFT	Stock	42.454	42.48	42.27	42.28	1638016.0
2015-02-06 15:00:00	MSFT	Stock	42.285	42.345	42.18	42.235	3993227.0

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

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