PREVIEW / stock_5min / 2012-03-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-03-20.parquet
  size:    4.8 MB
  rows:    326,317
  symbols: 3,541

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-03-20 04:00:00	AAPL	Stock	21.6225	21.6225	21.6196	21.6196	14000.0
2012-03-20 04:05:00	AAPL	Stock	21.6196	21.6286	21.5936	21.5936	42000.0
2012-03-20 04:15:00	AAPL	Stock	21.5761	21.5761	21.5696	21.5696	70756.0
2012-03-20 04:20:00	AAPL	Stock	21.5696	21.6071	21.5696	21.6071	42000.0
2012-03-20 04:25:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	8400.0
2012-03-20 04:35:00	AAPL	Stock	21.5964	21.5964	21.5843	21.5843	22400.0
2012-03-20 04:40:00	AAPL	Stock	21.5964	21.5964	21.5964	21.5964	28000.0
2012-03-20 04:45:00	AAPL	Stock	21.5921	21.5921	21.5921	21.5921	2800.0
2012-03-20 04:50:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	11200.0
2012-03-20 04:55:00	AAPL	Stock	21.5929	21.5929	21.5925	21.5925	5600.0
2012-03-20 05:00:00	AAPL	Stock	21.5893	21.5893	21.5696	21.5696	60032.0
2012-03-20 05:05:00	AAPL	Stock	21.5696	21.5857	21.5696	21.5857	29960.0
2012-03-20 05:10:00	AAPL	Stock	21.5857	21.5857	21.5857	21.5857	5600.0
2012-03-20 05:15:00	AAPL	Stock	21.5893	21.5964	21.5893	21.5964	22400.0
2012-03-20 05:20:00	AAPL	Stock	21.5875	21.5875	21.5875	21.5875	3584.0
2012-03-20 05:30:00	AAPL	Stock	21.5696	21.5696	21.5536	21.5536	26600.0
2012-03-20 05:35:00	AAPL	Stock	21.5429	21.5536	21.5357	21.55	35000.0
2012-03-20 05:40:00	AAPL	Stock	21.5107	21.5179	21.5107	21.5179	5600.0
2012-03-20 06:05:00	AAPL	Stock	21.5057	21.5057	21.4943	21.4943	16800.0
2012-03-20 06:15:00	AAPL	Stock	21.4929	21.5	21.4664	21.4664	28672.0
2012-03-20 06:20:00	AAPL	Stock	21.4646	21.4914	21.4646	21.4914	22400.0
2012-03-20 06:30:00	AAPL	Stock	21.4707	21.4707	21.4289	21.4289	11200.0
2012-03-20 06:35:00	AAPL	Stock	21.4486	21.4546	21.4486	21.4546	5600.0
2012-03-20 06:40:00	AAPL	Stock	21.4604	21.4614	21.4604	21.4614	21560.0
2012-03-20 06:45:00	AAPL	Stock	21.4614	21.4625	21.4607	21.4607	14000.0
2012-03-20 06:50:00	AAPL	Stock	21.4289	21.4446	21.4214	21.4286	61600.0
2012-03-20 06:55:00	AAPL	Stock	21.41	21.41	21.3786	21.3929	82460.0
2012-03-20 07:00:00	AAPL	Stock	21.4107	21.4464	21.4107	21.4214	78512.0
2012-03-20 07:05:00	AAPL	Stock	21.4286	21.4643	21.4136	21.4643	170828.0
2012-03-20 07:10:00	AAPL	Stock	21.4596	21.4857	21.4482	21.4786	297836.0
2012-03-20 07:15:00	AAPL	Stock	21.4782	21.4782	21.4464	21.4743	99064.0
2012-03-20 07:20:00	AAPL	Stock	21.4543	21.4714	21.4432	21.4636	105588.0
2012-03-20 07:25:00	AAPL	Stock	21.4664	21.47	21.4554	21.47	152432.0
2012-03-20 07:30:00	AAPL	Stock	21.4711	21.4711	21.4429	21.4514	93660.0
2012-03-20 07:35:00	AAPL	Stock	21.4571	21.4571	21.3961	21.4071	191268.0
2012-03-20 07:40:00	AAPL	Stock	21.4129	21.4286	21.4071	21.4268	148400.0
2012-03-20 07:45:00	AAPL	Stock	21.4179	21.4282	21.4036	21.4182	134316.0
2012-03-20 07:50:00	AAPL	Stock	21.4179	21.4236	21.3929	21.3936	133840.0
2012-03-20 07:55:00	AAPL	Stock	21.4093	21.4161	21.3682	21.3682	266084.0
2012-03-20 08:00:00	AAPL	Stock	21.375	21.4554	21.3139	21.3571	1859200.0
2012-03-20 08:05:00	AAPL	Stock	21.3429	21.3496	21.3071	21.3207	1189580.0
2012-03-20 08:10:00	AAPL	Stock	21.3157	21.3554	21.3143	21.3554	731528.0
2012-03-20 08:15:00	AAPL	Stock	21.3514	21.3814	21.3479	21.375	711592.0
2012-03-20 08:20:00	AAPL	Stock	21.3743	21.4071	21.3682	21.3957	659764.0
2012-03-20 08:25:00	AAPL	Stock	21.3896	21.4025	21.3768	21.4025	468524.0
2012-03-20 08:30:00	AAPL	Stock	21.4018	21.4036	21.3793	21.3882	492408.0
2012-03-20 08:35:00	AAPL	Stock	21.3882	21.4057	21.3832	21.4	621404.0
2012-03-20 08:40:00	AAPL	Stock	21.395	21.3986	21.3775	21.3807	410564.0
2012-03-20 08:45:00	AAPL	Stock	21.3814	21.3814	21.3643	21.3714	384916.0
2012-03-20 08:50:00	AAPL	Stock	21.3739	21.3821	21.3671	21.3732	149240.0

> showing 50 of 326,317 rows — these rows as CSV

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