PREVIEW / stock_30min / 2013-03-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-19.parquet
  size:    1.5 MB
  rows:    78,703
  symbols: 3,468

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-19 04:00:00	AAPL	Stock	16.325	16.325	16.325	16.325	2800.0
2013-03-19 04:30:00	AAPL	Stock	16.3125	16.325	16.3121	16.3125	25200.0
2013-03-19 05:00:00	AAPL	Stock	16.3125	16.3125	16.3125	16.3125	25200.0
2013-03-19 05:30:00	AAPL	Stock	16.3125	16.3125	16.3125	16.3125	2800.0
2013-03-19 06:00:00	AAPL	Stock	16.3375	16.3375	16.2911	16.2911	30800.0
2013-03-19 06:30:00	AAPL	Stock	16.3125	16.3125	16.2857	16.3	84840.0
2013-03-19 07:00:00	AAPL	Stock	16.3	16.3107	16.2507	16.3036	234136.0
2013-03-19 07:30:00	AAPL	Stock	16.3011	16.3261	16.2964	16.3204	206808.0
2013-03-19 08:00:00	AAPL	Stock	16.3	16.4439	16.2679	16.4114	2845304.0
2013-03-19 08:30:00	AAPL	Stock	16.4021	16.4221	16.3929	16.4018	1457792.0
2013-03-19 09:00:00	AAPL	Stock	16.4064	16.4221	16.3768	16.41	2734480.0
2013-03-19 09:30:00	AAPL	Stock	16.4107	16.4632	16.3036	16.3604	98772016.0
2013-03-19 10:00:00	AAPL	Stock	16.36	16.39	16.2418	16.2532	50693272.0
2013-03-19 10:30:00	AAPL	Stock	16.2553	16.2632	16.1393	16.1561	55212584.0
2013-03-19 11:00:00	AAPL	Stock	16.1536	16.2186	16.1311	16.2078	33832708.0
2013-03-19 11:30:00	AAPL	Stock	16.2077	16.2182	16.0861	16.1031	30709308.0
2013-03-19 12:00:00	AAPL	Stock	16.1029	16.1243	16.0429	16.0761	35425208.0
2013-03-19 12:30:00	AAPL	Stock	16.0754	16.1161	16.0571	16.0914	17948056.0
2013-03-19 13:00:00	AAPL	Stock	16.0904	16.1357	16.0179	16.0389	25396700.0
2013-03-19 13:30:00	AAPL	Stock	16.0414	16.0936	16.0268	16.07	15997968.0
2013-03-19 14:00:00	AAPL	Stock	16.0686	16.1982	16.0579	16.1882	27631688.0
2013-03-19 14:30:00	AAPL	Stock	16.1868	16.2061	16.0936	16.1261	20773256.0
2013-03-19 15:00:00	AAPL	Stock	16.1275	16.2429	16.0714	16.1625	34823040.0
2013-03-19 15:30:00	AAPL	Stock	16.1627	16.2357	16.1296	16.2318	43809556.0
2013-03-19 16:00:00	AAPL	Stock	16.2318	16.2386	16.2075	16.2285	11547648.0
2013-03-19 16:30:00	AAPL	Stock	16.2143	16.252	16.1254	16.2054	1222312.0
2013-03-19 17:00:00	AAPL	Stock	16.2	16.2318	16.1986	16.2089	367080.0
2013-03-19 17:30:00	AAPL	Stock	16.2089	16.2318	16.2089	16.2232	237412.0
2013-03-19 18:00:00	AAPL	Stock	16.2168	16.2232	16.2143	16.2143	42700.0
2013-03-19 18:30:00	AAPL	Stock	16.2214	16.2214	16.2	16.2046	110124.0
2013-03-19 19:00:00	AAPL	Stock	16.2068	16.2068	16.1986	16.1989	94696.0
2013-03-19 19:30:00	AAPL	Stock	16.2032	16.2143	16.2032	16.2125	398888.0
2013-03-19 07:30:00	MSFT	Stock	28.1	28.1	28.1	28.1	100.0
2013-03-19 08:00:00	MSFT	Stock	28.1	28.15	28.1	28.1	420.0
2013-03-19 08:30:00	MSFT	Stock	28.15	28.15	28.15	28.15	200.0
2013-03-19 09:00:00	MSFT	Stock	28.18	28.2	28.15	28.18	6927.0
2013-03-19 09:30:00	MSFT	Stock	28.12	28.19	28.055	28.17	3349955.0
2013-03-19 10:00:00	MSFT	Stock	28.16	28.22	28.06	28.12	3470173.0
2013-03-19 10:30:00	MSFT	Stock	28.11	28.145	28.08	28.13	3148872.0
2013-03-19 11:00:00	MSFT	Stock	28.12	28.138	28.06	28.114	1610276.0
2013-03-19 11:30:00	MSFT	Stock	28.114	28.13	28.03	28.06	4845412.0
2013-03-19 12:00:00	MSFT	Stock	28.065	28.13	28.04	28.085	5135898.0
2013-03-19 12:30:00	MSFT	Stock	28.09	28.11	28.055	28.06	1405941.0
2013-03-19 13:00:00	MSFT	Stock	28.06	28.1	28.03	28.07	7349284.0
2013-03-19 13:30:00	MSFT	Stock	28.07	28.105	28.055	28.09	2077894.0
2013-03-19 14:00:00	MSFT	Stock	28.08	28.11	28.05	28.075	4084699.0
2013-03-19 14:30:00	MSFT	Stock	28.075	28.11	28.06	28.087	2945630.0
2013-03-19 15:00:00	MSFT	Stock	28.085	28.19	28.05	28.085	4769148.0
2013-03-19 15:30:00	MSFT	Stock	28.085	28.18	28.06	28.17	5281563.0
2013-03-19 16:00:00	MSFT	Stock	28.18	28.18	28.08	28.08	1671941.0

> showing 50 of 78,703 rows — these rows as CSV

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