PREVIEW / stock_30min / 2014-06-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-09.parquet
  size:    1.6 MB
  rows:    82,131
  symbols: 3,551

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
2014-06-09 04:00:00	AAPL	Stock	23.0575	23.125	23.0575	23.1	15600.0
2014-06-09 04:30:00	AAPL	Stock	23.125	23.1725	23.12	23.16	33472.0
2014-06-09 05:00:00	AAPL	Stock	23.1575	23.16	23.1	23.14	48228.0
2014-06-09 05:30:00	AAPL	Stock	23.1275	23.1275	23.1	23.1	18400.0
2014-06-09 06:00:00	AAPL	Stock	23.09	23.1	23.08	23.1	57740.0
2014-06-09 06:30:00	AAPL	Stock	23.1	23.1	23.0375	23.05	62312.0
2014-06-09 07:00:00	AAPL	Stock	23.0575	23.0575	22.9325	23.02	298172.0
2014-06-09 07:30:00	AAPL	Stock	23.0125	23.03	22.9825	23.0125	233264.0
2014-06-09 08:00:00	AAPL	Stock	23.0125	23.4175	22.9875	23.025	1719820.0
2014-06-09 08:30:00	AAPL	Stock	23.0325	23.0325	22.95	23.0125	1246324.0
2014-06-09 09:00:00	AAPL	Stock	23.0125	23.1975	23.0125	23.165	3434824.0
2014-06-09 09:30:00	AAPL	Stock	23.17	23.27	23.03	23.0775	48797772.0
2014-06-09 10:00:00	AAPL	Stock	23.08	23.095	22.9375	23.085	25580292.0
2014-06-09 10:30:00	AAPL	Stock	23.085	23.1875	23.04	23.155	17559528.0
2014-06-09 11:00:00	AAPL	Stock	23.155	23.2325	23.115	23.2125	15151364.0
2014-06-09 11:30:00	AAPL	Stock	23.2125	23.29	23.205	23.2525	18615064.0
2014-06-09 12:00:00	AAPL	Stock	23.2525	23.3375	23.25	23.33	18058268.0
2014-06-09 12:30:00	AAPL	Stock	23.3312	23.4325	23.3312	23.4237	20194664.0
2014-06-09 13:00:00	AAPL	Stock	23.4248	23.45	23.3525	23.3625	16618732.0
2014-06-09 13:30:00	AAPL	Stock	23.3602	23.455	23.36	23.44	13611824.0
2014-06-09 14:00:00	AAPL	Stock	23.4412	23.46	23.3275	23.3375	17300132.0
2014-06-09 14:30:00	AAPL	Stock	23.34	23.4325	23.3375	23.4225	9797524.0
2014-06-09 15:00:00	AAPL	Stock	23.4225	23.465	23.3712	23.46	13737828.0
2014-06-09 15:30:00	AAPL	Stock	23.46	23.47	23.405	23.425	22510180.0
2014-06-09 16:00:00	AAPL	Stock	23.425	23.4425	23.4	23.4175	6883192.0
2014-06-09 16:30:00	AAPL	Stock	23.4175	23.425	23.4	23.4	478300.0
2014-06-09 17:00:00	AAPL	Stock	23.405	23.435	23.4	23.4325	194300.0
2014-06-09 17:30:00	AAPL	Stock	23.4325	23.435	23.4125	23.4225	86812.0
2014-06-09 18:00:00	AAPL	Stock	23.42	23.4375	23.4125	23.43	99664.0
2014-06-09 18:30:00	AAPL	Stock	23.4325	23.44	23.425	23.44	68320.0
2014-06-09 19:00:00	AAPL	Stock	23.4375	23.44	23.425	23.435	35464.0
2014-06-09 19:30:00	AAPL	Stock	23.43	23.445	23.4275	23.4425	94332.0
2014-06-09 07:30:00	MSFT	Stock	41.58	41.58	41.58	41.58	1000.0
2014-06-09 08:00:00	MSFT	Stock	41.5	41.7	41.48	41.52	3325.0
2014-06-09 08:30:00	MSFT	Stock	41.53	41.55	41.53	41.54	1075.0
2014-06-09 09:00:00	MSFT	Stock	41.58	41.58	41.37	41.4	22481.0
2014-06-09 09:30:00	MSFT	Stock	41.39	41.48	41.13	41.25	2354010.0
2014-06-09 10:00:00	MSFT	Stock	41.25	41.34	41.14	41.32	1038626.0
2014-06-09 10:30:00	MSFT	Stock	41.325	41.33	41.26	41.32	619348.0
2014-06-09 11:00:00	MSFT	Stock	41.32	41.34	41.26	41.31	633078.0
2014-06-09 11:30:00	MSFT	Stock	41.317	41.37	41.31	41.33	573998.0
2014-06-09 12:00:00	MSFT	Stock	41.32	41.33	41.27	41.293	628010.0
2014-06-09 12:30:00	MSFT	Stock	41.3	41.31	41.25	41.27	597464.0
2014-06-09 13:00:00	MSFT	Stock	41.27	41.28	41.17	41.21	734452.0
2014-06-09 13:30:00	MSFT	Stock	41.205	41.22	41.13	41.14	662346.0
2014-06-09 14:00:00	MSFT	Stock	41.13	41.14	41.02	41.075	929257.0
2014-06-09 14:30:00	MSFT	Stock	41.08	41.18	41.07	41.16	790079.0
2014-06-09 15:00:00	MSFT	Stock	41.16	41.23	41.14	41.21	861572.0
2014-06-09 15:30:00	MSFT	Stock	41.2	41.27	41.13	41.27	2671452.0
2014-06-09 16:00:00	MSFT	Stock	41.26	41.48	41.26	41.48	1396478.0

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

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