PREVIEW / stock_1min / 2007-01-04

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-01-04.parquet
  size:    9.4 MB
  rows:    762,653
  symbols: 2,026

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
2007-01-04 06:51:00	AAPL	Stock	2.9989	2.9989	2.9989	2.9989	11200.0
2007-01-04 07:28:00	AAPL	Stock	2.9993	2.9993	2.9993	2.9993	14000.0
2007-01-04 07:38:00	AAPL	Stock	2.9943	2.9943	2.9943	2.9943	5600.0
2007-01-04 07:40:00	AAPL	Stock	2.9925	2.9925	2.9925	2.9925	5600.0
2007-01-04 07:47:00	AAPL	Stock	3.0	3.0	3.0	3.0	16800.0
2007-01-04 07:48:00	AAPL	Stock	3.0	3.0	3.0	3.0	9800.0
2007-01-04 08:00:00	AAPL	Stock	3.0032	3.0032	2.9929	2.9946	122556.0
2007-01-04 08:05:00	AAPL	Stock	2.9946	2.9946	2.9929	2.9946	43400.0
2007-01-04 08:08:00	AAPL	Stock	2.9929	2.9929	2.9911	2.9911	56000.0
2007-01-04 08:09:00	AAPL	Stock	2.9893	2.9893	2.9875	2.9875	16800.0
2007-01-04 08:10:00	AAPL	Stock	2.9875	2.9875	2.9846	2.9857	56000.0
2007-01-04 08:11:00	AAPL	Stock	2.9836	2.9861	2.9836	2.9861	77840.0
2007-01-04 08:12:00	AAPL	Stock	2.9864	2.9871	2.9854	2.9861	91560.0
2007-01-04 08:13:00	AAPL	Stock	2.9839	2.9839	2.9825	2.9836	98000.0
2007-01-04 08:14:00	AAPL	Stock	2.9839	2.985	2.9821	2.985	86800.0
2007-01-04 08:15:00	AAPL	Stock	2.9857	2.9857	2.9832	2.9832	67200.0
2007-01-04 08:16:00	AAPL	Stock	2.985	2.9857	2.985	2.9857	158340.0
2007-01-04 08:17:00	AAPL	Stock	2.9836	2.9836	2.9825	2.9825	9520.0
2007-01-04 08:18:00	AAPL	Stock	2.985	2.985	2.9818	2.9825	79800.0
2007-01-04 08:19:00	AAPL	Stock	2.9825	2.9832	2.9825	2.9825	18200.0
2007-01-04 08:20:00	AAPL	Stock	2.9821	2.9836	2.9821	2.9836	5600.0
2007-01-04 08:21:00	AAPL	Stock	2.9839	2.9839	2.9839	2.9839	18200.0
2007-01-04 08:22:00	AAPL	Stock	2.985	2.985	2.985	2.985	12600.0
2007-01-04 08:24:00	AAPL	Stock	2.985	2.985	2.985	2.985	5600.0
2007-01-04 08:25:00	AAPL	Stock	2.985	2.9871	2.985	2.9871	212660.0
2007-01-04 08:26:00	AAPL	Stock	2.9871	2.9896	2.9871	2.9896	36400.0
2007-01-04 08:27:00	AAPL	Stock	2.9904	2.9904	2.9886	2.9886	21000.0
2007-01-04 08:28:00	AAPL	Stock	2.9871	2.9871	2.9871	2.9871	22400.0
2007-01-04 08:30:00	AAPL	Stock	2.9857	2.9857	2.9857	2.9857	2800.0
2007-01-04 08:31:00	AAPL	Stock	2.9839	2.985	2.9814	2.9814	61600.0
2007-01-04 08:32:00	AAPL	Stock	2.9825	2.9825	2.9825	2.9825	14000.0
2007-01-04 08:33:00	AAPL	Stock	2.9879	2.9879	2.9807	2.9814	84000.0
2007-01-04 08:34:00	AAPL	Stock	2.9814	2.9814	2.9804	2.9807	39200.0
2007-01-04 08:35:00	AAPL	Stock	2.9839	2.9839	2.9839	2.9839	2800.0
2007-01-04 08:36:00	AAPL	Stock	2.9836	2.9836	2.9836	2.9836	14000.0
2007-01-04 08:37:00	AAPL	Stock	2.9811	2.9821	2.9811	2.9821	10304.0
2007-01-04 08:38:00	AAPL	Stock	2.9821	2.9825	2.9821	2.9825	28000.0
2007-01-04 08:39:00	AAPL	Stock	2.9836	2.9864	2.9836	2.985	175000.0
2007-01-04 08:40:00	AAPL	Stock	2.9857	2.9857	2.985	2.985	8400.0
2007-01-04 08:43:00	AAPL	Stock	2.9854	2.9857	2.9854	2.9857	49700.0
2007-01-04 08:44:00	AAPL	Stock	2.9857	2.9864	2.9857	2.9864	108052.0
2007-01-04 08:46:00	AAPL	Stock	2.9861	2.9875	2.9857	2.9875	12320.0
2007-01-04 08:48:00	AAPL	Stock	2.9911	2.9914	2.9911	2.9914	60536.0
2007-01-04 08:49:00	AAPL	Stock	2.9929	2.9929	2.9925	2.9925	70000.0
2007-01-04 08:50:00	AAPL	Stock	2.9868	2.9868	2.985	2.985	73304.0
2007-01-04 08:53:00	AAPL	Stock	2.9893	2.9911	2.9893	2.9911	29120.0
2007-01-04 08:54:00	AAPL	Stock	2.9911	2.9911	2.9911	2.9911	2800.0
2007-01-04 08:55:00	AAPL	Stock	2.9911	2.9911	2.9868	2.9868	30800.0
2007-01-04 08:56:00	AAPL	Stock	2.9875	2.9875	2.9875	2.9875	36400.0
2007-01-04 08:57:00	AAPL	Stock	2.9889	2.9889	2.9889	2.9889	14000.0

> showing 50 of 762,653 rows — these rows as CSV

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