PREVIEW / stock_30min / 2013-03-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-20.parquet
  size:    1.5 MB
  rows:    76,779
  symbols: 3,458

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-03-20 04:00:00	AAPL	Stock	16.3036	16.3036	16.3036	16.3036	5600.0
2013-03-20 05:00:00	AAPL	Stock	16.31	16.31	16.31	16.31	2800.0
2013-03-20 05:30:00	AAPL	Stock	16.3107	16.3107	16.3107	16.3107	12040.0
2013-03-20 06:00:00	AAPL	Stock	16.3143	16.3286	16.3143	16.3286	18060.0
2013-03-20 06:30:00	AAPL	Stock	16.3018	16.3214	16.3018	16.3125	23884.0
2013-03-20 07:00:00	AAPL	Stock	16.3179	16.3179	16.2857	16.31	210448.0
2013-03-20 07:30:00	AAPL	Stock	16.3036	16.3036	16.2721	16.2839	219632.0
2013-03-20 08:00:00	AAPL	Stock	16.3118	16.3286	16.2732	16.305	1489796.0
2013-03-20 08:30:00	AAPL	Stock	16.3	16.3121	16.2318	16.3043	870968.0
2013-03-20 09:00:00	AAPL	Stock	16.3036	16.3514	16.2996	16.3439	1450792.0
2013-03-20 09:30:00	AAPL	Stock	16.3393	16.3439	16.084	16.0846	67421480.0
2013-03-20 10:00:00	AAPL	Stock	16.0851	16.1607	16.0849	16.1525	35386820.0
2013-03-20 10:30:00	AAPL	Stock	16.1564	16.1954	16.0946	16.1146	23443140.0
2013-03-20 11:00:00	AAPL	Stock	16.1118	16.1393	16.0914	16.1154	15811656.0
2013-03-20 11:30:00	AAPL	Stock	16.1154	16.1389	16.0568	16.0675	17419164.0
2013-03-20 12:00:00	AAPL	Stock	16.0686	16.1354	16.0657	16.1296	16116716.0
2013-03-20 12:30:00	AAPL	Stock	16.1329	16.1687	16.1064	16.1687	12496820.0
2013-03-20 13:00:00	AAPL	Stock	16.1604	16.1707	16.1171	16.1347	9422504.0
2013-03-20 13:30:00	AAPL	Stock	16.1346	16.1514	16.1147	16.1314	7677824.0
2013-03-20 14:00:00	AAPL	Stock	16.1254	16.1714	16.1157	16.1522	15202992.0
2013-03-20 14:30:00	AAPL	Stock	16.1537	16.1704	16.125	16.1375	13246688.0
2013-03-20 15:00:00	AAPL	Stock	16.1371	16.16	16.1036	16.1439	19355336.0
2013-03-20 15:30:00	AAPL	Stock	16.1409	16.1675	16.1111	16.1439	29952216.0
2013-03-20 16:00:00	AAPL	Stock	16.1464	16.15	16.0936	16.1018	9069956.0
2013-03-20 16:30:00	AAPL	Stock	16.1036	16.1383	16.0936	16.1011	323876.0
2013-03-20 17:00:00	AAPL	Stock	16.0996	16.1457	16.0929	16.0964	547008.0
2013-03-20 17:30:00	AAPL	Stock	16.1007	16.1036	16.0982	16.1018	142128.0
2013-03-20 18:00:00	AAPL	Stock	16.1	16.1036	16.0964	16.1018	156240.0
2013-03-20 18:30:00	AAPL	Stock	16.1018	16.1161	16.1018	16.1161	69132.0
2013-03-20 19:00:00	AAPL	Stock	16.11	16.1171	16.0911	16.0911	200984.0
2013-03-20 19:30:00	AAPL	Stock	16.1	16.1018	16.0893	16.0946	166880.0
2013-03-20 05:30:00	MSFT	Stock	28.3	28.33	28.3	28.33	309.0
2013-03-20 07:00:00	MSFT	Stock	28.2	28.29	28.2	28.29	600.0
2013-03-20 08:00:00	MSFT	Stock	28.21	28.31	28.21	28.3	29301.0
2013-03-20 08:30:00	MSFT	Stock	28.29	28.35	28.28	28.28	47550.0
2013-03-20 09:00:00	MSFT	Stock	28.28	28.35	28.28	28.35	40248.0
2013-03-20 09:30:00	MSFT	Stock	28.34	28.49	28.3	28.31	4709598.0
2013-03-20 10:00:00	MSFT	Stock	28.315	28.39	28.29	28.31	2719298.0
2013-03-20 10:30:00	MSFT	Stock	28.32	28.32	28.19	28.305	2705054.0
2013-03-20 11:00:00	MSFT	Stock	28.315	28.32	28.2	28.22	2268942.0
2013-03-20 11:30:00	MSFT	Stock	28.22	28.26	28.18	28.19	1874170.0
2013-03-20 12:00:00	MSFT	Stock	28.19	28.22	28.18	28.21	2118753.0
2013-03-20 12:30:00	MSFT	Stock	28.2	28.26	28.2	28.24	1269382.0
2013-03-20 13:00:00	MSFT	Stock	28.245	28.26	28.24	28.246	490000.0
2013-03-20 13:30:00	MSFT	Stock	28.24	28.265	28.22	28.25	1611897.0
2013-03-20 14:00:00	MSFT	Stock	28.245	28.395	28.23	28.36	2357842.0
2013-03-20 14:30:00	MSFT	Stock	28.36	28.38	28.32	28.33	1893560.0
2013-03-20 15:00:00	MSFT	Stock	28.33	28.34	28.28	28.295	2085613.0
2013-03-20 15:30:00	MSFT	Stock	28.295	28.345	28.23	28.3	5611676.0
2013-03-20 16:00:00	MSFT	Stock	28.3	28.34	28.06	28.218	2987014.0

> showing 50 of 76,779 rows — these rows as CSV

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