PREVIEW / stock_30min / 2013-07-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-11.parquet
  size:    1.5 MB
  rows:    79,313
  symbols: 3,500

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
2013-07-11 04:00:00	AAPL	Stock	15.1596	15.1604	15.1586	15.1604	20300.0
2013-07-11 04:30:00	AAPL	Stock	15.1521	15.1521	15.1479	15.1479	26712.0
2013-07-11 05:00:00	AAPL	Stock	15.1479	15.1479	15.1293	15.1293	21000.0
2013-07-11 06:00:00	AAPL	Stock	15.1286	15.1296	15.1286	15.1296	5600.0
2013-07-11 07:00:00	AAPL	Stock	15.1286	15.1429	15.1071	15.1179	122976.0
2013-07-11 07:30:00	AAPL	Stock	15.1146	15.13	15.0857	15.1075	238812.0
2013-07-11 08:00:00	AAPL	Stock	15.1071	15.1429	15.1071	15.1304	1024520.0
2013-07-11 08:30:00	AAPL	Stock	15.1304	15.1304	15.0982	15.1071	900144.0
2013-07-11 09:00:00	AAPL	Stock	15.1071	15.125	15.0946	15.0961	733572.0
2013-07-11 09:30:00	AAPL	Stock	15.1036	15.1414	15.0418	15.1029	47287492.0
2013-07-11 10:00:00	AAPL	Stock	15.1064	15.1304	15.0743	15.1143	23834888.0
2013-07-11 10:30:00	AAPL	Stock	15.1164	15.1859	15.0832	15.1786	32955832.0
2013-07-11 11:00:00	AAPL	Stock	15.1811	15.2261	15.155	15.2201	23301152.0
2013-07-11 11:30:00	AAPL	Stock	15.223	15.2386	15.1936	15.2354	14112112.0
2013-07-11 12:00:00	AAPL	Stock	15.2354	15.2568	15.1962	15.2482	16742544.0
2013-07-11 12:30:00	AAPL	Stock	15.2443	15.2757	15.2286	15.2642	21455028.0
2013-07-11 13:00:00	AAPL	Stock	15.2643	15.2746	15.2346	15.2457	15639288.0
2013-07-11 13:30:00	AAPL	Stock	15.2479	15.2768	15.2204	15.2529	16072336.0
2013-07-11 14:00:00	AAPL	Stock	15.2554	15.2857	15.2468	15.2746	17879540.0
2013-07-11 14:30:00	AAPL	Stock	15.275	15.2946	15.2311	15.2457	21127372.0
2013-07-11 15:00:00	AAPL	Stock	15.2464	15.2886	15.2421	15.2696	17647308.0
2013-07-11 15:30:00	AAPL	Stock	15.2689	15.2843	15.2389	15.2625	27855716.0
2013-07-11 16:00:00	AAPL	Stock	15.265	15.275	15.1991	15.2586	24194436.0
2013-07-11 16:30:00	AAPL	Stock	15.2668	15.3234	15.156	15.3234	347788.0
2013-07-11 17:00:00	AAPL	Stock	15.26	15.2607	15.2568	15.26	78568.0
2013-07-11 17:30:00	AAPL	Stock	15.2614	15.2614	15.2607	15.2611	12404.0
2013-07-11 18:00:00	AAPL	Stock	15.2643	15.2643	15.2643	15.2643	5600.0
2013-07-11 18:30:00	AAPL	Stock	15.2657	15.2657	15.2643	15.2654	21756.0
2013-07-11 19:00:00	AAPL	Stock	15.26	15.2657	15.26	15.2657	44800.0
2013-07-11 19:30:00	AAPL	Stock	15.2675	15.2789	15.2561	15.2561	117040.0
2013-07-11 04:30:00	MSFT	Stock	34.97	34.97	34.97	34.97	1361.0
2013-07-11 05:00:00	MSFT	Stock	34.81	35.12	34.8	35.12	1860.0
2013-07-11 07:00:00	MSFT	Stock	35.0	35.0	34.97	34.97	200.0
2013-07-11 07:30:00	MSFT	Stock	34.97	35.1	34.97	35.05	8993.0
2013-07-11 08:00:00	MSFT	Stock	35.1	35.17	35.09	35.17	34146.0
2013-07-11 08:30:00	MSFT	Stock	35.13	35.18	34.7	35.13	169934.0
2013-07-11 09:00:00	MSFT	Stock	35.12	35.15	34.96	35.0	461725.0
2013-07-11 09:30:00	MSFT	Stock	35.0	35.37	34.9	35.36	7201594.0
2013-07-11 10:00:00	MSFT	Stock	35.35	35.36	35.13	35.165	3984739.0
2013-07-11 10:30:00	MSFT	Stock	35.165	35.205	35.11	35.15	2978190.0
2013-07-11 11:00:00	MSFT	Stock	35.16	35.33	35.14	35.32	3319268.0
2013-07-11 11:30:00	MSFT	Stock	35.32	35.37	35.25	35.37	2214368.0
2013-07-11 12:00:00	MSFT	Stock	35.365	35.38	35.33	35.344	2079734.0
2013-07-11 12:30:00	MSFT	Stock	35.34	35.46	35.27	35.45	2711726.0
2013-07-11 13:00:00	MSFT	Stock	35.45	35.47	35.38	35.394	1926374.0
2013-07-11 13:30:00	MSFT	Stock	35.4	35.43	35.39	35.411	1539006.0
2013-07-11 14:00:00	MSFT	Stock	35.415	35.57	35.37	35.56	2580031.0
2013-07-11 14:30:00	MSFT	Stock	35.57	35.67	35.56	35.66	3004025.0
2013-07-11 15:00:00	MSFT	Stock	35.655	35.76	35.61	35.745	3244314.0
2013-07-11 15:30:00	MSFT	Stock	35.74	35.77	35.64	35.68	9977315.0

> showing 50 of 79,313 rows — these rows as CSV

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