PREVIEW / stock_5min / 2009-04-20

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-20.parquet
  size:    4.5 MB
  rows:    313,089
  symbols: 3,310

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
2009-04-20 04:45:00	AAPL	Stock	4.3882	4.3882	4.3882	4.3882	2800.0
2009-04-20 05:40:00	AAPL	Stock	4.3214	4.3214	4.3214	4.3214	2800.0
2009-04-20 06:25:00	AAPL	Stock	4.3564	4.3564	4.3564	4.3564	8400.0
2009-04-20 06:55:00	AAPL	Stock	4.3464	4.3464	4.3464	4.3464	2800.0
2009-04-20 07:00:00	AAPL	Stock	4.3464	4.35	4.3357	4.3357	18200.0
2009-04-20 07:05:00	AAPL	Stock	4.365	4.365	4.365	4.365	9800.0
2009-04-20 07:10:00	AAPL	Stock	4.3643	4.3643	4.3643	4.3643	13860.0
2009-04-20 07:15:00	AAPL	Stock	4.3571	4.3571	4.3571	4.3571	8400.0
2009-04-20 07:20:00	AAPL	Stock	4.3643	4.3643	4.3643	4.3643	11200.0
2009-04-20 07:35:00	AAPL	Stock	4.3704	4.3714	4.3704	4.3714	30800.0
2009-04-20 07:50:00	AAPL	Stock	4.3761	4.3796	4.3761	4.3775	22400.0
2009-04-20 07:55:00	AAPL	Stock	4.3775	4.3821	4.3686	4.3821	106400.0
2009-04-20 08:00:00	AAPL	Stock	4.3832	4.3839	4.3714	4.375	140924.0
2009-04-20 08:05:00	AAPL	Stock	4.3846	4.3846	4.3768	4.3768	52780.0
2009-04-20 08:10:00	AAPL	Stock	4.3782	4.3893	4.3782	4.3893	81900.0
2009-04-20 08:15:00	AAPL	Stock	4.3893	4.3946	4.3825	4.3825	84980.0
2009-04-20 08:20:00	AAPL	Stock	4.3829	4.3829	4.3768	4.3768	53256.0
2009-04-20 08:25:00	AAPL	Stock	4.3768	4.3825	4.3571	4.3607	513772.0
2009-04-20 08:30:00	AAPL	Stock	4.3607	4.3643	4.3607	4.3607	77112.0
2009-04-20 08:35:00	AAPL	Stock	4.3614	4.375	4.3604	4.3643	211540.0
2009-04-20 08:40:00	AAPL	Stock	4.3721	4.3721	4.3661	4.3721	11200.0
2009-04-20 08:45:00	AAPL	Stock	4.3721	4.3811	4.3721	4.375	50232.0
2009-04-20 08:50:00	AAPL	Stock	4.375	4.3814	4.3714	4.3814	63336.0
2009-04-20 08:55:00	AAPL	Stock	4.3775	4.3775	4.3732	4.3732	11900.0
2009-04-20 09:00:00	AAPL	Stock	4.3696	4.3696	4.3518	4.3568	677880.0
2009-04-20 09:05:00	AAPL	Stock	4.355	4.355	4.3511	4.3536	296800.0
2009-04-20 09:10:00	AAPL	Stock	4.3536	4.3543	4.3489	4.35	268240.0
2009-04-20 09:15:00	AAPL	Stock	4.35	4.35	4.3489	4.35	120652.0
2009-04-20 09:20:00	AAPL	Stock	4.35	4.3571	4.35	4.3554	241724.0
2009-04-20 09:25:00	AAPL	Stock	4.355	4.355	4.3464	4.3525	124600.0
2009-04-20 09:30:00	AAPL	Stock	4.35	4.3754	4.3411	4.3714	14503860.0
2009-04-20 09:35:00	AAPL	Stock	4.3714	4.3925	4.3661	4.3814	13211324.0
2009-04-20 09:40:00	AAPL	Stock	4.3821	4.3893	4.3607	4.3771	11905404.0
2009-04-20 09:45:00	AAPL	Stock	4.3761	4.3821	4.3618	4.3686	9946664.0
2009-04-20 09:50:00	AAPL	Stock	4.3689	4.3693	4.3529	4.3625	10187604.0
2009-04-20 09:55:00	AAPL	Stock	4.3629	4.3629	4.35	4.3518	9516948.0
2009-04-20 10:00:00	AAPL	Stock	4.3521	4.3664	4.35	4.3632	7491736.0
2009-04-20 10:05:00	AAPL	Stock	4.3625	4.3707	4.3593	4.3611	4530484.0
2009-04-20 10:10:00	AAPL	Stock	4.3604	4.3614	4.3429	4.3445	7434532.0
2009-04-20 10:15:00	AAPL	Stock	4.3444	4.3449	4.3236	4.3254	10668840.0
2009-04-20 10:20:00	AAPL	Stock	4.3239	4.3282	4.3175	4.3279	7290612.0
2009-04-20 10:25:00	AAPL	Stock	4.3268	4.3293	4.3207	4.3207	5821900.0
2009-04-20 10:30:00	AAPL	Stock	4.3211	4.3671	4.3007	4.3143	8044428.0
2009-04-20 10:35:00	AAPL	Stock	4.3146	4.3214	4.307	4.3143	5595912.0
2009-04-20 10:40:00	AAPL	Stock	4.315	4.3157	4.3	4.3039	6137992.0
2009-04-20 10:45:00	AAPL	Stock	4.3036	4.3036	4.29	4.2946	6540968.0
2009-04-20 10:50:00	AAPL	Stock	4.2952	4.3018	4.2893	4.2996	5424608.0
2009-04-20 10:55:00	AAPL	Stock	4.2996	4.3032	4.2929	4.3004	4330816.0
2009-04-20 11:00:00	AAPL	Stock	4.3007	4.3018	4.29	4.2911	4904256.0
2009-04-20 11:05:00	AAPL	Stock	4.2907	4.3	4.2893	4.2957	4502988.0

> showing 50 of 313,089 rows — these rows as CSV

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