PREVIEW / stock_30min / 2015-08-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-17.parquet
  size:    1.6 MB
  rows:    81,559
  symbols: 3,457

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-08-17 04:00:00	AAPL	Stock	28.9925	29.0625	28.9925	29.0625	4000.0
2015-08-17 04:30:00	AAPL	Stock	29.035	29.0875	29.035	29.0875	9200.0
2015-08-17 05:30:00	AAPL	Stock	29.1	29.1	29.0925	29.0925	980.0
2015-08-17 06:00:00	AAPL	Stock	29.0975	29.105	29.095	29.095	32360.0
2015-08-17 06:30:00	AAPL	Stock	29.0775	29.105	29.05	29.05	26064.0
2015-08-17 07:00:00	AAPL	Stock	29.09	29.09	28.9725	28.9875	37204.0
2015-08-17 07:30:00	AAPL	Stock	29.0125	29.045	29.0	29.025	50732.0
2015-08-17 08:00:00	AAPL	Stock	29.025	29.0875	28.995	29.04	370532.0
2015-08-17 08:30:00	AAPL	Stock	29.04	29.04	28.9575	28.975	346100.0
2015-08-17 09:00:00	AAPL	Stock	28.9775	29.0125	28.9625	28.9875	184500.0
2015-08-17 09:30:00	AAPL	Stock	29.01	29.1225	28.875	29.0075	22830092.0
2015-08-17 10:00:00	AAPL	Stock	29.0075	29.195	28.9925	29.1625	17479204.0
2015-08-17 10:30:00	AAPL	Stock	29.1625	29.3175	29.1125	29.2975	15628848.0
2015-08-17 11:00:00	AAPL	Stock	29.2975	29.3375	29.2	29.2675	14876520.0
2015-08-17 11:30:00	AAPL	Stock	29.2675	29.39	29.2575	29.355	12566148.0
2015-08-17 12:00:00	AAPL	Stock	29.355	29.3825	29.305	29.3215	7383356.0
2015-08-17 12:30:00	AAPL	Stock	29.3225	29.35	29.265	29.345	9309504.0
2015-08-17 13:00:00	AAPL	Stock	29.345	29.4025	29.3225	29.3898	7176068.0
2015-08-17 13:30:00	AAPL	Stock	29.3878	29.4125	29.3375	29.3538	7598400.0
2015-08-17 14:00:00	AAPL	Stock	29.3525	29.405	29.3075	29.35	6546756.0
2015-08-17 14:30:00	AAPL	Stock	29.3525	29.37	29.2725	29.32	7124072.0
2015-08-17 15:00:00	AAPL	Stock	29.3225	29.3275	29.255	29.2875	8177604.0
2015-08-17 15:30:00	AAPL	Stock	29.2875	29.33	29.2625	29.2925	12384960.0
2015-08-17 16:00:00	AAPL	Stock	29.29	29.32	28.9872	29.3	5340892.0
2015-08-17 16:30:00	AAPL	Stock	29.3	29.32	29.295	29.3118	39604.0
2015-08-17 17:00:00	AAPL	Stock	29.305	29.3092	29.3025	29.3075	10220.0
2015-08-17 17:30:00	AAPL	Stock	29.3	29.31	29.29	29.3025	93056.0
2015-08-17 18:00:00	AAPL	Stock	29.3025	29.31	29.3025	29.31	21200.0
2015-08-17 18:30:00	AAPL	Stock	29.31	29.31	29.2975	29.31	31272.0
2015-08-17 19:00:00	AAPL	Stock	29.31	29.31	29.3	29.3	4616.0
2015-08-17 19:30:00	AAPL	Stock	29.3	29.3075	29.295	29.295	33916.0
2015-08-17 08:00:00	MSFT	Stock	47.01	47.01	47.0	47.0	1902.0
2015-08-17 08:30:00	MSFT	Stock	46.95	46.95	46.9	46.9	1100.0
2015-08-17 09:00:00	MSFT	Stock	46.9	46.9	46.8	46.8	26675.0
2015-08-17 09:30:00	MSFT	Stock	46.82	46.93	46.57	46.7	2142704.0
2015-08-17 10:00:00	MSFT	Stock	46.691	47.09	46.66	47.01	1823247.0
2015-08-17 10:30:00	MSFT	Stock	47.019	47.07	46.89	47.01	1728602.0
2015-08-17 11:00:00	MSFT	Stock	47.01	47.14	47.0	47.045	1476419.0
2015-08-17 11:30:00	MSFT	Stock	47.05	47.1	47.0	47.09	895440.0
2015-08-17 12:00:00	MSFT	Stock	47.08	47.23	47.08	47.16	657811.0
2015-08-17 12:30:00	MSFT	Stock	47.165	47.24	47.1	47.23	697747.0
2015-08-17 13:00:00	MSFT	Stock	47.224	47.35	47.22	47.326	696171.0
2015-08-17 13:30:00	MSFT	Stock	47.325	47.41	47.31	47.345	885703.0
2015-08-17 14:00:00	MSFT	Stock	47.34	47.41	47.26	47.281	832598.0
2015-08-17 14:30:00	MSFT	Stock	47.29	47.395	47.26	47.39	852431.0
2015-08-17 15:00:00	MSFT	Stock	47.398	47.45	47.28	47.335	1705728.0
2015-08-17 15:30:00	MSFT	Stock	47.335	47.38	47.28	47.32	2235015.0
2015-08-17 16:00:00	MSFT	Stock	47.32	47.36	47.32	47.36	3377211.0
2015-08-17 16:30:00	MSFT	Stock	47.35	47.35	47.263	47.263	1176.0
2015-08-17 18:00:00	MSFT	Stock	47.35	47.35	47.35	47.35	2825.0

> showing 50 of 81,559 rows — these rows as CSV

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