PREVIEW / stock_30min / 2015-09-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-14.parquet
  size:    1.5 MB
  rows:    80,365
  symbols: 3,435

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-09-14 04:00:00	AAPL	Stock	28.5725	28.75	28.5725	28.67	18504.0
2015-09-14 04:30:00	AAPL	Stock	28.6675	28.6675	28.65	28.6625	8724.0
2015-09-14 05:00:00	AAPL	Stock	28.675	28.7125	28.675	28.7	8548.0
2015-09-14 05:30:00	AAPL	Stock	28.68	28.6875	28.6625	28.6875	4892.0
2015-09-14 06:00:00	AAPL	Stock	28.685	28.7475	28.685	28.7375	73968.0
2015-09-14 06:30:00	AAPL	Stock	28.725	28.8475	28.725	28.8425	254744.0
2015-09-14 07:00:00	AAPL	Stock	28.83	28.985	28.825	28.96	417496.0
2015-09-14 07:30:00	AAPL	Stock	28.96	29.03	28.925	28.9375	537924.0
2015-09-14 08:00:00	AAPL	Stock	28.9325	29.0275	28.6875	28.9325	1194604.0
2015-09-14 08:30:00	AAPL	Stock	28.9275	29.2675	28.845	29.2025	4096344.0
2015-09-14 09:00:00	AAPL	Stock	29.2075	29.3125	29.15	29.1525	2625672.0
2015-09-14 09:30:00	AAPL	Stock	29.145	29.2225	28.915	28.9838	49752808.0
2015-09-14 10:00:00	AAPL	Stock	28.975	29.14	28.9375	29.066	20982564.0
2015-09-14 10:30:00	AAPL	Stock	29.0662	29.0772	28.8425	28.9425	20967864.0
2015-09-14 11:00:00	AAPL	Stock	28.945	29.005	28.8425	28.8488	11472508.0
2015-09-14 11:30:00	AAPL	Stock	28.8475	28.9375	28.8275	28.865	10870420.0
2015-09-14 12:00:00	AAPL	Stock	28.865	28.8925	28.715	28.7722	14526844.0
2015-09-14 12:30:00	AAPL	Stock	28.77	28.9025	28.73	28.7722	9154496.0
2015-09-14 13:00:00	AAPL	Stock	28.77	28.825	28.7425	28.815	6844268.0
2015-09-14 13:30:00	AAPL	Stock	28.815	28.945	28.81	28.9312	9800876.0
2015-09-14 14:00:00	AAPL	Stock	28.9312	28.935	28.8278	28.845	7748544.0
2015-09-14 14:30:00	AAPL	Stock	28.845	28.9525	28.8325	28.8612	9255224.0
2015-09-14 15:00:00	AAPL	Stock	28.8612	28.935	28.765	28.85	12875508.0
2015-09-14 15:30:00	AAPL	Stock	28.8525	28.8775	28.7925	28.8345	17002516.0
2015-09-14 16:00:00	AAPL	Stock	28.825	28.8688	28.8	28.83	7352876.0
2015-09-14 16:30:00	AAPL	Stock	28.83	28.8375	28.8125	28.8125	87376.0
2015-09-14 17:00:00	AAPL	Stock	28.825	28.845	28.8175	28.82	168012.0
2015-09-14 17:30:00	AAPL	Stock	28.82	28.8275	28.8125	28.8275	32796.0
2015-09-14 18:00:00	AAPL	Stock	28.815	28.825	28.8025	28.825	27180.0
2015-09-14 18:30:00	AAPL	Stock	28.815	28.8275	28.795	28.815	71124.0
2015-09-14 19:00:00	AAPL	Stock	28.815	28.825	28.8025	28.8125	37592.0
2015-09-14 19:30:00	AAPL	Stock	28.825	28.8325	28.8025	28.83	66176.0
2015-09-14 07:30:00	MSFT	Stock	43.5	43.5	43.5	43.5	5900.0
2015-09-14 08:00:00	MSFT	Stock	43.4	43.5	43.21	43.5	1615.0
2015-09-14 08:30:00	MSFT	Stock	43.4	43.4	43.4	43.4	155.0
2015-09-14 09:00:00	MSFT	Stock	43.35	43.5	43.35	43.43	3310.0
2015-09-14 09:30:00	MSFT	Stock	43.43	43.44	42.86	42.91	2240747.0
2015-09-14 10:00:00	MSFT	Stock	42.911	43.13	42.89	43.01	1435197.0
2015-09-14 10:30:00	MSFT	Stock	43.01	43.1	42.98	43.05	1169726.0
2015-09-14 11:00:00	MSFT	Stock	43.05	43.12	42.97	42.985	1171361.0
2015-09-14 11:30:00	MSFT	Stock	42.98	42.99	42.875	42.945	944248.0
2015-09-14 12:00:00	MSFT	Stock	42.95	42.99	42.88	42.97	1117831.0
2015-09-14 12:30:00	MSFT	Stock	42.97	43.05	42.91	42.975	878904.0
2015-09-14 13:00:00	MSFT	Stock	42.97	42.98	42.92	42.93	707948.0
2015-09-14 13:30:00	MSFT	Stock	42.925	43.09	42.92	43.07	1305756.0
2015-09-14 14:00:00	MSFT	Stock	43.07	43.07	42.92	42.92	1442102.0
2015-09-14 14:30:00	MSFT	Stock	42.925	43.096	42.9	43.04	1775787.0
2015-09-14 15:00:00	MSFT	Stock	43.03	43.04	42.92	42.97	1678908.0
2015-09-14 15:30:00	MSFT	Stock	42.98	43.07	42.91	43.03	3362596.0
2015-09-14 16:00:00	MSFT	Stock	43.04	43.08	42.933	43.08	3440392.0

> showing 50 of 80,365 rows — these rows as CSV

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