PREVIEW / stock_30min / 2014-03-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-28.parquet
  size:    1.6 MB
  rows:    82,834
  symbols: 3,553

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-03-28 04:30:00	AAPL	Stock	19.2657	19.2657	19.2657	19.2657	2800.0
2014-03-28 05:00:00	AAPL	Stock	19.2739	19.2739	19.2739	19.2739	2800.0
2014-03-28 05:30:00	AAPL	Stock	19.275	19.2786	19.2743	19.2786	64400.0
2014-03-28 06:00:00	AAPL	Stock	19.2786	19.3143	19.2786	19.3125	50316.0
2014-03-28 06:30:00	AAPL	Stock	19.3214	19.3214	19.2971	19.2971	16800.0
2014-03-28 07:00:00	AAPL	Stock	19.31	19.32	19.2607	19.2896	133140.0
2014-03-28 07:30:00	AAPL	Stock	19.2932	19.2932	19.2857	19.2857	25340.0
2014-03-28 08:00:00	AAPL	Stock	19.2857	19.3021	19.2675	19.2675	351652.0
2014-03-28 08:30:00	AAPL	Stock	19.2646	19.2668	19.2446	19.2571	196224.0
2014-03-28 09:00:00	AAPL	Stock	19.2629	19.2679	19.2036	19.2221	588028.0
2014-03-28 09:30:00	AAPL	Stock	19.2257	19.2479	19.1475	19.192	28618968.0
2014-03-28 10:00:00	AAPL	Stock	19.1964	19.2231	19.1618	19.1718	10928820.0
2014-03-28 10:30:00	AAPL	Stock	19.1729	19.2136	19.1674	19.2104	8317960.0
2014-03-28 11:00:00	AAPL	Stock	19.2075	19.2146	19.1607	19.1726	11514832.0
2014-03-28 11:30:00	AAPL	Stock	19.1779	19.2043	19.1607	19.1889	10941392.0
2014-03-28 12:00:00	AAPL	Stock	19.1886	19.2207	19.18	19.1907	6293252.0
2014-03-28 12:30:00	AAPL	Stock	19.1914	19.2089	19.1839	19.1993	4128040.0
2014-03-28 13:00:00	AAPL	Stock	19.2004	19.2014	19.1482	19.1586	9039772.0
2014-03-28 13:30:00	AAPL	Stock	19.1607	19.1664	19.1289	19.1457	9707936.0
2014-03-28 14:00:00	AAPL	Stock	19.1407	19.145	19.0804	19.1175	14480648.0
2014-03-28 14:30:00	AAPL	Stock	19.1189	19.1282	19.0829	19.1133	9996952.0
2014-03-28 15:00:00	AAPL	Stock	19.1146	19.1371	19.0986	19.1211	10762864.0
2014-03-28 15:30:00	AAPL	Stock	19.1196	19.1757	19.1168	19.1736	24394188.0
2014-03-28 16:00:00	AAPL	Stock	19.1736	19.1971	19.1632	19.1971	5717572.0
2014-03-28 16:30:00	AAPL	Stock	19.1971	19.1971	19.1697	19.1946	464716.0
2014-03-28 17:00:00	AAPL	Stock	19.1964	19.2032	19.1932	19.1964	493556.0
2014-03-28 17:30:00	AAPL	Stock	19.2	19.2032	19.1736	19.1954	156688.0
2014-03-28 18:00:00	AAPL	Stock	19.1954	19.1954	19.1736	19.1875	1339436.0
2014-03-28 18:30:00	AAPL	Stock	19.19	19.2114	19.19	19.21	49504.0
2014-03-28 19:00:00	AAPL	Stock	19.21	19.2143	19.2046	19.2046	56700.0
2014-03-28 19:30:00	AAPL	Stock	19.2054	19.2121	19.1964	19.2068	49616.0
2014-03-28 05:00:00	MSFT	Stock	39.44	39.44	39.44	39.44	110.0
2014-03-28 06:00:00	MSFT	Stock	39.86	39.86	39.72	39.75	750.0
2014-03-28 06:30:00	MSFT	Stock	39.73	39.75	39.6	39.64	3700.0
2014-03-28 07:30:00	MSFT	Stock	39.69	39.69	39.61	39.61	1000.0
2014-03-28 08:00:00	MSFT	Stock	39.69	39.69	39.6	39.6	8195.0
2014-03-28 08:30:00	MSFT	Stock	39.6	39.75	39.6	39.65	14282.0
2014-03-28 09:00:00	MSFT	Stock	39.72	39.84	39.7	39.78	53515.0
2014-03-28 09:30:00	MSFT	Stock	39.79	40.43	39.68	40.27	8025250.0
2014-03-28 10:00:00	MSFT	Stock	40.28	40.635	40.26	40.471	7415312.0
2014-03-28 10:30:00	MSFT	Stock	40.47	40.57	40.445	40.52	3337963.0
2014-03-28 11:00:00	MSFT	Stock	40.51	40.52	40.32	40.365	2342320.0
2014-03-28 11:30:00	MSFT	Stock	40.365	40.45	40.34	40.45	2139617.0
2014-03-28 12:00:00	MSFT	Stock	40.44	40.556	40.43	40.434	2018130.0
2014-03-28 12:30:00	MSFT	Stock	40.44	40.53	40.41	40.496	1384595.0
2014-03-28 13:00:00	MSFT	Stock	40.5	40.51	40.35	40.405	1317128.0
2014-03-28 13:30:00	MSFT	Stock	40.41	40.49	40.375	40.42	1244509.0
2014-03-28 14:00:00	MSFT	Stock	40.41	40.41	40.17	40.32	2838793.0
2014-03-28 14:30:00	MSFT	Stock	40.32	40.33	40.07	40.124	1589568.0
2014-03-28 15:00:00	MSFT	Stock	40.13	40.3	40.12	40.23	1955044.0

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

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