PREVIEW / stock_30min / 2013-03-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-08.parquet
  size:    1.5 MB
  rows:    76,903
  symbols: 3,494

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-08 04:00:00	AAPL	Stock	15.3964	15.3964	15.3921	15.3921	25200.0
2013-03-08 04:30:00	AAPL	Stock	15.4196	15.4196	15.4196	15.4196	5600.0
2013-03-08 05:00:00	AAPL	Stock	15.4196	15.4196	15.4	15.4	11200.0
2013-03-08 05:30:00	AAPL	Stock	15.3964	15.4196	15.3964	15.4196	5600.0
2013-03-08 06:00:00	AAPL	Stock	15.4196	15.4196	15.4189	15.4196	13300.0
2013-03-08 06:30:00	AAPL	Stock	15.4189	15.4196	15.4068	15.4068	52108.0
2013-03-08 07:00:00	AAPL	Stock	15.4089	15.4593	15.4089	15.4179	408632.0
2013-03-08 07:30:00	AAPL	Stock	15.4214	15.4321	15.3393	15.35	495740.0
2013-03-08 08:00:00	AAPL	Stock	15.3621	15.4429	15.2964	15.3143	1482656.0
2013-03-08 08:30:00	AAPL	Stock	15.3143	15.3893	15.2904	15.3121	2934792.0
2013-03-08 09:00:00	AAPL	Stock	15.3121	15.355	15.3	15.3518	2103360.0
2013-03-08 09:30:00	AAPL	Stock	15.3504	15.5511	15.3075	15.51	103085668.0
2013-03-08 10:00:00	AAPL	Stock	15.5143	15.5143	15.3571	15.4861	47157572.0
2013-03-08 10:30:00	AAPL	Stock	15.4836	15.4957	15.4021	15.4443	25771004.0
2013-03-08 11:00:00	AAPL	Stock	15.4439	15.45	15.3893	15.4346	18504668.0
2013-03-08 11:30:00	AAPL	Stock	15.4354	15.4671	15.3975	15.4412	16442244.0
2013-03-08 12:00:00	AAPL	Stock	15.4414	15.4518	15.3682	15.3804	14831740.0
2013-03-08 12:30:00	AAPL	Stock	15.3807	15.3925	15.3446	15.3736	18275880.0
2013-03-08 13:00:00	AAPL	Stock	15.3732	15.4318	15.3643	15.4204	14755804.0
2013-03-08 13:30:00	AAPL	Stock	15.4186	15.4414	15.3911	15.4059	12122768.0
2013-03-08 14:00:00	AAPL	Stock	15.4068	15.4282	15.3779	15.3901	8902964.0
2013-03-08 14:30:00	AAPL	Stock	15.3901	15.4043	15.3754	15.3943	9530892.0
2013-03-08 15:00:00	AAPL	Stock	15.3957	15.4504	15.3945	15.4175	19199208.0
2013-03-08 15:30:00	AAPL	Stock	15.4184	15.4407	15.3854	15.4125	39634700.0
2013-03-08 16:00:00	AAPL	Stock	15.4186	15.4382	15.4068	15.415	25237156.0
2013-03-08 16:30:00	AAPL	Stock	15.415	15.4232	15.4143	15.4225	251692.0
2013-03-08 17:00:00	AAPL	Stock	15.4196	15.5411	15.4157	15.4186	152348.0
2013-03-08 17:30:00	AAPL	Stock	15.4186	15.4186	15.4093	15.4179	1522948.0
2013-03-08 18:00:00	AAPL	Stock	15.4179	15.4179	15.4125	15.4132	38640.0
2013-03-08 18:30:00	AAPL	Stock	15.4132	15.4179	15.4132	15.4179	54544.0
2013-03-08 19:00:00	AAPL	Stock	15.4179	15.4236	15.4179	15.4214	21224.0
2013-03-08 19:30:00	AAPL	Stock	15.4211	15.4268	15.4211	15.4232	63756.0
2013-03-08 04:00:00	MSFT	Stock	28.22	28.22	28.22	28.22	100.0
2013-03-08 05:30:00	MSFT	Stock	28.23	28.23	28.23	28.23	100.0
2013-03-08 07:00:00	MSFT	Stock	28.15	28.15	28.15	28.15	300.0
2013-03-08 08:00:00	MSFT	Stock	28.27	28.28	28.22	28.22	700.0
2013-03-08 08:30:00	MSFT	Stock	28.22	28.24	28.2	28.24	24007.0
2013-03-08 09:00:00	MSFT	Stock	28.24	28.31	28.2	28.29	29517.0
2013-03-08 09:30:00	MSFT	Stock	28.25	28.33	28.07	28.09	3911896.0
2013-03-08 10:00:00	MSFT	Stock	28.09	28.18	28.032	28.18	2840801.0
2013-03-08 10:30:00	MSFT	Stock	28.18	28.22	28.15	28.175	1774932.0
2013-03-08 11:00:00	MSFT	Stock	28.18	28.21	28.145	28.18	1600310.0
2013-03-08 11:30:00	MSFT	Stock	28.189	28.21	28.17	28.19	988961.0
2013-03-08 12:00:00	MSFT	Stock	28.19	28.2	28.13	28.14	1734548.0
2013-03-08 12:30:00	MSFT	Stock	28.14	28.15	28.07	28.07	1942708.0
2013-03-08 13:00:00	MSFT	Stock	28.08	28.1	28.065	28.09	1847107.0
2013-03-08 13:30:00	MSFT	Stock	28.084	28.09	28.04	28.045	1596888.0
2013-03-08 14:00:00	MSFT	Stock	28.05	28.07	28.03	28.06	1694072.0
2013-03-08 14:30:00	MSFT	Stock	28.06	28.06	28.02	28.054	1717178.0
2013-03-08 15:00:00	MSFT	Stock	28.05	28.13	28.05	28.1	1747256.0

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

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