PREVIEW / stock_5min / 2011-03-29

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-03-29.parquet
  size:    4.8 MB
  rows:    328,630
  symbols: 3,523

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
2011-03-29 04:00:00	AAPL	Stock	12.5711	12.5711	12.5711	12.5711	2800.0
2011-03-29 04:25:00	AAPL	Stock	12.5457	12.5457	12.5446	12.5446	8400.0
2011-03-29 04:45:00	AAPL	Stock	12.5632	12.5632	12.5632	12.5632	23800.0
2011-03-29 05:00:00	AAPL	Stock	12.5468	12.5468	12.5443	12.5443	11200.0
2011-03-29 05:30:00	AAPL	Stock	12.5311	12.5311	12.5082	12.5082	16800.0
2011-03-29 05:35:00	AAPL	Stock	12.4907	12.4907	12.4739	12.4739	16800.0
2011-03-29 06:25:00	AAPL	Stock	12.5011	12.5011	12.5011	12.5011	2800.0
2011-03-29 06:35:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-03-29 07:00:00	AAPL	Stock	12.5186	12.5186	12.5186	12.5186	2800.0
2011-03-29 07:05:00	AAPL	Stock	12.5121	12.5121	12.5121	12.5121	5600.0
2011-03-29 07:10:00	AAPL	Stock	12.5089	12.5089	12.5089	12.5089	2800.0
2011-03-29 07:15:00	AAPL	Stock	12.5007	12.5007	12.5004	12.5004	30800.0
2011-03-29 07:20:00	AAPL	Stock	12.4993	12.4993	12.4993	12.4993	5600.0
2011-03-29 07:25:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-03-29 07:30:00	AAPL	Stock	12.5	12.5	12.4996	12.4996	5600.0
2011-03-29 07:35:00	AAPL	Stock	12.5075	12.5075	12.5075	12.5075	2800.0
2011-03-29 07:40:00	AAPL	Stock	12.4961	12.4961	12.4914	12.4914	22400.0
2011-03-29 07:45:00	AAPL	Stock	12.4961	12.4961	12.4929	12.4929	28000.0
2011-03-29 07:50:00	AAPL	Stock	12.4957	12.51	12.4954	12.5004	30800.0
2011-03-29 07:55:00	AAPL	Stock	12.5	12.5	12.495	12.495	19600.0
2011-03-29 08:00:00	AAPL	Stock	12.5	12.5071	12.4911	12.5039	169064.0
2011-03-29 08:05:00	AAPL	Stock	12.5071	12.5161	12.5036	12.5143	187292.0
2011-03-29 08:10:00	AAPL	Stock	12.5171	12.5171	12.5107	12.5107	70000.0
2011-03-29 08:15:00	AAPL	Stock	12.5039	12.5039	12.5039	12.5039	6188.0
2011-03-29 08:20:00	AAPL	Stock	12.5089	12.5089	12.5	12.5	52416.0
2011-03-29 08:25:00	AAPL	Stock	12.5021	12.505	12.4971	12.4971	87696.0
2011-03-29 08:30:00	AAPL	Stock	12.4993	12.5	12.4736	12.4736	262164.0
2011-03-29 08:35:00	AAPL	Stock	12.4825	12.4857	12.4464	12.4636	527716.0
2011-03-29 08:40:00	AAPL	Stock	12.4618	12.4639	12.4404	12.4596	214956.0
2011-03-29 08:45:00	AAPL	Stock	12.4643	12.4786	12.4518	12.4518	927836.0
2011-03-29 08:50:00	AAPL	Stock	12.4504	12.4536	12.4357	12.4421	454944.0
2011-03-29 08:55:00	AAPL	Stock	12.4414	12.4414	12.4254	12.4261	760368.0
2011-03-29 09:00:00	AAPL	Stock	12.4268	12.4357	12.4132	12.4264	880768.0
2011-03-29 09:05:00	AAPL	Stock	12.4214	12.4282	12.4146	12.4146	349356.0
2011-03-29 09:10:00	AAPL	Stock	12.4146	12.4157	12.4068	12.4121	1218000.0
2011-03-29 09:15:00	AAPL	Stock	12.4118	12.4143	12.4036	12.4107	1728076.0
2011-03-29 09:20:00	AAPL	Stock	12.4125	12.4125	12.4018	12.4046	335244.0
2011-03-29 09:25:00	AAPL	Stock	12.4036	12.4193	12.4018	12.4143	988708.0
2011-03-29 09:30:00	AAPL	Stock	12.4143	12.4475	12.4036	12.4228	15919680.0
2011-03-29 09:35:00	AAPL	Stock	12.425	12.4354	12.3654	12.38	18371668.0
2011-03-29 09:40:00	AAPL	Stock	12.38	12.4093	12.3593	12.3975	14014952.0
2011-03-29 09:45:00	AAPL	Stock	12.3975	12.4107	12.3893	12.4032	10002356.0
2011-03-29 09:50:00	AAPL	Stock	12.4046	12.4321	12.4016	12.4136	9499952.0
2011-03-29 09:55:00	AAPL	Stock	12.4136	12.4182	12.4018	12.4136	5108404.0
2011-03-29 10:00:00	AAPL	Stock	12.4136	12.4461	12.4	12.4446	9667280.0
2011-03-29 10:05:00	AAPL	Stock	12.4455	12.4786	12.4396	12.4771	11018868.0
2011-03-29 10:10:00	AAPL	Stock	12.4786	12.49	12.4718	12.4835	8437940.0
2011-03-29 10:15:00	AAPL	Stock	12.4843	12.4925	12.4679	12.4849	9033192.0
2011-03-29 10:20:00	AAPL	Stock	12.4873	12.4979	12.4711	12.4804	5891760.0
2011-03-29 10:25:00	AAPL	Stock	12.4807	12.4904	12.47	12.4704	3906028.0

> showing 50 of 328,630 rows — these rows as CSV

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