PREVIEW / stock_30min / 2013-11-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-04.parquet
  size:    1.7 MB
  rows:    88,618
  symbols: 3,531

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-11-04 04:00:00	AAPL	Stock	18.5771	18.5771	18.575	18.575	16800.0
2013-11-04 04:30:00	AAPL	Stock	18.6071	18.6196	18.6071	18.6196	20692.0
2013-11-04 05:00:00	AAPL	Stock	18.6214	18.6429	18.6196	18.6429	14000.0
2013-11-04 05:30:00	AAPL	Stock	18.6589	18.6589	18.6589	18.6589	3920.0
2013-11-04 06:00:00	AAPL	Stock	18.6518	18.6518	18.6518	18.6518	8400.0
2013-11-04 07:00:00	AAPL	Stock	18.6196	18.6289	18.5961	18.6289	207172.0
2013-11-04 07:30:00	AAPL	Stock	18.6289	18.6425	18.6214	18.6214	82768.0
2013-11-04 08:00:00	AAPL	Stock	18.6386	18.6425	18.5721	18.5929	865172.0
2013-11-04 08:30:00	AAPL	Stock	18.5929	18.6225	18.5929	18.6214	726068.0
2013-11-04 09:00:00	AAPL	Stock	18.6161	18.6407	18.5929	18.6071	1199184.0
2013-11-04 09:30:00	AAPL	Stock	18.6093	18.6746	18.5289	18.5889	40363960.0
2013-11-04 10:00:00	AAPL	Stock	18.59	18.7536	18.5804	18.7069	33372164.0
2013-11-04 10:30:00	AAPL	Stock	18.7082	18.7425	18.6846	18.6993	13537916.0
2013-11-04 11:00:00	AAPL	Stock	18.7004	18.7046	18.6639	18.6789	11007080.0
2013-11-04 11:30:00	AAPL	Stock	18.6807	18.7007	18.6479	18.6968	10274740.0
2013-11-04 12:00:00	AAPL	Stock	18.6943	18.6986	18.6611	18.6636	5296228.0
2013-11-04 12:30:00	AAPL	Stock	18.6636	18.6909	18.6471	18.6482	5556964.0
2013-11-04 13:00:00	AAPL	Stock	18.65	18.6561	18.5932	18.6475	11237044.0
2013-11-04 13:30:00	AAPL	Stock	18.6475	18.665	18.6286	18.6493	6570116.0
2013-11-04 14:00:00	AAPL	Stock	18.6493	18.6964	18.6486	18.6929	8139684.0
2013-11-04 14:30:00	AAPL	Stock	18.6929	18.7589	18.6893	18.7289	17663380.0
2013-11-04 15:00:00	AAPL	Stock	18.7314	18.7657	18.6971	18.7592	16850708.0
2013-11-04 15:30:00	AAPL	Stock	18.7604	18.815	18.7357	18.8107	32640076.0
2013-11-04 16:00:00	AAPL	Stock	18.8125	18.8275	18.6579	18.8071	4907560.0
2013-11-04 16:30:00	AAPL	Stock	18.8018	18.8162	18.6951	18.8	700000.0
2013-11-04 17:00:00	AAPL	Stock	18.8054	18.8157	18.8029	18.8143	123788.0
2013-11-04 17:30:00	AAPL	Stock	18.8143	18.8154	18.8107	18.8154	56392.0
2013-11-04 18:00:00	AAPL	Stock	18.815	18.8154	18.8018	18.8107	169988.0
2013-11-04 18:30:00	AAPL	Stock	18.8125	18.8125	18.8036	18.8036	145684.0
2013-11-04 19:00:00	AAPL	Stock	18.8036	18.8107	18.8036	18.8036	14000.0
2013-11-04 19:30:00	AAPL	Stock	18.8079	18.8118	18.7946	18.8118	203056.0
2013-11-04 04:00:00	MSFT	Stock	35.75	35.75	35.75	35.75	100.0
2013-11-04 05:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	114.0
2013-11-04 05:30:00	MSFT	Stock	35.68	35.69	35.68	35.69	1000.0
2013-11-04 08:00:00	MSFT	Stock	35.61	35.69	35.61	35.63	3725.0
2013-11-04 08:30:00	MSFT	Stock	35.59	35.64	35.59	35.64	300.0
2013-11-04 09:00:00	MSFT	Stock	35.66	35.66	35.56	35.58	11128.0
2013-11-04 09:30:00	MSFT	Stock	35.56	35.75	35.55	35.73	3037169.0
2013-11-04 10:00:00	MSFT	Stock	35.73	35.89	35.68	35.87	2348441.0
2013-11-04 10:30:00	MSFT	Stock	35.88	35.98	35.77	35.78	2670700.0
2013-11-04 11:00:00	MSFT	Stock	35.77	35.8	35.68	35.7	1448806.0
2013-11-04 11:30:00	MSFT	Stock	35.703	35.77	35.69	35.74	1023873.0
2013-11-04 12:00:00	MSFT	Stock	35.741	35.77	35.72	35.754	759601.0
2013-11-04 12:30:00	MSFT	Stock	35.755	35.83	35.75	35.765	1031835.0
2013-11-04 13:00:00	MSFT	Stock	35.765	35.79	35.73	35.79	1000762.0
2013-11-04 13:30:00	MSFT	Stock	35.79	35.88	35.76	35.86	1834255.0
2013-11-04 14:00:00	MSFT	Stock	35.85	35.95	35.84	35.91	1314667.0
2013-11-04 14:30:00	MSFT	Stock	35.905	35.93	35.86	35.88	1194485.0
2013-11-04 15:00:00	MSFT	Stock	35.875	35.89	35.83	35.87	3959808.0
2013-11-04 15:30:00	MSFT	Stock	35.87	35.95	35.84	35.94	4158925.0

> showing 50 of 88,618 rows — these rows as CSV

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