PREVIEW / stock_30min / 2008-10-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-29.parquet
  size:    1.2 MB
  rows:    71,296
  symbols: 3,323

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-10-29 04:00:00	AAPL	Stock	3.5689	3.5689	3.5689	3.5689	2800.0
2008-10-29 06:00:00	AAPL	Stock	3.5575	3.5629	3.5418	3.5629	44800.0
2008-10-29 06:30:00	AAPL	Stock	3.5454	3.6179	3.5454	3.6179	8400.0
2008-10-29 07:00:00	AAPL	Stock	3.6071	3.6071	3.5818	3.5982	93352.0
2008-10-29 07:30:00	AAPL	Stock	3.5921	3.6429	3.5911	3.625	361872.0
2008-10-29 08:00:00	AAPL	Stock	3.6232	3.6357	3.5929	3.5929	2689792.0
2008-10-29 08:30:00	AAPL	Stock	3.5946	3.6143	3.5761	3.5875	2422560.0
2008-10-29 09:00:00	AAPL	Stock	3.5857	3.6046	3.5764	3.5982	2239608.0
2008-10-29 09:30:00	AAPL	Stock	3.6021	3.6929	3.5693	3.6757	220661392.0
2008-10-29 10:00:00	AAPL	Stock	3.6761	3.8129	3.6586	3.7975	210252812.0
2008-10-29 10:30:00	AAPL	Stock	3.7975	3.8125	3.7043	3.7188	161075320.0
2008-10-29 11:00:00	AAPL	Stock	3.7196	3.7679	3.7064	3.7589	93880612.0
2008-10-29 11:30:00	AAPL	Stock	3.7586	3.8	3.7446	3.7943	71678964.0
2008-10-29 12:00:00	AAPL	Stock	3.7936	3.8214	3.7575	3.82	73732428.0
2008-10-29 12:30:00	AAPL	Stock	3.82	3.8471	3.8079	3.8193	99195096.0
2008-10-29 13:00:00	AAPL	Stock	3.8193	3.8525	3.8071	3.8432	70703864.0
2008-10-29 13:30:00	AAPL	Stock	3.8425	3.8593	3.8196	3.8332	86452604.0
2008-10-29 14:00:00	AAPL	Stock	3.8343	3.8661	3.7468	3.8061	161309736.0
2008-10-29 14:30:00	AAPL	Stock	3.8057	3.855	3.7429	3.8254	213257072.0
2008-10-29 15:00:00	AAPL	Stock	3.8261	3.9121	3.8125	3.8904	196451332.0
2008-10-29 15:30:00	AAPL	Stock	3.8879	3.9118	3.7246	3.7343	225988504.0
2008-10-29 16:00:00	AAPL	Stock	3.7346	3.8524	3.6842	3.7375	30757132.0
2008-10-29 16:30:00	AAPL	Stock	3.7371	3.814	3.7211	3.7411	2033808.0
2008-10-29 17:00:00	AAPL	Stock	3.7379	3.7543	3.7343	3.7411	606620.0
2008-10-29 17:30:00	AAPL	Stock	3.7429	3.7486	3.7357	3.7393	308140.0
2008-10-29 18:00:00	AAPL	Stock	3.7379	3.7475	3.7343	3.7446	314216.0
2008-10-29 18:30:00	AAPL	Stock	3.7432	3.7543	3.7429	3.7543	245616.0
2008-10-29 19:00:00	AAPL	Stock	3.7582	3.7582	3.7518	3.7546	230580.0
2008-10-29 19:30:00	AAPL	Stock	3.7561	3.7564	3.7482	3.7518	413336.0
2008-10-29 20:00:00	AAPL	Stock	3.7386	3.7386	3.7386	3.7386	5656.0
2008-10-29 07:30:00	MSFT	Stock	22.82	22.86	22.82	22.86	2000.0
2008-10-29 08:00:00	MSFT	Stock	23.1	23.2	23.0	23.14	27690.0
2008-10-29 08:30:00	MSFT	Stock	23.11	23.15	23.0	23.02	21366.0
2008-10-29 09:00:00	MSFT	Stock	23.02	23.16	22.92	23.14	36237.0
2008-10-29 09:30:00	MSFT	Stock	23.12	23.16	22.7	22.865	7749124.0
2008-10-29 10:00:00	MSFT	Stock	22.86	23.3	22.72	23.24	7499390.0
2008-10-29 10:30:00	MSFT	Stock	23.25	23.3	22.86	22.93	7053029.0
2008-10-29 11:00:00	MSFT	Stock	22.93	23.0	22.8	22.95	4937966.0
2008-10-29 11:30:00	MSFT	Stock	22.94	23.18	22.85	23.14	5238683.0
2008-10-29 12:00:00	MSFT	Stock	23.14	23.51	23.1	23.51	4901423.0
2008-10-29 12:30:00	MSFT	Stock	23.5	23.9	23.47	23.74	7402173.0
2008-10-29 13:00:00	MSFT	Stock	23.74	23.84	23.6	23.73	3974046.0
2008-10-29 13:30:00	MSFT	Stock	23.73	23.83	23.47	23.47	5957409.0
2008-10-29 14:00:00	MSFT	Stock	23.471	23.65	23.03	23.25	8237472.0
2008-10-29 14:30:00	MSFT	Stock	23.26	23.51	22.88	23.31	9048214.0
2008-10-29 15:00:00	MSFT	Stock	23.3	23.9	23.12	23.77	10169967.0
2008-10-29 15:30:00	MSFT	Stock	23.79	23.97	22.85	22.98	19488332.0
2008-10-29 16:00:00	MSFT	Stock	22.97	23.333	22.84	23.333	4991241.0
2008-10-29 16:30:00	MSFT	Stock	23.77	23.78	23.01	23.05	118499.0
2008-10-29 17:00:00	MSFT	Stock	23.05	23.13	23.02	23.13	61006.0

> showing 50 of 71,296 rows — these rows as CSV

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