PREVIEW / stock_30min / 2014-05-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-15.parquet
  size:    1.6 MB
  rows:    83,828
  symbols: 3,537

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-15 05:30:00	AAPL	Stock	21.1804	21.1804	21.1804	21.1804	2800.0
2014-05-15 07:00:00	AAPL	Stock	21.1964	21.2139	21.1964	21.2139	75488.0
2014-05-15 07:30:00	AAPL	Stock	21.2029	21.2029	21.1804	21.1804	8400.0
2014-05-15 08:00:00	AAPL	Stock	21.1829	21.2029	21.1768	21.1964	87444.0
2014-05-15 08:30:00	AAPL	Stock	21.1996	21.2482	21.1993	21.2143	401576.0
2014-05-15 09:00:00	AAPL	Stock	21.2143	21.2468	21.2039	21.2289	388752.0
2014-05-15 09:30:00	AAPL	Stock	21.2354	21.3071	21.1875	21.2421	33133744.0
2014-05-15 10:00:00	AAPL	Stock	21.2354	21.2436	21.1036	21.1568	23408364.0
2014-05-15 10:30:00	AAPL	Stock	21.1611	21.1818	21.1289	21.1554	10852856.0
2014-05-15 11:00:00	AAPL	Stock	21.1579	21.1607	21.0657	21.0789	14459228.0
2014-05-15 11:30:00	AAPL	Stock	21.0721	21.1393	21.0207	21.0421	15110620.0
2014-05-15 12:00:00	AAPL	Stock	21.0446	21.0786	21.0268	21.0625	11908988.0
2014-05-15 12:30:00	AAPL	Stock	21.0572	21.095	21.0514	21.0689	5461512.0
2014-05-15 13:00:00	AAPL	Stock	21.0723	21.0889	21.0482	21.0839	6437956.0
2014-05-15 13:30:00	AAPL	Stock	21.0839	21.0879	21.0268	21.0293	8594432.0
2014-05-15 14:00:00	AAPL	Stock	21.03	21.0704	21.0014	21.0614	13233556.0
2014-05-15 14:30:00	AAPL	Stock	21.0566	21.105	21.0546	21.0968	10706948.0
2014-05-15 15:00:00	AAPL	Stock	21.1021	21.1086	21.0507	21.0654	7952112.0
2014-05-15 15:30:00	AAPL	Stock	21.0668	21.0946	21.0286	21.0293	15492652.0
2014-05-15 16:00:00	AAPL	Stock	21.0293	21.0714	20.9993	21.0179	11436544.0
2014-05-15 16:30:00	AAPL	Stock	21.0179	21.0293	21.0129	21.0179	308112.0
2014-05-15 17:00:00	AAPL	Stock	21.0143	21.0293	21.0089	21.0136	521780.0
2014-05-15 17:30:00	AAPL	Stock	21.0161	21.0161	21.0057	21.0089	49420.0
2014-05-15 18:00:00	AAPL	Stock	21.0168	21.0293	21.0125	21.0125	558208.0
2014-05-15 18:30:00	AAPL	Stock	21.0143	21.0143	21.0143	21.0143	11032.0
2014-05-15 19:00:00	AAPL	Stock	21.0179	21.0179	21.0143	21.0143	52640.0
2014-05-15 19:30:00	AAPL	Stock	21.0179	21.0282	21.0143	21.0282	168000.0
2014-05-15 08:00:00	MSFT	Stock	40.19	40.19	40.19	40.19	700.0
2014-05-15 08:30:00	MSFT	Stock	40.21	40.21	40.21	40.21	300.0
2014-05-15 09:00:00	MSFT	Stock	40.19	40.19	40.1	40.17	8950.0
2014-05-15 09:30:00	MSFT	Stock	40.16	40.4	39.76	39.85	3291489.0
2014-05-15 10:00:00	MSFT	Stock	39.85	39.86	39.54	39.68	4314398.0
2014-05-15 10:30:00	MSFT	Stock	39.68	39.82	39.6	39.66	1834656.0
2014-05-15 11:00:00	MSFT	Stock	39.67	39.72	39.59	39.64	1977012.0
2014-05-15 11:30:00	MSFT	Stock	39.65	39.68	39.56	39.62	1964094.0
2014-05-15 12:00:00	MSFT	Stock	39.61	39.68	39.51	39.59	1355328.0
2014-05-15 12:30:00	MSFT	Stock	39.59	39.67	39.57	39.62	1107306.0
2014-05-15 13:00:00	MSFT	Stock	39.62	39.68	39.55	39.68	1200117.0
2014-05-15 13:30:00	MSFT	Stock	39.68	39.7	39.53	39.6	8182404.0
2014-05-15 14:00:00	MSFT	Stock	39.6	39.64	39.51	39.57	1733629.0
2014-05-15 14:30:00	MSFT	Stock	39.571	39.78	39.54	39.695	1435760.0
2014-05-15 15:00:00	MSFT	Stock	39.7	39.735	39.56	39.612	2112875.0
2014-05-15 15:30:00	MSFT	Stock	39.62	39.7	39.58	39.61	4137121.0
2014-05-15 16:00:00	MSFT	Stock	39.6	39.68	39.598	39.6	1583821.0
2014-05-15 16:30:00	MSFT	Stock	39.61	39.64	39.592	39.61	64312.0
2014-05-15 17:00:00	MSFT	Stock	39.6	39.61	39.6	39.61	134410.0
2014-05-15 17:30:00	MSFT	Stock	39.6	39.6	39.6	39.6	500.0
2014-05-15 18:00:00	MSFT	Stock	39.6	39.6	39.6	39.6	15333.0
2014-05-15 18:30:00	MSFT	Stock	39.61	39.61	39.61	39.61	270.0
2014-05-15 19:00:00	MSFT	Stock	39.58	39.58	39.58	39.58	200.0

> showing 50 of 83,828 rows — these rows as CSV

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