PREVIEW / stock_30min / 2014-09-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-29.parquet
  size:    1.6 MB
  rows:    82,978
  symbols: 3,586

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-09-29 04:00:00	AAPL	Stock	25.135	25.135	24.7475	24.82	114144.0
2014-09-29 04:30:00	AAPL	Stock	24.8175	24.8175	24.7	24.775	118216.0
2014-09-29 05:00:00	AAPL	Stock	24.775	24.855	24.7575	24.8325	63004.0
2014-09-29 05:30:00	AAPL	Stock	24.855	24.855	24.8375	24.84	12936.0
2014-09-29 06:00:00	AAPL	Stock	24.845	24.95	24.845	24.9275	34588.0
2014-09-29 06:30:00	AAPL	Stock	24.9275	24.9375	24.875	24.875	93508.0
2014-09-29 07:00:00	AAPL	Stock	24.895	24.9975	24.88	24.88	474132.0
2014-09-29 07:30:00	AAPL	Stock	24.8875	24.9025	24.865	24.9	314512.0
2014-09-29 08:00:00	AAPL	Stock	24.9025	24.9825	24.8725	24.875	808864.0
2014-09-29 08:30:00	AAPL	Stock	24.885	24.9075	24.7425	24.75	1296560.0
2014-09-29 09:00:00	AAPL	Stock	24.75	24.77	24.63	24.675	1604456.0
2014-09-29 09:30:00	AAPL	Stock	24.6825	24.8625	24.6575	24.8	30734480.0
2014-09-29 10:00:00	AAPL	Stock	24.8	25.0125	24.7775	24.94	17449032.0
2014-09-29 10:30:00	AAPL	Stock	24.9382	25.0	24.8925	24.9625	11604004.0
2014-09-29 11:00:00	AAPL	Stock	24.9578	25.1	24.9362	25.0175	15101428.0
2014-09-29 11:30:00	AAPL	Stock	25.02	25.0475	24.99	25.0335	8672988.0
2014-09-29 12:00:00	AAPL	Stock	25.0325	25.0725	24.9525	24.99	9071116.0
2014-09-29 12:30:00	AAPL	Stock	24.99	25.06	24.92	25.0462	8015852.0
2014-09-29 13:00:00	AAPL	Stock	25.045	25.1	25.0175	25.0492	8819188.0
2014-09-29 13:30:00	AAPL	Stock	25.0478	25.0875	25.0125	25.065	6173588.0
2014-09-29 14:00:00	AAPL	Stock	25.0625	25.0775	24.94	24.9492	9261348.0
2014-09-29 14:30:00	AAPL	Stock	24.9475	25.035	24.885	25.02	11890392.0
2014-09-29 15:00:00	AAPL	Stock	25.0208	25.1088	24.975	25.0875	15430704.0
2014-09-29 15:30:00	AAPL	Stock	25.09	25.0975	25.02	25.0275	17290792.0
2014-09-29 16:00:00	AAPL	Stock	25.0275	25.1548	24.9658	25.005	6599900.0
2014-09-29 16:30:00	AAPL	Stock	25.0	25.05	24.995	25.05	210216.0
2014-09-29 17:00:00	AAPL	Stock	25.0	25.0275	24.9925	24.9925	560004.0
2014-09-29 17:30:00	AAPL	Stock	24.9925	25.0	24.99	24.9925	1250332.0
2014-09-29 18:00:00	AAPL	Stock	24.9975	25.0275	24.99	24.9975	51812.0
2014-09-29 18:30:00	AAPL	Stock	25.0275	25.0275	24.99	24.99	608944.0
2014-09-29 19:00:00	AAPL	Stock	24.99	24.99	24.9875	24.9875	16608.0
2014-09-29 19:30:00	AAPL	Stock	24.9925	24.9975	24.9775	24.985	62416.0
2014-09-29 04:00:00	MSFT	Stock	46.39	46.39	46.23	46.23	300.0
2014-09-29 04:30:00	MSFT	Stock	46.22	46.22	46.22	46.22	300.0
2014-09-29 06:00:00	MSFT	Stock	46.22	46.22	46.22	46.22	500.0
2014-09-29 07:00:00	MSFT	Stock	46.1	46.1	46.1	46.1	2146.0
2014-09-29 08:00:00	MSFT	Stock	46.22	46.22	46.1	46.11	420.0
2014-09-29 08:30:00	MSFT	Stock	46.2	46.21	46.08	46.08	7356.0
2014-09-29 09:00:00	MSFT	Stock	46.05	46.13	45.98	45.98	3506.0
2014-09-29 09:30:00	MSFT	Stock	45.98	46.16	45.76	46.07	3273500.0
2014-09-29 10:00:00	MSFT	Stock	46.07	46.22	45.96	46.15	2053960.0
2014-09-29 10:30:00	MSFT	Stock	46.16	46.33	46.13	46.305	1401148.0
2014-09-29 11:00:00	MSFT	Stock	46.3	46.45	46.26	46.35	2060114.0
2014-09-29 11:30:00	MSFT	Stock	46.35	46.4	46.32	46.4	1063609.0
2014-09-29 12:00:00	MSFT	Stock	46.4	46.4	46.17	46.23	1243876.0
2014-09-29 12:30:00	MSFT	Stock	46.225	46.3	46.16	46.3	1192629.0
2014-09-29 13:00:00	MSFT	Stock	46.3	46.305	46.195	46.275	971634.0
2014-09-29 13:30:00	MSFT	Stock	46.27	46.34	46.26	46.295	721737.0
2014-09-29 14:00:00	MSFT	Stock	46.3	46.34	46.21	46.255	1323061.0
2014-09-29 14:30:00	MSFT	Stock	46.255	46.381	46.24	46.38	857793.0

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

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