PREVIEW / stock_5min / 2012-01-19

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-19.parquet
  size:    4.8 MB
  rows:    321,206
  symbols: 3,499

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-01-19 05:30:00	AAPL	Stock	15.3861	15.3861	15.3861	15.3861	5600.0
2012-01-19 06:00:00	AAPL	Stock	15.3771	15.3771	15.375	15.375	8400.0
2012-01-19 06:15:00	AAPL	Stock	15.3857	15.3857	15.3857	15.3857	2800.0
2012-01-19 06:20:00	AAPL	Stock	15.375	15.375	15.375	15.375	2800.0
2012-01-19 06:40:00	AAPL	Stock	15.3829	15.3857	15.3829	15.3857	11200.0
2012-01-19 06:50:00	AAPL	Stock	15.3857	15.3857	15.3857	15.3857	5600.0
2012-01-19 06:55:00	AAPL	Stock	15.3854	15.3854	15.3714	15.3714	25200.0
2012-01-19 07:00:00	AAPL	Stock	15.3714	15.3804	15.3714	15.3804	8400.0
2012-01-19 07:05:00	AAPL	Stock	15.3675	15.3804	15.3675	15.3804	13272.0
2012-01-19 07:15:00	AAPL	Stock	15.3625	15.3661	15.3607	15.3661	66668.0
2012-01-19 07:20:00	AAPL	Stock	15.3707	15.3968	15.3707	15.3925	62020.0
2012-01-19 07:25:00	AAPL	Stock	15.385	15.3896	15.3761	15.3768	58800.0
2012-01-19 07:30:00	AAPL	Stock	15.3821	15.3857	15.3821	15.3825	56000.0
2012-01-19 07:35:00	AAPL	Stock	15.39	15.3968	15.3879	15.3882	116480.0
2012-01-19 07:40:00	AAPL	Stock	15.3886	15.3886	15.3821	15.3829	21420.0
2012-01-19 07:45:00	AAPL	Stock	15.375	15.375	15.3714	15.3714	19600.0
2012-01-19 07:50:00	AAPL	Stock	15.3793	15.3911	15.3793	15.3846	39200.0
2012-01-19 07:55:00	AAPL	Stock	15.3846	15.3868	15.3729	15.3761	63000.0
2012-01-19 08:00:00	AAPL	Stock	15.375	15.3929	15.3132	15.3132	345184.0
2012-01-19 08:05:00	AAPL	Stock	15.3857	15.3857	15.3761	15.3761	57960.0
2012-01-19 08:10:00	AAPL	Stock	15.3786	15.3786	15.3668	15.3714	138824.0
2012-01-19 08:15:00	AAPL	Stock	15.3718	15.3854	15.3718	15.3854	55160.0
2012-01-19 08:20:00	AAPL	Stock	15.385	15.3854	15.3571	15.36	334656.0
2012-01-19 08:25:00	AAPL	Stock	15.3718	15.3746	15.3643	15.3654	82320.0
2012-01-19 08:30:00	AAPL	Stock	15.375	15.3857	15.3643	15.3732	191016.0
2012-01-19 08:35:00	AAPL	Stock	15.375	15.3814	15.3679	15.3814	83552.0
2012-01-19 08:40:00	AAPL	Stock	15.3839	15.3857	15.3786	15.3846	94248.0
2012-01-19 08:45:00	AAPL	Stock	15.3843	15.3857	15.3821	15.3821	68012.0
2012-01-19 08:50:00	AAPL	Stock	15.3818	15.3821	15.3714	15.375	168532.0
2012-01-19 08:55:00	AAPL	Stock	15.375	15.3764	15.3679	15.37	145712.0
2012-01-19 09:00:00	AAPL	Stock	15.37	15.3743	15.3682	15.3725	51940.0
2012-01-19 09:05:00	AAPL	Stock	15.375	15.3786	15.375	15.3786	202328.0
2012-01-19 09:10:00	AAPL	Stock	15.3786	15.3786	15.3714	15.375	430136.0
2012-01-19 09:15:00	AAPL	Stock	15.3761	15.3907	15.3761	15.3857	263088.0
2012-01-19 09:20:00	AAPL	Stock	15.3857	15.3857	15.3804	15.3821	134988.0
2012-01-19 09:25:00	AAPL	Stock	15.3821	15.3821	15.3571	15.3571	806484.0
2012-01-19 09:30:00	AAPL	Stock	15.3625	15.406	15.3504	15.3786	17446884.0
2012-01-19 09:35:00	AAPL	Stock	15.3798	15.3821	15.34	15.3614	7740936.0
2012-01-19 09:40:00	AAPL	Stock	15.3607	15.3625	15.3446	15.3571	4966444.0
2012-01-19 09:45:00	AAPL	Stock	15.3556	15.3564	15.3329	15.3486	6851964.0
2012-01-19 09:50:00	AAPL	Stock	15.35	15.35	15.3179	15.3291	10139612.0
2012-01-19 09:55:00	AAPL	Stock	15.3286	15.3457	15.3279	15.3336	5970300.0
2012-01-19 10:00:00	AAPL	Stock	15.3311	15.3314	15.3029	15.3089	10919384.0
2012-01-19 10:05:00	AAPL	Stock	15.3054	15.3257	15.2929	15.3236	6959428.0
2012-01-19 10:10:00	AAPL	Stock	15.3239	15.3339	15.3186	15.33	3124688.0
2012-01-19 10:15:00	AAPL	Stock	15.3314	15.3425	15.3257	15.3293	3443272.0
2012-01-19 10:20:00	AAPL	Stock	15.3293	15.3432	15.3261	15.3386	4241384.0
2012-01-19 10:25:00	AAPL	Stock	15.3383	15.3389	15.3207	15.3264	3762780.0
2012-01-19 10:30:00	AAPL	Stock	15.3264	15.33	15.3179	15.3232	2116016.0
2012-01-19 10:35:00	AAPL	Stock	15.3239	15.3239	15.3043	15.3096	3249428.0

> showing 50 of 321,206 rows — these rows as CSV

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