PREVIEW / stock_1min / 2012-09-28

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-09-28.parquet
  size:    12.3 MB
  rows:    914,202
  symbols: 2,835

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
2012-09-28 04:06:00	AAPL	Stock	24.4104	24.4104	24.41	24.41	5600.0
2012-09-28 04:09:00	AAPL	Stock	24.4071	24.4071	24.4071	24.4071	19600.0
2012-09-28 04:20:00	AAPL	Stock	24.4	24.4	24.4	24.4	2800.0
2012-09-28 04:47:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	2800.0
2012-09-28 04:51:00	AAPL	Stock	24.4196	24.4196	24.4196	24.4196	3752.0
2012-09-28 04:53:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	2800.0
2012-09-28 05:00:00	AAPL	Stock	24.4411	24.4411	24.4411	24.4411	5600.0
2012-09-28 05:36:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	14000.0
2012-09-28 05:37:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	8400.0
2012-09-28 05:41:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	5600.0
2012-09-28 05:46:00	AAPL	Stock	24.425	24.425	24.425	24.425	2800.0
2012-09-28 05:49:00	AAPL	Stock	24.4232	24.4232	24.4232	24.4232	2800.0
2012-09-28 05:56:00	AAPL	Stock	24.4143	24.4143	24.4143	24.4143	5600.0
2012-09-28 05:58:00	AAPL	Stock	24.4125	24.4125	24.4107	24.4107	14000.0
2012-09-28 05:59:00	AAPL	Stock	24.4107	24.4107	24.4107	24.4107	16800.0
2012-09-28 06:00:00	AAPL	Stock	24.4107	24.4107	24.4107	24.4107	2800.0
2012-09-28 06:03:00	AAPL	Stock	24.4054	24.4054	24.4054	24.4054	2940.0
2012-09-28 06:06:00	AAPL	Stock	24.4036	24.4036	24.3929	24.3929	21140.0
2012-09-28 06:07:00	AAPL	Stock	24.3929	24.3929	24.3929	24.3929	9660.0
2012-09-28 06:08:00	AAPL	Stock	24.3839	24.3839	24.3839	24.3839	7252.0
2012-09-28 06:09:00	AAPL	Stock	24.375	24.375	24.375	24.375	9268.0
2012-09-28 06:21:00	AAPL	Stock	24.375	24.375	24.375	24.375	3332.0
2012-09-28 06:22:00	AAPL	Stock	24.3571	24.3571	24.3571	24.3571	14000.0
2012-09-28 06:36:00	AAPL	Stock	24.3571	24.3571	24.3571	24.3571	4228.0
2012-09-28 06:38:00	AAPL	Stock	24.3236	24.3236	24.3236	24.3236	2800.0
2012-09-28 06:40:00	AAPL	Stock	24.3521	24.3521	24.3521	24.3521	2800.0
2012-09-28 06:43:00	AAPL	Stock	24.3568	24.3568	24.3568	24.3568	2800.0
2012-09-28 06:55:00	AAPL	Stock	24.3521	24.3521	24.3521	24.3521	5600.0
2012-09-28 06:57:00	AAPL	Stock	24.3521	24.3521	24.3521	24.3521	5600.0
2012-09-28 07:00:00	AAPL	Stock	24.3521	24.3521	24.3146	24.3146	40460.0
2012-09-28 07:01:00	AAPL	Stock	24.3214	24.3214	24.2907	24.2907	34300.0
2012-09-28 07:02:00	AAPL	Stock	24.2932	24.2932	24.2857	24.2857	28000.0
2012-09-28 07:03:00	AAPL	Stock	24.2854	24.2854	24.2575	24.2575	13300.0
2012-09-28 07:04:00	AAPL	Stock	24.2857	24.2857	24.2857	24.2857	2800.0
2012-09-28 07:05:00	AAPL	Stock	24.2839	24.2857	24.275	24.275	28000.0
2012-09-28 07:06:00	AAPL	Stock	24.2843	24.2857	24.2843	24.2857	16800.0
2012-09-28 07:07:00	AAPL	Stock	24.2857	24.2857	24.2857	24.2857	5600.0
2012-09-28 07:08:00	AAPL	Stock	24.2857	24.2857	24.2857	24.2857	14000.0
2012-09-28 07:09:00	AAPL	Stock	24.2721	24.2721	24.25	24.25	82796.0
2012-09-28 07:12:00	AAPL	Stock	24.2746	24.2754	24.2746	24.2754	11200.0
2012-09-28 07:13:00	AAPL	Stock	24.275	24.2768	24.275	24.2768	12600.0
2012-09-28 07:14:00	AAPL	Stock	24.2686	24.2686	24.2607	24.2679	50400.0
2012-09-28 07:15:00	AAPL	Stock	24.25	24.25	24.245	24.245	16800.0
2012-09-28 07:17:00	AAPL	Stock	24.2504	24.2504	24.25	24.2504	11200.0
2012-09-28 07:20:00	AAPL	Stock	24.2654	24.2654	24.2654	24.2654	4620.0
2012-09-28 07:21:00	AAPL	Stock	24.2589	24.2589	24.2589	24.2589	2800.0
2012-09-28 07:22:00	AAPL	Stock	24.2514	24.2679	24.2514	24.2664	16996.0
2012-09-28 07:27:00	AAPL	Stock	24.2746	24.2768	24.2729	24.2768	12460.0
2012-09-28 07:31:00	AAPL	Stock	24.2857	24.2857	24.2857	24.2857	42420.0
2012-09-28 07:32:00	AAPL	Stock	24.2857	24.2857	24.2857	24.2857	21168.0

> showing 50 of 914,202 rows — these rows as CSV

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