PREVIEW / stock_1min / 2009-07-07

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-07-07.parquet
  size:    12.4 MB
  rows:    955,041
  symbols: 2,700

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-07-07 08:00:00	AAPL	Stock	4.9725	4.9725	4.9718	4.9718	61908.0
2009-07-07 08:02:00	AAPL	Stock	4.9718	4.9718	4.9718	4.9718	5600.0
2009-07-07 08:03:00	AAPL	Stock	4.9718	4.9718	4.9582	4.9643	93380.0
2009-07-07 08:05:00	AAPL	Stock	4.9564	4.9596	4.9564	4.9596	5600.0
2009-07-07 08:07:00	AAPL	Stock	4.9536	4.9536	4.9536	4.9536	2800.0
2009-07-07 08:08:00	AAPL	Stock	4.9529	4.9529	4.9529	4.9529	14000.0
2009-07-07 08:10:00	AAPL	Stock	4.9607	4.9607	4.9607	4.9607	5600.0
2009-07-07 08:11:00	AAPL	Stock	4.9607	4.9607	4.9607	4.9607	2800.0
2009-07-07 08:12:00	AAPL	Stock	4.9607	4.9607	4.9604	4.9604	19600.0
2009-07-07 08:13:00	AAPL	Stock	4.9568	4.9568	4.9554	4.9568	75600.0
2009-07-07 08:14:00	AAPL	Stock	4.9586	4.9586	4.9554	4.9554	36568.0
2009-07-07 08:15:00	AAPL	Stock	4.9554	4.9554	4.9554	4.9554	12684.0
2009-07-07 08:16:00	AAPL	Stock	4.9564	4.9589	4.9564	4.9589	5600.0
2009-07-07 08:17:00	AAPL	Stock	4.9564	4.9564	4.9564	4.9564	2800.0
2009-07-07 08:18:00	AAPL	Stock	4.96	4.9632	4.96	4.9632	25200.0
2009-07-07 08:19:00	AAPL	Stock	4.9611	4.9611	4.9611	4.9611	11200.0
2009-07-07 08:21:00	AAPL	Stock	4.9621	4.9621	4.9621	4.9621	70000.0
2009-07-07 08:22:00	AAPL	Stock	4.9611	4.9611	4.9611	4.9611	5600.0
2009-07-07 08:26:00	AAPL	Stock	4.9589	4.9589	4.9561	4.9582	61600.0
2009-07-07 08:27:00	AAPL	Stock	4.9568	4.9568	4.9568	4.9568	2800.0
2009-07-07 08:28:00	AAPL	Stock	4.9571	4.9582	4.9571	4.9582	84924.0
2009-07-07 08:31:00	AAPL	Stock	4.96	4.96	4.9582	4.9582	11200.0
2009-07-07 08:32:00	AAPL	Stock	4.9582	4.9582	4.9582	4.9582	5600.0
2009-07-07 08:33:00	AAPL	Stock	4.9582	4.9582	4.9561	4.9561	28000.0
2009-07-07 08:37:00	AAPL	Stock	4.9596	4.9596	4.9596	4.9596	10444.0
2009-07-07 08:38:00	AAPL	Stock	4.9596	4.96	4.9596	4.96	21000.0
2009-07-07 08:40:00	AAPL	Stock	4.96	4.9607	4.96	4.9607	62720.0
2009-07-07 08:41:00	AAPL	Stock	4.9621	4.9621	4.9611	4.9611	11200.0
2009-07-07 08:42:00	AAPL	Stock	4.9611	4.9621	4.9607	4.9618	57344.0
2009-07-07 08:43:00	AAPL	Stock	4.96	4.96	4.96	4.96	2800.0
2009-07-07 08:46:00	AAPL	Stock	4.9618	4.9618	4.9589	4.9604	49224.0
2009-07-07 08:52:00	AAPL	Stock	4.9625	4.9679	4.9618	4.9618	51716.0
2009-07-07 08:56:00	AAPL	Stock	4.9621	4.9621	4.9607	4.9607	9800.0
2009-07-07 08:58:00	AAPL	Stock	4.9593	4.9607	4.9593	4.9607	44800.0
2009-07-07 09:00:00	AAPL	Stock	4.9614	4.9643	4.9614	4.9643	16940.0
2009-07-07 09:02:00	AAPL	Stock	4.9621	4.9621	4.9611	4.9611	14000.0
2009-07-07 09:06:00	AAPL	Stock	4.9614	4.9614	4.9607	4.9614	33600.0
2009-07-07 09:08:00	AAPL	Stock	4.9614	4.9614	4.9579	4.9579	157276.0
2009-07-07 09:10:00	AAPL	Stock	4.9586	4.9586	4.9586	4.9586	2800.0
2009-07-07 09:12:00	AAPL	Stock	4.9586	4.9586	4.9554	4.9554	118720.0
2009-07-07 09:15:00	AAPL	Stock	4.9568	4.9579	4.9568	4.9579	63280.0
2009-07-07 09:17:00	AAPL	Stock	4.9582	4.9582	4.9582	4.9582	2800.0
2009-07-07 09:19:00	AAPL	Stock	4.9557	4.9557	4.9536	4.9536	240744.0
2009-07-07 09:20:00	AAPL	Stock	4.9504	4.9561	4.9504	4.9561	32200.0
2009-07-07 09:21:00	AAPL	Stock	4.9561	4.9571	4.9529	4.9536	92400.0
2009-07-07 09:22:00	AAPL	Stock	4.9532	4.9536	4.9486	4.9518	147560.0
2009-07-07 09:23:00	AAPL	Stock	4.9511	4.9518	4.9507	4.9518	9968.0
2009-07-07 09:24:00	AAPL	Stock	4.9518	4.9518	4.9504	4.9504	8400.0
2009-07-07 09:25:00	AAPL	Stock	4.9518	4.9518	4.9486	4.9486	16800.0
2009-07-07 09:26:00	AAPL	Stock	4.9514	4.9521	4.9514	4.9514	17640.0

> showing 50 of 955,041 rows — these rows as CSV

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