PREVIEW / stock_30min / 2014-05-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-14.parquet
  size:    1.6 MB
  rows:    84,095
  symbols: 3,541

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-05-14 05:00:00	AAPL	Stock	21.1579	21.1582	21.1446	21.1446	16800.0
2014-05-14 05:30:00	AAPL	Stock	21.1289	21.1289	21.1257	21.1257	8400.0
2014-05-14 06:30:00	AAPL	Stock	21.1321	21.1479	21.1321	21.1479	19600.0
2014-05-14 07:00:00	AAPL	Stock	21.1425	21.1425	21.1418	21.1425	11200.0
2014-05-14 07:30:00	AAPL	Stock	21.135	21.1532	21.1321	21.1532	16800.0
2014-05-14 08:00:00	AAPL	Stock	21.1439	21.1664	21.135	21.1507	208208.0
2014-05-14 08:30:00	AAPL	Stock	21.1586	21.1607	21.1486	21.1571	81928.0
2014-05-14 09:00:00	AAPL	Stock	21.1607	21.1643	21.1482	21.1621	83020.0
2014-05-14 09:30:00	AAPL	Stock	21.1571	21.2757	21.1496	21.2493	22551648.0
2014-05-14 10:00:00	AAPL	Stock	21.2489	21.3357	21.2326	21.2936	20452768.0
2014-05-14 10:30:00	AAPL	Stock	21.2932	21.3064	21.2525	21.2804	10121804.0
2014-05-14 11:00:00	AAPL	Stock	21.2832	21.3007	21.2189	21.2254	7983500.0
2014-05-14 11:30:00	AAPL	Stock	21.2264	21.2686	21.2111	21.2307	6463520.0
2014-05-14 12:00:00	AAPL	Stock	21.2316	21.2693	21.23	21.2557	3422860.0
2014-05-14 12:30:00	AAPL	Stock	21.2554	21.2854	21.2404	21.2757	3292352.0
2014-05-14 13:00:00	AAPL	Stock	21.2789	21.2946	21.265	21.2689	3575684.0
2014-05-14 13:30:00	AAPL	Stock	21.2732	21.2771	21.2293	21.2464	3980508.0
2014-05-14 14:00:00	AAPL	Stock	21.2471	21.2625	21.2321	21.2529	3396176.0
2014-05-14 14:30:00	AAPL	Stock	21.2543	21.275	21.2321	21.2382	5512276.0
2014-05-14 15:00:00	AAPL	Stock	21.2406	21.2421	21.15	21.1707	13092688.0
2014-05-14 15:30:00	AAPL	Stock	21.1711	21.21	21.1336	21.2093	17711428.0
2014-05-14 16:00:00	AAPL	Stock	21.2089	21.2698	21.1932	21.2096	7143024.0
2014-05-14 16:30:00	AAPL	Stock	21.2107	21.2268	21.2054	21.2268	359576.0
2014-05-14 17:00:00	AAPL	Stock	21.2289	21.2289	21.2232	21.2232	16044.0
2014-05-14 17:30:00	AAPL	Stock	21.2232	21.2232	21.22	21.22	8260.0
2014-05-14 18:00:00	AAPL	Stock	21.2264	21.2264	21.2096	21.2261	124992.0
2014-05-14 18:30:00	AAPL	Stock	21.2196	21.2286	21.2179	21.2179	48664.0
2014-05-14 19:00:00	AAPL	Stock	21.2214	21.2229	21.2214	21.2229	20496.0
2014-05-14 19:30:00	AAPL	Stock	21.2207	21.2357	21.2196	21.225	107492.0
2014-05-14 07:00:00	MSFT	Stock	40.22	40.22	40.22	40.22	200.0
2014-05-14 08:00:00	MSFT	Stock	40.3	40.3	40.26	40.26	700.0
2014-05-14 08:30:00	MSFT	Stock	40.27	40.3	40.27	40.3	1250.0
2014-05-14 09:00:00	MSFT	Stock	40.3	40.32	40.25	40.27	5200.0
2014-05-14 09:30:00	MSFT	Stock	40.3	40.45	40.2	40.41	3146517.0
2014-05-14 10:00:00	MSFT	Stock	40.416	40.45	40.21	40.325	1901148.0
2014-05-14 10:30:00	MSFT	Stock	40.32	40.41	40.255	40.27	1108676.0
2014-05-14 11:00:00	MSFT	Stock	40.27	40.29	40.18	40.22	705369.0
2014-05-14 11:30:00	MSFT	Stock	40.22	40.29	40.17	40.2	942057.0
2014-05-14 12:00:00	MSFT	Stock	40.204	40.32	40.203	40.285	645645.0
2014-05-14 12:30:00	MSFT	Stock	40.28	40.36	40.23	40.28	627789.0
2014-05-14 13:00:00	MSFT	Stock	40.29	40.35	40.28	40.325	441736.0
2014-05-14 13:30:00	MSFT	Stock	40.323	40.33	40.26	40.27	505515.0
2014-05-14 14:00:00	MSFT	Stock	40.28	40.29	40.23	40.28	630979.0
2014-05-14 14:30:00	MSFT	Stock	40.28	40.31	40.205	40.235	881283.0
2014-05-14 15:00:00	MSFT	Stock	40.232	40.28	40.185	40.205	1297648.0
2014-05-14 15:30:00	MSFT	Stock	40.205	40.24	40.05	40.24	3636612.0
2014-05-14 16:00:00	MSFT	Stock	40.24	40.292	40.15	40.24	1726331.0
2014-05-14 16:30:00	MSFT	Stock	40.27	40.29	40.232	40.235	45779.0
2014-05-14 17:00:00	MSFT	Stock	40.241	40.3	40.241	40.28	1195.0
2014-05-14 17:30:00	MSFT	Stock	40.25	40.25	40.25	40.25	1000.0

> showing 50 of 84,095 rows — these rows as CSV

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