PREVIEW / stock_30min / 2014-08-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-14.parquet
  size:    1.6 MB
  rows:    81,962
  symbols: 3,580

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-08-14 04:00:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	1900.0
2014-08-14 04:30:00	AAPL	Stock	24.335	24.3375	24.335	24.3375	10160.0
2014-08-14 05:00:00	AAPL	Stock	24.33	24.3425	24.33	24.33	9688.0
2014-08-14 05:30:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	2400.0
2014-08-14 06:00:00	AAPL	Stock	24.3375	24.3725	24.32	24.3725	12076.0
2014-08-14 06:30:00	AAPL	Stock	24.355	24.355	24.355	24.355	400.0
2014-08-14 07:00:00	AAPL	Stock	24.3575	24.37	24.35	24.3525	9572.0
2014-08-14 07:30:00	AAPL	Stock	24.345	24.35	24.32	24.3275	40924.0
2014-08-14 08:00:00	AAPL	Stock	24.3325	24.37	24.31	24.345	324544.0
2014-08-14 08:30:00	AAPL	Stock	24.3425	24.3425	24.295	24.3	365196.0
2014-08-14 09:00:00	AAPL	Stock	24.2975	24.35	24.29	24.33	466556.0
2014-08-14 09:30:00	AAPL	Stock	24.325	24.3625	24.2	24.2775	21344520.0
2014-08-14 10:00:00	AAPL	Stock	24.28	24.33	24.2438	24.315	12656288.0
2014-08-14 10:30:00	AAPL	Stock	24.315	24.385	24.298	24.3625	9972728.0
2014-08-14 11:00:00	AAPL	Stock	24.3625	24.385	24.3288	24.335	5653852.0
2014-08-14 11:30:00	AAPL	Stock	24.3337	24.3425	24.2812	24.3275	7262072.0
2014-08-14 12:00:00	AAPL	Stock	24.33	24.3462	24.305	24.3075	3796256.0
2014-08-14 12:30:00	AAPL	Stock	24.3082	24.3475	24.3075	24.3275	3913928.0
2014-08-14 13:00:00	AAPL	Stock	24.3268	24.3775	24.3125	24.3665	5883976.0
2014-08-14 13:30:00	AAPL	Stock	24.3672	24.3925	24.3525	24.39	3884452.0
2014-08-14 14:00:00	AAPL	Stock	24.39	24.39	24.3325	24.3625	4539828.0
2014-08-14 14:30:00	AAPL	Stock	24.3625	24.3875	24.3538	24.3712	4479012.0
2014-08-14 15:00:00	AAPL	Stock	24.3722	24.3862	24.345	24.385	5781596.0
2014-08-14 15:30:00	AAPL	Stock	24.3843	24.3925	24.36	24.375	10490100.0
2014-08-14 16:00:00	AAPL	Stock	24.3728	24.385	24.3332	24.385	2987228.0
2014-08-14 16:30:00	AAPL	Stock	24.38	24.3925	24.334	24.38	82096.0
2014-08-14 17:00:00	AAPL	Stock	24.3825	24.39	24.3725	24.3725	64956.0
2014-08-14 17:30:00	AAPL	Stock	24.3725	24.375	24.3625	24.3625	68140.0
2014-08-14 18:00:00	AAPL	Stock	24.37	24.39	24.37	24.39	32632.0
2014-08-14 18:30:00	AAPL	Stock	24.37	24.3825	24.37	24.375	17192.0
2014-08-14 19:00:00	AAPL	Stock	24.375	24.39	24.375	24.39	33732.0
2014-08-14 19:30:00	AAPL	Stock	24.39	24.395	24.3875	24.395	47192.0
2014-08-14 06:00:00	MSFT	Stock	43.95	43.95	43.95	43.95	100.0
2014-08-14 07:00:00	MSFT	Stock	44.12	44.12	44.12	44.12	100.0
2014-08-14 08:00:00	MSFT	Stock	44.11	44.11	44.1	44.1	758.0
2014-08-14 08:30:00	MSFT	Stock	44.05	44.05	43.99	44.04	515.0
2014-08-14 09:00:00	MSFT	Stock	44.07	44.09	44.07	44.09	2542.0
2014-08-14 09:30:00	MSFT	Stock	44.1	44.33	44.03	44.27	2057878.0
2014-08-14 10:00:00	MSFT	Stock	44.27	44.28	44.05	44.1	1492540.0
2014-08-14 10:30:00	MSFT	Stock	44.11	44.13	44.01	44.07	1454486.0
2014-08-14 11:00:00	MSFT	Stock	44.06	44.26	44.04	44.21	1869904.0
2014-08-14 11:30:00	MSFT	Stock	44.22	44.23	44.12	44.22	1066994.0
2014-08-14 12:00:00	MSFT	Stock	44.22	44.22	44.132	44.15	747415.0
2014-08-14 12:30:00	MSFT	Stock	44.15	44.24	44.08	44.187	830869.0
2014-08-14 13:00:00	MSFT	Stock	44.19	44.27	44.15	44.26	818032.0
2014-08-14 13:30:00	MSFT	Stock	44.25	44.325	44.24	44.31	869894.0
2014-08-14 14:00:00	MSFT	Stock	44.3	44.39	44.29	44.385	897331.0
2014-08-14 14:30:00	MSFT	Stock	44.39	44.417	44.25	44.36	1223458.0
2014-08-14 15:00:00	MSFT	Stock	44.355	44.37	44.245	44.27	1630578.0
2014-08-14 15:30:00	MSFT	Stock	44.265	44.3	44.24	44.28	2127405.0

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

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