PREVIEW / stock_30min / 2006-03-27

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-03-27.parquet
  size:    883 KB
  rows:    47,888
  symbols: 2,223

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-03-27 06:30:00	AAPL	Stock	2.1446	2.1464	2.1446	2.1464	5600.0
2006-03-27 07:00:00	AAPL	Stock	2.1446	2.1464	2.1446	2.1464	33600.0
2006-03-27 07:30:00	AAPL	Stock	2.1432	2.1493	2.1432	2.1475	156800.0
2006-03-27 08:00:00	AAPL	Stock	2.15	2.1529	2.1464	2.1475	1870512.0
2006-03-27 08:30:00	AAPL	Stock	2.1479	2.1514	2.1475	2.1489	1112356.0
2006-03-27 09:00:00	AAPL	Stock	2.1507	2.1554	2.1475	2.1539	1868440.0
2006-03-27 09:30:00	AAPL	Stock	2.1554	2.1921	2.1446	2.1886	193706100.0
2006-03-27 10:00:00	AAPL	Stock	2.1886	2.1893	2.1714	2.1779	121263828.0
2006-03-27 10:30:00	AAPL	Stock	2.1782	2.1857	2.1661	2.1661	63586404.0
2006-03-27 11:00:00	AAPL	Stock	2.1661	2.1771	2.1607	2.1682	73247132.0
2006-03-27 11:30:00	AAPL	Stock	2.1689	2.1707	2.1518	2.1554	65569420.0
2006-03-27 12:00:00	AAPL	Stock	2.155	2.1557	2.1479	2.1529	46683728.0
2006-03-27 12:30:00	AAPL	Stock	2.1525	2.17	2.1518	2.1639	53183676.0
2006-03-27 13:00:00	AAPL	Stock	2.1643	2.1693	2.1554	2.1571	43177820.0
2006-03-27 13:30:00	AAPL	Stock	2.1568	2.1654	2.1493	2.1625	37716056.0
2006-03-27 14:00:00	AAPL	Stock	2.1618	2.1643	2.1518	2.1546	48579944.0
2006-03-27 14:30:00	AAPL	Stock	2.1554	2.1596	2.1529	2.1557	41481832.0
2006-03-27 15:00:00	AAPL	Stock	2.1561	2.1561	2.1293	2.1346	122363640.0
2006-03-27 15:30:00	AAPL	Stock	2.1343	2.1386	2.1214	2.1261	176276800.0
2006-03-27 16:00:00	AAPL	Stock	2.1257	2.1286	2.1214	2.1268	4902072.0
2006-03-27 16:30:00	AAPL	Stock	2.1261	2.1282	2.125	2.1271	404656.0
2006-03-27 17:00:00	AAPL	Stock	2.1271	2.1275	2.1254	2.1254	247212.0
2006-03-27 17:30:00	AAPL	Stock	2.1268	2.1268	2.1246	2.1254	464828.0
2006-03-27 18:00:00	AAPL	Stock	2.1254	2.1268	2.1239	2.1246	433832.0
2006-03-27 07:30:00	MSFT	Stock	27.0	27.0	27.0	27.0	400.0
2006-03-27 08:00:00	MSFT	Stock	27.0	27.06	27.0	27.05	12260.0
2006-03-27 08:30:00	MSFT	Stock	27.05	27.06	27.05	27.06	4047.0
2006-03-27 09:00:00	MSFT	Stock	27.05	27.07	27.01	27.04	83307.0
2006-03-27 09:30:00	MSFT	Stock	27.01	27.2	27.0	27.17	5893614.0
2006-03-27 10:00:00	MSFT	Stock	27.16	27.22	27.13	27.13	4595782.0
2006-03-27 10:30:00	MSFT	Stock	27.13	27.21	27.13	27.142	4805306.0
2006-03-27 11:00:00	MSFT	Stock	27.15	27.17	27.07	27.13	4355730.0
2006-03-27 11:30:00	MSFT	Stock	27.12	27.17	27.09	27.131	4417310.0
2006-03-27 12:00:00	MSFT	Stock	27.13	27.26	27.13	27.2	4502934.0
2006-03-27 12:30:00	MSFT	Stock	27.2	27.25	27.17	27.2	2621599.0
2006-03-27 13:00:00	MSFT	Stock	27.2	27.3	27.2	27.26	4615852.0
2006-03-27 13:30:00	MSFT	Stock	27.26	27.27	27.18	27.22	1734524.0
2006-03-27 14:00:00	MSFT	Stock	27.22	27.28	27.16	27.17	2203875.0
2006-03-27 14:30:00	MSFT	Stock	27.18	27.22	27.11	27.12	2346542.0
2006-03-27 15:00:00	MSFT	Stock	27.12	27.16	27.07	27.1	3449316.0
2006-03-27 15:30:00	MSFT	Stock	27.09	27.12	27.01	27.02	10479208.0
2006-03-27 16:00:00	MSFT	Stock	27.01	27.04	27.01	27.01	85954.0
2006-03-27 16:30:00	MSFT	Stock	27.02	27.03	27.01	27.03	4486.0
2006-03-27 17:00:00	MSFT	Stock	27.02	27.02	27.02	27.02	100.0
2006-03-27 17:30:00	MSFT	Stock	27.01	27.02	27.01	27.02	500100.0
2006-03-27 18:00:00	MSFT	Stock	27.02	27.03	27.02	27.03	1985.0
2006-03-27 08:00:00	NVDA	Stock	0.4371	0.4371	0.4333	0.4339	168000.0
2006-03-27 08:30:00	NVDA	Stock	0.4342	0.4342	0.4331	0.4333	360000.0
2006-03-27 09:00:00	NVDA	Stock	0.4333	0.4333	0.4327	0.4333	266040.0
2006-03-27 09:30:00	NVDA	Stock	0.4333	0.4422	0.4318	0.4397	127472040.0

> showing 50 of 47,888 rows — these rows as CSV

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