PREVIEW / stock_1min / 2009-05-19

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-05-19.parquet
  size:    12.9 MB
  rows:    987,246
  symbols: 2,726

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-05-19 04:37:00	AAPL	Stock	4.5557	4.5557	4.5557	4.5557	2800.0
2009-05-19 04:42:00	AAPL	Stock	4.5646	4.5768	4.5646	4.5768	19600.0
2009-05-19 04:51:00	AAPL	Stock	4.5618	4.5618	4.5618	4.5618	2800.0
2009-05-19 05:42:00	AAPL	Stock	4.5786	4.5786	4.5786	4.5786	5600.0
2009-05-19 05:43:00	AAPL	Stock	4.5804	4.5804	4.5804	4.5804	5600.0
2009-05-19 05:45:00	AAPL	Stock	4.5893	4.5911	4.5893	4.5911	9716.0
2009-05-19 06:37:00	AAPL	Stock	4.5739	4.5739	4.5721	4.5721	16800.0
2009-05-19 06:39:00	AAPL	Stock	4.5607	4.5607	4.5429	4.5429	44800.0
2009-05-19 06:42:00	AAPL	Stock	4.5429	4.5429	4.5286	4.5286	21000.0
2009-05-19 06:50:00	AAPL	Stock	4.5868	4.5871	4.5868	4.5871	8400.0
2009-05-19 06:51:00	AAPL	Stock	4.5871	4.5871	4.5871	4.5871	11200.0
2009-05-19 07:09:00	AAPL	Stock	4.5646	4.5646	4.5643	4.5643	56000.0
2009-05-19 07:12:00	AAPL	Stock	4.5643	4.5646	4.5643	4.5646	30800.0
2009-05-19 07:16:00	AAPL	Stock	4.5625	4.5625	4.5625	4.5625	25200.0
2009-05-19 07:17:00	AAPL	Stock	4.5639	4.5643	4.5639	4.5643	14000.0
2009-05-19 07:18:00	AAPL	Stock	4.5639	4.5639	4.5639	4.5639	22036.0
2009-05-19 07:43:00	AAPL	Stock	4.5571	4.5571	4.5571	4.5571	2800.0
2009-05-19 07:56:00	AAPL	Stock	4.5625	4.5639	4.5625	4.5639	11200.0
2009-05-19 07:57:00	AAPL	Stock	4.5632	4.5632	4.5632	4.5632	2800.0
2009-05-19 07:58:00	AAPL	Stock	4.5607	4.5607	4.5607	4.5607	14000.0
2009-05-19 08:00:00	AAPL	Stock	4.5607	4.5639	4.5596	4.5596	38248.0
2009-05-19 08:01:00	AAPL	Stock	4.5625	4.5625	4.5625	4.5625	8400.0
2009-05-19 08:02:00	AAPL	Stock	4.5557	4.5589	4.5557	4.5589	23380.0
2009-05-19 08:03:00	AAPL	Stock	4.5571	4.5571	4.5571	4.5571	2800.0
2009-05-19 08:04:00	AAPL	Stock	4.5554	4.56	4.5543	4.56	30240.0
2009-05-19 08:05:00	AAPL	Stock	4.5536	4.5536	4.5536	4.5536	2800.0
2009-05-19 08:06:00	AAPL	Stock	4.5571	4.5571	4.5536	4.5536	27972.0
2009-05-19 08:10:00	AAPL	Stock	4.5554	4.5554	4.5539	4.5554	37240.0
2009-05-19 08:11:00	AAPL	Stock	4.5554	4.5596	4.5554	4.5596	17528.0
2009-05-19 08:12:00	AAPL	Stock	4.5611	4.5614	4.5571	4.5571	20440.0
2009-05-19 08:13:00	AAPL	Stock	4.5536	4.5557	4.5536	4.5536	22624.0
2009-05-19 08:14:00	AAPL	Stock	4.5536	4.5536	4.5536	4.5536	5600.0
2009-05-19 08:15:00	AAPL	Stock	4.5536	4.5536	4.5536	4.5536	11200.0
2009-05-19 08:16:00	AAPL	Stock	4.5536	4.5536	4.5536	4.5536	11200.0
2009-05-19 08:17:00	AAPL	Stock	4.5536	4.5536	4.5529	4.5529	19600.0
2009-05-19 08:20:00	AAPL	Stock	4.5536	4.5536	4.5536	4.5536	5600.0
2009-05-19 08:21:00	AAPL	Stock	4.5536	4.5536	4.5529	4.5529	26880.0
2009-05-19 08:22:00	AAPL	Stock	4.5521	4.5536	4.5493	4.5536	25480.0
2009-05-19 08:23:00	AAPL	Stock	4.5504	4.5504	4.5504	4.5504	5600.0
2009-05-19 08:24:00	AAPL	Stock	4.5539	4.5557	4.5539	4.5557	5600.0
2009-05-19 08:27:00	AAPL	Stock	4.5568	4.5568	4.5568	4.5568	2800.0
2009-05-19 08:28:00	AAPL	Stock	4.5536	4.5536	4.5536	4.5536	5600.0
2009-05-19 08:30:00	AAPL	Stock	4.5518	4.5518	4.5507	4.5507	62384.0
2009-05-19 08:31:00	AAPL	Stock	4.5507	4.5536	4.5507	4.5511	92400.0
2009-05-19 08:32:00	AAPL	Stock	4.5571	4.5571	4.5571	4.5571	2800.0
2009-05-19 08:33:00	AAPL	Stock	4.555	4.555	4.555	4.555	22400.0
2009-05-19 08:34:00	AAPL	Stock	4.5564	4.5564	4.5564	4.5564	5600.0
2009-05-19 08:37:00	AAPL	Stock	4.5564	4.5564	4.5536	4.5536	29400.0
2009-05-19 08:38:00	AAPL	Stock	4.5532	4.5532	4.5525	4.5525	5600.0
2009-05-19 08:39:00	AAPL	Stock	4.5525	4.5525	4.5525	4.5525	28000.0

> showing 50 of 987,246 rows — these rows as CSV

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