PREVIEW / stock_5min / 2012-04-09

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-09.parquet
  size:    4.8 MB
  rows:    325,417
  symbols: 3,527

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-04-09 04:15:00	AAPL	Stock	22.4286	22.4286	22.4286	22.4286	4480.0
2012-04-09 04:55:00	AAPL	Stock	22.4357	22.4357	22.4357	22.4357	8400.0
2012-04-09 05:20:00	AAPL	Stock	22.5	22.5104	22.5	22.5104	5600.0
2012-04-09 05:35:00	AAPL	Stock	22.5104	22.5104	22.5104	22.5104	4200.0
2012-04-09 06:10:00	AAPL	Stock	22.4714	22.4714	22.4643	22.4643	8400.0
2012-04-09 06:25:00	AAPL	Stock	22.4286	22.4286	22.4286	22.4286	3640.0
2012-04-09 06:40:00	AAPL	Stock	22.4293	22.4293	22.4143	22.4143	11200.0
2012-04-09 06:45:00	AAPL	Stock	22.4054	22.4054	22.4054	22.4054	5460.0
2012-04-09 06:50:00	AAPL	Stock	22.3929	22.4021	22.3214	22.3214	135016.0
2012-04-09 06:55:00	AAPL	Stock	22.3218	22.3218	22.2839	22.2857	108500.0
2012-04-09 07:00:00	AAPL	Stock	22.2839	22.3354	22.2696	22.3218	281848.0
2012-04-09 07:05:00	AAPL	Stock	22.3214	22.3804	22.3096	22.375	367584.0
2012-04-09 07:10:00	AAPL	Stock	22.375	22.3925	22.3654	22.3664	91280.0
2012-04-09 07:15:00	AAPL	Stock	22.3754	22.3925	22.3643	22.3764	85092.0
2012-04-09 07:20:00	AAPL	Stock	22.3818	22.3982	22.3818	22.3846	116088.0
2012-04-09 07:25:00	AAPL	Stock	22.38	22.3893	22.3607	22.3893	113428.0
2012-04-09 07:30:00	AAPL	Stock	22.405	22.4054	22.3786	22.3929	65268.0
2012-04-09 07:35:00	AAPL	Stock	22.3996	22.4018	22.375	22.3918	143360.0
2012-04-09 07:40:00	AAPL	Stock	22.3929	22.3989	22.3643	22.3643	280728.0
2012-04-09 07:45:00	AAPL	Stock	22.3675	22.3679	22.3504	22.3504	179312.0
2012-04-09 07:50:00	AAPL	Stock	22.3496	22.3571	22.3143	22.3429	277620.0
2012-04-09 07:55:00	AAPL	Stock	22.3293	22.3386	22.325	22.3357	93716.0
2012-04-09 08:00:00	AAPL	Stock	22.3461	22.4104	22.2696	22.3929	965972.0
2012-04-09 08:05:00	AAPL	Stock	22.4004	22.4004	22.3607	22.3854	644756.0
2012-04-09 08:10:00	AAPL	Stock	22.3832	22.4	22.3786	22.3929	402024.0
2012-04-09 08:15:00	AAPL	Stock	22.3893	22.4021	22.3764	22.3929	181216.0
2012-04-09 08:20:00	AAPL	Stock	22.3875	22.3893	22.3632	22.3679	375144.0
2012-04-09 08:25:00	AAPL	Stock	22.3679	22.3679	22.3304	22.3389	890344.0
2012-04-09 08:30:00	AAPL	Stock	22.3464	22.3525	22.3254	22.3393	402584.0
2012-04-09 08:35:00	AAPL	Stock	22.3464	22.3639	22.3429	22.3571	359940.0
2012-04-09 08:40:00	AAPL	Stock	22.3571	22.3732	22.3571	22.3571	362684.0
2012-04-09 08:45:00	AAPL	Stock	22.3654	22.3714	22.35	22.35	361844.0
2012-04-09 08:50:00	AAPL	Stock	22.35	22.3536	22.3339	22.3357	296492.0
2012-04-09 08:55:00	AAPL	Stock	22.3339	22.3571	22.3339	22.3571	128016.0
2012-04-09 09:00:00	AAPL	Stock	22.3571	22.3571	22.3254	22.3275	364616.0
2012-04-09 09:05:00	AAPL	Stock	22.3325	22.3389	22.3082	22.3214	908992.0
2012-04-09 09:10:00	AAPL	Stock	22.325	22.3464	22.3168	22.3214	812672.0
2012-04-09 09:15:00	AAPL	Stock	22.3232	22.3304	22.3146	22.3211	269220.0
2012-04-09 09:20:00	AAPL	Stock	22.315	22.3329	22.3143	22.3329	411404.0
2012-04-09 09:25:00	AAPL	Stock	22.3336	22.3679	22.3336	22.3661	1309000.0
2012-04-09 09:30:00	AAPL	Stock	22.3618	22.4764	22.3321	22.4761	30225524.0
2012-04-09 09:35:00	AAPL	Stock	22.4736	22.4857	22.4329	22.4635	18051068.0
2012-04-09 09:40:00	AAPL	Stock	22.4618	22.4939	22.4375	22.4464	11783912.0
2012-04-09 09:45:00	AAPL	Stock	22.4451	22.4496	22.4046	22.4179	12184256.0
2012-04-09 09:50:00	AAPL	Stock	22.42	22.42	22.3664	22.4011	11993016.0
2012-04-09 09:55:00	AAPL	Stock	22.3993	22.4225	22.3686	22.4018	7824488.0
2012-04-09 10:00:00	AAPL	Stock	22.4021	22.4304	22.3968	22.415	8136996.0
2012-04-09 10:05:00	AAPL	Stock	22.4158	22.4429	22.4104	22.4193	8122884.0
2012-04-09 10:10:00	AAPL	Stock	22.4214	22.4443	22.4164	22.4432	6376944.0
2012-04-09 10:15:00	AAPL	Stock	22.4429	22.5071	22.4371	22.5068	11961852.0

> showing 50 of 325,417 rows — these rows as CSV

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