PREVIEW / stock_30min / 2014-08-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-04.parquet
  size:    1.6 MB
  rows:    83,468
  symbols: 3,560

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-04 04:00:00	AAPL	Stock	24.0	24.1525	24.0	24.15	7340.0
2014-08-04 04:30:00	AAPL	Stock	24.125	24.125	24.1	24.1	9836.0
2014-08-04 05:00:00	AAPL	Stock	24.1225	24.125	24.1225	24.125	15844.0
2014-08-04 05:30:00	AAPL	Stock	24.15	24.165	24.15	24.165	4524.0
2014-08-04 06:00:00	AAPL	Stock	24.15	24.2	24.15	24.2	2400.0
2014-08-04 06:30:00	AAPL	Stock	24.1725	24.1825	24.17	24.1775	14092.0
2014-08-04 07:00:00	AAPL	Stock	24.1775	24.205	24.1775	24.19	40564.0
2014-08-04 07:30:00	AAPL	Stock	24.1875	24.2	24.1475	24.1625	101872.0
2014-08-04 08:00:00	AAPL	Stock	24.1675	24.21	24.15	24.15	268948.0
2014-08-04 08:30:00	AAPL	Stock	24.15	24.1975	24.1425	24.175	273676.0
2014-08-04 09:00:00	AAPL	Stock	24.165	24.17	24.0375	24.075	425848.0
2014-08-04 09:30:00	AAPL	Stock	24.0775	24.145	24.0025	24.0725	19788168.0
2014-08-04 10:00:00	AAPL	Stock	24.0725	24.115	24.0025	24.0255	12430888.0
2014-08-04 10:30:00	AAPL	Stock	24.0275	24.0375	23.8025	23.8165	17842172.0
2014-08-04 11:00:00	AAPL	Stock	23.815	23.895	23.7925	23.883	10048244.0
2014-08-04 11:30:00	AAPL	Stock	23.885	23.8925	23.8	23.845	10156340.0
2014-08-04 12:00:00	AAPL	Stock	23.845	23.885	23.805	23.8615	7497100.0
2014-08-04 12:30:00	AAPL	Stock	23.86	23.945	23.85	23.925	7254492.0
2014-08-04 13:00:00	AAPL	Stock	23.925	23.9375	23.87	23.8775	6120716.0
2014-08-04 13:30:00	AAPL	Stock	23.88	23.9175	23.875	23.905	4887416.0
2014-08-04 14:00:00	AAPL	Stock	23.9075	23.9375	23.875	23.8995	5541804.0
2014-08-04 14:30:00	AAPL	Stock	23.9	23.9675	23.8975	23.9625	7353944.0
2014-08-04 15:00:00	AAPL	Stock	23.9625	24.0302	23.9572	24.0068	8816332.0
2014-08-04 15:30:00	AAPL	Stock	24.0075	24.0675	23.895	23.8975	18811132.0
2014-08-04 16:00:00	AAPL	Stock	23.8975	23.944	23.845	23.88	11805132.0
2014-08-04 16:30:00	AAPL	Stock	23.8875	23.988	23.8572	23.8875	560576.0
2014-08-04 17:00:00	AAPL	Stock	23.89	23.8975	23.8775	23.89	854180.0
2014-08-04 17:30:00	AAPL	Stock	23.89	23.9025	23.8775	23.9025	149464.0
2014-08-04 18:00:00	AAPL	Stock	23.8975	23.8975	23.8825	23.895	29960.0
2014-08-04 18:30:00	AAPL	Stock	23.8925	23.8975	23.875	23.885	109536.0
2014-08-04 19:00:00	AAPL	Stock	23.88	23.89	23.8775	23.8775	55340.0
2014-08-04 19:30:00	AAPL	Stock	23.8825	23.885	23.875	23.885	29740.0
2014-08-04 04:30:00	MSFT	Stock	42.89	42.89	42.89	42.89	200.0
2014-08-04 05:30:00	MSFT	Stock	42.89	42.89	42.89	42.89	100.0
2014-08-04 07:30:00	MSFT	Stock	43.03	43.05	43.03	43.05	7000.0
2014-08-04 08:00:00	MSFT	Stock	43.07	43.07	43.0	43.06	1680.0
2014-08-04 08:30:00	MSFT	Stock	43.07	43.07	43.01	43.01	1600.0
2014-08-04 09:00:00	MSFT	Stock	43.01	43.1	42.96	42.96	21325.0
2014-08-04 09:30:00	MSFT	Stock	42.97	43.23	42.81	43.04	4335936.0
2014-08-04 10:00:00	MSFT	Stock	43.05	43.105	42.93	42.96	2365335.0
2014-08-04 10:30:00	MSFT	Stock	42.96	43.05	42.93	42.95	2633645.0
2014-08-04 11:00:00	MSFT	Stock	42.95	43.14	42.92	43.11	1993878.0
2014-08-04 11:30:00	MSFT	Stock	43.11	43.2	43.01	43.15	1368587.0
2014-08-04 12:00:00	MSFT	Stock	43.15	43.22	43.1	43.15	1448500.0
2014-08-04 12:30:00	MSFT	Stock	43.15	43.19	43.12	43.186	1306509.0
2014-08-04 13:00:00	MSFT	Stock	43.185	43.2	43.07	43.19	1049432.0
2014-08-04 13:30:00	MSFT	Stock	43.19	43.2	43.16	43.16	976982.0
2014-08-04 14:00:00	MSFT	Stock	43.167	43.28	43.16	43.24	1492499.0
2014-08-04 14:30:00	MSFT	Stock	43.24	43.36	43.18	43.346	1588690.0
2014-08-04 15:00:00	MSFT	Stock	43.35	43.426	43.284	43.389	2102726.0

> showing 50 of 83,468 rows — these rows as CSV

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