PREVIEW / stock_30min / 2008-01-09

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-09.parquet
  size:    1.3 MB
  rows:    71,527
  symbols: 3,276

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-01-09 04:00:00	AAPL	Stock	6.1729	6.1975	6.1729	6.1975	8400.0
2008-01-09 04:30:00	AAPL	Stock	6.2018	6.2018	6.1711	6.1711	33600.0
2008-01-09 05:00:00	AAPL	Stock	6.1625	6.1914	6.1589	6.1914	47600.0
2008-01-09 05:30:00	AAPL	Stock	6.1779	6.1796	6.1779	6.1796	5600.0
2008-01-09 06:00:00	AAPL	Stock	6.195	6.195	6.195	6.195	2800.0
2008-01-09 06:30:00	AAPL	Stock	6.1964	6.1964	6.1786	6.1786	15008.0
2008-01-09 07:00:00	AAPL	Stock	6.1821	6.1893	6.1607	6.1839	567056.0
2008-01-09 07:30:00	AAPL	Stock	6.1786	6.1807	6.1679	6.1714	139860.0
2008-01-09 08:00:00	AAPL	Stock	6.1764	6.1768	6.1021	6.1607	5919984.0
2008-01-09 08:30:00	AAPL	Stock	6.1554	6.1686	6.1304	6.1307	3492412.0
2008-01-09 09:00:00	AAPL	Stock	6.1336	6.1357	6.0786	6.12	6202980.0
2008-01-09 09:30:00	AAPL	Stock	6.1236	6.2314	6.0982	6.1714	217418852.0
2008-01-09 10:00:00	AAPL	Stock	6.1718	6.2121	6.04	6.1196	171120068.0
2008-01-09 10:30:00	AAPL	Stock	6.12	6.2036	6.0821	6.1625	122916304.0
2008-01-09 11:00:00	AAPL	Stock	6.1621	6.1807	6.0911	6.1243	94308424.0
2008-01-09 11:30:00	AAPL	Stock	6.1239	6.1386	6.0179	6.0711	126957460.0
2008-01-09 12:00:00	AAPL	Stock	6.0711	6.1546	6.0575	6.1446	94470236.0
2008-01-09 12:30:00	AAPL	Stock	6.1464	6.1496	6.0936	6.1346	65830576.0
2008-01-09 13:00:00	AAPL	Stock	6.1354	6.1471	6.0825	6.1032	63013804.0
2008-01-09 13:30:00	AAPL	Stock	6.1021	6.1161	6.0439	6.0857	87629276.0
2008-01-09 14:00:00	AAPL	Stock	6.0857	6.0917	6.0107	6.0729	122530744.0
2008-01-09 14:30:00	AAPL	Stock	6.0732	6.2264	6.0664	6.2125	180267388.0
2008-01-09 15:00:00	AAPL	Stock	6.2111	6.2714	6.1929	6.2368	204828204.0
2008-01-09 15:30:00	AAPL	Stock	6.2357	6.4107	6.2179	6.4107	222144272.0
2008-01-09 16:00:00	AAPL	Stock	6.4098	6.4182	6.1608	6.4182	20061944.0
2008-01-09 16:30:00	AAPL	Stock	6.4161	6.4521	6.1216	6.4429	2321648.0
2008-01-09 17:00:00	AAPL	Stock	6.4425	6.4589	6.4393	6.4554	1291556.0
2008-01-09 17:30:00	AAPL	Stock	6.4564	6.4643	6.4454	6.4589	1498140.0
2008-01-09 18:00:00	AAPL	Stock	6.4557	6.4589	6.45	6.45	344064.0
2008-01-09 18:30:00	AAPL	Stock	6.4536	6.4586	6.4464	6.4518	447748.0
2008-01-09 19:00:00	AAPL	Stock	6.4571	6.4604	6.4518	6.4571	358120.0
2008-01-09 19:30:00	AAPL	Stock	6.4571	6.4589	6.4514	6.4561	271516.0
2008-01-09 06:00:00	MSFT	Stock	33.53	33.56	33.51	33.51	1400.0
2008-01-09 07:00:00	MSFT	Stock	33.43	33.43	33.43	33.43	200.0
2008-01-09 08:00:00	MSFT	Stock	33.5	33.5	33.42	33.5	6139.0
2008-01-09 08:30:00	MSFT	Stock	33.5	33.51	33.4	33.45	7063.0
2008-01-09 09:00:00	MSFT	Stock	33.4	33.54	33.35	33.37	43351.0
2008-01-09 09:30:00	MSFT	Stock	33.39	34.18	33.35	34.04	7433256.0
2008-01-09 10:00:00	MSFT	Stock	34.03	34.17	33.82	34.07	6830290.0
2008-01-09 10:30:00	MSFT	Stock	34.08	34.15	33.96	34.11	5453305.0
2008-01-09 11:00:00	MSFT	Stock	34.1	34.16	33.96	34.01	4247882.0
2008-01-09 11:30:00	MSFT	Stock	34.0	34.13	33.81	34.11	4541246.0
2008-01-09 12:00:00	MSFT	Stock	34.11	34.31	34.04	34.3	3757280.0
2008-01-09 12:30:00	MSFT	Stock	34.31	34.31	34.15	34.19	2127473.0
2008-01-09 13:00:00	MSFT	Stock	34.19	34.21	34.05	34.08	2994565.0
2008-01-09 13:30:00	MSFT	Stock	34.09	34.11	33.88	34.02	5281091.0
2008-01-09 14:00:00	MSFT	Stock	34.02	34.11	33.88	34.11	4888123.0
2008-01-09 14:30:00	MSFT	Stock	34.11	34.37	34.07	34.27	5360206.0
2008-01-09 15:00:00	MSFT	Stock	34.27	34.54	34.17	34.19	6954392.0
2008-01-09 15:30:00	MSFT	Stock	34.19	34.46	34.14	34.44	11147008.0

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

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