PREVIEW / stock_30min / 2016-03-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-15.parquet
  size:    1.6 MB
  rows:    81,773
  symbols: 3,325

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
2016-03-15 04:00:00	AAPL	Stock	25.7025	25.7025	25.5325	25.625	54000.0
2016-03-15 04:30:00	AAPL	Stock	25.575	25.575	25.56	25.575	11912.0
2016-03-15 05:00:00	AAPL	Stock	25.58	25.68	25.58	25.6775	25800.0
2016-03-15 05:30:00	AAPL	Stock	25.675	25.685	25.66	25.675	43972.0
2016-03-15 06:00:00	AAPL	Stock	25.675	25.825	25.675	25.825	56208.0
2016-03-15 06:30:00	AAPL	Stock	25.8225	25.925	25.8	25.9075	169256.0
2016-03-15 07:00:00	AAPL	Stock	25.875	26.0	25.875	26.0	281812.0
2016-03-15 07:30:00	AAPL	Stock	25.99	26.125	25.9375	26.0625	371780.0
2016-03-15 08:00:00	AAPL	Stock	26.045	26.0925	25.8875	26.0425	666716.0
2016-03-15 08:30:00	AAPL	Stock	26.0275	26.04	25.9525	25.9575	830948.0
2016-03-15 09:00:00	AAPL	Stock	25.9575	26.1025	25.9575	26.02	1286316.0
2016-03-15 09:30:00	AAPL	Stock	25.9975	26.195	25.9625	26.12	30478584.0
2016-03-15 10:00:00	AAPL	Stock	26.1175	26.1788	26.02	26.1788	14380356.0
2016-03-15 10:30:00	AAPL	Stock	26.18	26.2475	26.1575	26.225	13855864.0
2016-03-15 11:00:00	AAPL	Stock	26.226	26.2312	26.1775	26.215	7446448.0
2016-03-15 11:30:00	AAPL	Stock	26.215	26.295	26.195	26.2525	10846296.0
2016-03-15 12:00:00	AAPL	Stock	26.255	26.2675	26.1775	26.21	7366756.0
2016-03-15 12:30:00	AAPL	Stock	26.21	26.225	26.175	26.185	5167404.0
2016-03-15 13:00:00	AAPL	Stock	26.1875	26.194	26.085	26.125	7259604.0
2016-03-15 13:30:00	AAPL	Stock	26.1275	26.1737	26.12	26.1548	5108292.0
2016-03-15 14:00:00	AAPL	Stock	26.155	26.18	26.1175	26.1725	4630280.0
2016-03-15 14:30:00	AAPL	Stock	26.171	26.1775	26.1275	26.1575	4885480.0
2016-03-15 15:00:00	AAPL	Stock	26.1575	26.24	26.155	26.216	7952568.0
2016-03-15 15:30:00	AAPL	Stock	26.215	26.24	26.125	26.145	13970608.0
2016-03-15 16:00:00	AAPL	Stock	26.145	26.155	25.75	26.13	9334804.0
2016-03-15 16:30:00	AAPL	Stock	26.1325	26.1325	26.125	26.1325	61020.0
2016-03-15 17:00:00	AAPL	Stock	26.1325	26.1375	26.125	26.1375	65168.0
2016-03-15 17:30:00	AAPL	Stock	26.1375	26.145	26.1275	26.1275	18180.0
2016-03-15 18:00:00	AAPL	Stock	26.135	26.1375	26.135	26.1375	30372.0
2016-03-15 18:30:00	AAPL	Stock	26.1375	26.1525	26.135	26.1425	35688.0
2016-03-15 19:00:00	AAPL	Stock	26.1425	26.15	26.14	26.15	12876.0
2016-03-15 19:30:00	AAPL	Stock	26.15	26.155	26.145	26.155	56704.0
2016-03-15 04:00:00	MSFT	Stock	52.99	52.99	52.99	52.99	1500.0
2016-03-15 06:30:00	MSFT	Stock	52.7	52.7	52.7	52.7	458.0
2016-03-15 07:00:00	MSFT	Stock	52.8	52.8	52.79	52.79	378.0
2016-03-15 07:30:00	MSFT	Stock	52.84	52.84	52.81	52.81	400.0
2016-03-15 08:00:00	MSFT	Stock	52.77	52.99	52.77	52.86	1521.0
2016-03-15 08:30:00	MSFT	Stock	52.84	52.91	52.77	52.81	22791.0
2016-03-15 09:00:00	MSFT	Stock	52.91	52.92	52.75	52.75	28442.0
2016-03-15 09:30:00	MSFT	Stock	52.75	53.0	52.74	52.86	1815753.0
2016-03-15 10:00:00	MSFT	Stock	52.85	53.26	52.77	53.25	1436996.0
2016-03-15 10:30:00	MSFT	Stock	53.255	53.375	53.18	53.37	1228112.0
2016-03-15 11:00:00	MSFT	Stock	53.366	53.48	53.27	53.41	1120320.0
2016-03-15 11:30:00	MSFT	Stock	53.406	53.41	53.07	53.09	1015074.0
2016-03-15 12:00:00	MSFT	Stock	53.1	53.355	53.09	53.33	1003055.0
2016-03-15 12:30:00	MSFT	Stock	53.34	53.35	53.095	53.105	752097.0
2016-03-15 13:00:00	MSFT	Stock	53.105	53.15	52.97	53.14	898302.0
2016-03-15 13:30:00	MSFT	Stock	53.135	53.35	53.135	53.31	906102.0
2016-03-15 14:00:00	MSFT	Stock	53.32	53.38	53.25	53.31	1487384.0
2016-03-15 14:30:00	MSFT	Stock	53.305	53.44	53.28	53.415	971501.0

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

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