PREVIEW / stock_30min / 2015-10-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-23.parquet
  size:    1.6 MB
  rows:    81,777
  symbols: 3,428

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-10-23 04:00:00	AAPL	Stock	29.0	29.1	28.9575	29.1	20176.0
2015-10-23 04:30:00	AAPL	Stock	29.095	29.1	29.0625	29.0625	12400.0
2015-10-23 05:00:00	AAPL	Stock	29.0625	29.075	29.05	29.0525	14420.0
2015-10-23 05:30:00	AAPL	Stock	29.04	29.075	29.0	29.0425	19560.0
2015-10-23 06:00:00	AAPL	Stock	29.085	29.085	29.0175	29.05	36464.0
2015-10-23 06:30:00	AAPL	Stock	29.045	29.065	29.0025	29.025	58744.0
2015-10-23 07:00:00	AAPL	Stock	29.025	29.3425	29.0175	29.3225	341396.0
2015-10-23 07:30:00	AAPL	Stock	29.3	29.325	29.15	29.225	378708.0
2015-10-23 08:00:00	AAPL	Stock	29.225	29.3425	29.04	29.2725	520604.0
2015-10-23 08:30:00	AAPL	Stock	29.2575	29.2875	29.19	29.195	618500.0
2015-10-23 09:00:00	AAPL	Stock	29.195	29.25	29.1475	29.175	627320.0
2015-10-23 09:30:00	AAPL	Stock	29.175	29.6025	29.0825	29.5912	44074164.0
2015-10-23 10:00:00	AAPL	Stock	29.591	29.5975	29.4325	29.5575	26666396.0
2015-10-23 10:30:00	AAPL	Stock	29.5575	29.6375	29.5	29.6055	18512196.0
2015-10-23 11:00:00	AAPL	Stock	29.6025	29.6825	29.4295	29.6275	16147300.0
2015-10-23 11:30:00	AAPL	Stock	29.63	29.6325	29.525	29.55	10968144.0
2015-10-23 12:00:00	AAPL	Stock	29.5525	29.6425	29.52	29.635	9595260.0
2015-10-23 12:30:00	AAPL	Stock	29.635	29.6725	29.6165	29.6575	7976312.0
2015-10-23 13:00:00	AAPL	Stock	29.6562	29.6875	29.5875	29.6475	8017820.0
2015-10-23 13:30:00	AAPL	Stock	29.65	29.705	29.6475	29.6738	9126912.0
2015-10-23 14:00:00	AAPL	Stock	29.6748	29.7375	29.6425	29.72	10104716.0
2015-10-23 14:30:00	AAPL	Stock	29.7198	29.807	29.7025	29.7562	14458036.0
2015-10-23 15:00:00	AAPL	Stock	29.755	29.7675	29.6575	29.676	11647824.0
2015-10-23 15:30:00	AAPL	Stock	29.6775	29.775	29.6725	29.7725	20800536.0
2015-10-23 16:00:00	AAPL	Stock	29.77	29.785	29.5775	29.75	11058832.0
2015-10-23 16:30:00	AAPL	Stock	29.7575	29.77	29.75	29.7625	116864.0
2015-10-23 17:00:00	AAPL	Stock	29.7675	29.775	29.7575	29.77	147264.0
2015-10-23 17:30:00	AAPL	Stock	29.7675	29.7875	29.7675	29.78	62240.0
2015-10-23 18:00:00	AAPL	Stock	29.78	29.785	29.775	29.775	45172.0
2015-10-23 18:30:00	AAPL	Stock	29.7775	29.7825	29.775	29.7775	30988.0
2015-10-23 19:00:00	AAPL	Stock	29.7825	29.785	29.7775	29.785	35124.0
2015-10-23 19:30:00	AAPL	Stock	29.785	29.7925	29.7775	29.7925	129380.0
2015-10-23 04:00:00	MSFT	Stock	51.56	51.59	51.4	51.44	23040.0
2015-10-23 04:30:00	MSFT	Stock	51.58	51.58	51.45	51.45	400.0
2015-10-23 05:00:00	MSFT	Stock	51.45	51.45	51.35	51.45	1300.0
2015-10-23 05:30:00	MSFT	Stock	51.45	51.45	51.33	51.33	5200.0
2015-10-23 06:00:00	MSFT	Stock	51.45	52.0	51.45	52.0	59425.0
2015-10-23 06:30:00	MSFT	Stock	51.85	52.15	51.85	52.15	36664.0
2015-10-23 07:00:00	MSFT	Stock	52.15	52.92	51.87	52.9	493559.0
2015-10-23 07:30:00	MSFT	Stock	52.9	53.32	52.81	53.01	405187.0
2015-10-23 08:00:00	MSFT	Stock	53.0	53.25	52.01	52.66	1376648.0
2015-10-23 08:30:00	MSFT	Stock	52.67	52.95	52.55	52.91	1247974.0
2015-10-23 09:00:00	MSFT	Stock	52.92	53.13	52.3	52.63	3591394.0
2015-10-23 09:30:00	MSFT	Stock	52.3	53.585	52.25	53.31	31461304.0
2015-10-23 10:00:00	MSFT	Stock	53.31	53.61	53.139	53.28	15289947.0
2015-10-23 10:30:00	MSFT	Stock	53.29	53.295	52.89	53.08	7650464.0
2015-10-23 11:00:00	MSFT	Stock	53.085	53.16	52.95	53.05	5345594.0
2015-10-23 11:30:00	MSFT	Stock	53.05	53.11	52.72	52.925	9133424.0
2015-10-23 12:00:00	MSFT	Stock	52.93	53.16	52.85	53.105	4561868.0
2015-10-23 12:30:00	MSFT	Stock	53.1	53.15	52.78	52.97	4645385.0

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

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