PREVIEW / stock_1min / 2009-04-07

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-07.parquet
  size:    12.0 MB
  rows:    926,908
  symbols: 2,678

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
2009-04-07 05:29:00	AAPL	Stock	4.1607	4.1607	4.1607	4.1607	3584.0
2009-04-07 05:35:00	AAPL	Stock	4.1429	4.1429	4.1429	4.1429	10864.0
2009-04-07 06:40:00	AAPL	Stock	4.1804	4.1804	4.1793	4.1793	5600.0
2009-04-07 07:14:00	AAPL	Stock	4.1607	4.1607	4.1607	4.1607	2800.0
2009-04-07 07:16:00	AAPL	Stock	4.1607	4.1607	4.1604	4.1604	11200.0
2009-04-07 07:19:00	AAPL	Stock	4.1607	4.1607	4.1543	4.1543	8400.0
2009-04-07 07:20:00	AAPL	Stock	4.1543	4.1543	4.1543	4.1543	4200.0
2009-04-07 07:23:00	AAPL	Stock	4.1557	4.1557	4.1557	4.1557	2800.0
2009-04-07 07:24:00	AAPL	Stock	4.1554	4.1554	4.1546	4.1546	12600.0
2009-04-07 07:27:00	AAPL	Stock	4.1475	4.1475	4.1475	4.1475	2800.0
2009-04-07 07:47:00	AAPL	Stock	4.1586	4.1586	4.1586	4.1586	2800.0
2009-04-07 07:48:00	AAPL	Stock	4.1586	4.1586	4.1586	4.1586	7000.0
2009-04-07 07:49:00	AAPL	Stock	4.1711	4.1711	4.1643	4.1643	5600.0
2009-04-07 07:53:00	AAPL	Stock	4.1743	4.1743	4.1743	4.1743	2800.0
2009-04-07 07:57:00	AAPL	Stock	4.1696	4.1696	4.1696	4.1696	2800.0
2009-04-07 07:58:00	AAPL	Stock	4.1643	4.1643	4.1625	4.1625	22260.0
2009-04-07 07:59:00	AAPL	Stock	4.1625	4.1625	4.1625	4.1625	2800.0
2009-04-07 08:00:00	AAPL	Stock	4.1589	4.1625	4.1571	4.16	97244.0
2009-04-07 08:01:00	AAPL	Stock	4.1564	4.1564	4.1564	4.1564	16800.0
2009-04-07 08:02:00	AAPL	Stock	4.1564	4.1564	4.1564	4.1564	11200.0
2009-04-07 08:03:00	AAPL	Stock	4.1571	4.1571	4.1539	4.1539	21840.0
2009-04-07 08:04:00	AAPL	Stock	4.1536	4.1539	4.1536	4.1539	14700.0
2009-04-07 08:05:00	AAPL	Stock	4.1543	4.1554	4.1539	4.1539	8400.0
2009-04-07 08:06:00	AAPL	Stock	4.1586	4.1589	4.1571	4.1571	12600.0
2009-04-07 08:07:00	AAPL	Stock	4.1575	4.1575	4.1575	4.1575	2800.0
2009-04-07 08:09:00	AAPL	Stock	4.1607	4.1607	4.1607	4.1607	2800.0
2009-04-07 08:10:00	AAPL	Stock	4.1614	4.1643	4.1614	4.1643	16800.0
2009-04-07 08:11:00	AAPL	Stock	4.1643	4.1643	4.1643	4.1643	2800.0
2009-04-07 08:13:00	AAPL	Stock	4.1661	4.1721	4.1661	4.1721	18620.0
2009-04-07 08:16:00	AAPL	Stock	4.1704	4.1704	4.1704	4.1704	2800.0
2009-04-07 08:18:00	AAPL	Stock	4.1682	4.1704	4.1668	4.1668	81900.0
2009-04-07 08:19:00	AAPL	Stock	4.1654	4.1679	4.1654	4.1679	16800.0
2009-04-07 08:20:00	AAPL	Stock	4.1679	4.1679	4.1679	4.1679	5600.0
2009-04-07 08:21:00	AAPL	Stock	4.1679	4.1679	4.1679	4.1679	28448.0
2009-04-07 08:22:00	AAPL	Stock	4.1679	4.1679	4.1679	4.1679	7980.0
2009-04-07 08:23:00	AAPL	Stock	4.1654	4.1654	4.1654	4.1654	2800.0
2009-04-07 08:24:00	AAPL	Stock	4.1661	4.1679	4.1629	4.1629	60900.0
2009-04-07 08:25:00	AAPL	Stock	4.1643	4.1643	4.1629	4.1643	43456.0
2009-04-07 08:26:00	AAPL	Stock	4.1643	4.1643	4.1643	4.1643	14000.0
2009-04-07 08:28:00	AAPL	Stock	4.1643	4.165	4.1643	4.165	5600.0
2009-04-07 08:29:00	AAPL	Stock	4.1643	4.1646	4.1643	4.1643	79352.0
2009-04-07 08:30:00	AAPL	Stock	4.1614	4.1614	4.1564	4.1564	61460.0
2009-04-07 08:31:00	AAPL	Stock	4.1554	4.1554	4.1546	4.1546	83888.0
2009-04-07 08:32:00	AAPL	Stock	4.1571	4.1571	4.1571	4.1571	2800.0
2009-04-07 08:35:00	AAPL	Stock	4.1571	4.1571	4.1571	4.1571	8400.0
2009-04-07 08:36:00	AAPL	Stock	4.1546	4.1571	4.1546	4.1571	30800.0
2009-04-07 08:37:00	AAPL	Stock	4.1564	4.1589	4.1564	4.1589	6440.0
2009-04-07 08:39:00	AAPL	Stock	4.1593	4.1593	4.1593	4.1593	2800.0
2009-04-07 08:40:00	AAPL	Stock	4.1636	4.1636	4.1571	4.1571	23352.0
2009-04-07 08:41:00	AAPL	Stock	4.1571	4.1571	4.1557	4.1571	8400.0

> showing 50 of 926,908 rows — these rows as CSV

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