PREVIEW / stock_1min / 2012-05-01

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-05-01.parquet
  size:    13.4 MB
  rows:    999,042
  symbols: 2,873

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-05-01 04:07:00	AAPL	Stock	20.8564	20.8564	20.8564	20.8564	4200.0
2012-05-01 04:08:00	AAPL	Stock	20.8571	20.8571	20.8571	20.8571	8400.0
2012-05-01 04:18:00	AAPL	Stock	20.8286	20.8286	20.8286	20.8286	5600.0
2012-05-01 04:52:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	10612.0
2012-05-01 05:15:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	14000.0
2012-05-01 06:01:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	3388.0
2012-05-01 06:25:00	AAPL	Stock	20.7929	20.7929	20.7929	20.7929	8960.0
2012-05-01 06:46:00	AAPL	Stock	20.7946	20.7946	20.7946	20.7946	6580.0
2012-05-01 06:54:00	AAPL	Stock	20.8	20.8	20.7946	20.7946	12852.0
2012-05-01 07:03:00	AAPL	Stock	20.8482	20.8482	20.8482	20.8482	4200.0
2012-05-01 07:16:00	AAPL	Stock	20.8536	20.8536	20.8536	20.8536	2800.0
2012-05-01 07:17:00	AAPL	Stock	20.8536	20.8582	20.8536	20.8582	21308.0
2012-05-01 07:19:00	AAPL	Stock	20.875	20.875	20.875	20.875	14000.0
2012-05-01 07:21:00	AAPL	Stock	20.8736	20.8736	20.8736	20.8736	2800.0
2012-05-01 07:22:00	AAPL	Stock	20.8736	20.875	20.8736	20.875	30800.0
2012-05-01 07:23:00	AAPL	Stock	20.875	20.8857	20.875	20.8857	18284.0
2012-05-01 07:24:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	2800.0
2012-05-01 07:25:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	13160.0
2012-05-01 07:29:00	AAPL	Stock	20.9357	20.9368	20.9357	20.9368	5600.0
2012-05-01 07:31:00	AAPL	Stock	20.9429	20.9604	20.9429	20.9571	25284.0
2012-05-01 07:32:00	AAPL	Stock	20.9479	20.9479	20.9393	20.9464	62104.0
2012-05-01 07:33:00	AAPL	Stock	20.9343	20.9343	20.9343	20.9343	5600.0
2012-05-01 07:34:00	AAPL	Stock	20.935	20.935	20.9286	20.9286	8400.0
2012-05-01 07:36:00	AAPL	Stock	20.9268	20.9286	20.915	20.915	19684.0
2012-05-01 07:37:00	AAPL	Stock	20.9286	20.9393	20.9286	20.9393	37604.0
2012-05-01 07:38:00	AAPL	Stock	20.9371	20.9371	20.9371	20.9371	5600.0
2012-05-01 07:39:00	AAPL	Stock	20.9325	20.9325	20.9325	20.9325	2800.0
2012-05-01 07:40:00	AAPL	Stock	20.9404	20.95	20.9404	20.95	47600.0
2012-05-01 07:41:00	AAPL	Stock	20.9536	20.9643	20.9536	20.9643	8120.0
2012-05-01 07:42:00	AAPL	Stock	20.9643	20.9682	20.9643	20.9682	8400.0
2012-05-01 07:43:00	AAPL	Stock	20.9596	20.9596	20.9596	20.9596	2800.0
2012-05-01 07:44:00	AAPL	Stock	20.9679	20.9946	20.96	20.9732	62468.0
2012-05-01 07:45:00	AAPL	Stock	20.9836	21.02	20.9836	21.0125	59164.0
2012-05-01 07:46:00	AAPL	Stock	21.0125	21.0125	21.0	21.0	36400.0
2012-05-01 07:47:00	AAPL	Stock	21.0093	21.0107	20.9854	21.0	22540.0
2012-05-01 07:48:00	AAPL	Stock	20.9986	21.0004	20.9986	21.0004	5600.0
2012-05-01 07:51:00	AAPL	Stock	20.9886	20.9886	20.9836	20.9836	11200.0
2012-05-01 07:52:00	AAPL	Stock	20.9761	20.9857	20.975	20.975	11200.0
2012-05-01 07:54:00	AAPL	Stock	20.9857	20.9936	20.9821	20.9911	19600.0
2012-05-01 07:55:00	AAPL	Stock	20.9825	20.9832	20.9732	20.9732	36680.0
2012-05-01 07:56:00	AAPL	Stock	20.9646	20.9646	20.9543	20.9543	14000.0
2012-05-01 07:57:00	AAPL	Stock	20.9643	20.9646	20.9643	20.9646	30800.0
2012-05-01 07:58:00	AAPL	Stock	20.9743	20.975	20.9743	20.975	9520.0
2012-05-01 07:59:00	AAPL	Stock	20.975	20.9782	20.975	20.9782	13160.0
2012-05-01 08:00:00	AAPL	Stock	20.9761	20.9893	20.9464	20.9464	196168.0
2012-05-01 08:01:00	AAPL	Stock	20.9404	20.9632	20.9346	20.9632	50400.0
2012-05-01 08:02:00	AAPL	Stock	20.9536	20.9536	20.9468	20.9468	5600.0
2012-05-01 08:03:00	AAPL	Stock	20.9536	20.9718	20.9536	20.9714	33908.0
2012-05-01 08:04:00	AAPL	Stock	20.9714	20.9779	20.9714	20.9714	26600.0
2012-05-01 08:05:00	AAPL	Stock	20.9679	20.9768	20.9507	20.9582	65100.0

> showing 50 of 999,042 rows — these rows as CSV

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