PREVIEW / stock_5min / 2010-07-21

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-21.parquet
  size:    4.6 MB
  rows:    319,119
  symbols: 3,459

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
2010-07-21 04:00:00	AAPL	Stock	9.25	9.25	9.25	9.25	4620.0
2010-07-21 04:05:00	AAPL	Stock	9.2632	9.2632	9.2625	9.2625	24668.0
2010-07-21 04:10:00	AAPL	Stock	9.2679	9.2679	9.2679	9.2679	9800.0
2010-07-21 04:15:00	AAPL	Stock	9.2611	9.2611	9.2611	9.2611	14000.0
2010-07-21 04:25:00	AAPL	Stock	9.2614	9.2636	9.2614	9.2636	22400.0
2010-07-21 05:15:00	AAPL	Stock	9.2914	9.2914	9.2914	9.2914	2800.0
2010-07-21 05:25:00	AAPL	Stock	9.3018	9.3018	9.3018	9.3018	2800.0
2010-07-21 05:30:00	AAPL	Stock	9.3029	9.3029	9.3029	9.3029	2800.0
2010-07-21 05:40:00	AAPL	Stock	9.3211	9.3211	9.3211	9.3211	2800.0
2010-07-21 05:50:00	AAPL	Stock	9.3036	9.3036	9.3029	9.3029	9800.0
2010-07-21 05:55:00	AAPL	Stock	9.3029	9.3029	9.3029	9.3029	16800.0
2010-07-21 06:00:00	AAPL	Stock	9.3029	9.3029	9.3029	9.3029	4256.0
2010-07-21 06:15:00	AAPL	Stock	9.3029	9.3029	9.3029	9.3029	14000.0
2010-07-21 06:25:00	AAPL	Stock	9.2964	9.2964	9.2911	9.2911	8400.0
2010-07-21 06:30:00	AAPL	Stock	9.2918	9.2918	9.2911	9.2911	8400.0
2010-07-21 06:35:00	AAPL	Stock	9.2857	9.2857	9.2743	9.2743	16800.0
2010-07-21 06:55:00	AAPL	Stock	9.2739	9.2857	9.2739	9.2857	13356.0
2010-07-21 07:00:00	AAPL	Stock	9.2907	9.3196	9.2907	9.2964	138796.0
2010-07-21 07:05:00	AAPL	Stock	9.3036	9.3214	9.3036	9.3207	99792.0
2010-07-21 07:10:00	AAPL	Stock	9.3221	9.35	9.3214	9.3464	112000.0
2010-07-21 07:15:00	AAPL	Stock	9.3429	9.35	9.3393	9.3393	320348.0
2010-07-21 07:20:00	AAPL	Stock	9.3393	9.3429	9.3221	9.3236	137088.0
2010-07-21 07:25:00	AAPL	Stock	9.3304	9.3393	9.325	9.3296	163492.0
2010-07-21 07:30:00	AAPL	Stock	9.3379	9.3457	9.3214	9.3393	271292.0
2010-07-21 07:35:00	AAPL	Stock	9.3446	9.3654	9.3443	9.3571	801920.0
2010-07-21 07:40:00	AAPL	Stock	9.3571	9.3571	9.3375	9.3489	487116.0
2010-07-21 07:45:00	AAPL	Stock	9.35	9.3714	9.35	9.3607	525392.0
2010-07-21 07:50:00	AAPL	Stock	9.3625	9.3625	9.3471	9.3504	1055264.0
2010-07-21 07:55:00	AAPL	Stock	9.3507	9.3536	9.3461	9.3482	562408.0
2010-07-21 08:00:00	AAPL	Stock	9.3482	9.3554	9.2857	9.3429	2235436.0
2010-07-21 08:05:00	AAPL	Stock	9.3396	9.3571	9.3236	9.3414	577472.0
2010-07-21 08:10:00	AAPL	Stock	9.3457	9.3511	9.3411	9.3414	537544.0
2010-07-21 08:15:00	AAPL	Stock	9.3414	9.3714	9.3411	9.3714	2045176.0
2010-07-21 08:20:00	AAPL	Stock	9.3714	9.3796	9.365	9.3714	2435412.0
2010-07-21 08:25:00	AAPL	Stock	9.3707	9.3732	9.3614	9.3682	827232.0
2010-07-21 08:30:00	AAPL	Stock	9.3664	9.3679	9.3482	9.3579	1485260.0
2010-07-21 08:35:00	AAPL	Stock	9.3579	9.3668	9.3571	9.3643	581448.0
2010-07-21 08:40:00	AAPL	Stock	9.3643	9.3811	9.3621	9.3771	2318568.0
2010-07-21 08:45:00	AAPL	Stock	9.3768	9.3907	9.3768	9.3843	2480268.0
2010-07-21 08:50:00	AAPL	Stock	9.3868	9.4036	9.3846	9.4	2621948.0
2010-07-21 08:55:00	AAPL	Stock	9.3993	9.4143	9.3911	9.4086	3207008.0
2010-07-21 09:00:00	AAPL	Stock	9.4093	9.4118	9.3989	9.4032	3369156.0
2010-07-21 09:05:00	AAPL	Stock	9.4039	9.4257	9.4021	9.4132	2336740.0
2010-07-21 09:10:00	AAPL	Stock	9.4146	9.4393	9.4146	9.4329	2584624.0
2010-07-21 09:15:00	AAPL	Stock	9.4325	9.4643	9.4289	9.4589	3808728.0
2010-07-21 09:20:00	AAPL	Stock	9.4582	9.5168	9.4554	9.4893	10171196.0
2010-07-21 09:25:00	AAPL	Stock	9.4864	9.4957	9.4571	9.4693	9168796.0
2010-07-21 09:30:00	AAPL	Stock	9.4686	9.4696	9.37	9.3761	94569132.0
2010-07-21 09:35:00	AAPL	Stock	9.3793	9.3857	9.3214	9.3243	59994648.0
2010-07-21 09:40:00	AAPL	Stock	9.3243	9.35	9.2971	9.3461	53234384.0

> showing 50 of 319,119 rows — these rows as CSV

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