PREVIEW / stock_30min / 2006-09-27

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-09-27.parquet
  size:    918 KB
  rows:    49,932
  symbols: 2,375

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
2006-09-27 04:00:00	AAPL	Stock	2.7661	2.7661	2.7661	2.7661	3920.0
2006-09-27 07:30:00	AAPL	Stock	2.7843	2.7843	2.7829	2.7829	16800.0
2006-09-27 08:00:00	AAPL	Stock	2.7829	2.7889	2.7804	2.7832	1635732.0
2006-09-27 08:30:00	AAPL	Stock	2.7839	2.7857	2.7496	2.75	8581048.0
2006-09-27 09:00:00	AAPL	Stock	2.7507	2.7589	2.7464	2.7568	2990456.0
2006-09-27 09:30:00	AAPL	Stock	2.7561	2.7668	2.7339	2.7464	139427092.0
2006-09-27 10:00:00	AAPL	Stock	2.7464	2.7532	2.7164	2.73	127276268.0
2006-09-27 10:30:00	AAPL	Stock	2.73	2.7393	2.725	2.7332	70507780.0
2006-09-27 11:00:00	AAPL	Stock	2.7336	2.7368	2.7229	2.7307	55208328.0
2006-09-27 11:30:00	AAPL	Stock	2.7311	2.7357	2.7279	2.7332	38263232.0
2006-09-27 12:00:00	AAPL	Stock	2.7332	2.7386	2.7282	2.7296	43609440.0
2006-09-27 12:30:00	AAPL	Stock	2.73	2.7346	2.7229	2.7311	32063920.0
2006-09-27 13:00:00	AAPL	Stock	2.7311	2.735	2.7232	2.7257	25492880.0
2006-09-27 13:30:00	AAPL	Stock	2.725	2.7286	2.7161	2.7265	41676180.0
2006-09-27 14:00:00	AAPL	Stock	2.7268	2.7314	2.715	2.7196	42943432.0
2006-09-27 14:30:00	AAPL	Stock	2.7196	2.7232	2.7079	2.7189	59062640.0
2006-09-27 15:00:00	AAPL	Stock	2.7189	2.7275	2.7121	2.7214	50213212.0
2006-09-27 15:30:00	AAPL	Stock	2.7218	2.7325	2.72	2.7275	60109700.0
2006-09-27 16:00:00	AAPL	Stock	2.7289	2.7293	2.7279	2.7286	1065204.0
2006-09-27 16:30:00	AAPL	Stock	2.7279	2.7289	2.7261	2.7289	1643600.0
2006-09-27 17:00:00	AAPL	Stock	2.7289	2.7304	2.7268	2.7268	85288.0
2006-09-27 17:30:00	AAPL	Stock	2.7268	2.7268	2.7243	2.725	65520.0
2006-09-27 18:00:00	AAPL	Stock	2.7268	2.7286	2.7268	2.7268	130088.0
2006-09-27 18:30:00	AAPL	Stock	2.7268	2.7282	2.7268	2.7282	50680.0
2006-09-27 19:30:00	AAPL	Stock	2.7254	2.7254	2.7236	2.7236	97300.0
2006-09-27 07:30:00	MSFT	Stock	27.24	27.24	27.24	27.24	100.0
2006-09-27 08:00:00	MSFT	Stock	27.25	27.29	27.24	27.27	467168.0
2006-09-27 08:30:00	MSFT	Stock	27.27	27.27	27.17	27.18	25516.0
2006-09-27 09:00:00	MSFT	Stock	27.18	27.21	27.09	27.18	55676.0
2006-09-27 09:30:00	MSFT	Stock	27.18	27.39	27.12	27.38	5366732.0
2006-09-27 10:00:00	MSFT	Stock	27.38	27.44	27.3	27.33	6051920.0
2006-09-27 10:30:00	MSFT	Stock	27.33	27.37	27.29	27.35	5885988.0
2006-09-27 11:00:00	MSFT	Stock	27.35	27.36	27.26	27.34	3152933.0
2006-09-27 11:30:00	MSFT	Stock	27.34	27.37	27.32	27.348	2164466.0
2006-09-27 12:00:00	MSFT	Stock	27.35	27.36	27.32	27.34	4115233.0
2006-09-27 12:30:00	MSFT	Stock	27.34	27.42	27.33	27.38	2747956.0
2006-09-27 13:00:00	MSFT	Stock	27.37	27.45	27.37	27.43	2607303.0
2006-09-27 13:30:00	MSFT	Stock	27.42	27.445	27.32	27.35	5542388.0
2006-09-27 14:00:00	MSFT	Stock	27.35	27.38	27.31	27.35	4593752.0
2006-09-27 14:30:00	MSFT	Stock	27.35	27.38	27.3	27.37	5236604.0
2006-09-27 15:00:00	MSFT	Stock	27.37	27.4	27.32	27.36	4769654.0
2006-09-27 15:30:00	MSFT	Stock	27.37	27.47	27.3	27.46	11453113.0
2006-09-27 16:00:00	MSFT	Stock	27.46	27.58	27.45	27.57	742192.0
2006-09-27 16:30:00	MSFT	Stock	27.57	27.72	27.56	27.68	128160.0
2006-09-27 17:00:00	MSFT	Stock	27.65	27.69	27.65	27.69	2440.0
2006-09-27 17:30:00	MSFT	Stock	27.65	27.65	27.62	27.63	7602.0
2006-09-27 18:00:00	MSFT	Stock	27.63	27.63	27.59	27.61	13900.0
2006-09-27 18:30:00	MSFT	Stock	27.6	27.61	27.6	27.61	6700.0
2006-09-27 19:30:00	MSFT	Stock	27.61	27.62	27.6	27.62	4061.0
2006-09-27 08:00:00	NVDA	Stock	0.5002	0.5055	0.5	0.5008	80040.0

> showing 50 of 49,932 rows — these rows as CSV

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