PREVIEW / stock_1min / 2009-08-14

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-08-14.parquet
  size:    12.6 MB
  rows:    964,961
  symbols: 2,725

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-08-14 05:09:00	AAPL	Stock	6.0268	6.0268	6.0268	6.0268	2800.0
2009-08-14 06:41:00	AAPL	Stock	6.0211	6.0211	6.0211	6.0211	8400.0
2009-08-14 06:42:00	AAPL	Stock	6.0268	6.0268	6.0268	6.0268	2800.0
2009-08-14 06:53:00	AAPL	Stock	6.0211	6.0211	6.0211	6.0211	5600.0
2009-08-14 07:39:00	AAPL	Stock	6.0179	6.0179	6.0179	6.0179	8400.0
2009-08-14 07:40:00	AAPL	Stock	6.0179	6.0179	6.0179	6.0179	2800.0
2009-08-14 07:41:00	AAPL	Stock	6.0179	6.0179	6.0179	6.0179	14000.0
2009-08-14 07:55:00	AAPL	Stock	6.0089	6.0089	6.0089	6.0089	4200.0
2009-08-14 08:00:00	AAPL	Stock	6.0175	6.0179	6.0175	6.0179	6692.0
2009-08-14 08:01:00	AAPL	Stock	6.0111	6.0111	6.0111	6.0111	2800.0
2009-08-14 08:03:00	AAPL	Stock	6.0157	6.0157	6.0157	6.0157	5208.0
2009-08-14 08:07:00	AAPL	Stock	6.0154	6.0154	6.0154	6.0154	5600.0
2009-08-14 08:08:00	AAPL	Stock	6.0114	6.0154	6.0114	6.0154	26572.0
2009-08-14 08:09:00	AAPL	Stock	6.0157	6.0157	6.0157	6.0157	8792.0
2009-08-14 08:10:00	AAPL	Stock	6.0179	6.0179	6.0161	6.0161	70448.0
2009-08-14 08:11:00	AAPL	Stock	6.0171	6.0171	6.0171	6.0171	2800.0
2009-08-14 08:12:00	AAPL	Stock	6.0179	6.0179	6.0179	6.0179	33600.0
2009-08-14 08:13:00	AAPL	Stock	6.0161	6.0161	6.0161	6.0161	2800.0
2009-08-14 08:14:00	AAPL	Stock	6.0125	6.0157	6.0125	6.0157	24920.0
2009-08-14 08:16:00	AAPL	Stock	6.0129	6.0139	6.0129	6.0139	5600.0
2009-08-14 08:17:00	AAPL	Stock	6.0139	6.0139	6.0139	6.0139	23380.0
2009-08-14 08:22:00	AAPL	Stock	6.0114	6.0114	6.0107	6.0107	21000.0
2009-08-14 08:23:00	AAPL	Stock	6.0136	6.0139	6.0136	6.0136	31500.0
2009-08-14 08:29:00	AAPL	Stock	6.0107	6.0139	6.0107	6.0107	20972.0
2009-08-14 08:30:00	AAPL	Stock	6.0136	6.0143	6.0136	6.0139	27160.0
2009-08-14 08:31:00	AAPL	Stock	6.0139	6.0139	6.0139	6.0139	2800.0
2009-08-14 08:32:00	AAPL	Stock	6.0107	6.0107	6.0089	6.0089	56392.0
2009-08-14 08:37:00	AAPL	Stock	6.0125	6.0125	6.0125	6.0125	2800.0
2009-08-14 08:38:00	AAPL	Stock	6.0111	6.0111	6.0111	6.0111	5600.0
2009-08-14 08:39:00	AAPL	Stock	6.0104	6.0118	6.0104	6.0114	38556.0
2009-08-14 08:47:00	AAPL	Stock	6.0154	6.0157	6.0107	6.0107	22400.0
2009-08-14 08:48:00	AAPL	Stock	6.0118	6.0121	6.0118	6.0121	8400.0
2009-08-14 08:49:00	AAPL	Stock	6.0136	6.0139	6.0136	6.0139	8400.0
2009-08-14 08:50:00	AAPL	Stock	6.0096	6.0111	6.0089	6.0089	66556.0
2009-08-14 08:51:00	AAPL	Stock	6.0068	6.0068	6.0061	6.0061	5600.0
2009-08-14 08:53:00	AAPL	Stock	6.0043	6.0043	6.0036	6.0039	19600.0
2009-08-14 08:54:00	AAPL	Stock	6.0025	6.0025	6.0011	6.0018	35000.0
2009-08-14 08:55:00	AAPL	Stock	6.0039	6.0046	6.0039	6.0046	5600.0
2009-08-14 09:00:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	2800.0
2009-08-14 09:03:00	AAPL	Stock	6.0039	6.0043	5.9946	5.9946	31388.0
2009-08-14 09:04:00	AAPL	Stock	5.9957	5.9957	5.9957	5.9957	8400.0
2009-08-14 09:09:00	AAPL	Stock	6.0007	6.0007	6.0007	6.0007	5600.0
2009-08-14 09:10:00	AAPL	Stock	6.005	6.0054	6.005	6.0054	14000.0
2009-08-14 09:12:00	AAPL	Stock	6.0054	6.0054	6.0054	6.0054	11200.0
2009-08-14 09:13:00	AAPL	Stock	6.0054	6.0054	6.0054	6.0054	30800.0
2009-08-14 09:15:00	AAPL	Stock	6.0032	6.0032	6.0	6.0007	21000.0
2009-08-14 09:17:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	2800.0
2009-08-14 09:18:00	AAPL	Stock	5.9957	5.9982	5.9957	5.9964	8400.0
2009-08-14 09:19:00	AAPL	Stock	5.9964	5.9971	5.9964	5.9971	11200.0
2009-08-14 09:20:00	AAPL	Stock	5.9989	5.9989	5.9986	5.9986	5600.0

> showing 50 of 964,961 rows — these rows as CSV

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