PREVIEW / stock_30min / 2013-09-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-30.parquet
  size:    1.6 MB
  rows:    81,349
  symbols: 3,548

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-09-30 04:00:00	AAPL	Stock	17.1532	17.1532	17.0104	17.0104	188888.0
2013-09-30 04:30:00	AAPL	Stock	17.0118	17.0446	17.0039	17.0446	33404.0
2013-09-30 05:30:00	AAPL	Stock	17.0539	17.0714	17.0539	17.0714	16800.0
2013-09-30 06:00:00	AAPL	Stock	17.0543	17.0786	17.0543	17.0714	36064.0
2013-09-30 06:30:00	AAPL	Stock	17.0754	17.0754	17.0539	17.0593	225372.0
2013-09-30 07:00:00	AAPL	Stock	17.0607	17.0961	17.0482	17.0482	330036.0
2013-09-30 07:30:00	AAPL	Stock	17.0586	17.1204	17.0571	17.0893	786100.0
2013-09-30 08:00:00	AAPL	Stock	17.0893	17.1489	17.0393	17.1314	901992.0
2013-09-30 08:30:00	AAPL	Stock	17.1411	17.155	17.0893	17.0929	876988.0
2013-09-30 09:00:00	AAPL	Stock	17.0904	17.3214	17.0104	17.0204	2068220.0
2013-09-30 09:30:00	AAPL	Stock	17.0296	17.1139	16.9432	17.0982	53632712.0
2013-09-30 10:00:00	AAPL	Stock	17.0915	17.1307	17.0357	17.0946	23208052.0
2013-09-30 10:30:00	AAPL	Stock	17.0996	17.2021	17.0904	17.1471	21538636.0
2013-09-30 11:00:00	AAPL	Stock	17.148	17.1529	17.0761	17.105	12315156.0
2013-09-30 11:30:00	AAPL	Stock	17.1075	17.1357	17.1054	17.1279	6533912.0
2013-09-30 12:00:00	AAPL	Stock	17.1272	17.1286	17.0905	17.107	5688648.0
2013-09-30 12:30:00	AAPL	Stock	17.1064	17.1529	17.1032	17.1269	6798512.0
2013-09-30 13:00:00	AAPL	Stock	17.1261	17.1429	17.0832	17.0971	8649452.0
2013-09-30 13:30:00	AAPL	Stock	17.0957	17.1161	17.0682	17.0779	8526224.0
2013-09-30 14:00:00	AAPL	Stock	17.0804	17.0857	17.06	17.0632	6594896.0
2013-09-30 14:30:00	AAPL	Stock	17.0634	17.1021	17.0604	17.0605	9184364.0
2013-09-30 15:00:00	AAPL	Stock	17.0604	17.0639	16.9879	17.0311	22230068.0
2013-09-30 15:30:00	AAPL	Stock	17.0307	17.0561	16.9861	17.0268	32191488.0
2013-09-30 16:00:00	AAPL	Stock	17.0293	17.0647	17.0221	17.0268	27955956.0
2013-09-30 16:30:00	AAPL	Stock	17.0264	17.0409	17.0036	17.0132	382928.0
2013-09-30 17:00:00	AAPL	Stock	17.0146	17.0257	17.0004	17.0204	256984.0
2013-09-30 17:30:00	AAPL	Stock	17.0179	17.0268	17.0179	17.0196	309372.0
2013-09-30 18:00:00	AAPL	Stock	17.0179	17.0321	17.0118	17.0271	147168.0
2013-09-30 18:30:00	AAPL	Stock	17.0293	17.0357	17.0271	17.0314	285544.0
2013-09-30 19:00:00	AAPL	Stock	17.0286	17.0343	17.0214	17.0343	62244.0
2013-09-30 19:30:00	AAPL	Stock	17.0346	17.0368	17.0146	17.0214	251160.0
2013-09-30 04:00:00	MSFT	Stock	33.29	33.29	33.29	33.29	100.0
2013-09-30 06:30:00	MSFT	Stock	32.98	32.98	32.98	32.98	1000.0
2013-09-30 07:00:00	MSFT	Stock	32.95	33.06	32.88	33.0	2300.0
2013-09-30 07:30:00	MSFT	Stock	33.0	33.0	33.0	33.0	1000.0
2013-09-30 08:00:00	MSFT	Stock	33.01	33.14	32.86	32.98	8570.0
2013-09-30 08:30:00	MSFT	Stock	32.98	33.0	32.95	32.97	9701.0
2013-09-30 09:00:00	MSFT	Stock	32.98	33.02	32.98	33.0	10070.0
2013-09-30 09:30:00	MSFT	Stock	32.97	33.0	32.7	32.74	5520968.0
2013-09-30 10:00:00	MSFT	Stock	32.733	32.96	32.733	32.86	2611665.0
2013-09-30 10:30:00	MSFT	Stock	32.86	32.93	32.82	32.885	2093139.0
2013-09-30 11:00:00	MSFT	Stock	32.88	33.04	32.85	33.029	2006571.0
2013-09-30 11:30:00	MSFT	Stock	33.021	33.11	33.0	33.11	1511587.0
2013-09-30 12:00:00	MSFT	Stock	33.108	33.11	32.958	32.99	1361744.0
2013-09-30 12:30:00	MSFT	Stock	32.98	33.07	32.97	33.0	956282.0
2013-09-30 13:00:00	MSFT	Stock	33.01	33.15	33.01	33.076	1364059.0
2013-09-30 13:30:00	MSFT	Stock	33.075	33.135	33.06	33.1	1554150.0
2013-09-30 14:00:00	MSFT	Stock	33.105	33.14	33.07	33.085	1196023.0
2013-09-30 14:30:00	MSFT	Stock	33.085	33.2	33.08	33.185	1566004.0
2013-09-30 15:00:00	MSFT	Stock	33.18	33.185	33.05	33.07	2486321.0

> showing 50 of 81,349 rows — these rows as CSV

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