PREVIEW / stock_30min / 2008-05-27

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-27.parquet
  size:    1.2 MB
  rows:    69,056
  symbols: 3,307

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
2008-05-27 07:00:00	AAPL	Stock	6.4846	6.4846	6.4818	6.4818	30520.0
2008-05-27 07:30:00	AAPL	Stock	6.4839	6.4893	6.4839	6.4893	59584.0
2008-05-27 08:00:00	AAPL	Stock	6.4793	6.5068	6.4732	6.4779	1890952.0
2008-05-27 08:30:00	AAPL	Stock	6.4786	6.4946	6.4786	6.4946	454860.0
2008-05-27 09:00:00	AAPL	Stock	6.495	6.5282	6.4871	6.5279	3049424.0
2008-05-27 09:30:00	AAPL	Stock	6.5271	6.5804	6.5146	6.5614	111124104.0
2008-05-27 10:00:00	AAPL	Stock	6.5629	6.5804	6.5493	6.5746	77506744.0
2008-05-27 10:30:00	AAPL	Stock	6.5739	6.5886	6.5546	6.5725	56636468.0
2008-05-27 11:00:00	AAPL	Stock	6.5729	6.5821	6.5357	6.5432	56251776.0
2008-05-27 11:30:00	AAPL	Stock	6.5432	6.5482	6.5107	6.5129	41527388.0
2008-05-27 12:00:00	AAPL	Stock	6.5129	6.5461	6.4943	6.545	47432532.0
2008-05-27 12:30:00	AAPL	Stock	6.5457	6.5532	6.5289	6.5457	27217708.0
2008-05-27 13:00:00	AAPL	Stock	6.5461	6.5714	6.5357	6.5612	30516752.0
2008-05-27 13:30:00	AAPL	Stock	6.5607	6.5857	6.5496	6.5779	42608104.0
2008-05-27 14:00:00	AAPL	Stock	6.5779	6.5864	6.5629	6.5637	36633352.0
2008-05-27 14:30:00	AAPL	Stock	6.5632	6.6257	6.5589	6.61	83488552.0
2008-05-27 15:00:00	AAPL	Stock	6.6107	6.6304	6.5982	6.6268	62544244.0
2008-05-27 15:30:00	AAPL	Stock	6.6246	6.6571	6.6229	6.6554	90704096.0
2008-05-27 16:00:00	AAPL	Stock	6.6564	6.6607	6.5407	6.6607	12985224.0
2008-05-27 16:30:00	AAPL	Stock	6.6607	6.6607	6.5746	6.6582	1210776.0
2008-05-27 17:00:00	AAPL	Stock	6.6604	6.6621	6.6139	6.6557	426300.0
2008-05-27 17:30:00	AAPL	Stock	6.6557	6.66	6.6554	6.6586	139300.0
2008-05-27 18:00:00	AAPL	Stock	6.6586	6.6589	6.6536	6.6536	185444.0
2008-05-27 18:30:00	AAPL	Stock	6.6589	6.6589	6.6539	6.6561	27888.0
2008-05-27 19:00:00	AAPL	Stock	6.6539	6.6568	6.6536	6.6568	43848.0
2008-05-27 19:30:00	AAPL	Stock	6.6571	6.6604	6.6564	6.6589	273868.0
2008-05-27 08:00:00	MSFT	Stock	28.15	28.25	28.05	28.14	7723.0
2008-05-27 08:30:00	MSFT	Stock	28.13	28.13	28.05	28.05	3513.0
2008-05-27 09:00:00	MSFT	Stock	28.06	28.16	28.06	28.1	21257.0
2008-05-27 09:30:00	MSFT	Stock	28.11	28.36	28.05	28.2	4013902.0
2008-05-27 10:00:00	MSFT	Stock	28.195	28.4	28.18	28.35	3613294.0
2008-05-27 10:30:00	MSFT	Stock	28.35	28.35	28.2	28.34	3249034.0
2008-05-27 11:00:00	MSFT	Stock	28.33	28.37	28.23	28.25	2686522.0
2008-05-27 11:30:00	MSFT	Stock	28.25	28.33	28.2	28.208	4866973.0
2008-05-27 12:00:00	MSFT	Stock	28.21	28.22	28.14	28.22	2196215.0
2008-05-27 12:30:00	MSFT	Stock	28.22	28.23	28.17	28.218	1159756.0
2008-05-27 13:00:00	MSFT	Stock	28.22	28.24	28.15	28.17	1492651.0
2008-05-27 13:30:00	MSFT	Stock	28.16	28.26	28.15	28.24	2004457.0
2008-05-27 14:00:00	MSFT	Stock	28.25	28.26	28.15	28.21	2697065.0
2008-05-27 14:30:00	MSFT	Stock	28.21	28.451	28.2	28.398	3749272.0
2008-05-27 15:00:00	MSFT	Stock	28.39	28.5	28.37	28.45	4842060.0
2008-05-27 15:30:00	MSFT	Stock	28.44	28.5	28.31	28.45	6771398.0
2008-05-27 16:00:00	MSFT	Stock	28.47	28.47	28.284	28.284	2935514.0
2008-05-27 16:30:00	MSFT	Stock	28.304	28.44	28.304	28.44	316228.0
2008-05-27 17:00:00	MSFT	Stock	28.39	28.39	28.314	28.314	1700.0
2008-05-27 17:30:00	MSFT	Stock	28.42	28.45	28.42	28.45	1243.0
2008-05-27 18:00:00	MSFT	Stock	28.4	28.4	28.4	28.4	400.0
2008-05-27 18:30:00	MSFT	Stock	28.42	28.42	28.38	28.4	1987.0
2008-05-27 19:00:00	MSFT	Stock	28.4	28.45	28.36	28.36	5620.0
2008-05-27 19:30:00	MSFT	Stock	28.39	28.46	28.39	28.39	78693.0

> showing 50 of 69,056 rows — these rows as CSV

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